BadGuy
Wed 23rd Nov '05, 11:58am
This is another forum for me need to good Optimization for the server .
1- dedicated .
2- Processor InformationProcessor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(TM) CPU 2.80GHz
Processor #1 speed: 2793.478 MHz
Processor #1 cache size: 1024 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(TM) CPU 2.80GHz
Processor #2 speed: 2793.478 MHz
Processor #2 cache size: 1024 KB
Processor #3 Vendor: GenuineIntel
Processor #3 Name: Intel(R) Xeon(TM) CPU 2.80GHz
Processor #3 speed: 2793.478 MHz
Processor #3 cache size: 1024 KB
Processor #4 Vendor: GenuineIntel
Processor #4 Name: Intel(R) Xeon(TM) CPU 2.80GHz
Processor #4 speed: 2793.478 MHz
Processor #4 cache size: 1024 KB
3GB ram
Apache/1.3.34
mysql (4.0.25)
PHP Version 4.4.1
MySQL 4.0.25
3 no innodb types
4- It was compiled using cpanel's mysql script (/scripts/mysqlup)
5- Some time i have high load up to 20
top - 10:55:13 up 22:01, 1 user, load average: 1.62, 1.28, 1.13
Tasks: 239 total, 8 running, 230 sleeping, 0 stopped, 1 zombie
Cpu(s): 44.5% us, 16.0% sy, 0.0% ni, 38.7% id, 0.9% wa, 0.0% hi, 0.0% si
Mem: 3113860k total, 2802744k used, 311116k free, 77756k buffers
Swap: 10482404k total, 10948k used, 10471456k free, 1587264k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11768 mysql 16 0 491m 216m 2068 S 46.1 7.1 0:05.93 mysqld
11348 nobody 15 0 22932 13m 3880 S 19.7 0.4 0:08.90 httpd
11766 mysql 16 0 491m 216m 2068 R 19.4 7.1 0:02.87 mysqld
11877 nobody 15 0 22952 13m 3864 S 15.5 0.4 0:02.17 httpd
11807 mysql 15 0 491m 217m 2068 S 15.1 7.1 0:03.32 mysqld
12111 nobody 15 0 19748 10m 3852 S 11.5 0.3 0:00.57 httpd
12105 nobody 18 0 21416 11m 3820 S 11.2 0.4 0:00.42 httpd
12089 nobody 15 0 19856 10m 3848 S 10.9 0.3 0:00.33 httpd
11801 mysql 15 0 491m 216m 2068 S 10.5 7.1 0:01.48 mysqld
10594 mysql 16 0 491m 216m 2068 R 8.6 7.1 0:25.15 mysqld
12100 nobody 17 0 19992 10m 3820 R 6.6 0.3 0:00.20 httpd
11812 mysql 16 0 491m 217m 2068 R 6.3 7.1 0:06.55 mysqld
12121 nobody 16 0 19068 9812 3788 R 6.3 0.3 0:00.21 httpd
12113 nobody 17 0 20184 10m 3848 S 4.9 0.4 0:00.68 httpd
12118 nobody 15 0 22220 12m 3804 S 4.9 0.4 0:00.15 httpd
11662 nobody 17 0 22592 13m 3876 S 4.6 0.4 0:09.31 httpd
12107 nobody 16 0 22596 13m 3868 S 4.6 0.4 0:00.42 httpd
11822 nobody 16 0 19820 10m 3876 S 4.3 0.4 0:02.71 httpd
11751 nobody 16 0 22824 13m 3892 S 3.9 0.4 0:03.53 httpd
11824 nobody 16 0 20248 10m 3856 S 3.3 0.4 0:02.65 httpd
11666 nobody 16 0 20344 11m 3880 R 2.6 0.4 0:08.03 httpd
11823 nobody 15 0 22820 13m 3872 S 2.6 0.4 0:03.70 httpd
12095 nobody 16 0 19860 10m 3824 S 2.6 0.3 0:00.41 httpd
11830 nobody 15 0 19788 10m 3880 S 2.3 0.3 0:02.83 httpd
5301 mysql 15 0 491m 216m 2068 S 2.0 7.1 0:57.87 mysqld
11610 nobody 15 0 22564 13m 3864 S 1.6 0.4 0:10.79 httpd
11697 mysql 16 0 491m 216m 2068 S 1.6 7.1 0:11.37 mysqld
11658 nobody 15 0 22800 13m 3876 S 1.3 0.4 0:10.33 httpd
11767 mysql 16 0 491m 216m 2068 S 1.3 7.1 0:07.93 mysqld
12142 root 19 0 10392 3868 2820 S 1.0 0.1 0:00.03 exim
5836 mysql 15 0 491m 216m 2068 S 0.7 7.1 1:10.38 mysqld
11782 mysql 16 0 491m 216m 2068 S 0.7 7.1 0:06.48 mysqld
11967 root 16 0 3540 1056 744 R 0.7 0.0 0:00.24 top
12098 nobody 16 0 20052 10m 3852 S 0.7 0.4 0:00.42 httpd
27498 mysql 15 0 491m 216m 2068 S 0.3 7.1 0:09.89 mysqld
11665 nobody 16 0 21008 11m 3856 S 0.3 0.4 0:06.83 httpd
12119 nobody 15 0 19956 10m 3852 S 0.3 0.3 0:00.63 httpd
1 root 16 0 2408 556 476 S 0.0 0.0 0:01.77 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.04 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.03 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
6 root RT 0 0 0 0 S 0.0 0.0 0:00.03 migration/2
7 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
8 root RT 0 0 0 0 S 0.0 0.0 0:00.03 migration/3
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
10 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
11 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1
12 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/2
13 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/3
14 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
15 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 kacpid
42 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0
6- [mysqld]
set-variable = max_connections=500
safe-show-database
7- +--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 217 |
| Aborted_connects | 1 |
| Bytes_received | 343961776 |
| Bytes_sent | 1283904081 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 114407 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 10202 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 19625 |
| Com_insert_select | 2202 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 22 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 3132 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 439412 |
| Com_set_option | 30 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 92 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 54 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 10 |
| Com_show_variables | 20 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 22 |
| Com_update | 130243 |
| Com_update_multi | 8 |
| Connections | 114638 |
| Created_tmp_disk_tables | 1142 |
| Created_tmp_tables | 42799 |
| Created_tmp_files | 3 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 17318 |
| Handler_read_first | 61771 |
| Handler_read_key | 51134043 |
| Handler_read_next | 253996096 |
| Handler_read_prev | 1101060 |
| Handler_read_rnd | 83970723 |
| Handler_read_rnd_next | 236364159 |
| Handler_rollback | 0 |
| Handler_update | 223650 |
| Handler_write | 38729495 |
| Key_blocks_used | 154433 |
| Key_read_requests | 176684031 |
| Key_reads | 153722 |
| Key_write_requests | 203441 |
| Key_writes | 98133 |
| Max_used_connections | 122 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 512 |
| Open_files | 665 |
| Open_streams | 0 |
| Opened_tables | 1159 |
| Questions | 1281287 |
| Qcache_queries_in_cache | 2142 |
| Qcache_inserts | 435449 |
| Qcache_hits | 447391 |
| Qcache_lowmem_prunes | 16714 |
| Qcache_not_cached | 3963 |
| Qcache_free_memory | 4540176 |
| Qcache_free_blocks | 1398 |
| Qcache_total_blocks | 6309 |
| Rpl_status | NULL |
| Select_full_join | 55 |
| Select_full_range_join | 14 |
| Select_range | 93075 |
| Select_range_check | 0 |
| Select_scan | 74419 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 63 |
| Sort_merge_passes | 0 |
| Sort_range | 98868 |
| Sort_rows | 86611181 |
| Sort_scan | 42708 |
| Table_locks_immediate | 1155061 |
| Table_locks_waited | 11509 |
| Threads_cached | 7 |
| Threads_created | 752 |
| Threads_connected | 27 |
| Threads_running | 1 |
| Uptime | 27170 |
+--------------------------+------------+
8- yes only .
9-
current:1100
Max: 2000
Cookie timeout: 3600
10- http://72.35.73.149/phpinfo.php
11-
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 10
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
MaxRequestsPerChild 100
12- 3.5.1
13. no log files that size were found
1- dedicated .
2- Processor InformationProcessor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(TM) CPU 2.80GHz
Processor #1 speed: 2793.478 MHz
Processor #1 cache size: 1024 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(TM) CPU 2.80GHz
Processor #2 speed: 2793.478 MHz
Processor #2 cache size: 1024 KB
Processor #3 Vendor: GenuineIntel
Processor #3 Name: Intel(R) Xeon(TM) CPU 2.80GHz
Processor #3 speed: 2793.478 MHz
Processor #3 cache size: 1024 KB
Processor #4 Vendor: GenuineIntel
Processor #4 Name: Intel(R) Xeon(TM) CPU 2.80GHz
Processor #4 speed: 2793.478 MHz
Processor #4 cache size: 1024 KB
3GB ram
Apache/1.3.34
mysql (4.0.25)
PHP Version 4.4.1
MySQL 4.0.25
3 no innodb types
4- It was compiled using cpanel's mysql script (/scripts/mysqlup)
5- Some time i have high load up to 20
top - 10:55:13 up 22:01, 1 user, load average: 1.62, 1.28, 1.13
Tasks: 239 total, 8 running, 230 sleeping, 0 stopped, 1 zombie
Cpu(s): 44.5% us, 16.0% sy, 0.0% ni, 38.7% id, 0.9% wa, 0.0% hi, 0.0% si
Mem: 3113860k total, 2802744k used, 311116k free, 77756k buffers
Swap: 10482404k total, 10948k used, 10471456k free, 1587264k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11768 mysql 16 0 491m 216m 2068 S 46.1 7.1 0:05.93 mysqld
11348 nobody 15 0 22932 13m 3880 S 19.7 0.4 0:08.90 httpd
11766 mysql 16 0 491m 216m 2068 R 19.4 7.1 0:02.87 mysqld
11877 nobody 15 0 22952 13m 3864 S 15.5 0.4 0:02.17 httpd
11807 mysql 15 0 491m 217m 2068 S 15.1 7.1 0:03.32 mysqld
12111 nobody 15 0 19748 10m 3852 S 11.5 0.3 0:00.57 httpd
12105 nobody 18 0 21416 11m 3820 S 11.2 0.4 0:00.42 httpd
12089 nobody 15 0 19856 10m 3848 S 10.9 0.3 0:00.33 httpd
11801 mysql 15 0 491m 216m 2068 S 10.5 7.1 0:01.48 mysqld
10594 mysql 16 0 491m 216m 2068 R 8.6 7.1 0:25.15 mysqld
12100 nobody 17 0 19992 10m 3820 R 6.6 0.3 0:00.20 httpd
11812 mysql 16 0 491m 217m 2068 R 6.3 7.1 0:06.55 mysqld
12121 nobody 16 0 19068 9812 3788 R 6.3 0.3 0:00.21 httpd
12113 nobody 17 0 20184 10m 3848 S 4.9 0.4 0:00.68 httpd
12118 nobody 15 0 22220 12m 3804 S 4.9 0.4 0:00.15 httpd
11662 nobody 17 0 22592 13m 3876 S 4.6 0.4 0:09.31 httpd
12107 nobody 16 0 22596 13m 3868 S 4.6 0.4 0:00.42 httpd
11822 nobody 16 0 19820 10m 3876 S 4.3 0.4 0:02.71 httpd
11751 nobody 16 0 22824 13m 3892 S 3.9 0.4 0:03.53 httpd
11824 nobody 16 0 20248 10m 3856 S 3.3 0.4 0:02.65 httpd
11666 nobody 16 0 20344 11m 3880 R 2.6 0.4 0:08.03 httpd
11823 nobody 15 0 22820 13m 3872 S 2.6 0.4 0:03.70 httpd
12095 nobody 16 0 19860 10m 3824 S 2.6 0.3 0:00.41 httpd
11830 nobody 15 0 19788 10m 3880 S 2.3 0.3 0:02.83 httpd
5301 mysql 15 0 491m 216m 2068 S 2.0 7.1 0:57.87 mysqld
11610 nobody 15 0 22564 13m 3864 S 1.6 0.4 0:10.79 httpd
11697 mysql 16 0 491m 216m 2068 S 1.6 7.1 0:11.37 mysqld
11658 nobody 15 0 22800 13m 3876 S 1.3 0.4 0:10.33 httpd
11767 mysql 16 0 491m 216m 2068 S 1.3 7.1 0:07.93 mysqld
12142 root 19 0 10392 3868 2820 S 1.0 0.1 0:00.03 exim
5836 mysql 15 0 491m 216m 2068 S 0.7 7.1 1:10.38 mysqld
11782 mysql 16 0 491m 216m 2068 S 0.7 7.1 0:06.48 mysqld
11967 root 16 0 3540 1056 744 R 0.7 0.0 0:00.24 top
12098 nobody 16 0 20052 10m 3852 S 0.7 0.4 0:00.42 httpd
27498 mysql 15 0 491m 216m 2068 S 0.3 7.1 0:09.89 mysqld
11665 nobody 16 0 21008 11m 3856 S 0.3 0.4 0:06.83 httpd
12119 nobody 15 0 19956 10m 3852 S 0.3 0.3 0:00.63 httpd
1 root 16 0 2408 556 476 S 0.0 0.0 0:01.77 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.04 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.03 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
6 root RT 0 0 0 0 S 0.0 0.0 0:00.03 migration/2
7 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
8 root RT 0 0 0 0 S 0.0 0.0 0:00.03 migration/3
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
10 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
11 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1
12 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/2
13 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/3
14 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
15 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 kacpid
42 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0
6- [mysqld]
set-variable = max_connections=500
safe-show-database
7- +--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 217 |
| Aborted_connects | 1 |
| Bytes_received | 343961776 |
| Bytes_sent | 1283904081 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 114407 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 10202 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 19625 |
| Com_insert_select | 2202 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 22 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 3132 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 439412 |
| Com_set_option | 30 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 92 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 54 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 10 |
| Com_show_variables | 20 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 22 |
| Com_update | 130243 |
| Com_update_multi | 8 |
| Connections | 114638 |
| Created_tmp_disk_tables | 1142 |
| Created_tmp_tables | 42799 |
| Created_tmp_files | 3 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 17318 |
| Handler_read_first | 61771 |
| Handler_read_key | 51134043 |
| Handler_read_next | 253996096 |
| Handler_read_prev | 1101060 |
| Handler_read_rnd | 83970723 |
| Handler_read_rnd_next | 236364159 |
| Handler_rollback | 0 |
| Handler_update | 223650 |
| Handler_write | 38729495 |
| Key_blocks_used | 154433 |
| Key_read_requests | 176684031 |
| Key_reads | 153722 |
| Key_write_requests | 203441 |
| Key_writes | 98133 |
| Max_used_connections | 122 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 512 |
| Open_files | 665 |
| Open_streams | 0 |
| Opened_tables | 1159 |
| Questions | 1281287 |
| Qcache_queries_in_cache | 2142 |
| Qcache_inserts | 435449 |
| Qcache_hits | 447391 |
| Qcache_lowmem_prunes | 16714 |
| Qcache_not_cached | 3963 |
| Qcache_free_memory | 4540176 |
| Qcache_free_blocks | 1398 |
| Qcache_total_blocks | 6309 |
| Rpl_status | NULL |
| Select_full_join | 55 |
| Select_full_range_join | 14 |
| Select_range | 93075 |
| Select_range_check | 0 |
| Select_scan | 74419 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 63 |
| Sort_merge_passes | 0 |
| Sort_range | 98868 |
| Sort_rows | 86611181 |
| Sort_scan | 42708 |
| Table_locks_immediate | 1155061 |
| Table_locks_waited | 11509 |
| Threads_cached | 7 |
| Threads_created | 752 |
| Threads_connected | 27 |
| Threads_running | 1 |
| Uptime | 27170 |
+--------------------------+------------+
8- yes only .
9-
current:1100
Max: 2000
Cookie timeout: 3600
10- http://72.35.73.149/phpinfo.php
11-
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 10
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
MaxRequestsPerChild 100
12- 3.5.1
13. no log files that size were found