Hi,
I've got the exact same problem than Johannes with MySQL 4.1.14.
Like him, i've set a little script
[EMAIL PROTECTED]($host,$user$password);
while ($i<50000) {
$x=mysql_query($query);
if ( $x) {
print "$i worked!<BR>";
} else {
print "$i ERROR! ".mysql_error()."<BR>";
}
$i++;
}
This script always crash before the end with error :
command denied to user
Now, i'm trying to install MySQL 4.1.14 on a different server and see if i
can reproduce this.
By the way, thanks for the link about jeremy's blog.
My servers are happy now with thread_cache_size = 40, but the "access
denied" bug is still there :(
From: sheeri kritzer <[EMAIL PROTECTED]>
I'm not sure if this will help you, but it might:
http://jeremy.zawodny.com/blog/archives/000173.html
(brief excerpt)
"So the moral of the story is this: If you have a busy server that's
getting a lot of quick connections, set your thread cache high enough
that the Threads_created value in SHOW STATUS stops increasing. Your
CPU will thank you."
The only other thing I can think of is if you have a lock on the table
(if it's MyISAM) at the same time, so the select is denied. Updates
have preference in MySQL over reads when there's a lock, so a read
query would wait for a write query. But then you'd get a timeout
error. . ..
SHOW STATUS LIKE 'Table%';
will show you the lock contention, if there is any.
What else is going on in the database? Are you doing maintenance,
like OPTIMIZE TABLE?
That is a very odd situation.
-Sheeri
_________________________________________________________________
MSN Hotmail : antivirus et antispam gratuits !
http://www.imagine-msn.com/hotmail/default.aspx?locale=fr-FR
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
