Tuning assistance request

[dandanfireman]

Current number of users: 157

Server hardware:

Celeron 1Ghz
Ram 512M
IDE Hard Drive

Apache config:
MinSpareServers 15
MaxSpareServers 25
StartServers 25
MaxClients 170

my.cnf:
[mysqld]
set-variable = max_connections=500
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=2M
set-variable = record_buffer=2M
set-variable = sort_buffer=4M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=3600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
skip-locking
[safe_mysqld]
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





9:03am up 30 days, 21:45, 2 users, load average: 34.41, 29.74, 30.47
252 processes: 196 sleeping, 56 running, 0 zombie, 0 stopped
Mem: 512368K av, 425816K used, 86552K free, 0K shrd, 12432K buff
Swap: 1052216K av, 33556K used, 1018660K free 183140K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
6182 nobody 18 0 9600 9600 6956 R 16.1 1.8 0:05 httpd
6262 nobody 18 0 12748 12M 9584 R 16.1 2.4 0:04 httpd
6174 nobody 18 0 8688 8688 5928 R 8.0 1.6 0:02 httpd
7285 nobody 18 0 7912 7912 4076 R 8.0 1.5 0:01 httpd
7351 nobody 16 0 1148 1148 820 R 8.0 0.2 0:00 top
7287 nobody 16 0 8036 8036 4064 R 5.9 1.5 0:00 httpd
6175 nobody 16 0 10640 10M 6824 R 3.2 2.0 0:05 httpd
6237 nobody 16 0 10864 10M 7004 R 2.6 2.1 0:05 httpd
6683 mysql 16 0 11048 10M 1244 R 1.6 2.1 0:01 mysqld
6830 mysql 16 0 11048 10M 1244 R 1.6 2.1 0:00 mysqld
6637 mysql 16 0 11048 10M 1244 R 1.0 2.1 0:01 mysqld
6168 nobody 19 0 11844 11M 7912 R 0.0 2.3 0:05 httpd
6170 nobody 19 0 12520 12M 9436 R 0.0 2.4 0:04 httpd
6177 nobody 19 0 14360 14M 10548 R 0.0 2.8 0:06 httpd
6178 nobody 19 0 10568 10M 7444 R 0.0 2.0 0:05 httpd
6183 nobody 19 0 11104 10M 8436 R 0.0 2.1 0:07 httpd
6190 nobody 19 0 12464 12M 9216 R 0.0 2.4 0:06 httpd
6192 nobody 19 0 11376 11M 9356 R 0.0 2.2 0:07 httpd
6214 nobody 19 0 11200 10M 8164 R 0.0 2.1 0:05 httpd
6221 nobody 19 0 12552 12M 9424 R 0.0 2.4 0:05 httpd
6240 nobody 19 0 9836 9836 7860 R 0.0 1.9 0:04 httpd
6244 nobody 19 0 11892 11M 9212 R 0.0 2.3 0:05 httpd
6247 nobody 19 0 10764 10M 8724 R 0.0 2.1 0:04 httpd
6265 nobody 19 0 10484 10M 7688 R 0.0 2.0 0:02 httpd
6313 nobody 19 0 11268 11M 9064 R 0.0 2.1 0:04 httpd
6606 nobody 19 0 10608 10M 7876 R 0.0 2.0 0:03 httpd
7291 nobody 19 0 6628 6628 4092 R 0.0 1.2 0:00 httpd
7295 nobody 19 0 7100 7100 4080 R 0.0 1.3 0:00 httpd


Http processes currently running = 81
Mysql processes currently running = 100

Netstat information summary
5 CLOSE_WAIT
6 FIN_WAIT2
12 SYN_RECV
29 LISTEN
45 TIME_WAIT
55 ESTABLISHED


