… machine with a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1.6TB) and 128GB memory. For the…=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… symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… innodb_buffer_pool_size = 36G 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…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…. First, the baseline configuration plus: innodb_read_io_threads = 16 innodb_write_io_threads = 16 We call this …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…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… innodb_flush_log_at_trx_commit = 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 = 5000…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… 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_capacity…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… If there are thousands of tables and slow IO then XtraBackup can spend a lot of … XtraBackup didn’t initialize per-thread data in the log copying thread which could cause XtraBackup to crash…fixed #1169509. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to fail…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb_io… thread, buf_flush_page_cleaner_thread, should be moving all pages to the free list. Foreground threads … they are trying to do it. I filed a few bugs for this and I …
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb_io… thread, buf_flush_page_cleaner_thread, should be moving all pages to the free list. Foreground threads … they are trying to do it. I filed a few bugs for this and I …
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…between checks done by log copying thread is now configurable by innobackupex –…files in the datadir after applying incremental backups. Bug fixed #1079135. If there are thousands of tables and slow IO…files behind due to a typo. Bug fixed #1172016. innobackupex wasn’t handling the innodb_data_file…
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\” > … /dev/null, and only have a log file for debugging purposes. Streaming logs from stdin… is logarithmic, so the difference between the IO usage is 2 orders of magnitude. All…
