bluefreesky
welcome to my space
Help my little Celeron hold on a bit longer!
January 9, 2009 on 3:38 pm | By | In bluefreesky.com | Help my little Celeron hold on a bit longer!This is a dedicated box
2. your server specs. For example:
cpu speed/type single or dual cpus): 2.4ghz Celeron
how much memory installed: 1gb ram
hard drive type/configuration: 80GB ide
linux distributor or windows version: Debian Sarge
apache/IIS version: apache 2.0.54
PHP version: PHP 4.3.10-19
MySQL version: mysql 4.0.24
*All are up to date by Debian standards. I'm using their packages.
3. what version of vB are you running ?
3.6.4
4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
No
5. if possible how mysql was compiled/installed
Using APT
6. your top stats
top - 22:40:00 up 158 days, 20:02, 1 user, load average: 7.62, 7.36, 6.14
Tasks: 195 total, 2 running, 192 sleeping, 0 stopped, 1 zombie
Cpu(s): 52.7% user, 10.8% system, 0.0% nice, 36.5% idle
Mem: 905404k total, 850952k used, 54452k free, 19016k buffers
Swap: 2000084k total, 67564k used, 1932520k free, 521080k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21440 www-data 11 0 18668 17m 11m S 7.0 1.9 0:04.67 apache2
21495 www-data 9 0 18492 16m 11m S 5.4 1.9 0:02.25 apache2
21466 www-data 9 0 21600 19m 11m S 5.0 2.3 0:03.84 apache2
21565 root 18 0 1136 1136 844 R 3.0 0.1 0:00.46 top
21478 www-data 9 0 18424 16m 11m S 2.4 1.9 0:03.35 apache2
28193 mysql 9 0 95172 86m 2760 S 1.8 9.8 1:42.56 mysqld
28223 mysql 10 0 95172 86m 2760 S 1.8 9.8 1:38.80 mysqld
21465 www-data 10 0 19508 17m 11m S 1.8 2.0 0:03.18 apache2
21568 www-data 9 0 14496 12m 11m S 1.6 1.5 0:00.10 apache2
21551 www-data 11 0 0 0 0 Z 1.4 0.0 0:01.28 apache2
21248 www-data 10 0 39848 37m 11m S 1.2 4.3 0:40.21 apache2
28197 mysql 9 0 95172 86m 2760 S 1.0 9.8 1:32.71 mysqld
21475 www-data 10 0 18896 17m 11m S 1.0 2.0 0:02.10 apache2
21561 www-data 9 0 14288 12m 11m S 1.0 1.4 0:00.09 apache2
21467 www-data 9 0 18496 16m 11m S 0.8 1.9 0:03.47 apache2
21470 www-data 9 0 18372 16m 11m S 0.8 1.9 0:03.28 apache2
21560 www-data 10 0 18256 16m 11m S 0.8 1.9 0:00.71 apache2
21562 www-data 10 0 17924 16m 11m S 0.8 1.8 0:00.34 apache2
17278 mysql 9 0 95172 86m 2760 S 0.6 9.8 0:11.12 mysqld
21494 www-data 10 0 19660 18m 11m S 0.4 2.0 0:03.19 apache2
21525 www-data 10 0 18308 16m 11m S 0.4 1.9 0:01.57 apache2
21556 www-data 9 0 21624 19m 11m S 0.4 2.3 0:00.57 apache2
21559 www-data 9 0 18056 16m 11m S 0.4 1.9 0:00.68 apache2
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).
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer = 32M
max_allowed_packet = 16M
thread_stack = 128K
max_connections = 500
table_cache = 1800
sort_buffer_size = 1M
join_buffer_size = 1M
read_buffer_size = 1M
myisam_sort_buffer_size = 64M
thread_cache_size = 384
wait_timeout = 30
tmp_table_size = 64M
connect_timeout = 10
max_connect_errors = 10
thread_concurrency = 2
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql.log
#log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
log-slow-queries = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
#log-bin = /var/log/mysql/mysql-bin.log
# See /etc/mysql/debian-log-rotate.conf for the number of files kept.
#max_binlog_size = 104857600
#binlog-do-db = include_database_name
#binlog-ignore-db = include_database_name
#
# * BerkeleyDB
#
# The use of BerkeleyDB is now discouraged and support for it will probably
# cease in the next versions.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Feature
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# If you want to enable SSL support (recommended) read the manual or my
# HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt.gz
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
8. MySQL stats from ssh telnet as root user type:
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Variable_name Value
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
back_log 50
basedir /usr/
bdb_cache_size 8388600
bdb_log_buffer_size 0
bdb_home
bdb_max_lock 10000
bdb_logdir
bdb_shared_data OFF
bdb_tmpdir
bdb_version Sleepycat Software: Berkeley DB 3.2.9a: (March 5, 2005)
binlog_cache_size 32768
bulk_insert_buffer_size 8388608
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 latin1_de latin2 latin5 sjis swe7 tis620 ujis usa7 win1250 win1251ukr win1251
concurrent_insert ON
connect_timeout 10
convert_character_set
datadir /var/lib/mysql/
default_week_format 0
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 0
ft_boolean_syntax + -><()~*:""&
ft_min_word_len 4
ft_max_word_len 254
ft_max_word_len_for_sort 20
ft_stopword_file (built-in)
have_bdb DISABLED
have_crypt YES
have_innodb YES
have_isam YES
have_raid YES
have_symlink YES
have_openssl NO
have_query_cache YES
init_file
innodb_additional_mem_pool_size 1048576
innodb_autoextend_increment 8
innodb_buffer_pool_size 8388608
innodb_data_file_path ibdata1:10M:autoextend
innodb_data_home_dir
innodb_file_io_threads 4
innodb_force_recovery 0
innodb_thread_concurrency 8
innodb_flush_log_at_trx_commit 1
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
innodb_max_dirty_pages_pct 90
innodb_max_purge_lag 0
innodb_table_locks ON
interactive_timeout 28800
join_buffer_size 1044480
key_buffer_size 33554432
language /usr/share/mysql/english/
large_files_support ON
license GPL
local_infile ON
locked_in_memory OFF
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
log_slow_queries ON
log_warnings 1
long_query_time 10
low_priority_updates OFF
lower_case_file_system OFF
lower_case_table_names 0
max_allowed_packet 16776192
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 500
max_connect_errors 10
max_delayed_threads 20
max_insert_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_relay_log_size 0
max_seeks_for_key 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_max_extra_sort_file_size 268435456
myisam_max_sort_file_size 2147483647
myisam_repair_threads 1
myisam_recover_options OFF
myisam_sort_buffer_size 67108864
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
new OFF
open_files_limit 4110
pid_file /var/run/mysqld/mysqld.pid
log_error
port 3306
protocol_version 10
query_alloc_block_size 8192
query_cache_limit 1048576
query_cache_size 33554432
query_cache_type ON
query_cache_wlock_invalidate OFF
query_prealloc_size 8192
range_alloc_block_size 2048
read_buffer_size 1044480
read_only OFF
read_rnd_buffer_size 262144
rpl_recovery_rank 0
server_id 0
slave_net_timeout 3600
skip_external_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket /var/run/mysqld/mysqld.sock
sort_buffer_size 1048568
sql_mode 0
table_cache 1800
table_type MYISAM
thread_cache_size 384
thread_stack 131072
tx_isolation REPEATABLE-READ
timezone EDT
tmp_table_size 67108864
tmpdir /tmp/
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
version 4.0.24_Debian-10sarge2-log
version_comment Source distribution
version_compile_os pc-linux-gnu
wait_timeout 30
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------+------------+
Variable_name Value
+--------------------------+------------+
Aborted_clients 152
Aborted_connects 638
Bytes_received 331105409
Bytes_sent 1299080420
Com_admin_commands 2
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 470
Com_change_db 67811
Com_change_master 0
Com_check 997
Com_commit 469
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_delete 7426
Com_delete_multi 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_flush 0
Com_grant 0
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_insert 31663
Com_insert_select 32
Com_kill 0
Com_load 0
Com_load_master_data 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 4471
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 1
Com_savepoint 0
Com_select 360453
Com_set_option 844
Com_show_binlog_events 0
Com_show_binlogs 1
Com_show_create 0
Com_show_databases 5
Com_show_fields 0
Com_show_grants 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_processlist 0
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 245
Com_show_innodb_status 0
Com_show_tables 98
Com_show_variables 8
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 0
Com_update 139999
Com_update_multi 0
Connections 163832
Created_tmp_disk_tables 2183
Created_tmp_tables 50201
Created_tmp_files 5
Delayed_insert_threads 0
Delayed_writes 82
Delayed_errors 1
Flush_commands 1
Handler_commit 0
Handler_delete 15592
Handler_read_first 100551
Handler_read_key 15317669
Handler_read_next 100368980
Handler_read_prev 618803
Handler_read_rnd 5658065
Handler_read_rnd_next 64652746
Handler_rollback 1
Handler_update 704328
Handler_write 846370
Key_blocks_used 31172
Key_read_requests 55841366
Key_reads 70738
Key_write_requests 132218
Key_writes 112118
Max_used_connections 32
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 1129
Open_files 2054
Open_streams 0
Opened_tables 1135
Questions 1300713
Qcache_queries_in_cache 10368
Qcache_inserts 327861
Qcache_hits 522717
Qcache_lowmem_prunes 2497
Qcache_not_cached 32592
Qcache_free_memory 13194136
Qcache_free_blocks 3578
Qcache_total_blocks 24815
Rpl_status NULL
Select_full_join 5204
Select_full_range_join 0
Select_range 101530
Select_range_check 0
Select_scan 37790
Slave_open_temp_tables 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 9
Sort_merge_passes 1
Sort_range 89033
Sort_rows 5778809
Sort_scan 24650
Table_locks_immediate 1022251
Table_locks_waited 1108
Threads_cached 31
Threads_created 33
Threads_connected 2
Threads_running 1
Uptime 37040
+--------------------------+------------+
Uptime: 37040 Threads: 2 Questions: 1300714 Slow queries: 9 Opens: 1135 Flush tables: 1 Open tables: 1129 Queries per second avg: 35.116
mysqladmin Ver 8.40 Distrib 4.0.24, for pc-linux-gnu on i386
(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.0.24_Debian-10sarge2-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 10 hours 17 min 20 sec
Threads: 2 Questions: 1300714 Slow queries: 9 Opens: 1135 Flush tables: 1 Open tables: 1129 Queries per second avg: 35.116
9. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
It's the main site. There's a couple phpbb sites that might have one or two people on at any given time. Very small stuff.
10. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
It claims there max is tonight.. 160 users online but that doesn't seem like a right number. We've never had this many people online at one time. Cookie timeout is 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://www.xceedspeed.com/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 :
Keepalive is off
StartServers 10
MinSpareServers 10
MaxSpareServers 15
MaxClients 150
MaxRequestsPerChild 150
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
No apache log files this large.
14. Post output from these 3 commands
uname -a
Linux srv01.xceednetwork.com 2.4.27-2-386 #1 Wed Aug 17 09:33:35 UTC 2005 i686 GNU/Linux
ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) unlimited
virtual memory (kbytes, -v) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Celeron(R) CPU 2.40GHz
stepping : 9
cpu MHz : 2423.931
cache size : 128 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid
bogomips : 4836.55
1. Upgrade MySQL server to 4.0.27
2. Upgrade PHP to 4.4.6 and/or recompile PHP 4.4.6 after upgrading MySQL
3. Edit /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
safe-show-database
skip-innodb
max_connections = 500
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 128
wait_timeout = 35
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 32M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 2M
query_cache_size = 16M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
4. Install APC Cache lastest version from http://pecl.php.net/package/APC. Read install guide at http://www.vbulletin.com/forum/showthread.php?t=165367 - please remove Zend Optimizer from php.ini before installing APC Cache. OR try the alternative PHP caching software, Xcache which seems to be a bit faster than APC Cache - http://www.vbulletin.com/forum/showthread.php?t=213267
5. Upgrade to vB 3.6.5 http://www.vbulletin.com/forum/showthread.php?t=221905 if you're on vB 3.6.x
6. If you just upgraded to vB 3.5.x/3.6.x try to disable these 4 options:
Admin CP -> vBulletin Options -> Forums Home Page Options -> Display Logged in Users?
Admin CP -> vBulletin Options -> Forum Display Options (forumdisplay) -> Show Users Browsing Forums
Admin CP -> vBulletin Options -> Thread Display Options -> Show Users Browsing Thread
Admin CP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread search
#If you have any other info about this subject , Please add it free.# |
edit