[Phpmyadmin-devel] Innodb and row exact count

Michal Čihař michal at cihar.com
Wed Jun 12 09:23:29 CEST 2013


Hi

Dne Tue, 11 Jun 2013 13:20:44 -0400
Marc Delisle <marc at infomarc.info> napsal(a):

> I don't find a winning solution so I'm seeking for advice. In this bug 
> report [0], we see that it's annoying to have incorrect page navigation 
> (page selector and arrows) for InnoDB.
> 
> However, when I apply my proposed patch (which forces an exact count in 
> sql.php), I see delays for larger InnoDB tables.
> 
> For example, on MySQL 5.5.31, the first time I browse a table having one 
> million rows, I wait for 9 seconds. I tried with 0.5 million and it was 
> about 5 seconds. A few minutes afterwards, even after closing the 
> browser, my big table starts to display in two seconds.
> 
> I tend to find these delays acceptable and I propose to apply my patch.

I agree this is acceptable and agree with the patch for 4.0.4.

For 4.1 I'd go even further - drop MaxExactCount and use only not exact
counts on overview pages and count properly when browsing.

-- 
	Michal Čihař | http://cihar.com | http://blog.cihar.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20130612/99bb5e23/attachment.sig>


More information about the Developers mailing list