I'm running some SQL statements against a large database to test their execution speed. Right now, all database management is through phpmyadmin. With our hosting provider, it would be a proper pain to set up another kind of DB access. And phpadmin is rewriting the queries, invalidating the tests.
Specifically, when I ask phpmyadmin to run the query:
SELECT * FROM records WHERE target = 35
...phpmyadmin transforms this into...
SELECT * FROM records WHERE target = 35 LIMIT 0 , 30
...and of course THAT runs plenty fast. That's not what I'm testing. I'm testing how long it takes to pull all million records.
Is there a way to get phpmyadmin to run the actual query I put in, without modification?
This configuration directive makes a "Show all" button appear, on a results page: http://docs.phpmyadmin.net/en/latest/config.html?highlight=showall#cfg_ShowAll
This "Show all" button permits you to see all results, without a LIMIT clause generated by phpMyAdmin.