+---------------------------+-----------------+
| Variable_name | Value |
+---------------------------+-----------------+
| Aborted_clients | 4 |
| Aborted_connects | 0 |
| Bytes_received | 4380949 |
| Bytes_sent | 99291582 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 974 |
| 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 | 47 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 252 |
| Com_insert_select | 2 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 13 |
| Com_replace_select | 2 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 859 |
| Com_select | 23408 |
| Com_set_option | 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_open_tables | 0 |
| Com_show_processlist | 2 |
| Com_show_slave_status | 0 |
| Com_show_status | 132 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 3 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 1415 |
| Connections | 847 |
| Created_tmp_disk_tables | 43 |
| Created_tmp_tables | 695 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 115 |
| Handler_read_first | 1206 |
| Handler_read_key | 142665 |
| Handler_read_next | 1652874 |
| Handler_read_prev | 332 |
| Handler_read_rnd | 161308 |
| Handler_read_rnd_next | 5211957 |
| Handler_update | 8842 |
| Handler_write | 23391 |
| Key_blocks_used | 1134 |
| Key_read_requests | 790519 |
| Key_reads | 1101 |
| Key_write_requests | 843 |
| Key_writes | 648 |
| Max_used_connections | 93 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 156 | 15% of table_cache in use
| Open_files | 271 |
| Open_streams | 0 |
| Opened_tables | 164 |
| Questions | 27734 |
| Select_full_join | 38 |
| Select_full_range_join | 21 |
| Select_range | 5704 |
| Select_range_check | 0 |
| Select_scan | 6814 |
| 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 | 8119 |
| Sort_rows | 708838 |
| Sort_scan | 3157 |
| Table_locks_immediate | 29358 |
| Table_locks_waited | 77 |
| Threads_cached | 6 |
| Threads_created | 94 |
| Threads_connected | 88 |
| Threads_running | 1 |
| Uptime | 695 | 11 mins 35 secs
+---------------------------+-----------------+


Key Reads/Key Read Requests = 0.001393 (Cache hit = 99.998607%)
Key Writes/Key Write Requests = 0.768683
Connections/second = 1.219 (/hour = 4387.338)
KB received/second = 6.155 (/hour = 22159.424)
KB sent/second = 139.517 (/hour = 502259.568)
Temporary Tables Created/second = 1.000 (/hour = 3600.000)
Opened Tables/second = 0.236 (/hour = 849.496)
Slow Queries/second = 0.001 (/hour = 5.180)
% of slow queries = 0.004%
Queries/second = 39.905 (/hour = 143658.129)

[dandanfireman]

I have more stats if you are interested.

[eva2000]

Originally posted by dandanfireman
I have more stats if you are interested. you're sure that's maxclients = 15 or 150 ?

[dandanfireman]

Sorry, typo. It is currently 170.

[dandanfireman]

try using [ code ] tags

[dandanfireman]

http://64.191.29.239/mysqlinfo.php

[marocnl]

Can anybody answer this thread and comeup with some useful tips of how to speed up things?

We just upgraded 2 a p4 1.6 Ghz 1 G DDR

It's still not quite doing the trick. Tsjek it on www.maroc.nl (http://www.maroc.nl)

[eva2000]

Originally posted by dandanfireman
http://64.191.29.239/mysqlinfo.php

1. change my.cnf to below one and restart mysql

set-variable = max_connections=350
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=64
set-variable = wait_timeout=7200
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
skip-locking

[safe_mysqld]
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


2. change httpd.conf's maxclients back from 170 to 150 and restart apache

3. max sure you have latest stable 2.4.x kernel, PHP 4.2.3 and MySQL 3.23.53a

[dandanfireman]

