Re: Server just hanging (Copying to tmp table)
100% open table cache is okay. Some would say that if you're at 100% with this, than to increase your table_cache even more, but I don't think that will have any affect on this problem. I'd really like to see a way to reproduce the problem, but I understand that's difficult on a production server (not many people intentionally try to break their production server).
Subject
Views
Written By
Posted
28513
August 11, 2005 11:25AM
23756
August 12, 2005 09:07AM
19018
August 12, 2005 01:06PM
18507
August 22, 2005 09:46AM
16603
August 24, 2005 03:27PM
13056
August 24, 2005 04:05PM
13762
August 26, 2005 11:02AM
7518
August 26, 2005 11:05AM
6919
August 26, 2005 11:45AM
6680
August 26, 2005 05:46PM
6944
August 26, 2005 10:34PM
6566
August 25, 2005 01:08PM
5952
August 26, 2005 11:07AM
5769
August 27, 2005 09:09AM
6091
August 29, 2005 11:50AM
6004
August 29, 2005 12:04PM
5376
August 29, 2005 12:55PM
5245
August 29, 2005 05:26PM
5220
August 29, 2005 06:34PM
4863
August 29, 2005 08:40PM
4747
August 29, 2005 08:47PM
4612
August 29, 2005 09:00PM
4800
August 30, 2005 10:05AM
4671
August 30, 2005 10:18AM
5196
August 30, 2005 10:20AM
6198
August 29, 2005 08:53PM
5068
August 29, 2005 09:50PM
Re: Server just hanging (Copying to tmp table)
4916
August 29, 2005 10:01PM
5348
August 30, 2005 08:53AM
4762
August 30, 2005 11:22AM
5295
August 30, 2005 11:33AM
4973
August 30, 2005 11:59AM
24437
August 31, 2005 02:32PM
6616
August 31, 2005 02:49PM
5284
August 31, 2005 02:56PM
5134
August 31, 2005 03:06PM
8404
December 07, 2006 10:30AM
5074
August 31, 2005 03:10PM
4953
August 31, 2005 03:32PM
17794
August 31, 2005 07:15PM
5196
September 01, 2005 03:05AM
7927
September 15, 2005 04:31PM
5629
September 01, 2005 04:39AM
4533
September 08, 2005 09:53AM
4920
September 08, 2005 11:25AM
4664
September 26, 2005 11:52AM
4587
September 26, 2005 12:13PM
4515
September 27, 2005 09:55AM
4298
September 27, 2005 10:18AM
4188
September 28, 2005 10:29AM
4346
September 28, 2005 10:34AM
4519
September 28, 2005 10:52AM
4965
September 28, 2005 10:58AM
9769
September 23, 2005 01:56AM
5037
September 23, 2005 07:11AM
5016
October 05, 2005 04:58AM
5464
October 05, 2005 04:52PM
6244
October 05, 2005 11:49PM
5465
October 06, 2005 01:34AM
6813
October 06, 2005 04:57PM
4735
December 13, 2005 10:28AM
4723
December 13, 2005 10:34AM
4625
November 17, 2005 09:39AM
4987
January 08, 2007 12:12PM
4853
December 12, 2005 02:13PM
4686
December 14, 2005 11:43PM
4274
December 15, 2005 08:37AM
4353
December 15, 2005 11:18AM
4269
December 15, 2005 11:27AM
4397
December 15, 2005 11:32AM
4152
December 15, 2005 11:43AM
4106
December 15, 2005 11:43AM
4298
December 15, 2005 11:48AM
4161
December 15, 2005 11:51AM
4558
December 15, 2005 02:14PM
4224
December 15, 2005 02:18PM
4125
December 15, 2005 02:27PM
4579
December 15, 2005 02:43PM
4123
December 15, 2005 08:46AM
5125
January 26, 2006 12:38PM
4249
January 26, 2006 01:48PM
4312
January 26, 2006 01:48PM
4112
January 26, 2006 01:52PM
4252
January 27, 2006 04:46PM
4128
January 29, 2006 11:21AM
4472
January 30, 2006 09:42AM
4502
February 27, 2006 02:17PM
4186
February 27, 2006 02:23PM
4407
March 05, 2006 04:56AM
4237
March 06, 2006 08:09AM
4214
April 05, 2006 01:03PM
4368
September 27, 2006 08:43AM
4334
November 19, 2006 04:42AM
4480
December 14, 2006 05:45PM
4303
February 01, 2007 04:40AM
4986
November 11, 2007 01:24PM
5190
December 20, 2007 10:40AM
6628
January 21, 2008 10:14AM
5962
January 21, 2008 10:53AM
5435
May 19, 2008 09:41AM
5627
February 05, 2008 10:27AM
6209
March 12, 2008 08:37AM
5507
May 19, 2008 03:02AM
6241
November 14, 2008 12:31AM
7271
March 06, 2009 03:36PM