…innodb_log_buffer_sizeblogpercona.commanual innodb_log_file_sizeblogpercona.commanual innodb_log_files_in_groupblogpercona.commanual innodb_log_group_home_dirblogpercona.commanual Innodb_log_waitsblogpercona.commanual Innodb_log_write_requestsblogpercona.commanual Innodb_log… updatable_views_with_…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… since the view was either created, or last refeshed. The incremental method is somewhat conceptually similar to using mysql binary logs for…, simply ignore this column. It is used to prevent wide innodb primary keys on the MV. mysql> select mview$pk as… The first parameter to flexviews.refresh() is the materialized view id. Each view has an identifier which can be obtained with flexviews…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…-112-39-98 log_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_file_size…:20:17 [Note] WSREP: New cluster view: global state: 77c9da88-b965-11e1-0800-ea53b7b12451:97, view# 18: Primary, number of nodes: 3… disabled. 120619 13:21:17 InnoDB: The InnoDB memory heap is disabled 120619 13:21:17 InnoDB: Mutexes and rw_locks use GCC…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… a 50-thousand-foot view of it all. The binary logging and replication code, and its interaction with InnoDB, is difficult to understand… replication through the InnoDB transaction log would work fine if a) all the data were in InnoDB, and b) InnoDB‘s data didn’t… point of view. Still, I have considered it. There would need to be a mechanism of transporting the log files, and InnoDB would…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 128M innodb_log_file_size = 512M innodb_log_files_in_group = 2 innodb_max… file dict/dict0dict.c line 1627″ It is index->lock, viewing the source file (and it may be HISTORY table). This…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… (Laurynas Biveinis). The XtraDB used to print the open read view list without taking the kernel mutex. Thus any list element… Biveinis). When option innodb_flush_method=O_DIRECT was set up, log bitmap files were created and treated as InnoDB data files for… if large innodb_log_block_size value is used in the combination with changed page tracking. Bug fixed #1114612 (Laurynas Biveinis). InnoDB monitor…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at…’s take a look at the graphs have a better view of the whole picture. Note, in the above graph, we…
Comment: How to change innodb_log_file_size safely
November 8, 2011 By 17 Comments
… Squeeze 6.0. And I can tell you that changing innodb_log_file_size does NOT work for good. Changed it to…:45:00 InnoDB: Log file ./ib_logfile0 did not exist: new to be created Nov 8 19:45:00 mysqld: InnoDB: Setting log file…. So as a final note (my personal view on this topic): Never change innodb_log_file_size in a running production system with…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
… searches/s, 532.42 non-hash searches/s — LOG — Log sequence number 586 10447960 Log flushed up to 586 10447960 Last checkpoint at… / 1000 ————– ROW OPERATIONS ————– 8 queries inside InnoDB, 3 queries in queue 12 read views open inside InnoDB Main thread process no. 3956, id…
Comment: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
…% of the InnoDB log file space used, while Percona server won’t. You’ll also normally benefit from setting innodb_purge_threads to… of multithreading, setting innodb_buffer_pool_instances to 8 as a starting point and adjusting from there. Views are my own, if you want an official Oracle view contact a PR person. James…
