…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
… of MySQL configuration parameters. For example, given that the front-end device is a very fast PCIe SSD, would it make more…_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_fast…
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… here 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
…=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… is quite significant impact when we use –innodb-log-block-size=4096. The average throughput for last 15 mins in first run is… sensitive to IO block size. And I know that other SSD/Flash drives like to have IO multiplied to their internal…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 13 Comments
… 320GB MLC cards are configured in software RAID0 to store InnoDB datafiles. For InnoDB logs and system tablespace I used partition on regular RAID10….com/2009/05/tables-on-ssd-redobinlogsystem.html and taking fact that FusionIO is not perfect for sequential writes http://www.mysqlperformanceblog…
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… SSD into RAID controller with battery-backup-ed write cache, but I am not sure what is good ones – another are for…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… Innodb log files to be able to use a lot of memory for write buffering efficiently. Q30: Question about using solid state disks for… in the log file group and the SSD dynamic wear leveling algorithm. I’m also wondering if you would recommend using SSD for this purpose, and how much performance gain there might be. HT: I guess the log writes themselves are…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… 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 = … in Percona Server: increase innodb_log_file_size. There are stability timeline for Percona Server with innodb_log_file_size=8GB And to …
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
… can set some InnoDB options! I’m going to try the obvious first: innodb-flush-method, sync-frm and innodb-flush-log-at-trx-commit. There is an undocumented option for innodb-flush-method called… the mysqltest language that’s for sure). After a “I’m glad this isn’t a SSD” killer amount of fsync() activity…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… good job on systems based on SSD/Flash storage, but it is not so good for regular slow hard drives. Let me… for the tpcc-mysql benchmark (100W ~ 10GB of data, 12G innodb_buffer_pool_size, 1G innodb_log_file_size), MySQL 5.5.10 with innodb… pages within the given innodb_max_dirty_pages_pct limit. Another possible solution would be to increase innodb_log_file_size, but that…
