X-bit labs - Print version::
The first dual-core Xeon processors are scheduled to come out in early 2006 and will offer their dual-core CPUs as high-performance server, desktop and mobile
http://www.xbitlabs.com/articles/cpu/print/dual-core.htmlHOME |
hi eva2000,
I have a Dual Xeon 2.8, 2048 Ram server.I m keeping just a forum site in the server, the real onlines are changing between 700 and 800 and for a month cpu load is about %40-50 and it degrees so rare and also the requests are 44.6 requestssec and 111.7kBsec - 2562 Brequest 200 requests currently being processed, 0 idle servers and when sometimes it gets 61.4 requestssec. I tried everything but i cant reduce the cpu load.
Even when i m waiting for your answer i want help of u for optimizing the server with payment. My vB version is 3.0.7 and i m giving all the information here. I didnt estimate that one forum can use that much cpu in a dual Xeon server.
Thanks for ur help
best wishes..
1. Linux 2.6.15.1 #1 SMP Sun Jan 29 20:07:55 EET 2006 i686 i686 i386 GNU/Linux
2.
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 1
cpu MHz : 2800.596
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 nx lm pni monitor ds_cpl cid cx16 xtpr
bogomips : 5606.41
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 1
cpu MHz : 2800.596
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 nx lm pni monitor ds_cpl cid cx16 xtpr
bogomips : 5600.61
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 1
cpu MHz : 2800.596
cache size : 1024 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 nx lm pni monitor ds_cpl cid cx16 xtpr
bogomips : 5600.65
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 1
cpu MHz : 2800.596
cache size : 1024 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
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 nx lm pni monitor ds_cpl cid cx16 xtpr
bogomips : 5600.69
3.
Operation System: CentOS 4.2
Apache Versyon: 1.3.33
MySQL version: mysql 4.0.25
PHP version: php 4.4.2
4. Avarage
top - 00:41:02 up 4:10, 1 user, load average: 51.64, 51.68, 50.59
Tasks: 432 total, 54 running, 378 sleeping, 0 stopped, 0 zombie
Cpu(s): 84.7% us, 5.5% sy, 0.0% ni, 6.2% id, 0.7% wa, 0.1% hi, 2.9% si
Mem: 2067644k total, 1812180k used, 255464k free, 16792k buffers
Swap: 1052248k total, 8k used, 1052240k free, 467320k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17908 mysql 16 0 336m 160m 1460 R 46.0 8.0 2:04.84 mysqld
20936 mysql 16 0 336m 160m 1460 R 38.1 8.0 1:42.51 mysqld
15872 mysql 16 0 336m 160m 1460 R 24.3 8.0 3:54.84 mysqld
18311 mysql 16 0 336m 160m 1460 S 19.7 8.0 2:18.85 mysqld
18324 mysql 17 0 336m 160m 1460 R 14.8 8.0 1:37.32 mysqld
20973 mysql 17 0 336m 160m 1460 R 14.4 8.0 1:12.48 mysqld
17966 mysql 15 0 336m 160m 1460 S 13.5 8.0 2:17.65 mysqld
25214 nobody 16 0 14940 9080 1896 S 13.1 0.4 0:16.17 httpd
21915 mysql 16 0 336m 160m 1460 R 10.2 8.0 1:14.24 mysqld
17874 mysql 15 0 336m 160m 1460 S 9.5 8.0 2:14.75 mysqld
18309 mysql 15 0 336m 160m 1460 S 8.9 8.0 2:03.32 mysqld
21996 mysql 15 0 336m 160m 1460 S 8.5 8.0 1:18.07 mysqld
25435 mysql 15 0 336m 160m 1460 S 8.2 8.0 0:34.59 mysqld
25473 mysql 15 0 336m 160m 1460 S 7.9 8.0 0:30.16 mysqld
17926 mysql 16 0 336m 160m 1460 R 7.6 8.0 1:56.17 mysqld
25447 mysql 17 0 336m 160m 1460 R 7.2 8.0 0:33.48 mysqld
25281 nobody 15 0 15612 9752 1896 S 5.9 0.5 0:16.28 httpd
25326 nobody 16 0 14676 8812 1892 S 5.6 0.4 0:14.22 httpd
25196 nobody 16 0 14864 9020 1916 R 4.6 0.4 0:17.46 httpd
25286 nobody 15 0 14704 8844 1896 S 4.6 0.4 0:08.08 httpd
25288 nobody 16 0 14820 9000 1936 S 4.3 0.4 0:18.08 httpd
25339 nobody 15 0 15588 9764 1932 S 3.9 0.5 0:20.41 httpd
25323 nobody 16 0 15596 9732 1892 S 3.6 0.5 0:14.70 httpd
25258 nobody 15 0 15676 9704 1896 S 3.3 0.5 0:15.54 httpd
25461 mysql 15 0 336m 160m 1460 S 3.3 8.0 0:36.98 mysqld
25204 nobody 15 0 14504 8640 1896 S 3.0 0.4 0:14.79 httpd
25244 nobody 15 0 14284 8500 1972 S 3.0 0.4 0:15.26 httpd
25261 nobody 15 0 15372 9596 1980 S 2.6 0.5 0:18.18 httpd
25289 nobody 16 0 14724 8860 1892 S 2.6 0.4 0:12.34 httpd
25220 nobody 15 0 14772 8996 1980 S 2.3 0.4 0:17.83 httpd
25229 nobody 15 0 14736 8912 1932 S 2.3 0.4 0:14.62 httpd
25253 nobody 15 0 14356 8492 1892 S 2.3 0.4 0:06.23 httpd
25255 nobody 15 0 15544 9760 1972 S 2.3 0.5 0:13.66 httpd
25285 nobody 16 0 15236 9384 1904 S 2.3 0.5 0:14.32 httpd
25302 nobody 15 0 15436 9580 1900 S 2.3 0.5 0:12.97 httpd
25304 nobody 16 0 14680 8908 1984 S 2.3 0.4 0:17.30 httpd
26869 nobody 15 0 14472 8612 1896 S 2.3 0.4 0:07.21 httpd
25202 nobody 15 0 14360 8544 1940 S 2.0 0.4 0:16.83 httpd
25293 nobody 15 0 14620 8756 1892 S 2.0 0.4 0:16.26 httpd
25337 nobody 16 0 14692 8864 1928 R 2.0 0.4 0:15.89 httpd
25228 nobody 15 0 15560 9608 1904 S 1.6 0.5 0:15.76 httpd
25251 nobody 15 0 14532 9104 2328 S 1.6 0.4 0:12.37 httpd
24082 nobody 16 0 14416 8488 1892 S 1.6 0.4 0:01.05 httpd
17354 mysql 15 0 336m 160m 1460 D 1.3 8.0 2:31.96 mysqld
25206 nobody 15 0 14408 8540 1892 S 1.3 0.4 0:15.08 httpd
25207 nobody 15 0 14844 9028 1940 S 1.3 0.4 0:14.71 httpd
25224 nobody 17 0 14976 9552 2332 S 1.3 0.5 0:15.62 httpd
25246 nobody 15 0 14372 8556 1940 S 1.3 0.4 0:17.08 httpd
5. my.cnf
[mysqld]
datadir=/var/lib/mysql
skip-locking
skip-innodb
skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=64M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
Dell PowerEdge 2650 Dual Xeon 2.8GHz 2GB 3x 73GB 2U Server Dell PowerEdge::
Dual embedded NICs with failover and load balancing support. Hot-plug redundant power supplies High availability fibre channel and SCSI cluster support
http://www.geeks.com/details.asp?invtid=PWREDGE-2650-28-RHOME |
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=64M ## 32MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M ## 1MB for every 1GB of RAM
read_buffer_size=2M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=2M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
log-slow-queries = /var/log/mysql_slow_query_log
long_query_time = 5
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
6. Veriables
-----------------------------------------------------------------------------------------+
Variable_name Value
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
back_log 50
basedir /
binlog_cache_size 32768
bulk_insert_buffer_size 8388608
character_set latin1
character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent_insert ON
connect_timeout 20
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 NO
have_crypt YES
have_innodb DISABLED
E7501 | Compare Prices on E7501 | Become.com::
servers, network management, security, voice, and load balancing. Details on 1U Server 533MHz No-Mem CPU HDD Dual Xeon 1U SCSI 320 Dual G LAN. Read More
http://www.become.com/e7501HOME |
Special Report: AMD Opteron - First Look: Opteron Inside -- Finally ::
load, where transaction processing stabilized with both high disk and CPU CPU) performing much better than the dual-channel DDR266 memory in the Xeon
http://www.extremetech.com/article2/0,3973,1149817,00.aspHOME |
have_isam YES
have_raid NO
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
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 10
join_buffer_size 1044480
key_buffer_size 67108864
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 5
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 20
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 200
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 10000
pid_file /var/lib/mysql/server.hackhell.com.pid
log_error
port 0
protocol_version 10
query_alloc_block_size 8192
query_cache_limit 1048576
query_cache_size 67108864
query_cache_type ON
query_cache_wlock_invalidate OFF
query_prealloc_size 8192
range_alloc_block_size 2048
read_buffer_size 2093056
read_only OFF
read_rnd_buffer_size 2093056
rpl_recovery_rank 0
server_id 1
slave_net_timeout 3600
skip_external_locking ON
skip_networking ON
skip_show_database OFF
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer_size 2097144
sql_mode 0
table_cache 1024
table_type MYISAM
thread_cache_size 128
thread_stack 126976
tx_isolation REPEATABLE-READ
timezone EET
tmp_table_size 33554432
tmpdir /tmp/
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
version 4.0.25-standard-log
version_comment Official MySQL RPM
version_compile_os pc-linux-gnu
wait_timeout 20
extended-status
+--------------------------+------------+
Variable_name Value
+--------------------------+------------+
Aborted_clients 2638
Aborted_connects 4
Bytes_received 219104833
Bytes_sent 113462246
Com_admin_commands 0
Com_alter_table 27
Com_analyze 0
Com_backup_table 0
Com_begin 3
Com_change_db 52632
Com_change_master 0
Com_check 0
Com_commit 3
Com_create_db 1
Com_create_function 0
Com_create_index 36
Com_create_table 19
Com_delete 2050
Com_delete_multi 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_flush 3
Com_grant 19
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_insert 5479
Com_insert_select 203
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 261
Com_optimize 0
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 4305
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_savepoint 0
Com_select 312955
Com_set_option 102
Com_show_binlog_events 0
Com_show_binlogs 0
Com_show_create 0
Com_show_databases 1
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 33
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 1
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 261
Com_update 68938
Com_update_multi 0
Connections 53309
Created_tmp_disk_tables 2109
Created_tmp_tables 16917
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_commit 0
Handler_delete 4567
Handler_read_first 28800
Handler_read_key 32164955
Handler_read_next 79598868
Handler_read_prev 704535
Handler_read_rnd 20820050
Handler_read_rnd_next 2623687759
Handler_rollback 0
Handler_update 1704471
Handler_write 8427110
Key_blocks_used 28676
Key_read_requests 95153008
Key_reads 26578
Key_write_requests 39211
Key_writes 25421
Max_used_connections 186
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 1024
Open_files 1001
Open_streams 0
Opened_tables 1138
Questions 757240
Qcache_queries_in_cache 7075
Qcache_inserts 290911
Qcache_hits 258553
Qcache_lowmem_prunes 0
Qcache_not_cached 22019
Qcache_free_memory 46465456
Qcache_free_blocks 3091
Qcache_total_blocks 17570
Rpl_status NULL
Select_full_join 242
Select_full_range_join 0
Select_range 52804
Select_range_check 0
Select_scan 130914
Slave_open_temp_tables 0
Slave_running OFF
Slow_launch_threads 2
Slow_queries 10908
Sort_merge_passes 0
Sort_range 42843
Sort_rows 91167880
Sort_scan 50756
Table_locks_immediate 584070
Table_locks_waited 147814
Threads_cached 29
Threads_created 223
Threads_connected 131
Threads_running 120
Uptime 9854
+--------------------------+------------+
7. Phpinfo
http://www.hackhell.com/phpinfo.php
8. httpd.conf
Timeout 90
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 7
MinSpareServers 15
MaxSpareServers 20
StartServers 15
MaxClients 200
MaxRequestsPerChild 0
Thanks for your help.. Save me from that cpu usage :(
Hi eva2000
informatıon of cpu load and prints about mysql whıch you want are above. Accordıng to ancıents actually %4 load whıch ıs usıng at the moment provides the pages openıng like a rocket however ı thınk %4 s have hıgh values ıf not ınsıde the month ı m planıng to dedıcate xeon3.2 for my web sıte. what do you thınk about what ı would do.would ı change the server or ıt wıll be enough for me for a long tıme ı would be grateful for your helps and supports thank you so much have a good works.
Cpu Load
top - 22:27:33 up 3 days, 11:56, 1 user, load average: 4.09, 4.45, 4.84
Tasks: 417 total, 7 running, 410 sleeping, 0 stopped, 0 zombie
Cpu(s): 27.4% us, 2.2% sy, 0.1% ni, 65.0% id, 3.7% wa, 0.0% hi, 1.5% si
Mem: 2067644k total, 1986100k used, 81544k free, 28752k buffers
Swap: 1052248k total, 7268k used, 1044980k free, 700776k cached
mysql
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Variable_name Value
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
back_log 50
basedir /
binlog_cache_size 32768
bulk_insert_buffer_size 8388608
character_set latin1
character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
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 NO
have_crypt YES
have_innodb DISABLED
have_isam YES
repost output of this command during how cpu loads
mysqladmin -u root -p var ext stat proc
How large is your forum database size ? attachments table size ?
Did you check if you have log files >2GB ?
Check disk free space ? type
df -h
what's the output ?
Checked your apache and mysql error logs ?
Do you have hacks installed on your vB forum ? remove all of them and see how it fairs
Cookie timeout for 700-800 vB users ????
Seems mysql is consuming all the cpu time there for some reason
1. Edit /etc/my.cnf and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards
[mysqld]
datadir=/var/lib/mysql
safe-show-database
skip-innodb
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 = 1800
thread_cache_size = 384
wait_timeout = 120
connect_timeout = 10
tmp_table_size = 128M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
thread_concurrency = 4
query_cache_limit = 2M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
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
2. 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
3. Upgrade to vB 3.0.12 http://www.vbulletin.com/forum/showthread.php?t=166389
4. edit httpd.conf values
from
Timeout 90
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 7
MinSpareServers 15
MaxSpareServers 20
StartServers 15
MaxClients 200
MaxRequestsPerChild 0
to
Timeout 90
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 7
MinSpareServers 15
MaxSpareServers 20
StartServers 15
MaxClients 150
MaxRequestsPerChild 10000
restart apache
5. ensure vB config.php usepconnect = 0 /disabled and if you have any other php/mysql apps like phpadsnew, disable persistent connections there as well
Hello Eva2000
Database is 600 mb. I checked Apache and mySQL logs, actually errors depend on file not found.
on vB forum, vBAdvanced, Thank you hack, Time spend hack are installed
Cookie timeout is 2400
And when I entered values u gave me, CPU loads are really decreased
You told me to upgrade to 3.0.12 but I plan to upgrade to 3.5.2. Is this cause a problem?
Thank you very much for helping me
how much cpu load reduced with the new my.cnf ?
i'd upgrade to 3.0.12 for now
how much cpu load reduced with the new my.cnf ?
i'd upgrade to 3.0.12 for now
Load
top - 18:17:22 up 7:45, 1 user, load average: 3.65, 3.27, 2.80
Tasks: 262 total, 1 running, 259 sleeping, 0 stopped, 2 zombie
Cpu(s): 35.3% us, 3.4% sy, 0.0% ni, 41.0% id, 16.5% wa, 0.0% hi, 3.7% si
Mem: 2067644k total, 1628728k used, 438916k free, 49104k buffers
Swap: 1052248k total, 128k used, 1052120k free, 866340k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
26481 nobody 16 0 48500 16m 10m S 11.0 0.8 0:30.98 httpd
26519 nobody 15 0 47904 14m 9816 S 8.3 0.7 0:30.59 httpd
26521 nobody 15 0 48788 15m 9m S 8.3 0.8 0:37.99 httpd
26494 nobody 16 0 48432 15m 10m S 7.6 0.8 0:32.89 httpd
26538 nobody 15 0 49128 17m 10m S 7.6 0.9 0:30.32 httpd
26541 nobody 15 0 47832 14m 9804 S 7.3 0.7 0:28.43 httpd
26564 nobody 16 0 48844 16m 10m S 7.0 0.8 0:36.76 httpd
26550 nobody 15 0 47764 14m 9716 S 6.0 0.7 0:33.01 httpd
3124 nobody 15 0 47584 13m 9328 S 6.0 0.7 0:09.42 httpd
26483 nobody 15 0 47824 15m 10m S 5.6 0.8 0:31.92 httpd
26495 nobody 16 0 48400 14m 9620 S 5.3 0.7 0:30.96 httpd
26547 nobody 15 0 48776 16m 10m S 5.3 0.8 0:32.48 httpd
26507 nobody 15 0 47568 14m 10m S 3.3 0.7 0:31.66 httpd
28152 hackhell 15 0 25340 22m 1760 S 2.7 1.1 0:07.82 spamd
26510 nobody 15 0 49124 19m 13m S 2.3 1.0 0:32.05 httpd
new my.conf
[mysqld]
datadir=/var/lib/mysql
safe-show-database
skip-innodb
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 = 1800
thread_cache_size = 384
wait_timeout = 120
connect_timeout = 10
tmp_table_size = 128M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
thread_concurrency = 4
query_cache_limit = 2M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
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
at the morning upgraded to 3.5.2 version and didnt load any other hack than vBadvanced.. now its workin alright..
 Where was the last debate on wednesday with Mccain and Obama?
 INSTANCE / WAITING FOR SPRING
|
Dual Xeon Server High Cpu Load :(