…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…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… device, vCache shines. Compared to a deployment with no SSD cache whatsoever, FlashCache still does quite well, massively outperforming …DIRECT innodb_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1 innodb_…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… we see about Innodb log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence number 9682004056 Log flushed up to… would be ‘estimate’ (good default) and ‘keep_average’ designed for SSD type storage. Running Percona Server and using this method is…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
…:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=4G innodb_adaptive_checkpoint=keep_average innodb… sensitive to IO block size. And I know that other SSD/Flash drives like to have IO multiplied to their internal…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
…:autoextend innodb_file_per_table=1 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=256M innodb_thread_concurrency=0 innodb_flush_log_at_trx_commit=1 innodb_flush… with RAID 10 So in conclusion to warranty Durability with SSD we have to disable write-cache which can affect performance…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… not forget you may need to increase size of your Innodb log files to be able to use a lot of memory… solid state disks for storing ib_log* files; I know that innodb writes files in the log file group in a round robin… occurring writes to the first file in the log file group and the SSD dynamic wear leveling algorithm. I’m also wondering…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… provide better experience on SSD is : innodb_flush_neighbor_pages = 0 innodb_adaptive_flushing_method = keep_average innodb_log_block_size = 4096 innodb_log_file_size = 4G… throughput in Percona Server: increase innodb_log_file_size. There are stability timeline for Percona Server with innodb_log_file_size=8GB And to…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
…”, is doing a very good job on systems based on SSD/Flash storage, but it is not so good for regular… ~ 10GB of data, 12G innodb_buffer_pool_size, 1G innodb_log_file_size), MySQL 5.5.10 with innodb_adaptive_flushing=ON (default)). The… pages within the given innodb_max_dirty_pages_pct limit. Another possible solution would be to increase innodb_log_file_size, but that…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 13 Comments
… MLC cards are configured in software RAID0 to store InnoDB datafiles. For InnoDB logs and system tablespace I used partition on regular RAID10…’s recommendations http://yoshinorimatsunobu.blogspot.com/2009/05/tables-on-ssd-redobinlogsystem.html and taking fact that FusionIO is not perfect…
Post: How long Innodb Shutdown may take
September 2, 2010 By 9 Comments
… the buffer pool varies depending on innodb_max_dirty_pages_pct as well as workload and innodb_log_buffer_size and can be anywhere from 10 to 90% in the real life workloads. Innodb_buffer_pool… writes/sec for high end SSD card. Flushing can be done using multiple threads (in XtraDB and Innodb Plugin at least) so…
