I'm having a problem with a w3k srv machine, i have several other equal to this one, and
this problem only happens on this one.
Some process in my application creates a temporary table, and mysql takes about 2 minutes
to complete it, on other machines takes about 2 secunds, when i do a "show processlist"
mysql tells me that he is coping to the tmp table, but it seams hanged in there, and if i
check the system processlist, the mysqld-nt.exe is taking about 50% of the system
Below i've pasted a copy of the mysql "show processlist"
| Id | User | Host | db | Command | Time | State | Info
| 44 | neotrix | localhost:2033 | bombeiros | Query | 17 | Copying to tmp table |
SELECT t1.*,concat(t1.numero,'/',t1.serie) as numser, if(t1.des1=0, t1.des2, t1.des1) as
I've installed the mysql service with the following command ("mysqld-nt --install MySQL
--skip-name-resolve"), to prevent dns resolution, i've thinked it could be that, but it
|• Creating TMP table problem||Jorge Bastos||27 Aug|