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: Copying to tmp table

: 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 : Table

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: 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

Re: Query hung up in Copying to tmp table

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 tmp table Matt, Thanks for your response. It's going to take a bit for me to get the actual

RE: Query hung up in Copying to tmp table

[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 examining/returning so many rows that it's going to take a long time to create the needed temporary table

Re: Query hung up in Copying to tmp table

(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 returns. In show processlist, it reports

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'm considering upgrading

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

re: Copying to tmp table

Teh, Tuesday, September 24, 2002, 8:31:54 AM, you wrote: TCP Does anyone has any idea to improve this situation? TCP When I show my processlist, there is inner join query that having Copying TCP to tmp Table state, and it takes quite long time to finish the query. Any TCP idea to avoid Copying

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 however

Re: Copying to tmp table

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? I have tried

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 takes me about 1

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 don't know what else could

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