These Are Not the Rows You’re Looking For

In April, I wondered why a simple COUNT(1) query took 30 seconds.  Now I know it could be a lot worse:

[bobbojones@test (none)] > SELECT COUNT(1) FROM r2;
| COUNT(1) |
|        0 |
1 row in set (59.76 sec)

It just took nearly a minute to determine that the table is empty.

That’ll do, MySQL.  That’ll do.