Out of ideas, any suggestions, I am in a real pickle!

[Guidster]

I have a new Rackshack dedicated server that is currently put to shame by my old virtual server. I am sure that the issues are configuration related, but I have not been able to track the issue(s) down to a specific cause. One of the first things that was done on the box was to fall back to MySql 3.23.56 based on all of the bad 4.0.12 press that I have seen here.

What I saw initially was fairly speedy response from the box, but it would degrade over time. Forum Home would load in under a second and degrade to the 8-9 second range. My site is all that is running on the box and the server load is nonexistent. I rarely have over 30 people on at one time.

To try and pep the box up, I installed php accelerator, but have since disabled it. I have also tried running with and without the Zend Optimizer as well. I have recompiled Apache many times, played with httpd.conf from reading here as well as my.cnf and php.ini. I am at my wits end. I believe that the problem lies with the php execution, but this is just my gut feeling as the delivery of the data once "chugged" is pretty peppy.

Thanks for any and all assistance you can provide!

Here is the scoop on the box:

The server is a P4 2Ghz box with 512MB Ram with 80Gb of EIDE drive.
Redhat Linux 7.3
PHP 4.3.1
Apache 1.3.27
MySql 3.23.56


MySql was compiled via Cpanel RPM I believe as Rackshack support did this for me after it failed once they performed the SQL roll back.

Top Stats:

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
22089 nobody 15 0 5820 5816 4080 S 2.9 1.1 0:00 httpd
22102 mysql 15 0 2144 2144 1204 S 0.5 0.4 0:00 mysqld
22110 root 15 0 996 996 792 R 0.1 0.1 0:00 top
1 root 15 0 480 480 416 S 0.0 0.0 0:08 init
2 root 15 0 0 0 0 SW 0.0 0.0 0:00 keventd
3 root 15 0 0 0 0 SW 0.0 0.0 0:04 kapmd
4 root 34 19 0 0 0 SWN 0.0 0.0 0:02 ksoftirqd_CPU0
5 root 15 0 0 0 0 SW 0.0 0.0 0:10 kswapd
6 root 25 0 0 0 0 SW 0.0 0.0 0:00 bdflush
7 root 15 0 0 0 0 SW 0.0 0.0 0:06 kupdated
8 root 25 0 0 0 0 SW 0.0 0.0 0:00 mdrecoveryd
12 root 15 0 0 0 0 SW 0.0 0.0 0:30 kjournald
90 root 15 0 0 0 0 SW 0.0 0.0 0:00 khubd
285 root 15 0 0 0 0 SW 0.0 0.0 0:01 kjournald
605 root 15 0 0 0 0 SW 0.0 0.0 0:00 eth0
710 root 15 0 552 552 460 S 0.0 0.1 0:00 syslogd
715 root 15 0 456 452 388 S 0.0 0.0 0:00 klogd
862 nobody 15 0 1212 1164 972 S 0.0 0.2 0:00 proftpd
1251 root 15 0 1224 1216 1092 S 0.0 0.2 0:01 sshd
1302 root 15 0 1324 1304 1128 S 0.0 0.2 0:08 antirelayd
1321 root 16 0 2580 1920 1376 S 0.0 0.3 0:06 chkservd
1354 root 34 19 4832 4340 1788 S N 0.0 0.8 0:00 cpanellogd
1356 root 15 0 3228 2880 1996 S 0.0 0.5 0:00 cpaneld
1361 root 15 0 2840 2552 1852 S 0.0 0.5 0:00 webmaild
1377 root 15 0 3976 3760 2372 S 0.0 0.7 0:00 cppop
1383 nobody 17 0 1980 1540 1312 S 0.0 0.3 0:00 entropychat
1388 nobody 16 0 592 592 356 S 0.0 0.1 0:00 melange
1399 cpanel 15 0 1704 1700 1320 S 0.0 0.3 0:00 stunnel-4.04loc
1404 cpanel 15 0 1704 1700 1320 S 0.0 0.3 0:01 stunnel-4.04loc
1410 root 15 0 3264 2888 2044 S 0.0 0.5 0:00 whostmgrd
1433 root 15 0 1332 1308 1116 S 0.0 0.2 0:00 exim
1441 root 15 0 1224 1212 1048 S 0.0 0.2 0:08 antirelayd
1533 named 15 0 2532 2524 1896 S 0.0 0.4 0:00 named
1535 named 15 0 2532 2524 1896 S 0.0 0.4 0:01 named
1536 named 15 0 2532 2524 1896 S 0.0 0.4 0:00 named
1537 named 15 0 2532 2524 1896 S 0.0 0.4 0:00 named
1538 named 15 0 2532 2524 1896 S 0.0 0.4 0:00 named
1547 root 15 0 14024 12M 1672 S 0.0 2.4 0:00 spamd


My.cnf:

[mysqld]
set-variable = max_connections=500
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=128
set-variable = wait_timeout=14400
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10

[mysql.server]
user=mysql
basedir=/var/lib/mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=8192

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

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


MySQLinfo.php Information:
Sun May 18 20:54:41 CDT 2003


