… features of InnoDB is the row level locking. This feature provides better concurrency under heavy write load but needs additional precautions to … data to other sessions. How to troubleshoot gap locks? Is possible to detect those gap locks using SHOW ENGINE INNODB STATUS: —TRANSACTION 72C, ACTIVE …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… one of little known new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty… known aspects of Innodb operations while I see it causing problems every so often. Q16: How Innodb decided how many pages to flush at each… may solve your thrashing problem but also will limit innodb to be able to use only couple of CPUs efficiently. Thought even that…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
… doing and how to optimize it. Customer demands. Customers come to us and ask for the features that … parts. When it comes to Sun/MySQL, we actively and openly talk to them about it, and …To Come True If you have a particular need for some modification to the MySQL server, XtraDB, Maatkit, our InnoDB…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
… (nothing stops you from starting to actively break old code though). Indeed …MySQL 4.0. This even applies to Innodb tables which were already on …standpoint the question is when or how to use MySQL not just if …advanced Monitoring and scaling features some users need other features than MySQL adding …
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… of low usage density features I would mention MySQL 5.1 features. During my talks I often asked people how many of them… years. Now how it all affects bugs an not features ? Well if you want to use latest Innodb you will need to use plugin which…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…innodb‘ ‘–with-csv-storage-engine’ (…) From that output you can learn how to run configure command, which needs to be done prior to… to this log file. Defaults logging to hostname-slow.log file. Must be enabled to activate…number of writes to the log. Note: this feature will fail to work well if…
Page: Consulting for MySQL
July 31, 2006 By
…actively monitor server to avoid downtime. Customized Training for MySQL Want your developers to learn MySQL best practices ? How to…Innodb Storage Engine Running transaction applications with MySQL ? Need help with deadlocks, understanding how Innodb locking works or having Innodb…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…to use it in traditional master-slave setups, but with big difference – with Galera we have Semi-synchronous slaves. How… It opens the possibility for active master – active master setups. You …InnoDB 5.1 instead of InnoDB-plugin. Standard InnoDB is seriously behind InnoDB-plugin in terms of features…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… or you happen to have failure during activity of certain …is also well too easy to use MySQL features which break replication. … O_DIRECT with Innodb which makes it to bypass file cache…to ensured consistency – MySQL Replication can out of sync – and there is bunch of tips in documentation of how to…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
…to hear a lot about features of new storage engines such as Nitro and InfoBright but there was nothing told about Innodb features… one and I kept thinking how these guys happened to be chosen ? Well It …unusual to see without Brian Aker which normally takes part in all Storage Related activities. …
