Re: Execution time of "show databases" increases when fewer databasesare visible

2006-04-21 Thread Alexey Polyakov
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 thi

Re: Execution time of "show databases" increases when fewer databasesare visible

2006-04-21 Thread Alexey Polyakov
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 read