… 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_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… global query_cache_size = 0; All this on a fairly decent size server where I have 6GB innodb_buffer_pool_size split into 3 innodb_buffer_pool_instances. The…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…:100M:autoextend innodb_flush_method = O_DIRECT 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: 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…_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…-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_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb_log_buffer_size = 128M innodb…
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_read_io_threads = 8 innodb…
Comment: How long Innodb Shutdown may take
May 14, 2013 By 9 Comments
…. 7 mins each 130514 7:57:39 InnoDB: Starting shutdown… 130514 8:04:26 InnoDB: Shutdown completed; log sequence number 4 3582590782… …. 130514 8:05:00 InnoDB: Initializing buffer pool, size = 4.0G 130514 8:12:29 InnoDB: Completed initialization of buffer pool Why initializing innodb buffer pool (size 4.0G) would take…
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… utility, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option. That solves most of the swapping issues… create files of 5GB since the backup size is about 28GB and the file upload size limit is 5GB. So, about 28GB…
Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
March 20, 2013 By 2 Comments
…, separate undo tablespace, 5.6-style buffer pool dump files). Bugs Fixed: Individual InnoDB tablespaces with size less than 1MB were extended to 1MB… XtraBackup without warning or error messages. This was happening because InnoDB code silently ignored datadir subdirectories it could not open. Bug…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
My last post about Innodb Performance Optimization got a lot of 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…
