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)
-------------------------------------------------------------------------------------------
show databases;
+----------------------------+
74 rows in set (5.87 sec)
-------------------------------------------------------------------------------------------
show databases;
+----------------------------+
141 rows in set (3.66 sec)
-------------------------------------------------------------------------------------------
show databases;
+----------------------------+
210 rows in set (1.45 sec)
Is this behaviour due to a bug or maybe my mysql tables are messed up?
Here are some stats:
select count(*) from mysql.user;
+----------+
| count(*) |
+----------+
| 998 |
+----------+
1 row in set (0.02 sec)
select count(*) from mysql.host;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.03 sec)
select count(*) from mysql.db;
+----------+
| count(*) |
+----------+
| 1402 |
+----------+
1 row in set (0.03 sec)
select count(*) from mysql.columns_priv;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.03 sec)
mysql> select count(*) from mysql.tables_priv;
+----------+
| count(*) |
+----------+
| 145894 |
+----------+
1 row in set (0.01 sec)
Nico
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Sei single e stai cercando lÂ’amore? Entra subito in Meetic, iscriviti gratis,
consulta i profili di milioni di single e chatta con loro
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=4051&d=21-4
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]