Innodb Settings: innodb_buffer_pool_size : The size in bytes of the buffer pool , the memory area where InnoDB caches table and index data. innodb_buffer_pool_instances : The number of regions that the InnoDB buffer pool is divided into . For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can improve concurrency , by reducing contention as different threads read and write to cached pages. Increase up to 16 if you have large number of CPU cores. innodb_sort_buffer_size : Specifies the size of sort buffers in BYTES , used to sort data during creation of an InnoDB index . Default is 1048576. innodb_flush_method : O_DIRECT - uses O_DIRECT (or directio() on Solaris) to open the data files , and uses fsync() to flush both the data and log files . Bypass OS cache . Good choice for most IO subsystems, default - NULL innodb_flush_log_at_trx_commit : With this value, the contents of the InnoDB log...
Welcome to explore technology about Kubernetes, MySQL, Machine Learning | Deep Learning - Shrenik Parekh