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: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… this feature, previous releases might also include them via supplemental repositories i.e. updates on CentOS. If you are using InnoDB, it… MySQL data. This way you don’t have to deactivate/activate the original logical volume to start the merging. So let… my salaries table back. Because leaving a production server with active snapshots can affect performance, this is not really an advisable…
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 11 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 17 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: 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 1 Comment
… 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…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… be in an acceptable range. It opens the possibility for active master – active master setups. You can write on both masters and… is based on standard InnoDB 5.1 instead of InnoDB-plugin. Standard InnoDB is seriously behind InnoDB-plugin in terms of features and performance. Update (6-Jun-2011): It was my misunderstanding: Galera does work with InnoDB-plugin…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… be actively maintained now. And hey this is exactly one if the reasons behind Drizzle project. Lower usage density means features are… is why I guess all new Innodb Development is going with Innodb Plugin which is separate from Innodb included default MySQL. Why is… how it all affects bugs an not features ? Well if you want to use latest Innodb you will need to use plugin…
