Re: Server just hanging (Copying to tmp table)
I got mysqlreport installed, that's a nice little script. I'm not currently having a problem but...
You asked me about tables. When I first ran it it said this:
__ Tables ______________________________________________________________
Open 1.00k of 1000 %Cache: 100.00
Opened 2.71k 0.02/s
Then I ran "FLUSH TABLES". And it went down to zero. After about 15 minutes it says this:
__ Tables ______________________________________________________________
Open 263 of 1000 %Cache: 26.30
Opened 2.97k 0.03/s
Ah, is there a problem with my system not closing tables properly or something? Or should it always open up all of them and keep them open?
I know enough to be dangerous. Thanks for being patient!
Subject
Views
Written By
Posted
27748
August 11, 2005 11:25AM
23670
August 12, 2005 09:07AM
18966
August 12, 2005 01:06PM
18441
August 22, 2005 09:46AM
16545
August 24, 2005 03:27PM
12996
August 24, 2005 04:05PM
13688
August 26, 2005 11:02AM
7465
August 26, 2005 11:05AM
6850
August 26, 2005 11:45AM
6630
August 26, 2005 05:46PM
6894
August 26, 2005 10:34PM
6503
August 25, 2005 01:08PM
5897
August 26, 2005 11:07AM
5703
August 27, 2005 09:09AM
6028
August 29, 2005 11:50AM
5949
August 29, 2005 12:04PM
5305
August 29, 2005 12:55PM
5188
August 29, 2005 05:26PM
5159
August 29, 2005 06:34PM
4799
August 29, 2005 08:40PM
4674
August 29, 2005 08:47PM
4549
August 29, 2005 09:00PM
4735
August 30, 2005 10:05AM
4617
August 30, 2005 10:18AM
5135
August 30, 2005 10:20AM
6138
August 29, 2005 08:53PM
Re: Server just hanging (Copying to tmp table)
5010
August 29, 2005 09:50PM
4842
August 29, 2005 10:01PM
5289
August 30, 2005 08:53AM
4700
August 30, 2005 11:22AM
5241
August 30, 2005 11:33AM
4907
August 30, 2005 11:59AM
24375
August 31, 2005 02:32PM
6543
August 31, 2005 02:49PM
5223
August 31, 2005 02:56PM
5076
August 31, 2005 03:06PM
8320
December 07, 2006 10:30AM
5013
August 31, 2005 03:10PM
4888
August 31, 2005 03:32PM
17731
August 31, 2005 07:15PM
5135
September 01, 2005 03:05AM
7854
September 15, 2005 04:31PM
5578
September 01, 2005 04:39AM
4473
September 08, 2005 09:53AM
4837
September 08, 2005 11:25AM
4616
September 26, 2005 11:52AM
4526
September 26, 2005 12:13PM
4454
September 27, 2005 09:55AM
4238
September 27, 2005 10:18AM
4138
September 28, 2005 10:29AM
4279
September 28, 2005 10:34AM
4452
September 28, 2005 10:52AM
4913
September 28, 2005 10:58AM
9700
September 23, 2005 01:56AM
4977
September 23, 2005 07:11AM
4956
October 05, 2005 04:58AM
5252
October 05, 2005 04:52PM
6171
October 05, 2005 11:49PM
5416
October 06, 2005 01:34AM
6738
October 06, 2005 04:57PM
4667
December 13, 2005 10:28AM
4658
December 13, 2005 10:34AM
4571
November 17, 2005 09:39AM
4925
January 08, 2007 12:12PM
4795
December 12, 2005 02:13PM
4639
December 14, 2005 11:43PM
4225
December 15, 2005 08:37AM
4304
December 15, 2005 11:18AM
4221
December 15, 2005 11:27AM
4340
December 15, 2005 11:32AM
4090
December 15, 2005 11:43AM
4052
December 15, 2005 11:43AM
4222
December 15, 2005 11:48AM
4107
December 15, 2005 11:51AM
4498
December 15, 2005 02:14PM
4155
December 15, 2005 02:18PM
4030
December 15, 2005 02:27PM
4525
December 15, 2005 02:43PM
4062
December 15, 2005 08:46AM
5062
January 26, 2006 12:38PM
4186
January 26, 2006 01:48PM
4258
January 26, 2006 01:48PM
4048
January 26, 2006 01:52PM
4186
January 27, 2006 04:46PM
4070
January 29, 2006 11:21AM
4404
January 30, 2006 09:42AM
4439
February 27, 2006 02:17PM
4121
February 27, 2006 02:23PM
4351
March 05, 2006 04:56AM
4173
March 06, 2006 08:09AM
4143
April 05, 2006 01:03PM
4317
September 27, 2006 08:43AM
4274
November 19, 2006 04:42AM
4423
December 14, 2006 05:45PM
4244
February 01, 2007 04:40AM
4919
November 11, 2007 01:24PM
5124
December 20, 2007 10:40AM
6566
January 21, 2008 10:14AM
5897
January 21, 2008 10:53AM
5373
May 19, 2008 09:41AM
5574
February 05, 2008 10:27AM
6121
March 12, 2008 08:37AM
5434
May 19, 2008 03:02AM
6169
November 14, 2008 12:31AM
7182
March 06, 2009 03:36PM