8:54pm up 10:57, 0 users, load average: 0.01, 0.04, 0.00
74 processes: 73 sleeping, 1 running, 0 zombie, 0 stopped
Mem: 506024K av, 397212K used, 108812K free, 0K shrd, 36064K buff
Swap: 1044216K av, 4976K used, 1039240K free 265352K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
21344 nobody 15 0 996 996 788 R 0.0 0.1 0:00 top


Http processes currently running = 13
Mysql processes currently running = 16

Netstat information summary
3 ESTABLISHED
24 LISTEN


+---------------------------+-----------------+
| Variable_name | Value |
+---------------------------+-----------------+
| Aborted_clients | 6 |
| Aborted_connects | 1 |
| Bytes_received | 11080662 |
| Bytes_sent | 166838481 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 5355 |
| 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 | 459 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 532 |
| Com_insert_select | 17 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 4 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 39 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 64567 |
| Com_set_option | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 1 |
| Com_show_fields | 0 |
| 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 | 131 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 2 |
| Com_show_variables | 5 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 13383 |
| Connections | 3419 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 3144 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 723 |
| Handler_read_first | 3596 |
| Handler_read_key | 305428 |
| Handler_read_next | 313096 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 474884 |
| Handler_read_rnd_next | 2043009 |
| Handler_update | 21526 |
| Handler_write | 84212 |
| Key_blocks_used | 1373 |
| Key_read_requests | 1429308 |
| Key_reads | 1332 |
| Key_write_requests | 2525 |
| Key_writes | 2359 |
| Max_used_connections | 9 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 115 | 11% of table_cache in use
| Open_files | 218 |
| Open_streams | 0 |
| Opened_tables | 125 |
| Questions | 87909 |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 16710 |
| Select_range_check | 0 |
| Select_scan | 19396 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 1 | (execution time > 10 secs)
| Sort_merge_passes | 0 |
| Sort_range | 17464 |
| Sort_rows | 478719 |
| Sort_scan | 6949 |
| Table_locks_immediate | 86597 |
| Table_locks_waited | 3 |
| Threads_cached | 9 |
| Threads_created | 10 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 39352 | 10 hrs 55 mins 52 secs
+---------------------------+-----------------+


Key Reads/Key Read Requests = 0.000932 (Cache hit = 99.999068%)
Key Writes/Key Write Requests = 0.934257
Connections/second = 0.087 (/hour = 312.777)
KB received/second = 0.275 (/hour = 989.835)
KB sent/second = 4.140 (/hour = 14904.981)
Temporary Tables Created/second = 0.080 (/hour = 287.619)
Opened Tables/second = 0.003 (/hour = 11.435)
Slow Queries/second = 0.000 (/hour = 0.091)
% of slow queries = 0.001%
Queries/second = 2.234 (/hour = 8042.092)


PHPINFO.PHP Information:

PHP Version 4.3.1

System Linux server1.allthingsmoto.com 2.4.18-27.7.x #1 Fri Mar 14 06:44:53 EST 2003 i686
Build Date May 18 2003 11:29:03
Configure Command './configure' '--with-apxs=/usr/local/apache/bin/apxs' '--with-xml' '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--with-gd' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr' '--with-xpm-dir=/usr/X11R6' '--with-imap' '--with-imap-ssl' '--with-kerberos' '--with-mcrypt' '--enable-magic-quotes' '--with-mysql' '--with-pear' '--enable-sockets' '--enable-track-vars' '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf' '--enable-versioning' '--with-zlib'
Server API Apache
Virtual Directory Support disabled
Configuration File (php.ini) Path /usr/local/Zend/etc/php.ini
PHP API 20020918
PHP Extension 20020429
Zend Extension 20021010
Debug Build no
Thread Safety disabled
Registered PHP Streams php, http, ftp, compress.zlib

This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright (c) 1998-2002 Zend Technologies with Zend Optimizer v2.1.0, Copyright (c) 1998-2003, by Zend Technologies


Apache Information (From Phpinfo.php):

apache
APACHE_INCLUDE no value
APACHE_TARGET no value
Apache Version Apache/1.3.27
Apache Release 10327100
Apache API Version 19990320
Hostname:Port http://www.allthingsmoto.com:80
User/Group nobody(99)/99
Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 200
Timeouts Connection: 60 - Keep-Alive: 15
Server Root /usr/local/apache
Loaded Modules mod_log_bytes, mod_bwlimited, mod_php4, mod_frontpage, mod_setenvif, mod_so, mod_auth, mod_access, mod_rewrite, mod_alias, mod_userdir, mod_actions, mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_status, mod_negotiation, mod_mime, mod_log_config, mod_env, http_core

HTTPD.Conf:
KeepAlive=on
MaxKeepAliveRequests=200
KeepAliveTimeout=15
MinSpareServers=5
MaxSpareServers=10
StartServers=5
MaxClients=150

I am running Vb 2.2.9.

Thanks for any and all assistance you are able to provide!

Also, I have been using the Cpanel EasyApache script to compile Apache if this is pertinent.

[Link14716]

This doesn't have much to do with PHP or MySQL, so I'd suggest asking it in the "Server Configuration" forum at vB.com.