… machine with a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1.6TB) and 128GB memory. For the…=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=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… 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: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
….g. for 1024 concurrent threads each SELECT has to scan about 100 update transactions to create a read view: I hope this… 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: 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: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1\” >…Read-only playback Using the –session-init-query command-line option, we set the option innodb… is logarithmic, so the difference between the IO usage is 2 orders of magnitude. …
Comment: MySQL and Percona Server in LinkBench benchmark
May 11, 2013 By 18 Comments
… BP 600sec measure after (maybe) enough warmup; PCI-e flash) threads ops/sec 64 around 8000 16 around 8000 4 around… for this workload-hardware innodb_io_capacity = 20000 innodb_io_capacity_max = 100000 innodb_read_ahead_threshold = 0 innodb_change_buffer_max_size = 1 innodb_lru_scan_depth…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in … are thousands of tables and slow IO then XtraBackup can spend a…’t initialize per-thread data in the log copying thread which could cause … still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would …
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in …between checks done by log copying thread is now configurable by innobackupex –… are thousands of tables and slow IO then XtraBackup can spend a… still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… size with 1, 4 and 8 threads. The operations were done in 16kB units to mimic InnoDB pages. There were couple interesting… 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…
