We are quickly approaching opening up the MySQL Query Analyzer for general beta and I wanted to pass along an open invite to the following related and informational events.

On 8/13, I will be doing a micro level presentation on MySQL Enterprise. Please attend and learn more about the database software, monitoring and advisor services and support solutions that make up a subscription. I plan to do a demo of the Enterprise Monitor and the new Query Analyzer; that alone makes attending worth the price of admission (in this case 45 minutes of your time!). Learn more and register here.

On 8/20, I will be doing a presentation on the new Query Analyzer. This will be a technical discussion around how DBAs monitor for bad queries now and how the Query Analyzer makes the job much easier. This will be a good time to learn about getting in …

As the Product Manager for MySQL Enterprise and the Enterprise Monitor I am constantly being asked questions from our Sales team, prospects, customers, etc. about how our products stack up against competing products. This is tough for a PM because competitive situations change with each new release cycle and ISVs (both free/open and commercial) with agile development practices can deliver new features in very short order. Further, getting into a feature-feature discussion is a no win situation because someone will ALWAYS have more check marks. Also, I tend to be more positive about competing products because a) healthy competition makes us all better and b) my competitors enable more people to use MySQL to build apps that will most likely need MySQL support and c) the best support for MySQL comes under a MySQL Enterprise subscription! With those things in mind you will *never* hear …

I’m attempting this is be as unbiased as possible, since I write the Monolith application. This will hopefully help one decide between a free MySQL server monitoring system and paying for a per-server based licensed product. Both have strengths and weaknesses that should be pointed out before making a decision. You can infer the weaknesses based on the strengths below. That said, let’s just get into it.

Strengths of each product over the other

Monolith - MySQL DBA Console

• presents overall database size, index size, data size, number of schema per server, and aggregate statistics for all monitored servers
• runs mysql server backups remotely and reports on backup state execution
• collects cnf files from each server during the talkback script execution for historical viewing
• built on the LAMP stack, no need for tomcat/jboss knowlege
• provides …

At OSCON, Brian and Dormando gave their ever famous talk, Memcached and MySQL: Everything You Need To Know. I didn’t attend the tutorial, but they assured me it was similar to what was given at the MySQL Conference 2008 (everything, but the very nice buttons dormando was giving out with the memcached logo!). Great, because not only is memcached hot, but I have notes from their talk: Memcached and MySQL tutorial.

Interestingly enough (and this didn’t happen at OSCON), …

The session has been recorded. The webex file and the webinar are available here.

Here is the Q&A session, with more detailed answers.

Q from Tomasz: You said memcached is integrated with, among others, MySQL. Did you mean integration by e.g. php or direct, automatic integration?
A: Memcached API are available for many enviroments, such as Php, Perl, C/C++, Rails etc. With MySQL, you can use UDF functions or a storage engine. Both are community projects.

Q from Juan: memcached: Facts data size up to 1MB? What size, i dont understand!
A: It's the size of an item associated to a key. When you store an element (item) into memcached, the size of the key is max 250 bytes and the item is max 1MByte.

Q from Frederik: Do memcached save data in RAM or disk?
A: It is RAM …

For the MySQL users who are still unfamiliar with the new features of MySQL Enterprise (2007 Fall Edition), I will present a webinar on this topic on Monday 3rd of March @ 3pm CET. The webinar will be in Italian, but the slides are rigourously in English, so if you are interested, just wait approx one week and you will be able to download slides and recording of this event.

The latest version of MySQL Enterprise is powered with an improved version of the Enterprise Monitor, which has a new set of Replication advisors and new set of cool graphs, to instantly control your servers. There is also a big improvement in the overall scalability of the Enterprise Monitor.

During the presentation we will discuss these new features and we will see the latest improvements in the Enterprise binaries.

If you are interested in any specific detail associated to this topic, feel free to comment on this blog or to drop me …