At the MySQL User Conference - MySQL Quiz Show we were asked to Stump a MySQL Guru. Well I submitted a few questions, and the first one stumped the guru, being Jeremy Cole, and my prize was a MySQL tee-shirt.

The Question: What are the current supported languages of the GRT Environment used in the MySQL GUI products?
The Answer: Lua, C, C++, Java, Python and PHP

Joe Kottke from FeedBurner in his MySQL Conference presentation today FeedBurner: Scalable Web Applications Using MySQL and Java mentioned a novel way of extracting SQL Select Statements from a MySQL Server.

The obvious MySQL ways include SHOW [FULL] PROCESSLIST, the Slow Query Log, and the General Query Log. In 5.1 you also use the INFORMATION_SCHEMA.PROCESSLIST.

Anyway, Joe mentioned he …

so he remembers

Just to add some more features of the MySQL Migration Toolkit from the MySQL Conference presentation MySQL Migration Toolkit by Mike Zinner from MySQL AB.

You can extend and modify the funcionality of the Migration toolkit with the supplied Eclipse Java project. I’ll need to download the code to write some more detailed notes, but here were a few points from Mike.

Classes are in the com.mysql.grt.modules Package Space
The main configurable classes are nameed Migration????..java and ReverseEngineer???.java with ???? being for the different Database Products

Within the Eclipse project, you can incoporate other languages. For example, ReveserEngineerMySQL Jdbc.java for example has a …

Man I'm wiped out. Have been operating on 5-6 hours of sleep a night since Sunday and it's starting to take it's toll. I should probably resist the urge to stay up hanging out with folks (and then trying to get work done after that).

I suspect there will be no problems sleeping on the red-eye flight home to Boston tomorrow night. Just one more jam-packed day to go, if I can make it through tonight's MySQL UC quiz show without falling over. With Markus, Beat, Giuseppe, Peter Z., and others on the team I think we're in good shape. Markus did a great job getting folks signed up.

I must admit that it has been …

Denial Of Sushi Attack

Woo, that was fun! I just finished "my talk":http://mysqluc.com/cs/mysqluc2006/view/e_sess/8294 half an hour ago. (update: I've updated the slides to be a page per, uh, page rather than a page per "build")

I got a couple of "that was the {best,most useful} talk at the conference so far!" comments, so that alone made it worth getting up at 5.45am to fly up here!

The slides from the talk are now on the talks page of my new shiny website that Vani put together for me.

I had about 70 slides for 45 minutes (made it in 47!) so it went pretty fast, but I really think that's a lot more fun. I am sitting in the "InnoDB: Designing and Configuring for Best …

Woo, that was fun! I just finished "my talk":http://mysqluc.com/cs/mysqluc2006/view/e_sess/8294 half an hour ago. (update: I've updated the slides to be a page per, uh, page rather than a page per "build")

I got a couple of "that was the {best,most useful} talk at the conference so far!" comments, so that alone made it worth getting up at 5.45am to fly up here!

The slides from the talk are now on the talks page of my new shiny website that Vani put together for me.

I had about 70 slides for 45 minutes (made it in 47!) so it went pretty fast, but I really think that's a lot more fun. I am sitting in the "InnoDB: Designing and Configuring for Best …

This post dedicated to Edwin DeSouza.

Un-tuned SQL or stored procedures often fail to scale as table volumes increase, inefficiency increases exponentially with size.

Tune SQL/stored procedures and then buy new hardware.

use EXPLAIN to help optimize queries. Also use the slow query log.

EXPLAIN EXTENDED shows sql that was actually used — ie, optimizer may rewrite query, so it’s a neat tool.

you can always give optimizer hints, but they’re not recommended — keep checking them as your app grows — STRAIGHT_JOIN, FORCE INDEX, USE INDEX, and one other one.

SHOW STATUS gives you status variables. innodb_buffer_pool_read_requests and innodb_data_read will show how much data is being read from the buffer pool vs. data.

Index isn’t always used, if more than 20% or …