5 messages in com.mysql.lists.win32Re: queries getting stuck in "Opening...| From | Sent On | Attachments |
|---|---|---|
| Dan Fulbright | 22 Dec 2005 19:47 | |
| Daniel da Veiga | 22 Dec 2005 20:18 | |
| Dan Fulbright | 22 Dec 2005 21:16 | |
| Daniel da Veiga | 23 Dec 2005 05:12 | |
| Markus Grossrieder | 23 Dec 2005 09:01 |
| Subject: | Re: queries getting stuck in "Opening table" state |
|---|---|
| From: | Daniel da Veiga (dani...@gmail.com) |
| Date: | 12/23/2005 05:12:57 AM |
| List: | com.mysql.lists.win32 |
On 12/23/05, Dan Fulbright <dan+mysq...@dan.tulsa.ok.us> wrote:
I'm having problems on several similarly-configured Windows Server 2003 servers using various revisions of MySQL 4.1. Several times a
What are the exact versions? I had a similar problem with MySQL 4.1.xx, it was just annoying, simple queries with LIMIT, GROUP BY, just SELECTs use to get stuck, the problem gone away when I upgraded to MySQL 4.1.17, guess it was a bug of some kind.
Doing a spot check on three of the servers that have this problem, I see that one is running MySQL 4.1.11, and two are running 4.1.15.
You mentioned 4.1.17, however the GA release is 4.1.16. Do you know something I don't know? :-) I'll try upgrading to 4.1.16 and see if that fixes it.
Now, that scared me, just entered MySQL site and noticed that too, but one of my win servers is running 4.1.18, along with both lin servers. What happened? Where are the other releases?! Someone?! Ok, I've been working a lot, but downloading 2 "inexistent" packages with higher versions... Nah.
day, a query will get stuck, and MySQL is basically useless until it is restarted. I can't shutdown mysqld-nt.exe with "mysqladmin shutdown" (it doesn't give me any errors, it just doesn't shut it down) or with "net stop mysql." I have to kill it with Task Manager. Until I do this, MySQL generally accepts incoming connections, but queries just get stuck, and the process list grows and grows.
Maybe you should try switching from mysqld-nt to mysqld or mysqld-opt, check the Manual for the differences between them and test it.
That's something I haven't tried. Thanks for the suggestion.
I'll give both your suggestions a try and report back here with the results.
Thanks again.
-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=dani...@gmail.com
-- Daniel da Veiga Computer Operator - RS - Brazil -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END GEEK CODE BLOCK------