For a long time, whenever I wanted to do paging to browse through a table, I used to run 2 queries. The first would get the results, and the second would be an almost identical query, with a count() instead of fields, and I’d use the result of the second query to figure out how many pages I would need.

Now there’s a better solution, and it’s called found_rows(). Say you have a simple select statement:


select * from sometable LIMIT 10;


You don’t know how many rows are in the table, so you need to do a second query:


select count(1) from sometable;


Now you can calculate the number of pages.

Using found_rows, you write your first query as:


select SQL_CALC_FOUND_ROWS * from sometable LIMIT 10;
select found_rows();


Pagination with MySQL couldn’t be easier.

While this won’t …

Colin, son of Gary is officially the youngest attendee of the MySQL Camp. The new breed of MySQL DBA’s.

Colin really loves the swivel chairs, and now has is own Google shirt courtesy of Leslie!

Also check it out on Gary’s site.

I recently tested installing innotop on Microsoft Windows. There was one slight glitch, but I changed a couple lines of code, and now it runs out of the box under ActivePerl. Version 0.1.156 contains those changes for Windows compatibility.

Upon waking up this morning I was faced with the following question:

"Eat Hotel free breakfast, deal with crappy wireless.... or go to Google, get great food, and have good to great breakfast?"

Easy choice...

Yesterday? Explained daemon plugins, walked through the internals to MySQL and answered questions on refactoring MySQL.

Today?

Much of the same, and Brad and I are going to talk about memcached and ha_memcache (aka the Engine for MySQL). I think I am giving several other talks as well...

Busy, much busy...

Walking around Google and seeing all of the cheap projectors makes me wonder what I could do with a few dozen of these around the house....

It's been a while since I blogged. I've been busier than you can imagine.
Anyways, I finally got the opportunity to start playing with MySQL 5.1 beta and installed 5.1.12-beta on one of our beta database srevers to startt testing functionality. I'm really excited abiut this version, particularly Partitioning with InnoDB. 5.1.11-beta didn;t work at all. I'm about to put it through its tests and really start testing the performance of this new version. Stay tuned!

I just read this post, thanks to the database log buffer:

http://marist89.blogspot.com/2006/11/where-am-i-deploying-mysql.html

I think the major point is subtle, and can be gotten by taken the first and last few sentences of the post:

“If cost were no object, I’d always deploy Oracle. I’m comfortable with Oracle technology and I think I have a pretty good idea how to implement and administer it….My company is sold on MySQL and as our confidence grows in the software, so will our installed base.”

He says that MySQL is an “80% solution” but he would not use it for “mission critical applications.” I will venture to say that this is because he is not familiar with MySQL. If he were, …

I just read this post, thanks to the database log buffer:

http://marist89.blogspot.com/2006/11/where-am-i-deploying-mysql.html

I think the major point is subtle, and can be gotten by taken the first and last few sentences of the post:

“If cost were no object, I’d always deploy Oracle. I’m comfortable with Oracle technology and I think I have a pretty good idea how to implement and administer it….My company is sold on MySQL and as our confidence grows in the software, so will our installed base.”

He says that MySQL is an “80% solution” but he would not use it for “mission critical applications.” I will venture to say that this is because he is not familiar with MySQL. If he were, …

Plenty of people are writing highly technical stuff from MySQL Camp including your’s truly. However there needs to be a lighter side here, and well this is it, Memorable Quotes.

“That’s moderately easy to difficult.” Brian Aker talking about table_funcs in A MySQL Core Kernel

“That’s Trivial, it’s less then a day’s work”, Monty, also in “A MySQL Core Kernel”, of course Monty said “It’s Trivial” several times, and that’s fine, it probably is trivial and is a day’s work for the guru’s, the problem is there are presently 6,000 trivial day’s work on the list of things to do.

“I’m trying to estimate when my finger will fall off.” — Jay Pipes You had to be there. I will say no more.

?You work for InnoDB, right? — Dathan Vance Pattishall of …

Yes you got it, even while in the restroom here at Google (you can’t say toilets here in the US, because that’s the device), Google keeps you occupied while standing or sitting with the writings of “Testing on the Toilet”.

In Episode 19, TOTT talks about “Converting Old Style Tests”. An interesting read, rather then the daily grind of the front page of USA Today, plus as well as something that can be obviously changed at a longer frequency.

So how was the toilet experience here at MySQL Camp. Well you have toilet warming seats , my first experience, it was a little weird, and then you get the builtin “bidet” as well, with the ability for front cleaning, rear cleaning and then drying. Now that was really weird.

There has been a policy of what photos we can and can’t take and that’s cool, so I can’t post a copy of it. I will however show …

Not long ago, Kaj announced the plan to develop a native driver for PHP. As Kaj explained, the new development will be licensed under the terms of the PHP license and donated to the PHP Group to solve any license issues.

Don’t get us wrong here. We will not break any existing PHP code or PHP applications! We want to develop another, technical superior option for PHP users to connect to MySQL. Most of the new developments will happen “under the hood” of PHP on the C level. We will write a replacement for the libmysql that can be used by PHP extension internally. We will not develop a new PHP extension, thus there will be no new API for PHP developers. You will be offered an additional, alternative option in PHP 6 to connect to the MySQL Server.