Re-optimization

محروم.كوم · #1 05-05-2009, 07:40 AM

<div>This thread is in response to issues I was having in here:
http://www.vbulletin.com/forum/showthread.php?t=274513

Apparently, apache dying problem has come back again today after few weeks of rest along with mysql going away errors.

Anyway, here goes (little bit more info than last thread):

1. Dedicated box but other websites also exist on it

2. Server Specs:

CPU: Dual Processor Quad Core Xeon 5430 - 2.66GHz (Harpertown) - 2 x 12MB cache
Memory: 8 GB RAM

Hard Drives:
1x 74 GB Raptor 10k Hard drive
3x 150 GB Raptor 10k in RAID 05
Linux: CENTOS Enterprise 5.2 i686 on Standard
Apache 2.0.63
PHP 5.2.9
MySQL 5.0.45-community

3. What version of vB are you running?
recently upgraded to latest version but some sites exist with 3.7.4

4. Does not apply

5. Host did it.

6. Top stats

Quote:
top - 22:04:46 up 47 days, 10:28, 1 user, load average: 3.18, 2.63, 2.46
Tasks: 276 total, 1 running, 273 sleeping, 1 stopped, 1 zombie
Cpu0 : 2.3%us, 1.7%sy, 3.3%ni, 92.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 30.9%us, 9.3%sy, 0.3%ni, 59.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 23.0%us, 6.3%sy, 1.3%ni, 69.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 12.9%us, 9.3%sy, 7.9%ni, 69.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 1.0%us, 2.6%sy, 3.6%ni, 92.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 19.3%us, 10.7%sy, 4.7%ni, 65.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 0.0%us, 0.7%sy, 3.0%ni, 96.4%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 23.5%us, 9.6%sy, 3.6%ni, 63.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 8311000k total, 7268156k used, 1042844k free, 555144k buffers
Swap: 2096440k total, 124k used, 2096316k free, 2579324k cached
7. mysql my.cnf configuration file

Quote:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_user_connections=700
max_connections=650
interactive_timeout=10
wait_timeout=800
connect_timeout=100
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=128M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10# Try number of CPU's*2 for thread_concurrencythread_concurrency=8
myisam_sort_buffer_size=128M
#log-binserver-id=1
[mysql.server]
user=mysqlbasedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]

[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=384M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
8. mysql stats

<div style="margin:20px; margin-top:5px; "> Quote:
root@it [/]# mysqladmin -u root -p var ext stat ver proc

Enter password:
+---------------------------------+--------------------------------------------+
| Variable_name | Value |
+---------------------------------+--------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 100 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| keep_files_on_create | OFF |
| engine_condition_pushdown | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -> __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
CSS optimization	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	01-18-2010 06:50 AM
Forum Optimization	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	11-29-2009 07:50 PM
Server Optimization Request. First time optimization	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-08-2009 04:40 AM
PHP-FPM Optimization	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-26-2009 10:00 AM
Need Server Optimization Help Please	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-13-2009 01:00 PM