From: 156 Oud (oud156hotmail.com)
Date: Sat Oct 29 2005 - 08:26:10 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

I've got the exact same problem than Johannes with MySQL 4.1.14.
Like him, i've set a little script
>$db=mysql_connect($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 <awfiefgmail.com>
>
>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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]