… issue. At Groupon, our standard MySQL database configuration follows this active/passive pattern. There is a virtual IP that points to…-query \”set innodb_fake_changes=1\” > /var/log/playback.log 2>&1 & Our awesome development team added a few features to Percona… –session-init-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
At Users Conference Heikki did good presentation about Innodb planned features. I did not see some of big and tiny wishes … bad I will list it. Basically Innodb has problems scaling both with large number of active threads and with large number of… otherwise with raise of MultiCores Innodb will become unusable for more and more types of workloads What would your Innodb feature wishes be ?
Post: Some little known facts about Innodb Insert Buffer
January 13, 2009 By 12 Comments
Despite being standard Innodb feature forever Insert Buffers remains some kind of mysterious thing for … happening if system is loaded and merge process becomes more active if system is idle. This behavior can cause interesting results…. This can be very surprising. Stats about Innodb Insert Merge Buffer are available in SHOW INNODB STATUS output: ————————————- INSERT BUFFER AND ADAPTIVE…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… may not see a “free space” in Innodb tablespace to grow significantly. Q6: Does Innodb policy replacement algorithm takes into account page… gets it wrong. Q10: When Innodb decides to schedule sequential read-ahead, random read ahead ? HT: InnoDB schedules a sequential read-ahead… of little known new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
… go down to see details about locks held (feature available in Percona Server) we can see …key. Lets now see about writes: —TRANSACTION 12304, ACTIVE 3 sec fetching rows mysql tables in use… never will run into problems with Innodb table level locks because innodb will only set intentional level …
Post: Introducing the “Version Check” Feature in Percona Toolkit
September 10, 2012 By Leave a Comment
…. To list a few: MySQL 5.5.25 UPDATE on InnoDB table enters recursion, consumes all disk space All MariaDB and… “Version Check” feature in Percona Toolkit which will be available in the next release, version 2.1.4. To activate Version Check, you will call the tool that supports this feature with an option –version-check…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
One of the most important features of InnoDB is the row level locking. This feature provides better concurrency under heavy write load but… possible to detect those gap locks using SHOW ENGINE INNODB STATUS: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s), heap size… need to create locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… the teams mentioned. It started with Robins presentation about MySQL features and Roadmap. Not what it was something new but it… a lot about features of new storage engines such as Nitro and InfoBright but there was nothing told about Innodb features, even ones… Brian Aker which normally takes part in all Storage Related activities. There were some Q&A about various storage engines – mostly…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
… can be helpful: mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ | rseg_id | space_id | zip_size | … not need to compete with other activities of main theread. You can also … would like. I filed number of feature requests and I hope we’ll …
Post: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
… dirty and Alexey had series of sleepless nights digging into Innodb page and row structure. When few more companies followed, so… task to write more details about Innodb data recovery process and release code for our innodb recovery toolset, so you can recover… help you with development or organize custom feature development for Sphinx project. We have been active Sphinx users from very early stages…
