RE: Copying to tmp table

sage- From: Carlos Eduardo Caldi [mailto:ce_ca...@hotmail.com] Sent: Tuesday, April 28, 2009 8:19 PM To: mysql@lists.mysql.com Subject: Copying to tmp table Hi friends I have a proble with Copying to tmp table with large tables, table have more than 3 million rows EXPLAIN da Query : T

Copying to tmp table

Hi friends I have a proble with Copying to tmp table with large tables, table have more than 3 million rows EXPLAIN da Query : Table : log0904 Type : ref Possible_keys : data_login_tplig,emp_grp_login_dtlig,grp_tiporeg_tipolig_dtlig,grp_dtlig_tplig,dtlig_num

Re: Mysql openBSD Copying to tmp table

"Mevershosting.nl" <[EMAIL PROTECTED]> wrote: > Anyone here have any qlue ? We had a couple of dissatisfactions trying to run MySQL on OpenBSD. See http://bulk.fefe.de/scalability/ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensi

Mysql openBSD Copying to tmp table

, (2,6 Ghz 1GB internal mem) The forum runs quick until somebody searches the forum, the process list shows a item which has the: Copying to tmp table state This takes ages, at least 200 seconds I tested with all kinds of config in my.cnf but nothing seems to help at all.. Now i moved the DB over

Re: Query hung up in "Copying to tmp table"

s/columns if you can't let them be seen. :-) Hint: use \G instead of ; at the end of the EXPLAIN query to make the output more legible. Matt - Original Message - From: "Kevin Fries" Sent: Friday, September 05, 2003 11:09 AM Subject: RE: Query hung up in "Copying to tm

RE: Query hung up in "Copying to tmp table"

in > -Original Message- > From: Matt W [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 1:37 PM > To: [EMAIL PROTECTED] > Subject: Re: Query hung up in "Copying to tmp table" > > > Hi Kevin, > > I imagine the query is examini

Re: Query hung up in "Copying to tmp table"

ables (rows and MB). Matt - Original Message - From: "Kevin Fries" Sent: Wednesday, September 03, 2003 6:51 PM Subject: Query hung up in "Copying to tmp table" > I'm having a problem where a complex SELECT query begins eating up lots > of CPU and never

Query hung up in "Copying to tmp table"

I'm having a problem where a complex SELECT query begins eating up lots of CPU and never returns. In "show processlist", it reports "Copying to tmp table". Other queries seem to get locked waiting for this query, as well. This is on version 3.23.36 of mySQL, and I&#

Re: Copying to tmp table

Sender: [EMAIL PROTECTED] Date: Tue, 24 Sep 2002 08:21:20 +0200 From: Lars Heidieker <[EMAIL PROTECTED]> on solaris it probably a good idea to change the tmp directory from /var/tmp -> /tmp I recalled this feature and decided to look into linux for it's paral

re: Copying to tmp table

TCP> idea to avoid Copying to tmp Table? I have tried to increase my TCP> tmp_table_size however it does not remedy my problem. MySQL uses temporary tables in some queries. You can try to optimize your query. Here is some info that could help you: http://www.mysql.com/doc/en/EXPLAIN.html

Re: Copying to tmp table

ble is needed... Teh Chee Peng wrote: > hi, > Does anyone has any idea to improve this situation? > When I show my processlist, there is inner join query that having "Copying > to tmp Table" state, and it takes quite long time to finish the query. Any > idea to avoid

Copying to tmp table

hi, Does anyone has any idea to improve this situation? When I show my processlist, there is inner join query that having "Copying to tmp Table" state, and it takes quite long time to finish the query. Any idea to avoid Copying to tmp Table? I have tried to increase my tmp_table_size

RE: copying to tmp table

Paste EXPLAIN SELECT ... (your SELECT); from the mysql client. > Hi! > > When I join 4 tables with about 3000 records in each mysql seems to work > forever on "copying to tmp table". > > I wonder what that could be. I have enough free space in the tmp-dir and > d

copying to tmp table

Hi! When I join 4 tables with about 3000 records in each mysql seems to work forever on "copying to tmp table". I wonder what that could be. I have enough free space in the tmp-dir and don't know what else could it be. The database-model is normalized and on another machine it t

Copying to tmp table & order by, group by

max_tmp_tables=100 kind of the requets which takes more than 10sec. | Query | 13 | Copying to tmp table | SELECT medias.idmedia, medias.titre, |medias.note, medias.idtype, categ.nomcat FROM medias, medias_de | Query | 11 | Copying to tmp table | select products.products_id