Re: Server just hanging (Copying to tmp table)
I had the server slow down today when my boss noticed a site was dying. The query above that I posted was taking 15.75 seconds to execute. I checked the QCache and other things including ram and CPU and everything was normal. But the queries on that table were so slow! Other databases were running fine.
I restarted the server and the same query is now executing at 0.39 and faster.
I know enough to be dangerous. Thanks for being patient!
Subject
Views
Written By
Posted
29029
August 11, 2005 11:25AM
24172
August 12, 2005 09:07AM
Re: Server just hanging (Copying to tmp table)
19411
August 12, 2005 01:06PM
18929
August 22, 2005 09:46AM
16997
August 24, 2005 03:27PM
13463
August 24, 2005 04:05PM
14168
August 26, 2005 11:02AM
7906
August 26, 2005 11:05AM
7327
August 26, 2005 11:45AM
7064
August 26, 2005 05:46PM
7357
August 26, 2005 10:34PM
6978
August 25, 2005 01:08PM
6352
August 26, 2005 11:07AM
6164
August 27, 2005 09:09AM
6491
August 29, 2005 11:50AM
6396
August 29, 2005 12:04PM
5787
August 29, 2005 12:55PM
5668
August 29, 2005 05:26PM
5606
August 29, 2005 06:34PM
5246
August 29, 2005 08:40PM
5133
August 29, 2005 08:47PM
5007
August 29, 2005 09:00PM
5219
August 30, 2005 10:05AM
5128
August 30, 2005 10:18AM
5601
August 30, 2005 10:20AM
6597
August 29, 2005 08:53PM
5488
August 29, 2005 09:50PM
5342
August 29, 2005 10:01PM
5760
August 30, 2005 08:53AM
5146
August 30, 2005 11:22AM
5708
August 30, 2005 11:33AM
5368
August 30, 2005 11:59AM
24874
August 31, 2005 02:32PM
7029
August 31, 2005 02:49PM
5687
August 31, 2005 02:56PM
5557
August 31, 2005 03:06PM
8816
December 07, 2006 10:30AM
5481
August 31, 2005 03:10PM
5336
August 31, 2005 03:32PM
18241
August 31, 2005 07:15PM
5593
September 01, 2005 03:05AM
8311
September 15, 2005 04:31PM
6043
September 01, 2005 04:39AM
4950
September 08, 2005 09:53AM
5352
September 08, 2005 11:25AM
5055
September 26, 2005 11:52AM
4993
September 26, 2005 12:13PM
4917
September 27, 2005 09:55AM
4689
September 27, 2005 10:18AM
4556
September 28, 2005 10:29AM
4744
September 28, 2005 10:34AM
4917
September 28, 2005 10:52AM
5353
September 28, 2005 10:58AM
10199
September 23, 2005 01:56AM
5430
September 23, 2005 07:11AM
5414
October 05, 2005 04:58AM
6012
October 05, 2005 04:52PM
6632
October 05, 2005 11:49PM
5860
October 06, 2005 01:34AM
7221
October 06, 2005 04:57PM
5135
December 13, 2005 10:28AM
5119
December 13, 2005 10:34AM
5009
November 17, 2005 09:39AM
5374
January 08, 2007 12:12PM
5264
December 12, 2005 02:13PM
5091
December 14, 2005 11:43PM
4656
December 15, 2005 08:37AM
4731
December 15, 2005 11:18AM
4656
December 15, 2005 11:27AM
4793
December 15, 2005 11:32AM
4555
December 15, 2005 11:43AM
4458
December 15, 2005 11:43AM
4682
December 15, 2005 11:48AM
4545
December 15, 2005 11:51AM
4975
December 15, 2005 02:14PM
4630
December 15, 2005 02:18PM
4513
December 15, 2005 02:27PM
4981
December 15, 2005 02:43PM
4542
December 15, 2005 08:46AM
5523
January 26, 2006 12:38PM
4671
January 26, 2006 01:48PM
4719
January 26, 2006 01:48PM
4495
January 26, 2006 01:52PM
4676
January 27, 2006 04:46PM
4572
January 29, 2006 11:21AM
4897
January 30, 2006 09:42AM
4934
February 27, 2006 02:17PM
4597
February 27, 2006 02:23PM
4812
March 05, 2006 04:56AM
4703
March 06, 2006 08:09AM
4622
April 05, 2006 01:03PM
4809
September 27, 2006 08:43AM
4746
November 19, 2006 04:42AM
4900
December 14, 2006 05:45PM
4710
February 01, 2007 04:40AM
5383
November 11, 2007 01:24PM
5586
December 20, 2007 10:40AM
7032
January 21, 2008 10:14AM
6394
January 21, 2008 10:53AM
5855
May 19, 2008 09:41AM
6047
February 05, 2008 10:27AM
6588
March 12, 2008 08:37AM
5904
May 19, 2008 03:02AM
6642
November 14, 2008 12:31AM
7663
March 06, 2009 03:36PM