Re: Server just hanging (Copying to tmp table)
I ran into this same problem today, once it happens you can't recover from it. We have a powerhouse server, and MySQL variables/queries are tweaked.
As others have said, optimization of queries and variables is a potential work around, but shouldn't someone from MySQL take a look at the cause of the problem and devise a solution?
I am running 5.0.22-log
Subject
Views
Written By
Posted
29611
August 11, 2005 11:25AM
24409
August 12, 2005 09:07AM
19640
August 12, 2005 01:06PM
19216
August 22, 2005 09:46AM
17296
August 24, 2005 03:27PM
13717
August 24, 2005 04:05PM
14407
August 26, 2005 11:02AM
8166
August 26, 2005 11:05AM
7577
August 26, 2005 11:45AM
7341
August 26, 2005 05:46PM
7615
August 26, 2005 10:34PM
7220
August 25, 2005 01:08PM
7986
August 26, 2005 11:07AM
6376
August 27, 2005 09:09AM
6736
August 29, 2005 11:50AM
6628
August 29, 2005 12:04PM
6007
August 29, 2005 12:55PM
6336
August 29, 2005 05:26PM
7099
August 29, 2005 06:34PM
5478
August 29, 2005 08:40PM
6292
August 29, 2005 08:47PM
5293
August 29, 2005 09:00PM
6789
August 30, 2005 10:05AM
5353
August 30, 2005 10:18AM
5878
August 30, 2005 10:20AM
6844
August 29, 2005 08:53PM
5839
August 29, 2005 09:50PM
5580
August 29, 2005 10:01PM
6044
August 30, 2005 08:53AM
5390
August 30, 2005 11:22AM
5920
August 30, 2005 11:33AM
5592
August 30, 2005 11:59AM
25150
August 31, 2005 02:32PM
7276
August 31, 2005 02:49PM
6043
August 31, 2005 02:56PM
7347
August 31, 2005 03:06PM
9119
December 07, 2006 10:30AM
5711
August 31, 2005 03:10PM
7138
August 31, 2005 03:32PM
18484
August 31, 2005 07:15PM
5894
September 01, 2005 03:05AM
8552
September 15, 2005 04:31PM
6483
September 01, 2005 04:39AM
5430
September 08, 2005 09:53AM
5688
September 08, 2005 11:25AM
5935
September 26, 2005 11:52AM
5291
September 26, 2005 12:13PM
5212
September 27, 2005 09:55AM
5123
September 27, 2005 10:18AM
4798
September 28, 2005 10:29AM
4988
September 28, 2005 10:34AM
5211
September 28, 2005 10:52AM
5623
September 28, 2005 10:58AM
12009
September 23, 2005 01:56AM
5676
September 23, 2005 07:11AM
7473
October 05, 2005 04:58AM
7021
October 05, 2005 04:52PM
7948
October 05, 2005 11:49PM
6297
October 06, 2005 01:34AM
8230
October 06, 2005 04:57PM
5422
December 13, 2005 10:28AM
5368
December 13, 2005 10:34AM
5252
November 17, 2005 09:39AM
6231
January 08, 2007 12:12PM
5497
December 12, 2005 02:13PM
5440
December 14, 2005 11:43PM
6336
December 15, 2005 08:37AM
5568
December 15, 2005 11:18AM
6514
December 15, 2005 11:27AM
6276
December 15, 2005 11:32AM
4788
December 15, 2005 11:43AM
6327
December 15, 2005 11:43AM
4974
December 15, 2005 11:48AM
4814
December 15, 2005 11:51AM
5738
December 15, 2005 02:14PM
6004
December 15, 2005 02:18PM
4802
December 15, 2005 02:27PM
6497
December 15, 2005 02:43PM
4760
December 15, 2005 08:46AM
5745
January 26, 2006 12:38PM
4923
January 26, 2006 01:48PM
6248
January 26, 2006 01:48PM
4718
January 26, 2006 01:52PM
4904
January 27, 2006 04:46PM
6143
January 29, 2006 11:21AM
6691
January 30, 2006 09:42AM
5367
February 27, 2006 02:17PM
6450
February 27, 2006 02:23PM
5074
March 05, 2006 04:56AM
5853
March 06, 2006 08:09AM
4861
April 05, 2006 01:03PM
5663
September 27, 2006 08:43AM
6056
November 19, 2006 04:42AM
5300
December 14, 2006 05:45PM
4919
February 01, 2007 04:40AM
5649
November 11, 2007 01:24PM
Re: Server just hanging (Copying to tmp table)
6982
December 20, 2007 10:40AM
7268
January 21, 2008 10:14AM
6634
January 21, 2008 10:53AM
6354
May 19, 2008 09:41AM
6973
February 05, 2008 10:27AM
6824
March 12, 2008 08:37AM
6125
May 19, 2008 03:02AM
6852
November 14, 2008 12:31AM
7899
March 06, 2009 03:36PM