Next
Fri 9th Jan '04, 7:16pm
Hello,
Please advise me server optimzation for my new server. Your help is very much appreciated. Below is detail of my server.
1. Dedicated
2. Server Specifications
cpu speed/type single or dual cpus): P4 2.8GHz
how much memory installed: 1GB
hard drive type/configuration: 73GB SCSI
linux distributor or windows version: redhat linux 9
apache/IIS version: 1.3.29 (Unix)
PHP version: php 4.3.3
MySQL version: mysql 4.0.15-standard
3. Not sure.
4. Preinstalled by ServerMatrix
5. Average 100-200, Max 600 - 700 users if its server load, than i just moved to this server so cant really say how much. but on my ev1 server it touch 2.5 to 4
6. my.cnf contain following only.
[mysqld]
set-variable = max_connections=500
safe-show-database
7. mysql info
Fri Jan 9 16:56:08 CST 2004
16:56:09 up 1 day, 18:23, 2 users, load average: 0.20, 0.09, 0.04
89 processes: 88 sleeping, 1 running, 0 zombie, 0 stopped
Mem: 1022792k av, 1008540k used, 14252k free, 0k shrd, 93936k buff
769736k actv, 340k in_d, 17324k in_c
Swap: 2040244k av, 97344k used, 1942900k free 750828k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
14299 nobody 20 0 1184 1184 856 R 0.0 0.1 0:00 0 top
Http processes currently running = 14
Mysql processes currently running = 3
Netstat information summary
1 CLOSE_WAIT
6 TIME_WAIT
7 ESTABLISHED
30 LISTEN
+---------------------------+-----------------+
| Variable_name | Value |
+---------------------------+-----------------+
| Aborted_clients | 4 |
| Aborted_connects | 8 |
| Bytes_received | 2429845650 |
| Bytes_sent | 78288034 |
| Com_admin_commands | 0 |
| Com_alter_table | 26 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1306 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 6 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 299 |
| Com_delete | 1020 |
| Com_delete_multi | 0 |
| Com_drop_db | 1 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 89 |
| Com_flush | 66 |
| Com_grant | 59 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 1414896 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 281 |
| Com_optimize | 1 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 1 |
| Com_replace | 30 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 19941 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 237 |
| Com_show_fields | 8 |
| Com_show_grants | 19 |
| Com_show_keys | 3 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 511 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 261 |
| Com_show_variables | 26 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 281 |
| Com_update | 1243 |
| Connections | 2093 |
| Created_tmp_disk_tables | 264 |
| Created_tmp_tables | 1088 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 70 |
| Handler_read_first | 1894 |
| Handler_read_key | 246462 |
| Handler_read_next | 6426810 |
| Handler_read_prev | 1484 |
| Handler_read_rnd | 580185 |
| Handler_read_rnd_next | 30904089 |
| Handler_rollback | 1 |
| Handler_update | 128946 |
| Handler_write | 4305936 |
| Key_blocks_used | 7793 |
| Key_read_requests | 280301271 |
| Key_reads | 7664295 |
| Key_write_requests | 39460529 |
| Key_writes | 73038560 |
| Max_used_connections | 4 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 63 | 98% of table_cache in use
| Open_files | 124 |
| Open_streams | 0 |
| Opened_tables | 3580 |
| Questions | 1445448 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 14 |
| Select_full_range_join | 0 |
| Select_range | 913 |
| Select_range_check | 0 |
| Select_scan | 3878 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 105 | (execution time > 10 secs)
| Sort_merge_passes | 0 |
| Sort_range | 2174 |
| Sort_rows | 580218 |
| Sort_scan | 1265 |
| Table_locks_immediate | 1447519 |
| Table_locks_waited | 1 |
| Threads_cached | 0 |
| Threads_created | 2092 |
| Threads_connected | 3 |
| Threads_running | 1 |
| Uptime | 152581 | 1 day 18 hrs 23 mins 1 sec
+---------------------------+-----------------+
Key Reads/Key Read Requests = 0.027343 (Cache hit = 99.972657%)
Key Writes/Key Write Requests = 1.850927
Connections/second = 0.014 (/hour = 49.382)
KB received/second = 13.745 (/hour = 49480.234)
KB sent/second = 0.501 (/hour = 1803.834)
Temporary Tables Created/second = 0.007 (/hour = 25.670)
Opened Tables/second = 0.023 (/hour = 84.467)
Slow Queries/second = 0.001 (/hour = 2.477)
% of slow queries = 0.007%
Queries/second = 9.473 (/hour = 34103.937)
8. There are 4 other sites with 7 database, expected to grow in future.
9. average= 100 - 200 and Max = 600 - 700 (dependings on calander events/contest or other acvtivities once or twice a month)
10. http://69.56.214.70/forum/extras/phpinfo.php
11. values from apache server httpd.conf file:
KeepAlive on
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
12. 3.0.0 Gamma
Please advise me server optimzation for my new server. Your help is very much appreciated. Below is detail of my server.
1. Dedicated
2. Server Specifications
cpu speed/type single or dual cpus): P4 2.8GHz
how much memory installed: 1GB
hard drive type/configuration: 73GB SCSI
linux distributor or windows version: redhat linux 9
apache/IIS version: 1.3.29 (Unix)
PHP version: php 4.3.3
MySQL version: mysql 4.0.15-standard
3. Not sure.
4. Preinstalled by ServerMatrix
5. Average 100-200, Max 600 - 700 users if its server load, than i just moved to this server so cant really say how much. but on my ev1 server it touch 2.5 to 4
6. my.cnf contain following only.
[mysqld]
set-variable = max_connections=500
safe-show-database
7. mysql info
Fri Jan 9 16:56:08 CST 2004
16:56:09 up 1 day, 18:23, 2 users, load average: 0.20, 0.09, 0.04
89 processes: 88 sleeping, 1 running, 0 zombie, 0 stopped
Mem: 1022792k av, 1008540k used, 14252k free, 0k shrd, 93936k buff
769736k actv, 340k in_d, 17324k in_c
Swap: 2040244k av, 97344k used, 1942900k free 750828k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
14299 nobody 20 0 1184 1184 856 R 0.0 0.1 0:00 0 top
Http processes currently running = 14
Mysql processes currently running = 3
Netstat information summary
1 CLOSE_WAIT
6 TIME_WAIT
7 ESTABLISHED
30 LISTEN
+---------------------------+-----------------+
| Variable_name | Value |
+---------------------------+-----------------+
| Aborted_clients | 4 |
| Aborted_connects | 8 |
| Bytes_received | 2429845650 |
| Bytes_sent | 78288034 |
| Com_admin_commands | 0 |
| Com_alter_table | 26 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1306 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 6 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 299 |
| Com_delete | 1020 |
| Com_delete_multi | 0 |
| Com_drop_db | 1 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 89 |
| Com_flush | 66 |
| Com_grant | 59 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 1414896 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 281 |
| Com_optimize | 1 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 1 |
| Com_replace | 30 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 19941 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 237 |
| Com_show_fields | 8 |
| Com_show_grants | 19 |
| Com_show_keys | 3 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 511 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 261 |
| Com_show_variables | 26 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 281 |
| Com_update | 1243 |
| Connections | 2093 |
| Created_tmp_disk_tables | 264 |
| Created_tmp_tables | 1088 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 70 |
| Handler_read_first | 1894 |
| Handler_read_key | 246462 |
| Handler_read_next | 6426810 |
| Handler_read_prev | 1484 |
| Handler_read_rnd | 580185 |
| Handler_read_rnd_next | 30904089 |
| Handler_rollback | 1 |
| Handler_update | 128946 |
| Handler_write | 4305936 |
| Key_blocks_used | 7793 |
| Key_read_requests | 280301271 |
| Key_reads | 7664295 |
| Key_write_requests | 39460529 |
| Key_writes | 73038560 |
| Max_used_connections | 4 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 63 | 98% of table_cache in use
| Open_files | 124 |
| Open_streams | 0 |
| Opened_tables | 3580 |
| Questions | 1445448 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 14 |
| Select_full_range_join | 0 |
| Select_range | 913 |
| Select_range_check | 0 |
| Select_scan | 3878 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 105 | (execution time > 10 secs)
| Sort_merge_passes | 0 |
| Sort_range | 2174 |
| Sort_rows | 580218 |
| Sort_scan | 1265 |
| Table_locks_immediate | 1447519 |
| Table_locks_waited | 1 |
| Threads_cached | 0 |
| Threads_created | 2092 |
| Threads_connected | 3 |
| Threads_running | 1 |
| Uptime | 152581 | 1 day 18 hrs 23 mins 1 sec
+---------------------------+-----------------+
Key Reads/Key Read Requests = 0.027343 (Cache hit = 99.972657%)
Key Writes/Key Write Requests = 1.850927
Connections/second = 0.014 (/hour = 49.382)
KB received/second = 13.745 (/hour = 49480.234)
KB sent/second = 0.501 (/hour = 1803.834)
Temporary Tables Created/second = 0.007 (/hour = 25.670)
Opened Tables/second = 0.023 (/hour = 84.467)
Slow Queries/second = 0.001 (/hour = 2.477)
% of slow queries = 0.007%
Queries/second = 9.473 (/hour = 34103.937)
8. There are 4 other sites with 7 database, expected to grow in future.
9. average= 100 - 200 and Max = 600 - 700 (dependings on calander events/contest or other acvtivities once or twice a month)
10. http://69.56.214.70/forum/extras/phpinfo.php
11. values from apache server httpd.conf file:
KeepAlive on
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
12. 3.0.0 Gamma