mysqlperformanceblog.com rol szedd le a perconba buildeket
és
thread_stack = 200K
thread_cache_size = 8
join_buffer_size = 2M
read_buffer_size = 4M
read_rnd_buffer_size = 16M
sort_buffer_size = 4M
myisam_sort_buffer_size = 128M
key_buffer = 384M
query_cache_limit = 1M
query_cache_size = 32M
#PERCONA SPECIFIC
innodb_buffer_pool_size = 2G
innodb_flush_log_at_trx_commit = 0
innodb_thread_concurrency = 0
innodb_file_per_table = 1
innodb_status_file = 0
innodb_io_capacity = 1000
innodb_write_io_threads = 16
innodb_read_io_threads = 16
innodb_flush_method = O_DIRECT
innodb_adaptive_checkpoint = 1
ez 8giga ram, 2gb db, masodpercenkent olyan 2-300 q
--
--ha magyar MAC-et akarsz--