i had originally opened this thread before i moved to a dual server setup
now that i have the dual server setup i am posting this new thread as requested by eva
my server specs and other details follow in the next 2 posts and i wud like to ask a few questions in the post following that
webserver:
1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)
dedicated servers, but not dedicated to our forums. we have another vbulletin site & 2 xbt_trackers. mail also. and some static html sites which dont get 1000 hits in a month. and cpanel/whm, of course
2. your server specs. For example:
cpu speed/type single or dual cpus): dual opteron 250
how much memory installed: 4 gb ram (pc 3200)
hard drive type/configuration: 73 GB SCSI u320 15k rpm non raid
linux distributor or windows version: centOS 4.2
apache/IIS version: apache 1.3.34
PHP version: php 4.4.1
MySQL version: mysql 4.1.14-standard (this is not the db server)
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
i dont know
4. if possible how mysql was compiled/installed
by whm
5. your top stats
# top
top - 01:50:42 up 6 days, 3:25, 2 users, load average: 6.55, 8.73, 10.39
Tasks: 539 total, 6 running, 532 sleeping, 1 stopped, 0 zombie
Cpu(s): 78.7% us, 10.9% sy, 0.0% ni, 8.4% id, 1.5% wa, 0.5% hi, 0.0% si
Mem: 4090600k total, 3692700k used, 397900k free, 192680k buffers
Swap: 4096532k total, 4048k used, 4092484k free, 2031568k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5107 nobody 17 0 51032 13m 6952 S 12.2 0.3 0:02.02 httpd
5211 nobody 15 0 49724 11m 6820 S 11.9 0.3 0:01.18 httpd
5101 nobody 15 0 49764 13m 8372 S 10.6 0.3 0:01.45 httpd
4962 nobody 15 0 49724 12m 7208 S 10.3 0.3 0:01.38 httpd
6004 nobody 18 0 50560 11m 5964 S 9.9 0.3 0:00.30 httpd
5194 nobody 15 0 49640 12m 7232 S 8.6 0.3 0:00.42 httpd
5445 nobody 15 0 50636 13m 7560 S 7.9 0.3 0:00.41 httpd
5106 nobody 16 0 50520 13m 8344 S 7.3 0.3 0:01.55 httpd
5117 nobody 16 0 49780 13m 8676 R 7.3 0.3 0:02.43 httpd
5141 nobody 15 0 49716 11m 7092 S 7.3 0.3 0:00.75 httpd
6000 nobody 15 0 49668 11m 6692 S 6.6 0.3 0:00.23 httpd
5215 nobody 15 0 49680 11m 6828 S 6.3 0.3 0:01.10 httpd
5967 nobody 16 0 50464 12m 6708 S 6.3 0.3 0:00.83 httpd
5110 nobody 16 0 50732 14m 8228 S 6.0 0.4 0:02.25 httpd
5217 nobody 16 0 50508 12m 7188 S 5.6 0.3 0:00.46 httpd
5220 nobody 16 0 50416 12m 6696 S 5.3 0.3 0:00.45 httpd
5116 nobody 15 0 51400 17m 10m S 4.0 0.4 0:01.69 httpd
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
Quote:
mysqladmin -u root -p variables
copy and paste output here
# cat /etc/my.cnf
[mysqld]
default_character_set = latin1
default-character-set = latin1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
server-id = 1
max_connections = 650
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 64M
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
max_allowed_packet = 64M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet=16M
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=4M
write_buffer=4M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
7. your mysql extended-status output which shows entire server's mysql activity status (preferably with a day or 2 worth of mysql uptime for better indication of real activity) either:
# mysqladmin -u root -p ext stat ver
Enter
+----------------------------+------------+
Variable_name Value
+----------------------------+------------+
Aborted_clients 6216
Aborted_connects 1725
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 3898392817
Bytes_sent 1381909218
Com_admin_commands 0
Com_alter_db 0
Com_alter_table 241
Com_analyze 0
Com_backup_table 0
Com_begin 562
Com_change_db 3542818
Com_change_master 0
Com_check 0
Com_checksum 0
Com_commit 552
Com_create_db 11
Com_create_function 0
Com_create_index 71
Com_create_table 262
Com_dealloc_sql 0
Com_delete 183094
Com_delete_multi 2
Com_do 0
Com_drop_db 5
Com_drop_function 0
Com_drop_index 0
Com_drop_table 122
Com_drop_user 0
Com_execute_sql 0
Com_flush 246
Com_grant 287
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_help 1
Com_insert 2045734
Com_insert_select 2867
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 207
Com_optimize 0
Com_preload_keys 0
Com_prepare_sql 0
Com_purge 0
Com_purge_before_date 0
Com_rename_table 0
Com_repair 0
Com_replace 432479
Com_replace_select 0
Com_reset 0
O3Spaces Forum - View Thread - Separate DB and file server in ::
Topic: Separate DB and file server in Community Edition one server and have my files stored on a different server with the Community Edition (Java DB)?
http://trial.o3spaces.com/forum/fm/viewthread?thread=658&lastpage=yesHOME |
Com_restore_table 0
Com_revoke 0
Com_revoke_all 0
Com_rollback 1
Com_savepoint 0
Com_select 13978778
Com_set_option 4564
Com_show_binlog_events 0
Com_show_binlogs 23
Com_show_charsets 405
Com_show_collations 405
Com_show_column_types 0
Com_show_create_db 34
Com_show_create_table 752
Minimum SQL rights needed for separate db\rms install ::
2 posts - 2 authors - Last post: May 26, 2008System Center Community provides a forum for System Center users to come together to ask questions and share knowledge.
http://systemcentercommunity.com/forums/p/4029/12533.aspxHOME |
#601 (Separate DB connections for READ-ONLY vs WRITE queries ::
In order to facilitate much larger forums spanning multiple servers it would be helpful to separate the DB connections such that. DB reads would happen from
http://trac.phorum.org/ticket/601HOME |
Com_show_databases 357
Com_show_errors 0
Com_show_fields 1976
Com_show_grants 137
Com_show_innodb_status 0
Com_show_keys 113
Com_show_logs 0
Com_show_master_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_privileges 0
Com_show_processlist 1509
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 2
Com_show_storage_engines 1
Com_show_tables 2173
Com_show_variables 929
Com_show_warnings 0
Com_slave_start 0
Com_slave_stop 0
Com_stmt_prepare 0
Com_stmt_execute 0
Com_stmt_send_long_data 0
Com_stmt_reset 0
Com_stmt_close 0
Com_truncate 0
Com_unlock_tables 209
Com_update 4963729
Com_update_multi 5681
Connections 3403929
Created_tmp_disk_tables 2107
Created_tmp_files 23460
Created_tmp_tables 324771
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Flush_commands 1
Handler_commit 0
Handler_delete 566968
Handler_discover 0
Handler_read_first 5027522
Handler_read_key 1427963535
Handler_read_next 535250145
Handler_read_prev 92747601
Handler_read_rnd 27325947
Handler_read_rnd_next 2504137039
Handler_rollback 0
Handler_update 9814949
Handler_write 15104640
Key_blocks_not_flushed 0
Key_blocks_unused 373
Key_blocks_used 14497
Key_read_requests 3436283367
Key_reads 25171403
Key_write_requests 5253549
Key_writes 3434603
Max_used_connections 247
Not_flushed_delayed_rows 0
Open_files 1827
Open_streams 0
Open_tables 1800
Opened_tables 4875
Qcache_free_blocks 182
Qcache_free_memory 66493392
Qcache_hits 51337057
Qcache_inserts 13688866
Qcache_lowmem_prunes 454478
Qcache_not_cached 284606
Qcache_queries_in_cache 364
Qcache_total_blocks 1036
Questions 79907518
Rpl_status NULL
Select_full_join 57
Select_full_range_join 0
Select_range 2447733
Select_range_check 0
Select_scan 1416019
Slave_open_temp_tables 0
Slave_running OFF
Slave_retried_transactions 0
Slow_launch_threads 47
Slow_queries 203
Sort_merge_passes 11730
Sort_range 2738238
Sort_rows 1208455752
Sort_scan 370745
Table_locks_immediate 45672259
Table_locks_waited 477200
Threads_cached 244
Threads_connected 3
Threads_created 247
Threads_running 1
Uptime 451183
+----------------------------+------------+
Uptime: 451183 Threads: 2 Questions: 79907526 Slow queries: 203 Opens: 4875 Flush tables: 1 Open tables: 1800 Queries per second avg: 177.107
mysqladmin Ver 8.41 Distrib 4.1.14, for pc-linux-gnu on i686
(C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.14-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 5 days 5 hours 19 min 43 sec
Threads: 2 Questions: 79907530 Slow queries: 203 Opens: 4875 Flush tables: 1 Open tables: 1800 Queries per second avg: 177.107
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
see ans to Q 1
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
average ??? certainly above 750
max - we touch 1150 everyday
cookie timeout - 30 mins
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
PHP Code:
phpinfo();
?>
i.e. yourdomain.com/phpinfo.php
http://xboard.us/bbb/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 4
MinSpareServers 15
MaxSpareServers 25
StartServers 15
MaxClients 250
AND Maxrequestsperchild value = 200
12. what version of vB are you running ? 3.5.0
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log
You can use this command to find such files
Quote:
find / -size +2000000k
no log files that big. /usr/local/cpanel/whostmgr/docroot/core.21136 is about 2.3 GB
kernel upgrade is best left to web host to do.. so request them to do it.. might need to pay a fee but it's best :)
do you have a 2nd network card on web server to communicate with the web ?
yes, i do have a second network card
now my questions:
1. my config files are not optimised. what wud be optimum values? especially for mysql, php and apache
2. ever since i changed the config files as adviced in the old thread, i have been receiving these database error e-mails, but the board works fine. my wait_timeout was set to 180. when i shifted the db to the new dbserver i started receiving these errors by the zillion. i read somewhere on this forum, and increased that to 7200. i am still receiving the error e-mails, but much less frequently. sample e-mail:
Database error in vBulletin :
mysql_connect(): Lost connection to MySQL server during query
/home/???/public_html/bbb/includes/class_core.php on line 273
MySQL Error :
Error Number :
Date : Sunday, January 29th 2006 @ 01:35:17 AM
Script : http://www.xboard.us/bbb/showthread.php?t=37634
Referrer : http://www.xboard.us/bbb/forumdisplay.php?f=13&page=7&order=desc
IP Address : 59.95.153.34
Username :
Classname : vb_database
3. the cpanel server (webserver) is still running mysql, and i am afraid to remove it cos i think cpanel's own databases for mail etc are still running on this server. how can i shift them? i tried reading the cpanel documentation and the cpanel forums, but couldnt find any answer
4. is there any way to make mysql dump a backup on the other server once a day and then delete the previous day's backup?
TIA
i had set mysql wait_timeout to 120 before i started writing the above post
in the time it took me to write that post, i have received over 200 db errors
you should shift all database apart from cpanel's own use to the db server.. on both db server try this my.cnf
[mysqld]
default_character_set = latin1
default-character-set = latin1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
server-id = 1
max_connections = 650
key_buffer = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 512
wait_timeout = 120
connect_timeout = 10
tmp_table_size = 256M
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 16M
max_allowed_packet = 64M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
default-storage-engine = MyISAM
thread_concurrency = 4
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet=16M
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=4M
write_buffer=4M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
update to vB 3.5.3 and also post your phpinfo.php due to possible issue listed at http://www.vbulletin.com/forum/showthread.php?t=171071
to make all other apps use mysql on db server just in their respective config files point the mysql server to the db server internal ip address instead of localhost
then on mysql server setup the permissions for web server internal ip to access db server's mysql server
database server:
1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)
currently only the databases for the 2 vbulletins are on this server (tables for the trackers are also in thes databases)
2. your server specs. For example:
cpu speed/type single or dual cpus): dual opteron 246
how much memory installed: 4 gb ram (pc 3200)
hard drive type/configuration: 73 GB SCSI u320 15k rpm non raid
linux distributor or windows version: centOS 4.2
apache/IIS version: not installed
PHP version: not installed
MySQL version: mysql 4.1.16-standard
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
i dont know
4. if possible how mysql was compiled/installed
i downloaded and installed the "server" and "client" rpm's for RHE4 from mysql's website
5. your top stats
# top
top - 02:10:49 up 2 days, 6:10, 2 users, load average: 0.04, 0.17, 0.26
Tasks: 66 total, 1 running, 65 sleeping, 0 stopped, 0 zombie
Cpu(s): 4.0% us, 4.2% sy, 0.0% ni, 86.5% id, 4.2% wa, 1.2% hi, 0.0% si
Mem: 4090076k total, 4028216k used, 61860k free, 84412k buffers
Swap: 2048248k total, 0k used, 2048248k free, 3696248k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
4769 mysql 15 0 170m 131m 2904 S 17.3 3.3 447:00.14 mysqld
1 root 16 0 1736 516 440 S 0.0 0.0 0:00.68 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.07 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.04 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
6 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
7 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1
8 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
9 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 kacpid
38 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0
39 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/1
40 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khubd
52 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 aio/0
53 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 aio/1
51 root 15 0 0 0 0 S 0.0 0.0 0:00.24 kswapd0
126 root 25 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
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
Quote:
mysqladmin -u root -p variables
copy and paste output here
# cat /etc/my.cnf
[mysqld]
default_character_set = latin1
default-character-set = latin1
skip-innodb
server-id = 1
max_connections = 1650
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 5000
thread_cache_size = 768
wait_timeout = 7200
connect_timeout = 10
tmp_table_size = 128M
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
max_allowed_packet = 64M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet=16M
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=4M
write_buffer=4M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
7. your mysql extended-status output which shows entire server's mysql activity status (preferably with a day or 2 worth of mysql uptime for better indication of real activity) either:
# mysqladmin -u root -p ext stat ver
Enter
+----------------------------+------------+
Variable_name Value
+----------------------------+------------+
Aborted_clients 54
Aborted_connects 20
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 3991101873
Bytes_sent 1367795629
Com_admin_commands 0
Com_alter_db 0
Com_alter_table 186
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 1603358
Com_change_master 0
Com_check 0
Com_checksum 0
Com_commit 0
Com_create_db 1
Com_create_function 0
Com_create_index 0
Com_create_table 93
Com_dealloc_sql 0
Com_delete 117148
Com_delete_multi 0
Com_do 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 93
Com_drop_user 0
Com_execute_sql 0
Com_flush 0
Com_grant 1
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_help 0
Com_insert 878132
Com_insert_select 1321
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 93
Com_optimize 0
Com_preload_keys 0
Com_prepare_sql 0
Com_purge 0
Com_purge_before_date 0
Com_rename_table 0
Com_repair 0
Com_replace 206956
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_revoke_all 0
Com_rollback 0
Com_savepoint 0
Com_select 7008925
Com_set_option 15
Com_show_binlog_events 0
Com_show_binlogs 0
Com_show_charsets 0
Com_show_collations 0
Com_show_column_types 0
Com_show_create_db 0
Com_show_create_table 0
Com_show_databases 0
Com_show_errors 0
Com_show_fields 0
Com_show_grants 0
Com_show_innodb_status 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_status 0
Com_show_ndb_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_privileges 0
Com_show_processlist 0
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 1
Com_show_storage_engines 0
Com_show_tables 14
Com_show_variables 14
Com_show_warnings 0
Com_slave_start 0
Com_slave_stop 0
Com_stmt_close 0
Com_stmt_execute 0
Com_stmt_prepare 0
Com_stmt_reset 0
Com_stmt_send_long_data 0
Com_truncate 0
Com_unlock_tables 93
Com_update 2399912
Com_update_multi 1634
Connections 1282959
Created_tmp_disk_tables 634
Created_tmp_files 11416
Created_tmp_tables 149447
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Flush_commands 1
Handler_commit 0
Handler_delete 251901
Handler_discover 0
Handler_read_first 2412886
Handler_read_key 618500908
Handler_read_next 1763500488
Handler_read_prev 45430908
Handler_read_rnd 12478696
Handler_read_rnd_next 973032256
Handler_rollback 0
Handler_update 3862117
Handler_write 4641271
Key_blocks_not_flushed 0
Key_blocks_unused 0
Key_blocks_used 14497
Key_read_requests 1503829010
Key_reads 12466675
Key_write_requests 2727154
Key_writes 1301219
Max_used_connections 166
Not_flushed_delayed_rows 0
Open_files 1011
Open_streams 0
Open_tables 848
Opened_tables 1134
Qcache_free_blocks 6714
Qcache_free_memory 41939136
Qcache_hits 24296412
Qcache_inserts 6899372
Qcache_lowmem_prunes 27636
Qcache_not_cached 109406
Qcache_queries_in_cache 10081
Qcache_total_blocks 27458
Questions 37797265
Rpl_status NULL
Select_full_join 15
Select_full_range_join 1
Select_range 1228922
Select_range_check 0
Select_scan 637516
Slave_open_temp_tables 0
Slave_retried_transactions 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 0
Sort_merge_passes 5708
Sort_range 1393109
Sort_rows 566126570
Sort_scan 171919
Table_locks_immediate 23067397
Table_locks_waited 118266
Threads_cached 116
Threads_connected 50
Threads_created 166
Threads_running 9
Uptime 118538
+----------------------------+------------+
Uptime: 118538 Threads: 50 Questions: 37797266 Slow queries: 0 Opens: 1134 Flush tables: 1 Open tables: 848 Queries per second avg: 318.862
mysqladmin Ver 8.41 Distrib 4.1.16, for pc-linux-gnu on i686
(C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.16-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 8 hours 55 min 38 sec
Threads: 50 Questions: 37797266 Slow queries: 0 Opens: 1134 Flush tables: 1 Open tables: 848 Queries per second avg: 318.862
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
see ans to Q 1
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
average ??? certainly above 750
max - we touch 1150 everyday
cookie timeout - 30 mins
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
php not installed on this server
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 :
not installed on this server
12. what version of vB are you running ? 3.5.0
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log
You can use this command to find such files
Quote:
find / -size +2000000k
no files that big.
well sounds like it's the centos 2.6.9-22 load issue plays apart as well http://www.vbulletin.com/forum/showthread.php?t=171071 try upgrading the kernel on both servers :)
push wait_timeout back to 7200
Also how are the web and db servers connected ? what speed network cards ? dual network cards in web server ?
so last thing to look at is the kernel issue http://www.vbulletin.com/forum/showthread.php?t=171071
the dbserver does not have any cpanel - just centOS and mysql
i was constantly getting db error e-mails so i increased the wait_timeout (as per your advice in some other thread) and they have eased out a lot - now u r asking me to make it 120 again. r u sure?
the dbserver is running at low cpu load and lots of RAM is also free but the webserver (with cpanel) is facing cpu load issue once the number of concurrent users crosses 1000. doesnt this mean we should do something with the php / apache configuration?
with the usual 800 users online the load doesnt go above 4 - mostly below 3 and page generation times are below 0.2 seconds - so i dont think it is the issue with centOS version (though my server is running that version)
kernel upgrade is best left to web host to do.. so request them to do it.. might need to pay a fee but it's best :)
do you have a 2nd network card on web server to communicate with the web ?
well sounds like it's the centos 2.6.9-22 load issue plays apart as well http://www.vbulletin.com/forum/showthread.php?t=171071 try upgrading the kernel on both servers :)
push wait_timeout back to 7200
Also how are the web and db servers connected ? what speed network cards ? dual network cards in web server ?
the servers are connected via a gigabit cross connect independant from the internet connection
:blush: i dont know how to upgrade kernel - can u push me in the right direction?
 Where was the last debate on wednesday with Mccain and Obama?
 INSTANCE / WAITING FOR SPRING
|
separate db & web servers optimisation request