ilivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, January 20, 2001 5:27 AM
Subject: Re: temp tables lock unrelated tables
> Michael Griffith writes:
> > Cacheing before writing sounds like exact
Michael Griffith writes:
> Cacheing before writing sounds like exactly the type of thing that would
> explain the problem. However, I'm on FreeBSD (Sorry, didn't give too many
> details). Anybody know if there is something similar in to bdflush BSD?
>
> I did run iostat to monitor the the a
Michael Griffith writes:
> My TMPDIR is actually not separate from the data. There is plently of disk
> space. In fact, thinking it was some sort of RAM problem I reduced the size
> of the database by almost 30% with no change in performace.
>
> You say this should not happen, yet as I've be
Cacheing before writing sounds like exactly the type of thing that would
explain the problem. However, I'm on FreeBSD (Sorry, didn't give too many
details). Anybody know if there is something similar in to bdflush BSD?
I did run iostat to monitor the the activity during the freeze. It appears
th
>Earlier I posted a message about SHOW PROCESSLIST reporting queries "locked"
>whenever another thread is "Copying to tmp table"
>
>After many more hours of diagnosis, the actual problem is somewhat different:
>
>MySQL does report other processes as locked. But they do not wait until the
>temp t
Michael Griffith wrote:
>
> Earlier I posted a message about SHOW PROCESSLIST reporting queries "locked"
>whenever another thread is "Copying to tmp table"
>
> After many more hours of diagnosis, the actual problem is somewhat different:
>
> MySQL does report other processes as locked. But the
Earlier I posted a message about SHOW PROCESSLIST reporting queries "locked" whenever
another thread is "Copying to tmp table"
After many more hours of diagnosis, the actual problem is somewhat different:
MySQL does report other processes as locked. But they do not wait until the temp table
is
My TMPDIR is actually not separate from the data. There is plently of disk
space. In fact, thinking it was some sort of RAM problem I reduced the size
of the database by almost 30% with no change in performace.
You say this should not happen, yet as I've been searching the mailing list
there's at
Michael Griffith writes:
> Using SHOW PROCESSLIST or mysqladmin proc
>
> Every time a table reports status of 'copying to tmp table' all other UPDATE queries
>are locked, even in unrelated tables.
>
> For example:
>
> Query #1: SELECT * FROM a JOIN B WHERE Status: copying to tmp
Using SHOW PROCESSLIST or mysqladmin proc
Every time a table reports status of 'copying to tmp table' all other UPDATE queries
are locked, even in unrelated tables.
For example:
Query #1: SELECT * FROM a JOIN B WHERE Status: copying to tmp table
Query #2: UPDATE C SET x=x+1 WHERE..
10 matches
Mail list logo
