… innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… additional sets of experiments. First, the baseline configuration plus: innodb_read_io_threads = 16 innodb_write_io_threads = 16 We call this configuration B. The next one…_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb options (fixed) back…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… = 1 innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity… loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb_buffer_pool_instances=1 innodb_adaptive_flushing_method=keep_average innodb…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…_commit = 2 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_write_io_threads = 8 innodb_io…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1\” > /… may be faster than an actual database write. The slow logs were split into chunks,…axis is logarithmic, so the difference between the IO usage is 2 orders of magnitude. All…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… series at the time of writing). New Features: This version of…XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL…between checks done by log copying thread is now configurable by innobackupex –… are thousands of tables and slow IO then XtraBackup can spend a…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…. Also, at the time of this writing, from async stream, MyISAM is not… you can, you should consider moving to InnoDB altogether. There are very few reasons … additional overhead, this means the SQL_THREAD will not be able to execute … if your workload is CPU or IO bound. Peter wrote some good details …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io…, single thread performance improvement is marginal however WB cache brings single thread random write performance close to what 8 threads can do, and IO alignment…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… data reads and writes to the transaction log if you set this too high. innodb_write_io_threads: Controls how many threads will have writes in progress… one thread (particularly if you have relatively few tables and/or use the global tablespaces) *cough ext3 cough*. innodb_adaptive_flushing: An Innodb…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
….4-current) innodb_io_capacity = 4000 innodb_support_xa = false innodb_file_per_table = true innodb_buffer_pool_size = 16G innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_flush_log_at_trx_commit = 2 innodb…
