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.