Hi!
"Fournier" == Fournier Jocelyn <Fournier> writes:
Fournier> In fact, it seems the lock occurs when I execute several 'flush query
cache'
Fournier> command :
Fournier> [root@forum (15:45:27) bin]# mysql -uroot -p
Fournier> Enter password:
Fournier> Welcome to the MySQL monitor. Commands end with ; or \g.
Fournier> Your MySQL connection id is 1157 to server version: 4.0.1-alpha
Fournier> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> flush query cache;
Fournier> Query OK, 0 rows affected (0.03 sec)
mysql> flush query cache;
Fournier> Query OK, 0 rows affected (0.04 sec)
mysql> flush query cache;
Fournier> Query OK, 0 rows affected (0.03 sec)
mysql> flush query cache;
Fournier> LOCKED :(
I tried this on a newly started mysqld and it worked for me.
Did you have any other thread that was doing something at the same
time?
I am just now trying to use 'tests/fork_big.pl' to simulate this
problem, but I haven't yet managed to do this.
Could you try to do a test case for this problem ?
Regards,
Monty
6 messages in com.mysql.lists.bugsRe: Bug with flush query cache in MyS...