This is a review of Webyog's MONyog MySQL monitoring tool. The product is still in beta and has some rough edges, but holds promise. Its design includes some interesting architectural decisions I think will help distinguish it from MySQL's own Monitoring and Advisory Service.

With MySQL 5.0 the database provides trigger functionality on INSERT, REPLACE, UPDATE and DELETE.

Those of you who know some other RDBMS know, that there are also some system events where one would like to have triggers.

Unfortunately MySQL does not (yet) provide such functionality. This is sad because as database administrator this would be sometimes very helpful.

But you can build your own LOGON and STARTUP trigger.

MySQL provides some hooks for these events...

Complete Story (PDF 160 kbyte).

I was unable to attend JavaOne this year since I was at the Red Hat conference in San Diego. Still, I heard good things, especially about a new language and framework called Scala/lift.  Both Java Flex guru Bruce Eckel and scalability guru David Pollak commented on Scala. (More on that next week.) 

So my only way to find out what was going on was through blogs and news releases.  If you missed JavaOne, check out the links below.  Interesting highlights include Sun's announcement of …

With MySQL 5.0 the database provides trigger functionality on INSERT, REPLACE, UPDATE and DELETE.<br> Those from you who know some other RDBMS know, that there are also some system events where one would like to have triggers.<br> Unfortunately MySQL does not (yet) provide such functionality. This is sad because as database administrator this would be sometimes very helpful.<br> But you can build your own LOGON and STARTUP trigger.<br> MySQL provides some hooks for these events...<br>

mysql> check table noneofyourbusiness quick ;

Table                            Op     Msg_type  Msg_text 
 noneofyourbusiness   check status          OK  
1 row in set (56 min 26.29 sec)

You know you want to go. Its going to be in Tokyo, Japan. Having passed by the Narita airport quite some number of times, I’ve always wondered what was beyond those walls.

MySQL UC-J: September 11-12 2007

I would sincerely encourage all folk in the Asia-Pacific region, using or dabbling in MySQL to attempt to be there. Thats right, I’m calling on you folk from Singapore, Malaysia, China, Korea, Thailand, and how can we forget our beloved Australia & New Zealand (though I’m not sure if flying to Tokyo is any less harrowing an experience than flying to San Francisco).

Flights are going to be shorter, they are going to be cheaper, and you’re going to get to see Tokyo. More importantly, if you pre-register, rumor has it, you will not be paying an attendance fee. Seats will be snapped up fast. Session lineups are amazing. What more can I say besides its going to be a great & fun experience for all.

…

MySQL AB will hold its first ever MySQL users conference in Asia this September. Over the course of two days, the 'MySQL Users Conference Japan 2007' will feature a special executive keynote presentation, more than 15 business and technical sessions, and exhibition booths. About half of the sessions are presented in English with English-Japanese simultaneous translation.

This is a review of Webyog's MONyog MySQL monitoring tool. The product is still in beta and has some rough edges, but holds promise. Its design includes some interesting architectural decisions I think will help distinguish it from MySQL's own Monitoring and Advisory Service. MONyog overview MONyog starts an HTTP listener on your machine. After you start the program, you point your Web browser at localhost:9999. Your browser talks to MONyog, which talks to one or many MySQL servers.

Just an observation:
eBay now supports sending notifications to various IM networks... the usual list. Except Skype. Now that's curious, since eBay owns Skype, right? I would expect it to be the first offered, or at the very least be on the list....

I had this question asked many times during last week, and there is really no easy answer. There are just way too many variables to consider especially while loading large schemas with a lot of different table structures. So which variables affect the load speed:

Table Structure This one is tricky. The shorter rows you have the faster load will normally be, if you measure rows, but if you measure in amount of loaded data longer rows are faster.

Indexes The more indexes you have the longer load would take. Details depend on storage engines, for example MyISAM can build non-unique indexes by sort which is very fast and Innodb can use insert buffer for them.

Data Insert Order It is well known it is important to load data in primary key order into Innodb tables for optimal performance, but effect does not end here. If indexes are built by inserts in Btree order in which …