چگونگی اختصاص منابع مصرفی بیشتر به موتور دیتابیس ؟

[Varmazyar]

این کانفیگ :

[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql



#max_allowed_packet = 16M
max_allowed_packet = 32M 
#table_cache = 512
table_cache = 2048 
#query_cache_size = 64M
query_cache_size = 128M 
thread_cache_size = 4
#WVM: max_allowed_packet = 32M
#WVM: table_cache = 512
#WVM: query_cache_size = 32M
#WVM: thread_cache_size = 8

# WVM 

symbolic-links=0
read_rnd_buffer_size = 8M
read_buffer_size = 2M
sort_buffer_size = 2M
myisam_sort_buffer_size = 64M
innodb_file_per_table = 1
thread_concurrency = 8


#key_buffer = 512M
key_buffer = 384M
# Forced OLD_PASSWORD format is turned OFF by Plesk
#old_passwords=1
#OLD: default_character_set = utf8
collation_server = utf8_general_ci
character_set_server = utf8
max_connections = 75
query_cache_limit = 2024M
#default_table_type = InnoDB
default_storage_engine=InnoDB
#tmpdir = /var/lib/mysql/tmp
#tmp_table_size = 128M
tmp_table_size = 256M
#max_heap_table_size = 128M
max_heap_table_size = 256M
#join_buffer_size = 2M
join_buffer_size = 2M
thread_stack = 192K
log-slow-queries = /var/log/slow_query.log
#slow_query_log = /var/log/slow_query.log
#OLD: log_slow_queries
long_query_time = 1
#innodb_buffer_pool_size = 512M
innodb_buffer_pool_size = 2048M
innodb_flush_log_at_trx_commit = 0
innodb_log_buffer_size = 4M
#innodb_log_file_size = 512M
innodb_flush_method=O_DSYNC

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid 

اینم مشخصات سرور :

Linux 2.6.32-279.22.1.el6.x86_64 #1 SMP Wed Feb 6 03:10:46 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
Intel(R) Xeon(R) CPU            5130  @ 2.00GHz
MemTotal:       10130296 kB