Just like I did in 2007 and 2009 , this is my updated whishlist for MySQL. My 2007 List: Per user and/or per database quota I guess that this will be implemented together with catalog support.   External Authentication  Got it in 5.5! Thanks a lot! And the new MySQL Cluster even has support for sharing user credentials .   Database Locator There is still no TNSnames like support. Saving extra metadata about the database. Using the comment field of tables for things like svn release, customer number and more still just feels wrong. And a database still can't have a comment... Using I_S is possible, but it's not supported to create FK's for that, so consistency is not guaranteed. better protection against run-away queries With mk-kill this is now easy. restore manager I still have to use thinks like awk for this... My 2009 List: SNMP for statistics no changes   SNMP for alerting MySQL Enterprise Manager is quite good at this. Auditi...

In a default MySQL 5.5.8 installation there is one PROXY privilege: GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION What this does is: If USER() and CURRENT_USER() don't match root is still allowed to grant the proxy privilege. So if you connect using someuser@localhost using LDAP and LDAP tells you're root then you're still allowed to grant proxy privileges. This will only work if your user has the privilege to proxy to root. The documentation for PROXY is here .

It's the second point release of MySQL Enterprise Monitor 2.3. And there some nice new features and bugfixes. It's now possible to enable or disable event blackout for specific servers easily. It should now graph InnoDB with multiple buffer pools correctly. It won't work for 5.5.8 however, see Bug #60777 and Bug #60831 for more info on that. Read the complete changelogs for all the details. The Advisors/Rules were also updated. But there is still room for improvement: Bug #60828 Add rule to detect duplicate foreign keys Bug #60697 False Positives for Root Account Can Login Remotely Bug #60695 False positives for tables w/o keys for 5.5 with perf schema Bug #60677 "User Has Rights To Database That Does Not Exist" gives false positives Bug #60676 Add rule to monitor if the timezone info is loaded Bug #60587 Advice for Root Account Without Password is not correct Bug #60586 key buffer size check gives fals...

The MySQL Server from Oracle comes in a two different flavours: Community Edition and Enterprise Edition. The first one is under the GPLv2 license and the later is under the GPLv2 or Commercial license. The Enterprise Edition was always available from https://enterprise.mysql.com (which now has an expired SSL certificate) under the GPLv2 license. This download page was restricted to paying customers. Since the Enterprise downloads were moved to https://edelivery.oracle.com the downloads are available for everyone (as long as it's not restricted by export regulations and accept the trial license agreement). The license is now 'Commercial'. The download be named V24071-01.zip or something like that, which is annoying. The latest version for the Enterprise release on edelivery is 5.5.8 while the latest Community version is 5.5.11. Previously there were two enterprise releases: Advanced (With partitioning) and Professional (Without partitioning). If you use https://support.o...

For MySQL Enterprise Monitor an agent is required. I've downloaded V23981-01.zip from https://edelivery.oracle.com which contains mysqlmonitoragent-2.3.1.2044-linux-glibc2.3-x86-64bit-installer.rpm When I was testing the email alerting for my backup script I got an error: /etc/mail/submit.cf: line 544: fileclass: cannot open '/etc/mail/trusted-users': Group writable directory Luckily RPM was able to tell me that mysqlmonitoragent had set / to the wrong permissions.     # rpm -qf / filesystem-2.4.0-3.el5 mysqlmonitoragent-2.3.1.2044-0 # rpm -qvl mysqlmonitoragent-2.3.1.2044-0 | head -1 drwxrwxr-x 2 root root 0 Nov 25 01:51 / # rpm -qvl filesystem-2.4.0-3.el5 | head -1 drwxr-xr-x 2 root root 0 Oct 1 2009 / # echo test | mail -s test user@example.com # /etc/mail/submit.cf: line 544: fileclass: cannot open '/etc/mail/trusted-users': Group writable directory I've filed Bug #60752 for this. So watch out for this bug...