Server (VPS) optimisation request

محروم.كوم · #1 04-21-2009, 01:00 AM

<div>1. VPS

2.
Code:
Intel(R) Xeon(R) CPU E5420 @ 2.50GHz 1999.742 Mhz
1048576 kB RAM
25600 Mb of HDD
CentOS 5.2
Apache/2.2.3
PHP 5.1.6
mysql-server-5.0.45-7.el5
3. vBulletin 3.6.12 Patch Level 1

4. –

5. –

6.
Code:
top - 1854 up 3:24, 1 user, load average: 4.83, 4.80, 5.34
Tasks: 49 total, 2 running, 47 sleeping, 0 stopped, 0 zombie
Cpu0 : 68.5%us, 5.7%sy, 0.0%ni, 25.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 1048576k total, 324044k used, 724532k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
Load often jumps to 15-20

7.

Code:
[client]
#password =
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set = cp1251

[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=cp1251

[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8

[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8

[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=cp1251

[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8

[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8

[myisamchk]
character-sets-dir=/usr/share/mysql/charsets

[myisampack]
character-sets-dir=/usr/share/mysql/charsets

# use [safe_mysqld] with mysql-3
[mysqld_safe]
err-log = /var/log/mysqld.log

# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations
[mysqld]
character-set-server = utf8
default-character-set = cp1251
user = mysql
port = 3306
socket = /var/lib/mysql/mysql.sock
pid-file = /var/run/mysqld/mysqld.pid
log-error = /var/log/mysqld.log
basedir = /usr
datadir = /var/lib/mysql

skip-bdb
skip-innodb
skip-locking
skip-ndbcluster
skip-networking
#bind-address = 127.0.0.1

key_buffer = 32M

sort_buffer_size = 2M
read_buffer_size = 128K
read_rnd_buffer_size = 256K
join_buffer_size = 128K

language = /usr/share/mysql/russian

max_connections = 128
max_user_connections = 64
net_buffer_length = 16K
max_allowed_packet = 8M
table_cache = 256
max_connect_errors = 1024

max_tmp_tables = 32
tmp_table_size = 32M

query_cache_size = 4M
query_cache_type = 1

thread_cache = 2
thread_concurrency = 2
thread_stack = 196K

# uncomment the next directive for windows-1251 sites
#init_connect = 'SET NAMES cp1251'

[mysqldump]
quick
max_allowed_packet = 8M

[mysql]
# uncomment the next directive if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 32M
sort_buffer_size = 4M
read_buffer = 512K
write_buffer = 512K

[myisamchk]
key_buffer = 32M
sort_buffer_size = 4M
read_buffer = 512K
write_buffer = 512K

[mysqlhotcopy]
interactive-timeout
8.
<div style="margin:20px; margin-top:5px"> Code:
auto_increment_increment 1
auto_increment_offset 1
automatic_sp_privileges ON
back_log 50
basedir /usr/
bdb_cache_size 8388600
bdb_home
bdb_log_buffer_size 0
bdb_logdir
bdb_max_lock 10000
bdb_shared_data OFF
bdb_tmpdir
binlog_cache_size 32768
bulk_insert_buffer_size 8388608

character_set_client cp1251
character_set_connection cp1251
character_set_database cp1251
character_set_filesystem binary
character_set_results cp1251
character_set_server cp1251
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
collation_connection cp1251_general_ci
collation_database cp1251_general_ci
collation_server cp1251_general_ci
completion_type 0
concurrent_insert 1
connect_timeout 5
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
engine_condition_pushdown OFF
expire_logs_days 0
flush OFF
flush_time 0
ft_boolean_syntax + -> __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server Optimisation Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-23-2009 12:22 PM
Server Optimisation Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-06-2009 07:10 PM
Server Optimisation Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-30-2009 03:40 AM
Server optimisation request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-30-2009 01:40 AM
Server (VPS) optimisation request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-21-2009 01:10 AM