Skip to content

Comment on PhpMyAdmin Turns 15

Comments

I'd appreciate it more if they'd just stop doing

     SELECT COUNT(*) 
on innodb tables (which do not handle that query well with many rows). Yes there is a workaround but it is flawed.

What should you use on InnoDB tables instead?

Get a quick estimate out of SHOW TABLE STATUS

AboutSource Built by g1lg1l

Hackerly is an independent reader for Hacker News, built on the public HN API. Not affiliated with Y Combinator.