…introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB …log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with an incorrect position…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves… only my opinion and not any official Percona position, and I will look forward to being able …-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… the redo log by default, so applying Callaghan’s law to single-server Innodb, we’d get: [On a single node Innodb server… hotspots were really bad in standalone Innodb, you might consider relaxing the fsync: set innodb_flush_log_at_trx_commit to something besides… MySQL Innodb with asynchronous slaves. We may not think about the tradeoffs, but we’re making them (anyone obsessively testing slave position…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… when rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows parallel processing of …MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed …SHOW MASTER STATUS to obtain binlog file and position. This could trigger a bug if the …
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… we see about Innodb log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence number 9682004056 Log flushed up to… they are associated with, nor with the position associated with their modification in the transaction log. The effect of this is that…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… “free space” in Innodb tablespace to grow significantly. Q6: Does Innodb policy replacement algorithm takes into account page position in btree index ? HT… good performance is to set innodb_flush_log_at_trx_commit=2, that is, to flush the log to the disk only once… so. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in 5.1, to implement XA…
Post: InnoDB Flushing: Theory and solutions
April 4, 2011 By 23 Comments
…. The two most important parameters for InnoDB performance are innodb_buffer_pool_size and innodb_log_file_size. InnoDB works with data in memory, and… 7/8 of innodb_log_file_size, and the “async” point is at about 6/8 = 3/4 of innodb_log_file_size. So… add “throttling” to prevent it. The throttling depends on the position of checkpoint_age — the closer to “async”, the bigger the…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… not forget you may need to increase size of your Innodb log files to be able to use a lot of memory… solid state disks for storing ib_log* files; I know that innodb writes files in the log file group in a round robin… be able to cope with writes to the same file position. That kind of access is so common in files. The…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… log is necessary not only for replication, but for point-in-time recovery, too. Given a backup and the corresponding binary log position, you can replay the binary log and roll forward the state of your server… replication through the InnoDB transaction log would work fine if a) all the data were in InnoDB, and b) InnoDB‘s data didn’t…
Post: Thoughs on Innodb Incremental Backups
November 10, 2008 By 8 Comments
… log, which also can be easily compressed. What tool would need to do is to go through the pages for each Innodb file and simply write all the new pages to the separate file. Because pages already have position information in… and Innodb logs and MyISAM system tables need to be copied fully but they typically do not have any considerable portion of Innodb…
