V
V
vitalyg2015-04-09 20:48:14
PHP
vitalyg, 2015-04-09 20:48:14

Mysql, Is the query being processed for a long time, PARTITIONS?

select count(*) into @discard from `information_schema`.`PARTITIONS`
This query is very slow and slows down the entire selection.
How can I disable this request?
How can I turn it off at all, or if not turn it off, then speed up the selection, otherwise it is processed for 13-14 seconds.
Thank you.
UPD
Count: 1 Time=13.39s (13s) Lock=0.00s (0s) Rows=0.0 (0), debian-sys-maint[debian-sys-maint]@localhost

Answer the question

In order to leave comments, you need to log in

3 answer(s)
R
Ramallah, 2015-04-09
@ramallah

What is the table type? Number of entries?

V
vitalyg, 2015-04-09
@vitalyg

Table type `information_schema`? Everything is by default, there are no records, it thinks for a very long time.

F
FanatPHP, 2015-04-10
@FanatPHP

You need to find the code that executes this request and comment it out

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question