Hi,
I have a strange and annoying problem with Mysql 4.0.26 that I hope
someone will help me to fix:
the more databases a user has the less time it takes to execute show
databases and vice versa:
show databases;
+--+
5 rows in set (7.97 sec)
On 4/21/06, Nico Sabbi [EMAIL PROTECTED] wrote:
Is this behaviour due to a bug or maybe my mysql tables are messed up?
I'm not sure if we can call it a bug. But spending 8 seconds (and
using 100% CPU) for a simple SHOW DATABASES query is a bit too much,
and should be fixed.
mysqld first reads
On 4/21/06, Nico Sabbi [EMAIL PROTECTED] wrote:
the more databases a user has the less time it takes to execute show
databases and vice versa:
If no rows in `show databases` output appear because some user has
some table/columns privs but no db privs for a database in question,
then I think