<< the art of sql >>
MySQL | 2007-08-02
Target Practice – A Workshop in Tuning MySQL QueriesI gave a tutorial at OSCON last week on tuning MySQL queries, the EXPLAIN statement, the optimizer, and benchmarking. I’ve gone ahead and put the tutorial materials online now: The […]
MySQL | 2007-08-01
MySQL Camp II – Registrations Limited – Contact MeA while ago I blogged about the next MySQL Camp happening in New York. Sadly, I have had some trouble getting the new web server going (problems on my end […]
MySQL | 2007-07-24
Our Fearless Leader, MÃ¥rten Mickos – And Party on at OSCONHere is a perfect photo from James Duncan Davidson that illustrates the drive and ambition of MÃ¥rten Mickos, our fearless leader, battling with an unfortunate competitor at the Ubuntu Live […]
MySQL | 2007-07-19
Interview with me on HowSoftwareIsBuilt.comA few weeks ago, I had a chance to speak with Scott Swigart about MySQL, open source, development and community challenges, and other stuff. He sent me a link to […]
MySQL | 2007-07-17
Internals of MyISAM’s Concurrent Insert Functionality – Part IOK, so we’re going to get pretty down-and-dirty in the C source code that handles concurrent inserts… you’ve been warned. 🙂 For background on the MyISAM concurrent insert functionality, see […]
MySQL | 2007-07-17
Correction on Concurrent Insert for MyISAMMax Mether pointed out an error in something I mentioned last week in a performance tuning webinar and I wanted to clarify and correct. In the webinar I said that […]
DB Rambles | 2007-07-13
Congrats to the PostgreSQL/EnterpriseDB/Sun Team for BenchmarksI wanted to write a quick shout-out to congratulate the PostgreSQL development team, the folks at Sun who work with Josh Berkus, and the folks at EnterpriseDB, all of whom […]
MySQL | 2007-07-12
Speaking at ZendCon – October 8-11 – San FranciscoI’ll be giving a 1 hour session at ZendCon this year entitled “MySQL Performance Coding – From Soup to Nuts”. The abstract says 3 hours, but I believe it’s a […]
MySQL | 2007-07-12
Common Questions and Answers from Performance Tuning WebinarsYesterday and today I gave a couple webinars on basic performance tuning of SQL queries and schema/index strategies. I’ve given this presentation quite a few times now, and a number […]
MySQL | 2007-06-26
Long Overdue PlanetMySQL Style and Bug FixesOK, so I spent a few hours this afternoon cleaning up PlanetMySQL‘s stylesheets and layout, and fixing some bugs in the code. You’ll notice a more streamlined PlanetMySQL now, with […]