…/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb…percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… how important is the file cache for Linux. Basically, with InnoDB, since the file cache is not important we add “vm… memory for the MySQL process using the numactl utility, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option… create files of 5GB since the backup size is about 28GB and the file upload size limit is 5GB. So, about 28GB…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool is…adjustments. You may want to make MySQL to use Large Pages for allocating Innodb Buffer Pool and few other buffers, which may have other …
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine: InnoDB Version: 10 Row_…size out of which 1.4GB is the Index. First Lets look at results of Adding and Dropping column for 128M buffer pool, sized…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, …Innodb_buffer_pool_pages_latchedblogpercona.commanual Innodb_buffer_pool_pages_miscblogpercona.commanual Innodb_buffer_pool_pages_totalblogpercona.commanual Innodb_buffer_pool_read_aheadblogpercona.commanual Innodb_buffer_pool_read_ahead_evictedblogpercona.commanual Innodb_buffer_pool…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… G for every 25 G of the buffer pool. This can become significant in the proper innodb_buffer_pool_size estimations when the system has a lot of RAM and you want to have the largest possible innodb_buffer_pool_size. Do…
