unnecessary queries causing creating tmp tables on disk
Database management in a single PHP file
Brought to you by:
jakubvrana
Menu
▾
▴
#835 unnecessary queries causing creating tmp tables on disk
Hello,
Why is Adminer doing query like SHOW COLUMNS FROM tableXYZ for every table on every request? These info are not needed on every page AFAIK and they do create a disk temp table, each query 1. I've come across this by change when I was hunting down a cause of many temp tables being persisted on disk. In a big database, with a lot of tables, it may have an impact. The reason for tmp table being written to disk is that data are fetched from information_schema.columns which contains TEXT columns, more on https://bugs.mysql.com/bug.php?id=70433
originally posted on https://sourceforge.net/p/adminer/discussion/960418/thread/751b99c36e/?limit=25#34bc
Adminer needs this to get info about the fields in a table.
But does it need the info about every table in database on each request? I don't mind querying info about the currently viewed table but it runs the query for every table regardless the current section/action.