ladyfyre
Sat 1st Nov '03, 6:02pm
We are putting a new server online and it is behaving strangely. We know that we do not have a mysql issue because our current server is working with it and we can pull up the admin/index.php page with no problems. We cannot load the index.php, default.php and many other pages. We tried with the redhat 8.0 packages and a scratch install of Apache 2.0.48 and PHP 4.3.3. Here is all the needed server info minus the mysql stuff:
1. Dedicated server owned by us
2. 2x Xeon 2.4Ghz, 6 GB RAM, hardware Raid 5 36GB, RedHat 8.0 (latest patches), fresh install of Apache 2.0.48 and PHP 4.33, MySQL server (seperate box) running RedHat 8.0 and MySQL 3.23.54a
3. See above
4. Installed from MySQL rpms, if I remember correctly
5. average 250 users logged in at any time, max is currently 457 on current server
6. my.cnf settings:
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = max_connections=550
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=6000
set-variable = connect_timeout=10
[safe_mysqld]
open-files-limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=128M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
7. extended stats:
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 1160 |
| Aborted_connects | 15486 |
| Bytes_received | 2945847303 |
| Bytes_sent | 2583381431 |
| Com_admin_commands | 2 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 38265879 |
| Com_change_master | 0 |
| Com_check | 957 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 1834 |
| Com_delete | 3605717 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 1918 |
| Com_flush | 1 |
| Com_grant | 0 |
| Com_insert | 15930833 |
| Com_insert_select | 30696 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 939 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 106200 |
| Com_replace_select | 1817 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 712465356 |
| Com_set_option | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 5 |
| Com_show_fields | 44 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 37054475 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 12 |
| Com_show_variables | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 87720788 |
| Connections | 1227111 |
| Created_tmp_disk_tables | 31114327 |
| Created_tmp_tables | 46672757 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 6249579 |
| Handler_read_first | 10727554 |
| Handler_read_key | 305507941 |
| Handler_read_next | 3744669700 |
| Handler_read_prev | 1508 |
| Handler_read_rnd | 3940891734 |
| Handler_read_rnd_next | 1722540324 |
| Handler_update | 644218206 |
| Handler_write | 2305236154 |
| Key_blocks_used | 15582 |
| Key_read_requests | 845106755 |
| Key_reads | 27615538 |
| Key_write_requests | 39277603 |
| Key_writes | 36154687 |
| Max_used_connections | 157 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 541 |
| Open_files | 612 |
| Open_streams | 0 |
| Opened_tables | 20482 |
| Questions | 859345469 |
| Select_full_join | 30571 |
| Select_full_range_join | 46 |
| Select_range | 210758522 |
| Select_range_check | 0 |
| Select_scan | 129709596 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 450 |
| Sort_merge_passes | 0 |
| Sort_range | 211514147 |
| Sort_rows | 1153877953 |
| Sort_scan | 75558563 |
| Table_locks_immediate | 932995619 |
| Table_locks_waited | 9420199 |
| Threads_cached | 121 |
| Threads_created | 158 |
| Threads_connected | 37 |
| Threads_running | 2 |
| Uptime | 8875531 |
+--------------------------+------------+
Uptime: 8875531 Threads: 37 Questions: 859345470 Slow queries: 450 Opens: 20482 Flush tables: 1 Open tables: 541 Queries per second avg: 96.822
8. vB is the only thing running on the DB server and the server we are having problems with
9. average is around 200 and max is 450 on old server, new server not online yet
10. http://216.65.38.14/phpinfo.php
11. Keepalive = on
MaxKeepAliveRequests = 100
KeepAliveTimeout 15
Prefork MPM
StartServers 5
MinSpareServers 5
MaxSpareServers 10
MaxClients 150
Worker MPM
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
Running a very hacked version of 2.2.8
Any ideas anyone? Our current server is getting pretty slow and we need to get this new one up and running sometime soon. Any help would be appreciated.
1. Dedicated server owned by us
2. 2x Xeon 2.4Ghz, 6 GB RAM, hardware Raid 5 36GB, RedHat 8.0 (latest patches), fresh install of Apache 2.0.48 and PHP 4.33, MySQL server (seperate box) running RedHat 8.0 and MySQL 3.23.54a
3. See above
4. Installed from MySQL rpms, if I remember correctly
5. average 250 users logged in at any time, max is currently 457 on current server
6. my.cnf settings:
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = max_connections=550
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=6000
set-variable = connect_timeout=10
[safe_mysqld]
open-files-limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=128M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
7. extended stats:
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 1160 |
| Aborted_connects | 15486 |
| Bytes_received | 2945847303 |
| Bytes_sent | 2583381431 |
| Com_admin_commands | 2 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 38265879 |
| Com_change_master | 0 |
| Com_check | 957 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 1834 |
| Com_delete | 3605717 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 1918 |
| Com_flush | 1 |
| Com_grant | 0 |
| Com_insert | 15930833 |
| Com_insert_select | 30696 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 939 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 106200 |
| Com_replace_select | 1817 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 712465356 |
| Com_set_option | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 5 |
| Com_show_fields | 44 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 37054475 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 12 |
| Com_show_variables | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 87720788 |
| Connections | 1227111 |
| Created_tmp_disk_tables | 31114327 |
| Created_tmp_tables | 46672757 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 6249579 |
| Handler_read_first | 10727554 |
| Handler_read_key | 305507941 |
| Handler_read_next | 3744669700 |
| Handler_read_prev | 1508 |
| Handler_read_rnd | 3940891734 |
| Handler_read_rnd_next | 1722540324 |
| Handler_update | 644218206 |
| Handler_write | 2305236154 |
| Key_blocks_used | 15582 |
| Key_read_requests | 845106755 |
| Key_reads | 27615538 |
| Key_write_requests | 39277603 |
| Key_writes | 36154687 |
| Max_used_connections | 157 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 541 |
| Open_files | 612 |
| Open_streams | 0 |
| Opened_tables | 20482 |
| Questions | 859345469 |
| Select_full_join | 30571 |
| Select_full_range_join | 46 |
| Select_range | 210758522 |
| Select_range_check | 0 |
| Select_scan | 129709596 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 450 |
| Sort_merge_passes | 0 |
| Sort_range | 211514147 |
| Sort_rows | 1153877953 |
| Sort_scan | 75558563 |
| Table_locks_immediate | 932995619 |
| Table_locks_waited | 9420199 |
| Threads_cached | 121 |
| Threads_created | 158 |
| Threads_connected | 37 |
| Threads_running | 2 |
| Uptime | 8875531 |
+--------------------------+------------+
Uptime: 8875531 Threads: 37 Questions: 859345470 Slow queries: 450 Opens: 20482 Flush tables: 1 Open tables: 541 Queries per second avg: 96.822
8. vB is the only thing running on the DB server and the server we are having problems with
9. average is around 200 and max is 450 on old server, new server not online yet
10. http://216.65.38.14/phpinfo.php
11. Keepalive = on
MaxKeepAliveRequests = 100
KeepAliveTimeout 15
Prefork MPM
StartServers 5
MinSpareServers 5
MaxSpareServers 10
MaxClients 150
Worker MPM
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
Running a very hacked version of 2.2.8
Any ideas anyone? Our current server is getting pretty slow and we need to get this new one up and running sometime soon. Any help would be appreciated.