…innodb_thread_sleep_delayblogpercona.commanual Innodb_truncated_status_writesblogpercona.commanual innodb_use_native_aioblogpercona.commanual innodb_use_sys_mallocblogpercona.commanual innodb_versionblogpercona.commanual innodb_write…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… By default InnoDB uses 1 insert buffer thread, 1 log thread, 1 read thread, 1 write thread. With innodb_file_io_threads InnoDB will use…performance. * This test uses “innodb_read_ahead = 0″ (The both of read-ahead are disabled) “innodb_ibuf_contract_const = 50000″ “innodb_ibuf_contract_burst = 50000…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct = 50 innodb_io_capacity = 800 innodb_read_io_threads = 8 innodb_write… write throughput increase of 2x to 3x. In this particular case, since I was mostly concerned with write performance, so I went ahead…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…DIRECT 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…results Sequential read results are expectedly the least interesting. Read-ahead kicked in immediately giving ~9’600 iops (~150MB/s) at…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log-error=/var/log…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…=2 innodb_log_file_size=4G innodb_log_block_size=4096 innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_read_ahead = none innodb_flush_neighbor_pages = 0 innodb_write_io_threads=8 innodb…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
…”1″ record order of binlog and InnoDB transaction log could be not same. But because InnoDB manages transactions in correct order most …enough Write-Buffered), 0 may show better performance. Changed parameter for control read ahead activity. Now it accepts string values: innodb_read_ahead = [none…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…_lag 0 innodb_mirrored_log_groups 1 innodb_old_blocks_pct 37 innodb_old_blocks_time 0 innodb_open_files 300 innodb_read_ahead_threshold 56 innodb_read… 30 innodb_table_locks ON innodb_thread_concurrency 0 innodb_thread_sleep_delay 10000 innodb_use_sys_malloc ON innodb_version 1.0.11 innodb_write_io…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… is easy to miss, as is the absence of innodb_log_file_size. I won’t give you a full …’s variables or whatever other data I need, and write something instructional to the client about it. Preparing to … number of hours, such as 3 hours. Knowing this ahead of time gives us a framework within which we …
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…completed. Innodb tries to optimize these reads a bit – there is sequential read ahead and random read ahead …running query. Though this one is specific to write requests – if you have some reporting queries … to do is to flush transactional log. In case innodb_flush_log_at_trx_commit=1 (default) …
