(Andrew Hutchings) MySQL Cluster can be used as a general purpose transactional storage engine, but if you convert all your InnoDB tables to it and connect your application straight to it you may not see the performance you were hoping for. This is because MySQL Cluster was originally designed for

(Andrew Morgan) You may have read Bernd’s recent post that explained how to try out some new beta functionality for MySQL Cluster and wondered what kind of use you could put the new ndb$info to. ndb$info uses tables/views to give real-time access to a whole host of information that helps you monitor

(Mats Kindahl) In the previous post I described the first steps of a Python library for controlling the replication of large installations. The intention of the library is to provide a uniform interface to such installations and that will allow procedures for handling various situations to be writte

(Venu Anuganti) I had this patch for a while where one can get listing of both session and global temporary tables across all sessions. It really helped lot of times to understand the bottlenecks of some of the temporary table issues as MySQL never exposed them in the form of SHOW TABLES.

(Shlomi Noach) Ever so often a query provides a “bad” execution plan. Adding a missing index can many times solve the problem. However, not everything can be solved with an index. I wish to highlight the point of having an implicit cast, which negates the use of an index on MySQL.

(Alex Bolenok) This post is inspired by a discussion with John Didion: Is there any way to optimize the query for overlapping ranges in MySQL if both ranges are dynamic?

(Quassnoi) From Stack Overflow: I have a table users and there is a field invited_by_id showing user id of the person who invited this user.

(Simon Mudd) I have been upgrading more MySQL database instances recently and have found a few more potential gotchas, which if you are not careful, can potentially be rather nasty. These are not documented explicitly by MySQL, so it may be handy for you to know if you have not come across this type

(Oli Sennhauser) Recently we had a case where a customer got some corrupted blocks in his InnoDB tables. His largest tables where quite big, about 30 to 100 Gbyte. Why he got this corrupted blocks we did not find out yet (disk broken?).

(Rob Gravelle) My last DatabaseJournal article, All About the Crosstab Query, described how to formulate an SQL statement for generating a cross tabulation query. My original intention for today’s follow up was to explore the use of stored procedures to make crosstab generation more dynamic. That