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
29309
August 11, 2005 11:25AM
24355
August 12, 2005 09:07AM
19594
August 12, 2005 01:06PM
19145
August 22, 2005 09:46AM
17193
August 24, 2005 03:27PM
13666
August 24, 2005 04:05PM
14356
August 26, 2005 11:02AM
8081
August 26, 2005 11:05AM
7517
August 26, 2005 11:45AM
7284
August 26, 2005 05:46PM
7558
August 26, 2005 10:34PM
7165
August 25, 2005 01:08PM
6705
August 26, 2005 11:07AM
6332
August 27, 2005 09:09AM
6687
August 29, 2005 11:50AM
6585
August 29, 2005 12:04PM
5971
August 29, 2005 12:55PM
5941
August 29, 2005 05:26PM
5948
August 29, 2005 06:34PM
5435
August 29, 2005 08:40PM
5468
August 29, 2005 08:47PM
5232
August 29, 2005 09:00PM
5558
August 30, 2005 10:05AM
5311
August 30, 2005 10:18AM
5802
August 30, 2005 10:20AM
6774
August 29, 2005 08:53PM
5693
August 29, 2005 09:50PM
5530
August 29, 2005 10:01PM
5967
August 30, 2005 08:53AM
5338
August 30, 2005 11:22AM
5879
August 30, 2005 11:33AM
5545
August 30, 2005 11:59AM
25090
August 31, 2005 02:32PM
7219
August 31, 2005 02:49PM
5925
August 31, 2005 02:56PM
5921
August 31, 2005 03:06PM
9040
December 07, 2006 10:30AM
5672
August 31, 2005 03:10PM
5711
August 31, 2005 03:32PM
18445
August 31, 2005 07:15PM
5805
September 01, 2005 03:05AM
8501
September 15, 2005 04:31PM
6385
September 01, 2005 04:39AM
5208
September 08, 2005 09:53AM
5572
September 08, 2005 11:25AM
5343
September 26, 2005 11:52AM
5196
September 26, 2005 12:13PM
5135
September 27, 2005 09:55AM
4944
September 27, 2005 10:18AM
4753
September 28, 2005 10:29AM
4939
September 28, 2005 10:34AM
5134
September 28, 2005 10:52AM
5529
September 28, 2005 10:58AM
10591
September 23, 2005 01:56AM
5629
September 23, 2005 07:11AM
5801
October 05, 2005 04:58AM
6957
October 05, 2005 04:52PM
7897
October 05, 2005 11:49PM
6101
October 06, 2005 01:34AM
7551
October 06, 2005 04:57PM
5352
December 13, 2005 10:28AM
5313
December 13, 2005 10:34AM
5201
November 17, 2005 09:39AM
5669
January 08, 2007 12:12PM
5451
December 12, 2005 02:13PM
5346
December 14, 2005 11:43PM
5022
December 15, 2005 08:37AM
5494
December 15, 2005 11:18AM
5017
December 15, 2005 11:27AM
6203
December 15, 2005 11:32AM
4739
December 15, 2005 11:43AM
4855
December 15, 2005 11:43AM
4900
December 15, 2005 11:48AM
4737
December 15, 2005 11:51AM
5270
December 15, 2005 02:14PM
5930
December 15, 2005 02:18PM
4717
December 15, 2005 02:27PM
5338
December 15, 2005 02:43PM
4712
December 15, 2005 08:46AM
5700
January 26, 2006 12:38PM
4861
January 26, 2006 01:48PM
5058
January 26, 2006 01:48PM
4683
January 26, 2006 01:52PM
4859
January 27, 2006 04:46PM
4935
January 29, 2006 11:21AM
5280
January 30, 2006 09:42AM
5164
February 27, 2006 02:17PM
4986
February 27, 2006 02:23PM
5000
March 05, 2006 04:56AM
5806
March 06, 2006 08:09AM
4810
April 05, 2006 01:03PM
5112
September 27, 2006 08:43AM
5063
November 19, 2006 04:42AM
5129
December 14, 2006 05:45PM
4874
February 01, 2007 04:40AM
5589
November 11, 2007 01:24PM
Re: Server just hanging (Copying to tmp table)
6944
December 20, 2007 10:40AM
7222
January 21, 2008 10:14AM
6590
January 21, 2008 10:53AM
6105
May 19, 2008 09:41AM
6357
February 05, 2008 10:27AM
6784
March 12, 2008 08:37AM
6084
May 19, 2008 03:02AM
6815
November 14, 2008 12:31AM
7849
March 06, 2009 03:36PM