Как видно из оглавления , возникает вопрос как сделать чтоб все ядра были нагружены равномерно ?
2 GB RAM
processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 42 model name : Intel(R) Xeon(R) CPU E31230 @ 3.20GHz stepping : 7 cpu MHz : 3192.922 cache size : 8192 KB physical id : 0 siblings : 8 core id : 0 cpu cores : 4 apicid : 0 fpu : yes fpu_exception : yes cpuid level : 13 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 syscall nx rdtscp lm constant_tsc ida nonstop_tsc arat pni monitor ds_cpl vmx smx est tm2 ssse3 cx16 xtpr sse4_1 sse4_2 popcnt lahf_lm bogomips : 6385.84 clflush size : 64 cache_alignment : 64 address sizes : 36 bits physical, 48 bits virtual power management: [8]
[mysqld] 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 max_connections=400 thread_cache=16 thread_cache_size=128 key_buffer=256M ## 128MB for every 1GB of RAM key_buffer_size=280MB #30% 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=16 ## Number of CPUs x 2 innodb_file_per_table #innodb_thread_concurrency=8 ## Number of CPUs x 2 myisam_sort_buffer_size=64M log_slow_queries=/var/log/mysql-slow-queries.log long_query_time=20 interactive_timeout=20 #wait_timeout=57600 wait_timeout=100000 net_read_timeout=400 net_write_timeout=600 connect_timeout=20 delayed_insert_timeout=10 local-infile=0
log-warnings=2 log-error=/var/log/mysql_err.log max_allowed_packet=32M
############ #log-bin=master1-bin #expire_logs_days = 10 # purge binary log after 10 days #max_binlog_size = 1024M ############ #log = /var/log/mysql.log
[mysql.server] user=mysql
[safe_mysqld] open_files_limit=8192
[mysqldump] quick max_allowed_packet=16M
