…5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb… (8 cores, 16 threads) with fast IO (OCZ R4 1.6TB)…read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…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…
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…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences …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: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… benchmark tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each… 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…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5…. 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 XtraBackup… still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail…
Comment: MySQL and Percona Server in LinkBench benchmark
May 11, 2013 By 18 Comments
… warmup; PCI-e flash) threads ops/sec 64 around 8000 16 around 8000 4 around 5000 mysql-5.6.11 (wo doublewrite… 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.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5….between checks done by log copying thread is now configurable by innobackupex –log… are thousands of tables and slow IO then XtraBackup can spend a … still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…read-ahead means that when InnoDB notices that if at least 13 pages in an extent have been accessed very recently, then InnoDB reads… can gain significantly with multiple IO threads on systems with large amount…: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
… about 1.5 average outstanding IO requests to the disk. Lets look at SHOW INNODB STATUS: ——– FILE I/O ——– I/O thread 0 state… ————– ROW OPERATIONS ————– 8 queries inside InnoDB, 3 queries in queue 12 read views open inside InnoDB Main thread process no. 3956, id 1157658976, state… how Innodb read-ahead works by having more overlap between requests so thread would rarely need to stall unable to perform any quick IO…
