Bummer! I was hoping that you'd see what actually gets executed
during a SHOW DATABASES, like "select * from user, table_privs where
" so you could then run an EXPLAIN on it.
For me on 5.0.21 EXPLAIN SHOW DATABASES gives me an error so no joy there.
I suspect you've got a lot more entries i
Nico, as a first stab, I would try optimizing the tables in question.
OPTIMIZE TABLE mysql.user
etc.
The one with 194,177 entries would be a good candidate for this especially.
done, but with no improvement
I wonder also if you would see something logged in the slow query log
as this happe
Nico, as a first stab, I would try optimizing the tables in question.
OPTIMIZE TABLE mysql.user
etc.
The one with 194,177 entries would be a good candidate for this especially.
I wonder also if you would see something logged in the slow query log
as this happens? Perhaps the tables_priv table
Hello,
as the title reads, when a user X with access to few tables runs "show
databases"
the query executes _very_ slowly and there's a sudden HUGE load (mysqld
takes 99% cpu for the whole
duration of the query):
show databases;
++
| Database |
+--
