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
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_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
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 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
Posts
