ubject:
Re: Performance problem with more than 500 concurrent queries
Hi,
Could try your script with the key_buffer set to 0 ?
Regards,
Jocelyn Fournier
[EMAIL PROTECTED] a écrit :
> Hello,
>
> Thanks for you help. You can see the results in the .err file below.
I've
>
]>
To:
mysql@lists.mysql.com
Date:
26.06.2008 22:52
Subject:
Re: Performance problem with more than 500 concurrent queries
At 10:39 AM 6/26/2008, you wrote:
Hello,
thanks for the answer.
Where is the error.log stored? I run the mysqladmin, it requires the
password and it exits immediately.
Open files:20
Open streams: 0
Alarm status:
Active alarms: 265
Max used alarms: 279
Next alarm time: 28789
sh-3.2#
From:
mos <[EMAIL PROTECTED]>
To:
mysql@lists.mysql.com
Date:
26.06.2008 22:52
Subject:
Re: Performance problem with more than 500 concurrent querie
At 10:39 AM 6/26/2008, you wrote:
Hello,
thanks for the answer.
Where is the error.log stored? I run the mysqladmin, it requires the
password and it exits immediately. But I cannot find any error.log.
Thanks,
Guillermo
Guillermo,
Look in the \MySQL\Data\*.err file.
Also I don't
D]
> To:
> mysql@lists.mysql.com
> Date:
> 26.06.2008 17:39
> Subject:
> Re: Performance problem with more than 500 concurrent queries
>
>
>
> Hello,
>
> thanks for the answer.
>
> Where is the error.log stored? I run the mysqladmin, it requires the
> password
Sorry about the long signature in the email. I forgot to remove it...
Guillermo
From:
[EMAIL PROTECTED]
To:
mysql@lists.mysql.com
Date:
26.06.2008 17:39
Subject:
Re: Performance problem with more than 500 concurrent queries
Hello,
thanks for the answer.
Where is the error.log stored? I
;
Cc:
mysql@lists.mysql.com
Date:
26.06.2008 16:30
Subject:
Re: Performance problem with more than 500 concurrent queries
do this
mysqladmin -uroot -p debug
and check the error.log, see if there are any locks on the tables.
On 6/26/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> He
do this
mysqladmin -uroot -p debug
and check the error.log, see if there are any locks on the tables.
On 6/26/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hello guys,
>
> I am new to this list and also kind of new to mysql too.
>
> I have a multi-thread application written in Ruby. The
Hello guys,
I am new to this list and also kind of new to mysql too.
I have a multi-thread application written in Ruby. The application is
reading one table that has two columns (Father, Children). As you might
suspect, this is a tree. The fields are foreign keys to a second table,
but the sec
