Can I change phpMyAdmin's default queries?
<p>I have several large innodb tables (over 500M records). When I click on one to view it, the system takes forever (a couple minutes) to return the first 30 rows. I went into my shell program and saw that phpMyAdmin was doing a select count(*) from table. This DIES in innodb. I do have the table indexed by the primary key which is an auto-increment id. </p>

<p>Is there any way to change this so that phpMyAdmin is actually useful for large innoDB tables? It worked fine for myIsam as count(*) performs well there. With innodb you need to count an indexed column, such as count(id). </p>