<PRE>changes made. here is what happened next day with 202 users</PRE><PRE> </PRE><PRE>Thu Nov 28 07:43:58 EST 2002 7:44am up 6:38, 1 user, load average: 167.29, 80.73, 34.51521 processes: 319 sleeping, 201 running, 1 zombie, 0 stoppedMem: 1031512K av, 1018096K used, 13416K free, 0K shrd, 84056K buffSwap: 1052216K av, 27736K used, 1024480K free 574408K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND15979 nobody 17 0 9364 9204 7712 R 5.3 0.8 0:03 httpd16456 nobody 17 0 7384 7224 5880 R 4.1 0.7 0:00 httpd16543 nobody 17 0 1328 1328 820 R 4.1 0.1 0:00 top15144 nobody 18 0 12252 11M 10484 R 3.5 1.1 0:05 httpd15175 nobody 19 0 12332 11M 10620 R 3.5 1.1 0:03 httpd15176 nobody 18 0 14720 14M 10744 R 3.5 1.4 0:05 httpd15177 nobody 16 0 9528 9372 7376 R 3.5 0.9 0:06 httpd15541 nobody 16 0 10588 10M 8488 R 3.5 1.0 0:05 httpd15190 nobody 16 0 10984 10M 9076 R 3.4 1.0 0:05 httpd16558 mysql 15 0 30920 30M 1240 D 2.3 2.9 0:00 mysqld15155 nobody 16 0 13492 13M 11448 R 1.7 1.2 0:06 httpd15544 nobody 16 0 10900 10M 8704 R 1.7 1.0 0:04 httpd15686 nobody 18 0 10504 10M 8476 R 1.7 1.0 0:04 httpd16458 nobody 18 0 7680 7520 6044 R 1.7 0.7 0:01 httpd16083 mysql 16 0 30316 29M 1240 D 1.0 2.9 0:00 mysqld16257 mysql 15 0 30316 29M 1240 D 0.9 2.9 0:00 mysqld16110 mysql 15 0 30316 29M 1240 D 0.8 2.9 0:01 mysqld15322 nobody 16 0 11988 11M 10276 R 0.4 1.1 0:05 httpd16290 mysql 15 0 30316 29M 1240 D 0.3 2.9 0:00 mysqld15847 nobody 16 0 9684 9524 8136 R 0.2 0.9 0:02 httpd16092 mysql 15 0 30316 29M 1240 D 0.1 2.9 0:00 mysqld 2052 mysql 16 0 30312 29M 1240 R 0.0 2.9 0:00 mysqld15142 nobody 19 0 9468 9308 7756 R 0.0 0.9 0:03 httpd15145 nobody 20 0 11664 11M 8740 R 0.0 1.1 0:04 httpd15146 nobody 20 0 11312 10M 8820 R 0.0 1.0 0:04 httpd15148 nobody 19 0 12592 12M 10504 R 0.0 1.2 0:08 httpd15149 nobody 19 0 13172 12M 11396 R 0.0 1.2 0:07 httpd15150 nobody 19 0 14520 14M 10424 R 0.0 1.3 0:06 httpd15151 nobody 19 0 14436 13M 11556 R 0.0 1.3 0:04 httpd15152 nobody 19 0 13392 12M 11508 R 0.0 1.2 0:05 httpd15154 nobody 19 0 13580 13M 9560 R 0.0 1.3 0:04 httpd15169 nobody 20 0 8392 8232 6172 R 0.0 0.7 0:02 httpd15179 nobody 19 0 11636 11M 9732 R 0.0 1.1 0:06 httpd15180 nobody 19 0 12288 11M 10492 R 0.0 1.1 0:04 httpd15185 nobody 19 0 11720 11M 9444 R 0.0 1.1 0:03 httpd15189 nobody 19 0 13052 12M 11116 R 0.0 1.2 0:04 httpd15194 nobody 19 0 10228 9.8M 8376 R 0.0 0.9 0:02 httpd15196 nobody 20 0 9952 9792 7632 R 0.0 0.9 0:02 httpd15534 nobody 19 0 10232 9.8M 8500 R 0.0 0.9 0:06 httpd15537 nobody 19 0 9900 9740 8276 R 0.0 0.9 0:02 httpd15719 nobody 19 0 8384 8224 6564 R 0.0 0.7 0:01 httpd15726 nobody 20 0 8664 8504 6936 R 0.0 0.8 0:02 httpd15831 nobody 20 0 8300 8140 6480 R 0.0 0.7 0:01 httpd15848 nobody 19 0 8896 8736 7160 R 0.0 0.8 0:02 httpd15849 nobody 19 0 8296 8136 6632 R 0.0 0.7 0:01 httpd15851 nobody 19 0 8784 8624 6984 R 0.0 0.8 0:02 httpd15969 nobody 19 0 8976 8816 7112 R 0.0 0.8 0:02 httpd15975 nobody 19 0 6440 6280 4892 R 0.0 0.6 0:00 httpd15976 nobody 19 0 10044 9884 8256 R 0.0 0.9 0:02 httpd15991 nobody 19 0 6472 6312 4892 R 0.0 0.6 0:00 httpd16053 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16107 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16127 nobody 19 0 7712 7552 6000 R 0.0 0.7 0:02 httpd16129 mysql 15 0 30316 29M 1240 D 0.0 2.9 0:00 mysqld16130 nobody 19 0 10204 9.8M 8464 R 0.0 0.9 0:03 httpd16137 nobody 19 0 6496 6336 4964 R 0.0 0.6 0:00 httpd16139 nobody 19 0 6820 6660 5184 R 0.0 0.6 0:00 httpd16144 nobody 19 0 6640 6480 4928 R 0.0 0.6 0:00 httpd16152 nobody 19 0 7636 7476 5892 R 0.0 0.7 0:01 httpd16186 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16212 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16213 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16214 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16234 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16235 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16236 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16272 mysql 15 0 30316 29M 1240 D 0.0 2.9 0:00 mysqld16296 mysql 15 0 30316 29M 1240 D 0.0 2.9 0:00 mysqld16311 nobody 19 0 6536 6376 4948 R 0.0 0.6 0:00 httpd16324 nobody 19 0 6524 6364 4936 R 0.0 0.6 0:00 httpd16343 mysql 15 0 30316 29M 1240 D 0.0 2.9 0:00 mysqld16350 mysql 15 0 30316 29M 1240 D 0.0 2.9 0:01 mysqld16369 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16370 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16371 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16372 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16373 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16374 mysql 20 0 30316 29M 1240 R 0.0 2.9 0:00 mysqld16385 mysql 20 0 30920 30M 1240 R 0.0 2.9 0:00 mysqld16498 nobody 19 0 6592 6432 4888 R 0.0 0.6 0:00 httpd16499 nobody 19 0 6592 6432 4888 R 0.0 0.6 0:00 httpdHttp processes currently running = 111Mysql processes currently running = 123Netstat information summary 1 LAST_ACK 2 FIN_WAIT1 7 SYN_RECV 8 FIN_WAIT2 11 CLOSE_WAIT 28 LISTEN 48 ESTABLISHED 62 TIME_WAIT +---------------------------+-----------------+| Variable_name | Value |+---------------------------+-----------------+| Aborted_clients | 40 || Aborted_connects | 1 || Bytes_received | 95796475 || Bytes_sent | 3000844249 || Com_admin_commands | 0 || Com_alter_table | 0 || Com_analyze | 0 || Com_backup_table | 0 || Com_begin | 0 || Com_change_db | 24688 || 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 | 1005 || Com_drop_db | 0 || Com_drop_function | 0 || Com_drop_index | 0 || Com_drop_table | 0 || Com_flush | 4 || Com_grant | 0 || Com_insert | 4589 || Com_insert_select | 322 || Com_kill | 0 || Com_load | 0 || Com_load_master_table | 0 || Com_lock_tables | 0 || Com_optimize | 0 || Com_purge | 0 || Com_rename_table | 0 || Com_repair | 0 || Com_replace | 481 || Com_replace_select | 24 || Com_reset | 0 || Com_restore_table | 0 || Com_revoke | 0 || Com_rollback | 22752 || Com_select | 515604 || Com_set_option | 1642 || Com_show_binlogs | 0 || Com_show_create | 1642 || Com_show_databases | 9 || Com_show_fields | 1642 || 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 | 80 || Com_show_slave_status | 0 || Com_show_status | 3552 || Com_show_innodb_status | 0 || Com_show_tables | 18 || Com_show_variables | 1 || Com_slave_start | 0 || Com_slave_stop | 0 || Com_truncate | 0 || Com_unlock_tables | 0 || Com_update | 33662 || Connections | 21135 || Created_tmp_disk_tables | 1147 || Created_tmp_tables | 13825 || Created_tmp_files | 0 || Delayed_insert_threads | 0 || Delayed_writes | 0 || Delayed_errors | 0 || Flush_commands | 1 || Handler_delete | 5038 || Handler_read_first | 26780 || Handler_read_key | 3669357 || Handler_read_next | 28995474 || Handler_read_prev | 5511 || Handler_read_rnd | 3833479 || Handler_read_rnd_next | 117752164 || Handler_update | 250487 || Handler_write | 507673 || Key_blocks_used | 5057 || Key_read_requests | 17569970 || Key_reads | 4047 || Key_write_requests | 41333 || Key_writes | 30681 || Max_used_connections | 188 || Not_flushed_key_blocks | 0 || Not_flushed_delayed_rows | 0 || Open_tables | 950 | 93% of table_cache in use| Open_files | 1767 || Open_streams | 0 || Opened_tables | 978 || Questions | 629223 || Select_full_join | 394 || Select_full_range_join | 329 || Select_range | 143134 || Select_range_check | 0 || Select_scan | 133738 || Slave_running | OFF || Slave_open_temp_tables | 0 || Slow_launch_threads | 25 || Slow_queries | 4 | (execution time > 10 secs)| Sort_merge_passes | 0 || Sort_range | 186196 || Sort_rows | 13497233 || Sort_scan | 61455 || Table_locks_immediate | 646068 || Table_locks_waited | 1252 || Threads_cached | 63 || Threads_created | 194 || Threads_connected | 36 || Threads_running | 1 || Uptime | 23848 | 6 hrs 37 mins 28 secs+---------------------------+-----------------+Key Reads/Key Read Requests = 0.000230 (Cache hit = 99.99977%)Key Writes/Key Write Requests = 0.742288Connections/second = 0.886 (/hour = 3190.456)KB received/second = 3.923 (/hour = 14122.090)KB sent/second = 87.938 (/hour = 316577.642)Temporary Tables Created/second = 0.580 (/hour = 2086.967)Opened Tables/second = 0.041 (/hour = 147.635)Slow Queries/second = 0.000 (/hour = 0.604)% of slow queries = 0.001%Queries/second = 26.385 (/hour = 94985.022)</PRE>

