…’Com_rollback’, ’4666272′ ‘Com_savepoint’, ’0′ ‘Com_select’, ’378247551′ ‘Com_set_option’, ’285487367′ ‘Com_show_binlog_events’, ’0′ ‘Com_show_… to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb_…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it to load IO…
Comment: Choosing innodb_buffer_pool_size
September 24, 2010 By 39 Comments
…. and mysql with Innodb tables. 100mb of data is available. i have set normal configuration in ini with query_cache=64mb and innodb_additional…_min_res_unit slave_net_timeout innodb_data_file_path ibdata1:10M:autoextend innodb_file_io_threads 4 thread_concurrency 8 innodb_max_dirty_pages_pct 90 When…
Post: xtrabackup-0.6
April 29, 2009 By 6 Comments
…tool. Changelist includes: – set innodb_fast_shutdown=1 on xtrabackup shutdown – set innodb_write_io_threads=10 by default for…#359341: innobackupex still does not read defaults-file You can download current binaries RPM …/ Intel 64bit there: http://www.percona.com/mysql/xtrabackup/0.6/. By the same …
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…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…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread … writes to these log files as IO to the log files is not aligned to the…IO on the system. On Windows you do not need to do anything. On Linux, FreeBSD, Solaris you need to set innodb…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…ascending order of the file address, then InnoDB schedules the read …can gain significantly with multiple IO threads on systems with large amount…HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency… get good performance is to set innodb_flush_log_at_trx_commit=…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…of MySQL; they are very careful about upgrades. The RDS instance was a Quadruple Extra Large DB Instance. I used default settings… 37 innodb_old_blocks_time 0 innodb_open_files 300 innodb_read_ahead_threshold 56 innodb_read_io_threads 4 innodb_replication_delay 0 innodb_rollback_on_timeout OFF innodb…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB…innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct = 50 innodb_io_capacity = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file…-set …
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…IO bound hence such drop in performance. The performance of mysqldump is impacted too because we now have 2 threads…setting innodb_old_blocks_time to non zero value, if not I would strongly suggest changing default from zero in MySQL…
