Few days back, Baron re-introduced MySQL's command line pager command and described some cool tricks with maatkit's mk-visual-explain (one of my favorite tools). Soon after reading it, I wished if it was possible to describe regex based (on query) paging.

I have written a small hack, christened mysmartpager, that can actually do regex based paging for you.

The idea is simple, write a relay that will redirect the output based on to the desired pager. The problem was complex, there was no direct way of getting to know the original query. There are a couple of indirect ways of doing so, but of course with hurdles:

• Run mysql client with --xml option: This will print the output of each command in xml and the command itself is included in the xml. The downside was not many pagers (including …

OpenLogic announced an evolution to their "aggregated open source support" model today. According to the press release: "OpenLogic provides front line enterprise-grade support across the 400 open source packages in its certified library. In 2006, OpenLogic created its Expert Community to provide additional backstop support ? paying lead open source developers for support. Now, with this new partnership program, commercial partners will provide backstop support for their projects and OpenLogic will resell its partners? enterprise support offerings." OpenLogic's CEO Steve Grandchamp is quoted: "This is the next phase of our open source aggregation model where we partner with leading open... READ MORE

Are you getting fed up yet with my posts on calculating percentiles? Well, I'm sorry but I'm not quite finished.

Here's a simple, fast method to calculate the specified number of quantiles:

-- set the number of quantiles, for exmple:
--   quartiles: 4
--   deciles: 10
--   percentiles: 100

SET @quantiles:=4;  -- select quartiles

-- calculate all quantiles
-- 
--
SELECT     amount                     AS metric
,          @n DIV (@c DIV @quantiles) AS quantile
,          @n                         AS N
FROM       sakila.payment
CROSS JOIN (
            SELECT @n:=0                           -- rownumber
            ,      @c:=COUNT(*) …

News of the Krugle Enterprise appliance product announcement making it to the "Top Stories" list on InfoWorld left me scratching my head. Like many of you, I knew Krugle to be a search engine for code snippets from open source projects. As it turns out, what I had previously thought was "Krugle" is really "Krugle Public". "Krugle Enterprise" is a commercial offering targeted at enterprises. (Who knew??) While Krugle Public is largely targeted at finding code snippets, Krugle Enterprise does this and focuses on defect management and component development across projects, teams and developers. The Krugle Co. website states: "Turn... READ MORE

NetBeans IDE 6.5 Milestone 1 is now available. The New and Noteworthy feature list certainly makes it worthy for the install - comprehensive PHP support (Editor Screencast and PHP Learning Trail), JavaScript Debugger, Groovy Editor, …

While I realize that part 2 to the Lucene stuff is still forthcoming… (err..sorry?!), there are some interesting things going on:

1. Giuseppe, John Loehrer and Jimmy Guerrero will host the webinar Designing Scalable Architectures with MySQL Proxy today. Jan and myself will also attend.

   So, if you are thinking about using the proxy or are simply interested in what people do with it, strongly consider attending this one.

2. There’s a quickpoll up on the MySQL website where we’d …

In the meantime, don't forget the incoming webinar on Designing Scalable Architectures with MySQL …

I want to answer a simple question - If a query takes X milliseconds, how much of it is spent in the storage engine, and how much in the MySQL server? Why do I think is important? Well, since I am working on MySQL performance, I want to be able to place my bets on where to spend my time optimizing MySQL. Lets take an example. If a query takes 50ms, and I am able to figure out that 40ms is in the mysql server and the remaining 10ms is in the storage engine, the first place I would want to take a look at optimizing the MySQL server. This also tells me that it does not matter what the storage engine is, I am being limited by the server. Similarly if I find the storage engine taking up most of the time, I can explore alternate storage engines. I know all you mysql experts will tell me that much of the attribution (of time) has got to do with the capability of the storage engine, what features it supports, etc. and you cannot really do the …

Here’s a packed schedule. There will be a Sun crew visiting these universities between 16-17 July 2008. Will you be there? Where you’ll meet the rock stars:

• Wednesday, 16 July 2008, 9am - noon: Multimedia University, Cyberjaya
• Wednesday, 16 July 2008, 2pm - 5pm: Universiti Teknologi MARA, Shah Alam
• Thursday, 17 July 2008, 9am - noon: Management & Science University, Shah Alam
• Thursday, 17 July 2008, 2pm - 5pm: INTI, Subang

And what exactly will we be talking about? Besides the keynote, and tech demos, there will be focus on NetBeans (a fabulous IDE), an introduction to OpenSolaris, JavaFX, and of course, MySQL.

We all have 30 minute session slots, and the focus is rather developer centric, so I’m wondering what is best to cover in 30 minutes (what one can probably talk about in 5 days even)? Condensed talk on storage engines, index types, etc. ?

…

While I realize that part 2 to the Lucene stuff is still forthcoming… (err..sorry?!), there are some interesting things going on:

1. Giuseppe, John Loehrer and Jimmy Guerrero will host the webinar Designing Scalable Architectures with MySQL Proxy today. Jan and myself will also attend.

   So, if you are thinking about using the proxy or are simply interested in what people do with it, strongly consider attending this one.

2. There’s a quickpoll up on the MySQL website where we’d …