Innodb plugin 1.0.4 fine tune for performance

Wednesday, February 16, 2011


SERVER SETTINGS (my.cnf)
==========================================================================================================
#The MySQL server always must be started with the option ignore_builtin_innodb, as long as you want to use the InnoDB Plugin as a shared library.
ignore_builtin_innodb
#load the InnoDB Plugin and all Information Schema tables implemented in the InnoDB Plugin when the server starts:
plugin-load = innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;
innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=
ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so
#To use compression, enable the "file per table" and "file compression"
innodb_file_per_table=1
innodb_file_format=barracuda
#innodb_buffer_pool_size= 512M (Better performance if increased. suggested value is 50-80% of memory).
#The limit on the number of concurrent threads.
innodb_thread_concurrency=32
#number of background threads used for read. The purpose of this change is to make InnoDB more scalable on high end systems. Each background thread can handle up to 256 pending I/O requests.
innodb_read_io_threads=16
#Optional
#InnoDB uses to store data dictionary information and other internal data structures.
#The more tables you have in your application, the more memory you need to allocate here.
innodb_additional_mem_pool_size=20M
==========================================================================================================

Cheers!!!!!!!!!High Performance MySQL
Related Posts Plugin for WordPress, Blogger...

0 comments:

Post a Comment

 
© Copyright 2010-2012 Learn MySQL All Rights Reserved.
Template powered by Blogger.com.