[marocnl]

Hi,

Here is the phpinfo 4 the site. Maybe anybody has a suggestion of what to change to get things to speed up. http://64.191.29.239/phpinf.php

Greets,
www.maroc.nl (http://www.maroc.nl)

[eva2000]

Originally posted by marocnl
Hi,

Here is the phpinfo 4 the site. Maybe anybody has a suggestion of what to change to get things to speed up. http://64.191.29.239/phpinf.php

Greets,
www.maroc.nl (http://www.maroc.nl) 2.4.18-3 has a bug in it causing high cpu loads with mysql...

it happened with my server in my sig as well, upgrading to latest 2.4.x kernel fixed it

[dandanfireman]

Originally posted by eva2000
2.4.18-3 has a bug in it causing high cpu loads with mysql...

it happened with my server in my sig as well, upgrading to latest 2.4.x kernel fixed it

Upgraded to 2.4.18-grsec-1.9.4

[eva2000]

Originally posted by dandanfireman
Upgraded to 2.4.18-grsec-1.9.4 latest stable is 2.4.20 :)

[dandanfireman]

Originally posted by eva2000
latest stable is 2.4.20 :) Do you feel that this is the cause of the problem, or the fact that there are at times 300 simultaneous users on the server...please see other thead on server configuration.

[eva2000]

Originally posted by dandanfireman
Do you feel that this is the cause of the problem, or the fact that there are at times 300 simultaneous users on the server...please see other thead on server configuration. both celeron and P4 cpus aren't made for web serving and really don't perform well as compared to P3 especially tualatin's with 512k L2 caches

it would of been alot easier to have 1 thread for this issue

[Coreace]

Originally posted by eva2000
both celeron and P4 cpus aren't made for web serving and really don't perform well as compared to P3 especially tualatin's with 512k L2 caches

it would of been alot easier to have 1 thread for this issue

I'll join Eva on this one. Your problem is this:

Celeron 1Ghz
Ram 512M
IDE Hard Drive


Change it to:
P3/P4 Xeon/ Dual Athlon MP
1 GB RAM (more the better)
SCSI

:)

Sorry, not much of a help here. But I think you have to look at the server hardware. You can probably fine tune MySQL, PHP etc. however, you can only do so much with your current settings.

I had similar problems and after I changed my hardware, voila! What a different world!

[dandanfireman]

Originally posted by Coreace
I'll join Eva on this one. Your problem is this:

Celeron 1Ghz
Ram 512M
IDE Hard Drive


Change it to:
P3/P4 Xeon/ Dual Athlon MP
1 GB RAM (more the better)
SCSI

:)

Sorry, not much of a help here. But I think you have to look at the server hardware. You can probably fine tune MySQL, PHP etc. however, you can only do so much with your current settings.

I had similar problems and after I changed my hardware, voila! What a different world! The hardware was upgraded and I believe reported in this thread. It is now running on

P4 1.6G
1G Ram

[Coreace]

Originally posted by dandanfireman
The hardware was upgraded and I believe reported in this thread. It is now running on

P4 1.6G
1G Ram

Ah.. you had another thread open. Sorry, did not see that. Hope things are working better for you now.