Hello.
> Is there anything I can do to get this query to run - is there a size
> limit for the temp tables that can be tweaked?
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/full-table.html
Erich C. Beyrent wrote:
> Hi all,
>
> I am running into a brick wall with a q
Is their anyway of finding out what queries are causing tmp tables to write
to disk?
Cheers
John Wards
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 3:40 PM
Subject: Re: Re: temp tables
> J
John,
Tuesday, August 20, 2002, 5:27:27 PM, you wrote:
JW> Ta,
JW> But is it normal to have Temp table bigger than 10meg? And a lot of them?
JW> Here is my latest data from STATUS
JW> Created_tmp_disk_tables 46598
JW> Created_tmp_tables 87839
JW> Uptime 81773
JW> And I have set tmp_table_cache
the
size of the tmp tables and the number of them.
I am running an in house build CMS and running phorum. I get about 100,000
page views an hour.
John
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 3:0
John,
Tuesday, August 20, 2002, 11:55:55 AM, you wrote:
JW> MySQL is creating about 50% of temp tables on disk and this is with 10Meg of
JW> temp table cache. Is this normal? and sould I up temp table cache further.
Yes it's normal. Since 3.23 MySQL autommatically converts temporary
tables to di
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
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
13 matches
Mail list logo
