Antonio Pereira
Sun 9th Sep '07, 10:47am
First of all i need to explain this is a new server and have only one admin registered and dont have forums/subforums because iam configuring one vbulletin dedicated server first time, but i have allready one forum
Threads: 20,082, Posts: 79,026, Members: 39,903
And i dont what to export nothing to the new forum and user have to make again the register, because is a new and fresh install.
I have installed already XCache 1.2.1 for bather performance, so before i ask to user create register at new forum i need to now is everything ok.
1. Is this on dedicated or shared virtual server. If shared, how many sites share this server (ask web host if needed)
Dedicated Server only for this Vbulletin Board.
2. your server specs. For example:
cpu speed/type single or dual cpus): Intel(R) Core(TM)2 Duo CPU E4500 @ 2.20GHz
how much memory installed: 3Gb ram
hard drive type/configuration: 160 SATA non raid
linux distributor or windows version: CentOS 5
apache/IIS version: apache 1.3.37
PHP version: php 5.2.0
MySQL version: mysql 5.0.27
3. what version of vB are you running ?
vBulletin® Version 3.6.8
4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
First new install mysql 5.0.27
5. if possible how mysql was compiled/installed
??
6. your top stats
top -
top - 13:42:54 up 2 days, 12:26, 1 user, load average: 0.01, 0.01, 0.00
Tasks: 137 total, 1 running, 136 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.2%sy, 0.0%ni, 99.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 3107556k total, 2005504k used, 1102052k free, 451048k buffers
Swap: 104380k total, 0k used, 104380k free, 1172456k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
13356 mysql 15 0 127m 23m 4436 S 0 0.8 3:26.59 mysqld
28292 root 15 0 2160 1040 788 R 0 0.0 0:00.96 top
1 root 15 0 2036 640 548 S 0 0.0 0:00.80 init
2 root RT 0 0 0 0 S 0 0.0 0:00.13 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/0
5 root RT 0 0 0 0 S 0 0.0 0:00.14 migration/1
6 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1
7 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/1
8 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/0
9 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/1
10 root 10 -5 0 0 0 S 0 0.0 0:00.00 khelper
11 root 11 -5 0 0 0 S 0 0.0 0:00.00 kthread
15 root 10 -5 0 0 0 S 0 0.0 0:00.02 kblockd/0
16 root 18 -5 0 0 0 S 0 0.0 0:00.01 kblockd/1
17 root 14 -5 0 0 0 S 0 0.0 0:00.00 kacpid
114 root 14 -5 0 0 0 S 0 0.0 0:00.00 cqueue/0
115 root 14 -5 0 0 0 S 0 0.0 0:00.00 cqueue/1
118 root 10 -5 0 0 0 S 0 0.0 0:00.00 khubd
120 root 10 -5 0 0 0 S 0 0.0 0:00.00 kseriod
187 root 19 0 0 0 0 S 0 0.0 0:00.00 pdflush
188 root 15 0 0 0 0 S 0 0.0 0:00.93 pdflush
189 root 14 -5 0 0 0 S 0 0.0 0:00.00 kswapd0
190 root 14 -5 0 0 0 S 0 0.0 0:00.00 aio/0
191 root 14 -5 0 0 0 S 0 0.0 0:00.00 aio/1
342 root 12 -5 0 0 0 S 0 0.0 0:00.00 kpsmoused
375 root 17 -5 0 0 0 S 0 0.0 0:00.00 ata/0
376 root 17 -5 0 0 0 S 0 0.0 0:00.00 ata/1
377 root 17 -5 0 0 0 S 0 0.0 0:00.00 ata_aux
381 root 10 -5 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
382 root 10 -5 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
383 root 18 -5 0 0 0 S 0 0.0 0:00.28 kjournald
415 root 17 -5 0 0 0 S 0 0.0 0:00.04 kauditd
449 root 16 -4 2660 1132 368 S 0 0.0 0:00.11 udevd
826 root 18 0 8200 4580 2680 S 0 0.1 0:00.10 authProg
867 root 18 0 8196 4576 2680 S 0 0.1 0:00.15 authProg
1246 root 10 -5 0 0 0 S 0 0.0 0:00.00 kmirrord
1271 root 10 -5 0 0 0 S 0 0.0 0:00.31 kjournald
1273 root 10 -5 0 0 0 S 0 0.0 0:00.02 kjournald
7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).
/etc/my.cnf
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
8. MySQL stats from ssh telnet as root user type:
mysqladmin var ext stat ver
| Com_checksum | 0 |
| Com_commit | 100 |
| Com_create_db | 4 |
| Com_create_function | 0 |
| Com_create_index | 29 |
| Com_create_table | 322 |
| Com_dealloc_sql | 0 |
| Com_delete | 740 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 3 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 189 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 25 |
| Com_grant | 22 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 156580 |
| Com_insert_select | 40 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 819 |
| Com_optimize | 228 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 114 |
| Com_replace | 816 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 2 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 183186 |
| Com_set_option | 757 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 4 |
| Com_show_charsets | 459 |
| Com_show_collations | 11 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 465 |
| Com_show_databases | 59 |
| Com_show_errors | 0 |
| Com_show_fields | 370 |
| Com_show_grants | 30 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 2 |
| 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 | 552 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 30 |
| Com_show_triggers | 17 |
| Com_show_variables | 578 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 45 |
| Com_unlock_tables | 819 |
| Com_update | 83608 |
| Com_update_multi | 48 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 104129 |
| Created_tmp_disk_tables | 470 |
| Created_tmp_files | 144 |
| Created_tmp_tables | 2349 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 307 |
| Handler_delete | 771 |
| Handler_discover | 0 |
| Handler_prepare | 202 |
| Handler_read_first | 94461 |
| Handler_read_key | 1521971 |
| Handler_read_next | 1991804 |
| Handler_read_prev | 12 |
| Handler_read_rnd | 27826 |
| Handler_read_rnd_next | 29634100 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 55898 |
| Handler_write | 242127 |
| Innodb_buffer_pool_pages_data | 33 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 412 |
| Innodb_buffer_pool_pages_free | 478 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 1 |
| Innodb_buffer_pool_pages_total | 512 |
| Innodb_buffer_pool_read_ahead_rnd | 1 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 15424 |
| Innodb_buffer_pool_reads | 14 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 1007 |
| Innodb_data_fsyncs | 502 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 2527232 |
| Innodb_data_reads | 27 |
| Innodb_data_writes | 641 |
| Innodb_data_written | 13956096 |
| Innodb_dblwr_pages_written | 412 |
| Innodb_dblwr_writes | 93 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 623 |
| Innodb_log_writes | 210 |
| Innodb_os_log_fsyncs | 301 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 409088 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 12 |
| Innodb_pages_read | 21 |
| Innodb_pages_written | 412 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 57 |
| Innodb_row_lock_time_avg | 57 |
| Innodb_row_lock_time_max | 57 |
| Innodb_row_lock_waits | 1 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 6 |
| Innodb_rows_read | 199 |
| Innodb_rows_updated | 97 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 14402 |
| Key_blocks_used | 3335 |
| Key_read_requests | 5129094 |
| Key_reads | 16028 |
| Key_write_requests | 251074 |
| Key_writes | 211923 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 6 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 123 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 20587 |
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Questions | 440631 |
| Rpl_status | NULL |
| Select_full_join | 80 |
| Select_full_range_join | 0 |
| Select_range | 2169 |
| Select_range_check | 0 |
| Select_scan | 84940 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 23 |
| Sort_range | 97 |
| Sort_rows | 1098430 |
| Sort_scan | 79515 |
| Table_locks_immediate | 434512 |
| Table_locks_waited | 1 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 0 |
| Threads_connected | 2 |
| Threads_created | 104128 |
| Threads_running | 1 |
| Uptime | 164975 |
+-----------------------------------+-----------+
Uptime: 164975 Threads: 2 Questions: 440632 Slow queries: 0 Opens: 20587 Flush tables: 1 Open tables: 64 Queries per second avg: 2.671
mysqladmin Ver 8.41 Distrib 5.0.27, for pc-linux-gnu on i686
Copyright (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 5.0.27-standard-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 21 hours 49 min 35 sec
Threads: 2 Questions: 440632 Slow queries: 0 Opens: 20587 Flush tables: 1 Open tables: 64 Queries per second avg: 2.671
9. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Yes this server is only for 1 vbulletin board , and have XCache 1.2.1 more cpanel.
10. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
At this moment is a new server but after the user start registering to coming from old forum to new i think 600 users online to 900 cookie timeout according the old forum.
Average - 200 - 400
Max - 400 - 600
Cookietimeout - 900
11. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://78.129.139.115/phpinfo.php
12. 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 :
httpd.conf
KeepAlive ON
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
MaxRequestsPerChild 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
[root@server ~]# find / -size +2000000k
find: /proc/1667/task/1667/fd/4: No such file or directory
find: /proc/1667/fd/4: No such file or directory
find: /var/named/chroot/proc/1667/task/1667/fd/4: No such file or directory
find: /var/named/chroot/proc/1667/fd/4: No such file or directory
14. Post output from these 3 commands
uname -a
Linux server.dragteam.info 2.6.18-8.1.8.el5 #1 SMP Tue Jul 10 06:50:22 EDT 2007 i686 i686 i386 GNU/Linux
ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 49017
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
max rt priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 49017
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Core(TM)2 Duo CPU E4500 @ 2.20GHz
stepping : 13
cpu MHz : 1200.000
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe lm constant_tsc pni monitor ds_cpl est tm2 cx16 xtpr lahf_lm
bogomips : 4402.50
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Core(TM)2 Duo CPU E4500 @ 2.20GHz
stepping : 13
cpu MHz : 1200.000
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe lm constant_tsc pni monitor ds_cpl est tm2 cx16 xtpr lahf_lm
bogomips : 4399.96
Threads: 20,082, Posts: 79,026, Members: 39,903
And i dont what to export nothing to the new forum and user have to make again the register, because is a new and fresh install.
I have installed already XCache 1.2.1 for bather performance, so before i ask to user create register at new forum i need to now is everything ok.
1. Is this on dedicated or shared virtual server. If shared, how many sites share this server (ask web host if needed)
Dedicated Server only for this Vbulletin Board.
2. your server specs. For example:
cpu speed/type single or dual cpus): Intel(R) Core(TM)2 Duo CPU E4500 @ 2.20GHz
how much memory installed: 3Gb ram
hard drive type/configuration: 160 SATA non raid
linux distributor or windows version: CentOS 5
apache/IIS version: apache 1.3.37
PHP version: php 5.2.0
MySQL version: mysql 5.0.27
3. what version of vB are you running ?
vBulletin® Version 3.6.8
4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
First new install mysql 5.0.27
5. if possible how mysql was compiled/installed
??
6. your top stats
top -
top - 13:42:54 up 2 days, 12:26, 1 user, load average: 0.01, 0.01, 0.00
Tasks: 137 total, 1 running, 136 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.2%sy, 0.0%ni, 99.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 3107556k total, 2005504k used, 1102052k free, 451048k buffers
Swap: 104380k total, 0k used, 104380k free, 1172456k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
13356 mysql 15 0 127m 23m 4436 S 0 0.8 3:26.59 mysqld
28292 root 15 0 2160 1040 788 R 0 0.0 0:00.96 top
1 root 15 0 2036 640 548 S 0 0.0 0:00.80 init
2 root RT 0 0 0 0 S 0 0.0 0:00.13 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/0
5 root RT 0 0 0 0 S 0 0.0 0:00.14 migration/1
6 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1
7 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/1
8 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/0
9 root 10 -5 0 0 0 S 0 0.0 0:00.00 events/1
10 root 10 -5 0 0 0 S 0 0.0 0:00.00 khelper
11 root 11 -5 0 0 0 S 0 0.0 0:00.00 kthread
15 root 10 -5 0 0 0 S 0 0.0 0:00.02 kblockd/0
16 root 18 -5 0 0 0 S 0 0.0 0:00.01 kblockd/1
17 root 14 -5 0 0 0 S 0 0.0 0:00.00 kacpid
114 root 14 -5 0 0 0 S 0 0.0 0:00.00 cqueue/0
115 root 14 -5 0 0 0 S 0 0.0 0:00.00 cqueue/1
118 root 10 -5 0 0 0 S 0 0.0 0:00.00 khubd
120 root 10 -5 0 0 0 S 0 0.0 0:00.00 kseriod
187 root 19 0 0 0 0 S 0 0.0 0:00.00 pdflush
188 root 15 0 0 0 0 S 0 0.0 0:00.93 pdflush
189 root 14 -5 0 0 0 S 0 0.0 0:00.00 kswapd0
190 root 14 -5 0 0 0 S 0 0.0 0:00.00 aio/0
191 root 14 -5 0 0 0 S 0 0.0 0:00.00 aio/1
342 root 12 -5 0 0 0 S 0 0.0 0:00.00 kpsmoused
375 root 17 -5 0 0 0 S 0 0.0 0:00.00 ata/0
376 root 17 -5 0 0 0 S 0 0.0 0:00.00 ata/1
377 root 17 -5 0 0 0 S 0 0.0 0:00.00 ata_aux
381 root 10 -5 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
382 root 10 -5 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
383 root 18 -5 0 0 0 S 0 0.0 0:00.28 kjournald
415 root 17 -5 0 0 0 S 0 0.0 0:00.04 kauditd
449 root 16 -4 2660 1132 368 S 0 0.0 0:00.11 udevd
826 root 18 0 8200 4580 2680 S 0 0.1 0:00.10 authProg
867 root 18 0 8196 4576 2680 S 0 0.1 0:00.15 authProg
1246 root 10 -5 0 0 0 S 0 0.0 0:00.00 kmirrord
1271 root 10 -5 0 0 0 S 0 0.0 0:00.31 kjournald
1273 root 10 -5 0 0 0 S 0 0.0 0:00.02 kjournald
7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).
/etc/my.cnf
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
8. MySQL stats from ssh telnet as root user type:
mysqladmin var ext stat ver
| Com_checksum | 0 |
| Com_commit | 100 |
| Com_create_db | 4 |
| Com_create_function | 0 |
| Com_create_index | 29 |
| Com_create_table | 322 |
| Com_dealloc_sql | 0 |
| Com_delete | 740 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 3 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 189 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 25 |
| Com_grant | 22 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 156580 |
| Com_insert_select | 40 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 819 |
| Com_optimize | 228 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 114 |
| Com_replace | 816 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 2 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 183186 |
| Com_set_option | 757 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 4 |
| Com_show_charsets | 459 |
| Com_show_collations | 11 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 465 |
| Com_show_databases | 59 |
| Com_show_errors | 0 |
| Com_show_fields | 370 |
| Com_show_grants | 30 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 2 |
| 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 | 552 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 30 |
| Com_show_triggers | 17 |
| Com_show_variables | 578 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 45 |
| Com_unlock_tables | 819 |
| Com_update | 83608 |
| Com_update_multi | 48 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 104129 |
| Created_tmp_disk_tables | 470 |
| Created_tmp_files | 144 |
| Created_tmp_tables | 2349 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 307 |
| Handler_delete | 771 |
| Handler_discover | 0 |
| Handler_prepare | 202 |
| Handler_read_first | 94461 |
| Handler_read_key | 1521971 |
| Handler_read_next | 1991804 |
| Handler_read_prev | 12 |
| Handler_read_rnd | 27826 |
| Handler_read_rnd_next | 29634100 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 55898 |
| Handler_write | 242127 |
| Innodb_buffer_pool_pages_data | 33 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 412 |
| Innodb_buffer_pool_pages_free | 478 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 1 |
| Innodb_buffer_pool_pages_total | 512 |
| Innodb_buffer_pool_read_ahead_rnd | 1 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 15424 |
| Innodb_buffer_pool_reads | 14 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 1007 |
| Innodb_data_fsyncs | 502 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 2527232 |
| Innodb_data_reads | 27 |
| Innodb_data_writes | 641 |
| Innodb_data_written | 13956096 |
| Innodb_dblwr_pages_written | 412 |
| Innodb_dblwr_writes | 93 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 623 |
| Innodb_log_writes | 210 |
| Innodb_os_log_fsyncs | 301 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 409088 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 12 |
| Innodb_pages_read | 21 |
| Innodb_pages_written | 412 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 57 |
| Innodb_row_lock_time_avg | 57 |
| Innodb_row_lock_time_max | 57 |
| Innodb_row_lock_waits | 1 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 6 |
| Innodb_rows_read | 199 |
| Innodb_rows_updated | 97 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 14402 |
| Key_blocks_used | 3335 |
| Key_read_requests | 5129094 |
| Key_reads | 16028 |
| Key_write_requests | 251074 |
| Key_writes | 211923 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 6 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 123 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 20587 |
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Questions | 440631 |
| Rpl_status | NULL |
| Select_full_join | 80 |
| Select_full_range_join | 0 |
| Select_range | 2169 |
| Select_range_check | 0 |
| Select_scan | 84940 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 23 |
| Sort_range | 97 |
| Sort_rows | 1098430 |
| Sort_scan | 79515 |
| Table_locks_immediate | 434512 |
| Table_locks_waited | 1 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 0 |
| Threads_connected | 2 |
| Threads_created | 104128 |
| Threads_running | 1 |
| Uptime | 164975 |
+-----------------------------------+-----------+
Uptime: 164975 Threads: 2 Questions: 440632 Slow queries: 0 Opens: 20587 Flush tables: 1 Open tables: 64 Queries per second avg: 2.671
mysqladmin Ver 8.41 Distrib 5.0.27, for pc-linux-gnu on i686
Copyright (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 5.0.27-standard-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 21 hours 49 min 35 sec
Threads: 2 Questions: 440632 Slow queries: 0 Opens: 20587 Flush tables: 1 Open tables: 64 Queries per second avg: 2.671
9. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Yes this server is only for 1 vbulletin board , and have XCache 1.2.1 more cpanel.
10. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
At this moment is a new server but after the user start registering to coming from old forum to new i think 600 users online to 900 cookie timeout according the old forum.
Average - 200 - 400
Max - 400 - 600
Cookietimeout - 900
11. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://78.129.139.115/phpinfo.php
12. 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 :
httpd.conf
KeepAlive ON
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
MaxRequestsPerChild 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
[root@server ~]# find / -size +2000000k
find: /proc/1667/task/1667/fd/4: No such file or directory
find: /proc/1667/fd/4: No such file or directory
find: /var/named/chroot/proc/1667/task/1667/fd/4: No such file or directory
find: /var/named/chroot/proc/1667/fd/4: No such file or directory
14. Post output from these 3 commands
uname -a
Linux server.dragteam.info 2.6.18-8.1.8.el5 #1 SMP Tue Jul 10 06:50:22 EDT 2007 i686 i686 i386 GNU/Linux
ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 49017
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
max rt priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 49017
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Core(TM)2 Duo CPU E4500 @ 2.20GHz
stepping : 13
cpu MHz : 1200.000
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe lm constant_tsc pni monitor ds_cpl est tm2 cx16 xtpr lahf_lm
bogomips : 4402.50
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Core(TM)2 Duo CPU E4500 @ 2.20GHz
stepping : 13
cpu MHz : 1200.000
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe lm constant_tsc pni monitor ds_cpl est tm2 cx16 xtpr lahf_lm
bogomips : 4399.96