insanely slow server

[Smithy|MMGN]

seem to be having issues with my server at the moment..its very slow with smalll loads

Server Spec

Type of Server: Pentium 4 1.7Ghz - Ensim - 2x60GB 7200 - 1GB RAM

my.cnf :


[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=600
set-variable = key_buffer=16M
set-variable = table_cache=1024
set-variable = sort_buffer=4M
set-variable = join_buffer=3M
set-variable = record_buffer=3M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=512
set-variable = wait_timeout=3600
set-variable = connect_timeout=10
set-variable = thread_concurrency=2

[mysql]
no-auto-rehash


[mysqldump]
quick
set-variable = max_allowed_packet=128M


[safe_mysqld]
open-files-limit=8192

[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=16M
set-variable = write_buffer=16M

[mysqlhotcopy]
interactive-timeout




If any one has any ssuggestions i would be very greatful

[WingMan]

Have you tried a `Ping` to the box ? So you know ot's not your network speed (rather than server application speed) ??

[eva2000]

Smithy|MMGN, please provide the following

1. your server specs, such as mysql and php version
2. if possible how mysql was compiled/installed
3. your top stats
4. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type

mysqladmin -u root -p variables

copy and paste output here

5. your mysql extended-status output either still telnet as root user type

mysqladmin -u root -p extended-status

copy and paste output here

or preferred is to installed extended-status output script which is located at http://vbulletin.com/forum/showthread.php?threadid=3477

and post url to that here

6. oh and is your vB the only thing on the server? or other scripts? sites?

7. how many average and max concurrent users on your vB forum ?

8. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site

<?
phpinfo();
?>

i.e. yourdomain.com/phpinfo.php

[jphilipson]

First off...ensim is trash...but thats another story.. lol, anyway, I'd be willing to wager its a connection problem somewhere nad not your box. Although with ev1 (rackshack) slow pipes are not ussually a problem. I have had problems with other ensim boxes and mysql heavy sites. Server load flat lines, .85 .85 .85 for example.. and load stays consistantly heavy.