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
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