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 query
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 to
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
John,
Tuesday, August 20, 2002
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:06 PM
Subject: Re: temp
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 been
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
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 table
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
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 they do