(Giuseppe Maxia) Imagine having a database with 100 tables and you want to allow a user to read from all of it, except one.

(Peter Zaitsev) I was thinking today of how people tend to use MySQL in modern applications and it stroke me in many cases MySQL is not used to process the data, at least not on the large scale – instead it is used for data storage and light duty data retrieval. Even in this case however the cache (

(Kevin Burton) In a comment while we were discussing his Queue Engine Brian Aker mentioned his concept of “engine services” which is something I’ve been thinking of for a while now.

(Ludwig Ertl) A MySQL Storage engine requires functions that MySQL provides. Therefore, you normally need to link it into mysqld-core under Windows because mysqld.exe doesn’t export all required functions (it’s an .exe, not a .dll). So, you’re unable to import the required functions in your plugin.

(Giuseppe Maxia) The patch for SHOW PROFILE has been ported to MySQL 5.1.

(Peter Zaitsev) People are sometimes contacting me and asking about bugs like this which provide a trivial way to crash MySQL to the user with basic privileges and asking me what to do.

(Jag Singh) The star schemas along with aggregates support the full scope of the data warehouse, the multi-dimensional database (MDB) can be used to support a limited scope where query performance is paramount:

(Antony Curtis) This question seems to crop up again and again… In the words of one comment to my blog: “I’ve downloaded your External Language Stored Procedures package and am interested in trying out the JAVA part. Would appreciate if you could explain how use the downloaded stuff.”

(Ronald) The MySQL Table Checksum, part of the MySQL Toolkit (having to be renamed soon) is an invaluable community tool for use with MySQL. Most sites or installations of any volume will use MySQL Replication for one purpose or another, be it for read scalability, backups, testing, upgrading etc.

(Russell E Glaue) In Part 1 we have seen how the concept of state management works. Now it’s time to apply that concept to a load-balancer. In this Part 2 we will look at a strategy for using Linux Virtual Server with MPP for failover, and also take a closer look at the mechanics of MPP itself.