Thread: [adminer-tracker] [ adminer-Bugs and Features-3515776 ] query for routines is useless and gets a lo
Database management in a single PHP file
Brought to you by:
jakubvrana
From: SourceForge.net <no...@so...> - 2012-04-07 22:32:52
|
Bugs and Features item #3515776, was opened at 2012-04-07 15:32 Message generated for change (Tracker Item Submitted) made by moricio You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3515776&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MySQL Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Mauricio Ramirez (moricio) Assigned to: Jakub Vrána (jakubvrana) Summary: query for routines is useless and gets a lot of time Initial Comment: Hi! Every time I change from a db to another, adminer does a SELECT count(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = 'newdb' In my server I have over 700 databases and this query takes like a long time, over 1 minute and 30 seconds, just to change to another db. The query doesn't serve any purpose at all and takes a long a time, making adminer (and phpmyadmin btw) useless! It's not required, except if I'm doing an export of procedures or editing any of them. Please, cut it out! M. MySQL 5.1.37-community ------------------------------------- mysql> use information_schema; Database changed mysql> select count(*) from routines; +----------+ | count(*) | +----------+ | 23232 | +----------+ 1 row in set, 5 warnings (1 min 17.05 sec) mysql> SELECT count(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = 'mikrocrm_99'; +----------+ | count(*) | +----------+ | 55 | +----------+ 1 row in set, 5 warnings (1 min 28.75 sec) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3515776&group_id=264133 |
From: SourceForge.net <no...@so...> - 2012-05-14 00:27:45
|
Bugs and Features item #3515776, was opened at 2012-04-07 15:32 Message generated for change (Comment added) made by jakubvrana You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3515776&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MySQL Group: None Status: Open >Resolution: Accepted Priority: 5 Private: No Submitted By: Mauricio Ramirez (moricio) Assigned to: Jakub Vrána (jakubvrana) Summary: query for routines is useless and gets a lot of time Initial Comment: Hi! Every time I change from a db to another, adminer does a SELECT count(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = 'newdb' In my server I have over 700 databases and this query takes like a long time, over 1 minute and 30 seconds, just to change to another db. The query doesn't serve any purpose at all and takes a long a time, making adminer (and phpmyadmin btw) useless! It's not required, except if I'm doing an export of procedures or editing any of them. Please, cut it out! M. MySQL 5.1.37-community ------------------------------------- mysql> use information_schema; Database changed mysql> select count(*) from routines; +----------+ | count(*) | +----------+ | 23232 | +----------+ 1 row in set, 5 warnings (1 min 17.05 sec) mysql> SELECT count(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = 'mikrocrm_99'; +----------+ | count(*) | +----------+ | 55 | +----------+ 1 row in set, 5 warnings (1 min 28.75 sec) ---------------------------------------------------------------------- >Comment By: Jakub Vrána (jakubvrana) Date: 2012-05-13 17:27 Message: Adminer doesn't execute SELECT count(*), it executes SELECT * to get the list of routines in the database. I don't want to remove this feature (or load the list on a click) but I accept the request for improving its performance. Can you please try running SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS on your box and measure the time to run them? If they will be significantly faster then I will exchange them for the information_schema.ROUTINES query. If they will be slow too then I will probably make the call deferred. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3515776&group_id=264133 |
From: SourceForge.net <no...@so...> - 2013-04-27 20:03:35
|
Bugs and Features item #3515776, was opened at 2012-04-07 15:32 Message generated for change (Settings changed) made by jakubvrana You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3515776&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MySQL Group: None >Status: Pending Resolution: Accepted Priority: 5 Private: No Submitted By: Mauricio Ramirez (moricio) Assigned to: Jakub Vrána (jakubvrana) Summary: query for routines is useless and gets a lot of time Initial Comment: Hi! Every time I change from a db to another, adminer does a SELECT count(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = 'newdb' In my server I have over 700 databases and this query takes like a long time, over 1 minute and 30 seconds, just to change to another db. The query doesn't serve any purpose at all and takes a long a time, making adminer (and phpmyadmin btw) useless! It's not required, except if I'm doing an export of procedures or editing any of them. Please, cut it out! M. MySQL 5.1.37-community ------------------------------------- mysql> use information_schema; Database changed mysql> select count(*) from routines; +----------+ | count(*) | +----------+ | 23232 | +----------+ 1 row in set, 5 warnings (1 min 17.05 sec) mysql> SELECT count(*) FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = 'mikrocrm_99'; +----------+ | count(*) | +----------+ | 55 | +----------+ 1 row in set, 5 warnings (1 min 28.75 sec) ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2012-05-13 17:27 Message: Adminer doesn't execute SELECT count(*), it executes SELECT * to get the list of routines in the database. I don't want to remove this feature (or load the list on a click) but I accept the request for improving its performance. Can you please try running SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS on your box and measure the time to run them? If they will be significantly faster then I will exchange them for the information_schema.ROUTINES query. If they will be slow too then I will probably make the call deferred. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3515776&group_id=264133 |