منتدى استراحات زايد

<div>Long story short, switched to an upgraded VPS and now I'm having average load issues. The loads randomly jump to 1.XX - 2.XX under what seems to be no abnormal load. CPU utilization never really does anything. Memory usage is fine. I can't seem to trace the problem. Sometimes pages are slow (10 - 60s) to load after post (like submitting replies to threads, PMs, posting new threads, etc). But with debug on, it shows less than 0.5s load time. This didn't seem to exist on the previous VPS which had less processor, less memory, and less disk. I originally had copied my my.cnf, httpd.conf, and php.ini files from the original VPS. That had horrible results. After reading more than I've ever wanted to about these config files and tweaking here and there, I've got the loads to a reasonable level, but they're still higher than they were on slower hardware. Any help is much appreciated.

1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)

Dedicated VPS

2. your server specs. For example:

cpu speed/type single or dual cpus): dual quad-cores (not sure of speed)
how much memory installed: 1GB dedicated, 100GB burst
hard drive type/configuration: 30GB SAN
linux distributor or windows version: Centos 5
apache/IIS version: Apache 2.2.3
PHP version: PHP 5.2.9
MySQL version: MySQL 5.0.45

3. what version of vB are you running ?

3.8.1 PL1

4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?

No innodb at all

5. if possible how mysql was compiled/installed

via yum

6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top

Quote:
top - 17:02:44 up 8:13, 1 user, load average: 0.87, 0.44, 0.38
Tasks: 36 total, 2 running, 34 sleeping, 0 stopped, 0 zombie
Cpu(s): 3.8%us, 0.4%sy, 0.0%ni, 95.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 16618580k total, 302964k used, 16315616k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
Now while top is running hit the number 1 on keyboard to show break down of cpu load over all cpu cores. For example a Q6600 quad core kentsfield processor will have 4 cores. A dual Xeon 53xx/54xx quad core clovertown and harpertown processor based server will have 2x 4 = 8 cores listed.

Quote:
top - 17:03:26 up 8:14, 1 user, load average: 0.45, 0.39, 0.36
Tasks: 33 total, 3 running, 30 sleeping, 0 stopped, 0 zombie
Cpu0 : 1.7%us, 0.3%sy, 0.0%ni, 98.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 0.3%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 22.4%us, 5.6%sy, 0.0%ni, 71.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 5.3%us, 0.3%sy, 0.0%ni, 94.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 16618580k total, 290380k used, 16328200k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).

Quote:
[mysqld]
datadir=/var/lib/mysql
safe-show-database
old_passwords
back_log = 50
skip-innodb
max_connections = 500
key_buffer_size = 64M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 5000
thread_cache_size = 384
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 100000
thread_concurrency = 8
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_write_lock_count = 4

[mysqld_safe]
err-log=/var/log/mysqld.log
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 128M
sort_buffer = 16M
read_buffer = 16M
write_buffer = 16M
8. MySQL stats from ssh telnet as root user type:

<div style="margin:20px; margin-top:5px; "> Quote:
+---------------------------------+---------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /usr/ |
| bdb_cache_size | 8388600 |
| bdb_home | /var/lib/mysql/ |
| bdb_log_buffer_size | 2560000 |
| bdb_logdir | |
| bdb_max_lock | 10000 |
| bdb_shared_data | OFF |
| bdb_tmpdir | /tmp/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 2 |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| engine_condition_pushdown | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + ->