Racersden.net Config Request

[white_2kgt]

1. is this on dedicated or shared virual server

Dedicated to vb (but host 10 other small sites, 9 static sites and 1 that uses jboss).


2.your server specs. For example:
Single Intel Celeron 1.7GHz
256MB ram
40GB EIDE non raid
RedHat linux 9
Apache 2.0.40.21
PHP 4.2.2
MySQL 3.23.54

3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?


4. if possible how mysql was compiled/installed

Came w/ server install

5. your top stats



15:56:00 up 2 days, 16:58, 3 users, load average: 0.30, 0.35, 0.36

98 processes: 97 sleeping, 1 running, 0 zombie, 0 stopped

CPU states: 0.0% user 1.7% system 0.0% nice 0.0% iowait 98.2% idle

Mem: 247188k av, 243204k used, 3984k free, 0k shrd, 4912k buff

178920k actv, 18740k in_d, 5956k in_c

Swap: 522104k av, 230176k used, 291928k free 53900k cached



PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND

22618 root 18 0 1200 1200 856 R 1.7 0.4 0:00 0 top

1 root 15 0 84 56 40 S 0.0 0.0 0:03 0 init

2 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 keventd

3 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kapmd

4 root 34 19 0 0 0 SWN 0.0 0.0 0:02 0 ksoftirqd_CPU0

9 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush

5 root 15 0 0 0 0 SW 0.0 0.0 0:19 0 kswapd

6 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kscand/DMA

7 root 16 0 0 0 0 SW 0.0 0.0 1:50 0 kscand/Normal

8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kscand/HighMem

10 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kupdated

11 root 24 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd

15 root 15 0 0 0 0 SW 0.0 0.0 0:06 0 kjournald

73 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 khubd

2796 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald

3112 root 15 0 188 156 112 S 0.0 0.0 0:01 0 syslogd

3116 root 15 0 52 4 0 S 0.0 0.0 0:00 0 klogd

3134 rpc 15 0 76 0 0 SW 0.0 0.0 0:00 0 portmap

3153 rpcuser 25 0 80 0 0 SW 0.0 0.0 0:00 0 rpc.statd

3220 root 25 0 48 4 0 S 0.0 0.0 0:00 0 apmd

3259 named 25 0 684 240 124 S 0.0 0.0 0:00 0 named

3272 root 15 0 472 344 232 S 0.0 0.1 0:01 0 sshd

3286 root 15 0 144 4 0 S 0.0 0.0 0:00 0 xinetd

3298 root 25 0 156 4 0 S 0.0 0.0 0:00 0 safe_mysqld

3334 mysql 18 0 20356 9972 1460 S 0.0 4.0 49:10 0 mysqld

3336 root 25 0 64 4 0 S 0.0 0.0 0:00 0 couriertcpd

3339 root 25 0 40 4 0 S 0.0 0.0 0:00 0 courierlogger

3348 root 25 0 60 4 0 S 0.0 0.0 0:00 0 couriertcpd

3351 root 25 0 44 4 0 S 0.0 0.0 0:00 0 courierlogger

3358 root 25 0 60 4 0 S 0.0 0.0 0:00 0 couriertcpd

3360 root 25 0 44 4 0 S 0.0 0.0 0:00 0 courierlogger

3369 root 25 0 64 4 0 S 0.0 0.0 0:00 0 couriertcpd

3374 root 25 0 40 4 0 S 0.0 0.0 0:00 0 courierlogger

3378 qmails 15 0 72 4 0 S 0.0 0.0 0:03 0 qmail-send

3380 qmaill 15 0 56 4 0 S 0.0 0.0 0:00 0 splogger

3381 root 15 0 76 4 0 S 0.0 0.0 0:00 0 qmail-lspawn


6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf so post the contents inside of my.cnf (minus any passwords of course). If on Windows server if you don't have that file you need to log into telnet and as root user type

mysqladmin -u root -p variables

+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Variable_name | Value |

+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| back_log | 50 |

| basedir | /usr/ |

| binlog_cache_size | 32768 |

| character_set | latin1 |

| character_sets | latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7 win1250 win1251 win1251ukr ujis sjis tis620 |

| concurrent_insert | ON |

| connect_timeout | 5 |

| datadir | /var/lib/mysql/ |

| delay_key_write | ON |

| delayed_insert_limit | 100 |

| delayed_insert_timeout | 300 |

| delayed_queue_size | 1000 |

| flush | OFF |

| flush_time | 0 |

| have_bdb | NO |

| have_gemini | NO |

| have_innodb | DISABLED |

| have_isam | YES |

| have_raid | NO |

| have_openssl | NO |

| init_file | |

| innodb_additional_mem_pool_size | 1048576 |

| innodb_buffer_pool_size | 8388608 |

| innodb_data_file_path | |

| innodb_data_home_dir | |

| innodb_file_io_threads | 4 |

| innodb_force_recovery | 0 |

| innodb_thread_concurrency | 8 |

| innodb_flush_log_at_trx_commit | 0 |

| innodb_fast_shutdown | ON |

| innodb_flush_method | |

| innodb_lock_wait_timeout | 50 |

| innodb_log_arch_dir | |

| innodb_log_archive | OFF |

| innodb_log_buffer_size | 1048576 |

| innodb_log_file_size | 5242880 |

| innodb_log_files_in_group | 2 |

| innodb_log_group_home_dir | |

| innodb_mirrored_log_groups | 1 |

| interactive_timeout | 28800 |

| join_buffer_size | 131072 |

| key_buffer_size | 8388600 |

| language | /usr/share/mysql/english/ |

| large_files_support | ON |

| locked_in_memory | OFF |

| log | OFF |

| log_update | OFF |

| log_bin | OFF |

| log_slave_updates | OFF |

| log_long_queries | OFF |

| long_query_time | 10 |

| low_priority_updates | OFF |

| lower_case_table_names | 0 |

| max_allowed_packet | 1048576 |

| max_binlog_cache_size | 4294967295 |

| max_binlog_size | 1073741824 |

| max_connections | 100 |

| max_connect_errors | 10 |

| max_delayed_threads | 20 |

| max_heap_table_size | 16777216 |

| max_join_size | 4294967295 |

| max_sort_length | 1024 |

| max_user_connections | 0 |

| max_tmp_tables | 32 |

| max_write_lock_count | 4294967295 |

| myisam_max_extra_sort_file_size | 256 |

| myisam_max_sort_file_size | 2047 |

| myisam_recover_options | 0 |

| myisam_sort_buffer_size | 8388608 |

| net_buffer_length | 16384 |

| net_read_timeout | 30 |

| net_retry_count | 10 |

| net_write_timeout | 60 |

| open_files_limit | 0 |

| pid_file | /var/run/mysqld/mysqld.pid |

| port | 3306 |

| protocol_version | 10 |

| record_buffer | 131072 |

| record_rnd_buffer | 131072 |

| query_buffer_size | 0 |

| safe_show_database | OFF |

| server_id | 0 |

| slave_net_timeout | 3600 |

| skip_locking | ON |

| skip_networking | OFF |

| skip_show_database | OFF |

| slow_launch_time | 2 |

| socket | /var/lib/mysql/mysql.sock |

| sort_buffer | 2097144 |

| sql_mode | 0 |

| table_cache | 64 |

| table_type | MYISAM |

| thread_cache_size | 0 |

| thread_stack | 65536 |

| transaction_isolation | READ-COMMITTED |

| timezone | PDT |

| tmp_table_size | 33554432 |

| tmpdir | /tmp/ |

| version | 3.23.54 |

| wait_timeout | 28800 |

+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

7. your mysql extended-status output either still telnet as root user type



+--------------------------+------------+

| Variable_name | Value |

+--------------------------+------------+

| Aborted_clients | 10 |

| Aborted_connects | 409 |

| Bytes_received | 330368747 |

| Bytes_sent | 1807545023 |

| Com_admin_commands | 0 |

| Com_alter_table | 0 |

| Com_analyze | 0 |

| Com_backup_table | 0 |

| Com_begin | 12 |

| Com_change_db | 177499 |

| Com_change_master | 0 |

| Com_check | 0 |

| Com_commit | 21 |

| Com_create_db | 0 |

| Com_create_function | 0 |

| Com_create_index | 0 |

| Com_create_table | 0 |

| Com_delete | 4487 |

| Com_drop_db | 0 |

| Com_drop_function | 0 |

| Com_drop_index | 0 |

| Com_drop_table | 0 |

| Com_flush | 0 |

| Com_grant | 0 |

| Com_insert | 35253 |

| Com_insert_select | 923 |

| Com_kill | 0 |

| Com_load | 0 |

| Com_load_master_table | 0 |

| Com_lock_tables | 3 |

| Com_optimize | 0 |

| Com_purge | 0 |

| Com_rename_table | 0 |

| Com_repair | 0 |

| Com_replace | 3719 |

| Com_replace_select | 3 |

| Com_reset | 0 |

| Com_restore_table | 0 |

| Com_revoke | 0 |

| Com_rollback | 0 |

| Com_select | 822590 |

| Com_set_option | 617 |

| Com_show_binlogs | 0 |

| Com_show_create | 585 |

| Com_show_databases | 13 |

| Com_show_fields | 922 |

| Com_show_grants | 0 |

| Com_show_keys | 6 |

| 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 | 47 |

| Com_show_innodb_status | 0 |

| Com_show_tables | 99 |

| Com_show_variables | 20 |

| Com_slave_start | 0 |

| Com_slave_stop | 0 |

| Com_truncate | 0 |

| Com_unlock_tables | 0 |

| Com_update | 150550 |

| Connections | 177897 |

| Created_tmp_disk_tables | 765 |

| Created_tmp_tables | 57989 |

| Created_tmp_files | 2 |

| Delayed_insert_threads | 0 |

| Delayed_writes | 0 |

| Delayed_errors | 0 |

| Flush_commands | 1 |

| Handler_delete | 12160 |

| Handler_read_first | 162485 |

| Handler_read_key | 63695933 |

| Handler_read_next | 123652453 |

| Handler_read_prev | 248 |

| Handler_read_rnd | 4826720 |

| Handler_read_rnd_next | 33238136 |

| Handler_update | 274195 |

| Handler_write | 2748921 |

| Key_blocks_used | 7793 |

| Key_read_requests | 145598982 |

| Key_reads | 73423 |

| Key_write_requests | 103528 |

| Key_writes | 94072 |

| Max_used_connections | 100 |

| Not_flushed_key_blocks | 0 |

| Not_flushed_delayed_rows | 0 |

| Open_tables | 64 |

| Open_files | 115 |

| Open_streams | 0 |

| Opened_tables | 14444 |

| Questions | 1374796 |

| Select_full_join | 2367 |

| Select_full_range_join | 6920 |

| Select_range | 245498 |

| Select_range_check | 0 |

| Select_scan | 130121 |

| Slave_running | OFF |

| Slave_open_temp_tables | 0 |

| Slow_launch_threads | 66 |

| Slow_queries | 5076 |

| Sort_merge_passes | 1 |

| Sort_range | 106117 |

| Sort_rows | 57833130 |

| Sort_scan | 59227 |

| Table_locks_immediate | 1676375 |

| Table_locks_waited | 2226 |

| Threads_cached | 0 |

| Threads_created | 177896 |

| Threads_connected | 8 |

| Threads_running | 1 |

| Uptime | 233996 |

+--------------------------+------------+

8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?

For the most part yes. I have JBoss that also uses MySQL but not as much as vB.

9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?

30-50 users at a time.
900 Cookie Timeout

10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site

http://www.racersden.net/phpinfo.php

11. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :

KeepAlive OFF
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 150

12. what version of vB are you running ?

3.0.1


thanks!
-c

[eva2000]

1. upgrade PHP to 4.3.6 as 4.2.2 is out dated and buggy as hell :)

2. upgrade to MySQL 4.0.18 as it's 3x times more efficient and performs better than 3.23.x mysql version

3. after updating to MySQL 4.0.18 edit or create /etc/my.cnf file and place these settings in and restart mysql


[mysqld]
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[white_2kgt]

thanks!

-c

[eva2000]

no probs let me know how it goes :)

[white_2kgt]

Well, I got MySQL upgraded ok. Went to upgrade php, the new php needs apache 2.0.44 or better, ok so I get that, compile, it works. php works but now I don't have mod_ssl or mod_perl. Any tips on how to compile those?

thanks,
-c

[eva2000]

not sure about mod_ssl and mod_perl found http://perl.apache.org/docs/1.0/guide/install.html try googling :)

[white_2kgt]

not sure about mod_ssl and mod_perl found http://perl.apache.org/docs/1.0/guide/install.html try googling :)
yea, I have. I got mod_ssl working but now my vhost don't work, go figure. guess I will just stick w/ the old php

-c

[legolas]

That's why I hate distribution builds of apache. If you try to use an old config, everything breaks. Distributions don't seem to care that by putting logs, modules, etc. in strange places, they create an unmaintainable mess.

Vhosts do work. You just need to fix your apache config file.

You do not want to stick with 4.2.2. As eva said, it's old and buggy as hell.

[Scott MacVicar]

You'll also get better performance with a later apache 2 and PHP as they changed the method which they transfer data.

They now use an apache filter rather than the old apache handler.

[white_2kgt]

Ok I now have apache_1.3.31, php-4.3.6 and mysql-standard-4.0.18 compiled and installed with everything that I need. However, after about a day the site starts to load very slow, my top stats are:

15:52:15 up 18 days, 16:54, 1 user, load average: 1.67, 2.08, 2.06
157 processes: 151 sleeping, 5 running, 1 zombie, 0 stopped
CPU states: 98.0% user 1.9% system 0.0% nice 0.0% iowait 0.0% idle
Mem: 247188k av, 242464k used, 4724k free, 0k shrd, 3676k buff
181516k actv, 18956k in_d, 15368k in_c
Swap: 522104k av, 181448k used, 340656k free 58332k cached

I do not like stats that high and it seems as though the server is very slugish. This is with ~40 users online at a time. I had about 49 httpd processers running with one in the <defunct> status (what does that mean anyway). I also had ~70 mysqld processes running. Is there anything I can do to decrease the load or make the site load faster?

thanks,
-c

[eva2000]

Ok I now have apache_1.3.31, php-4.3.6 and mysql-standard-4.0.18 compiled and installed with everything that I need. However, after about a day the site starts to load very slow, my top stats are:

15:52:15 up 18 days, 16:54, 1 user, load average: 1.67, 2.08, 2.06
157 processes: 151 sleeping, 5 running, 1 zombie, 0 stopped
CPU states: 98.0% user 1.9% system 0.0% nice 0.0% iowait 0.0% idle
Mem: 247188k av, 242464k used, 4724k free, 0k shrd, 3676k buff
181516k actv, 18956k in_d, 15368k in_c
Swap: 522104k av, 181448k used, 340656k free 58332k cached

I do not like stats that high and it seems as though the server is very slugish. This is with ~40 users online at a time. I had about 49 httpd processers running with one in the <defunct> status (what does that mean anyway). I also had ~70 mysqld processes running. Is there anything I can do to decrease the load or make the site load faster?

thanks,
-c
reason is you're severely swapping to disk due to lack of ram upgrade from 256MB to 512MB should do you nicely

[white_2kgt]

reason is you're severely swapping to disk due to lack of ram upgrade from 256MB to 512MB should do you nicely
ugh, I knew you'd say that. Incase that's not an option is there anything else that I can do?

thanks,

-c

[eva2000]

ugh, I knew you'd say that. Incase that's not an option is there anything else that I can do?

thanks,

-c
hmm probably get super fast hard drives like 15,000rpm scsi drives and more power dual cpus... ;)

ram is what ya need

[white_2kgt]

hmm probably get super fast hard drives like 15,000rpm scsi drives and more power dual cpus... ;)

ram is what ya need
ok, I mean other than hardware. The server is a package deal. I pay $x for this server and I don't think they will just let me upgrade 1 piece of HW w/o upping to the next plan which is 2x as much $$$.

-c

[Scott MacVicar]

They usually let you do upgrade of parts, best way is to mail them and ask.

[eva2000]

like Scott said, web hosts usually for a fixed fee + monthly allow you to upgrade parts