May 12, 2008, 11:45:54 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Please support SEO4smf further development donating here or use paypal button from left menu.
 
  Home   Forum   Help Search Directory Calendar Login Register    RSS 2.0 feedAtom feed


News
Please support SEO4smf further development donating here or use paypal button from left menu.
Pages: [1]
  Print  
Author Topic:

High Value of Opened vs Open Tables

 (Read 1402 times)
0 Members and 1 Guest are viewing this topic.
MYBESTHOMESnet
Newbie
*

Points: 0
Offline Offline

Posts: 3


« on: August 08, 2007, 10:28:25 »

How to solve the problem in very high value of Opened vs Open Tables?

Basic Information
August 08, 2007, 02:46:34 AM
Operating System:    Microsoft Windows XP [Version 5.1.2600]
Processor:    x86 Family 15 Model 4 Stepping 1 GenuineIntel ~3000 Mhz,[02]: x86 Family 15 Model 4 Stepping 1 GenuineIntel (~3000MHz)
Current processes:    52 (52 running, 0 zombie)
Processes by CPU:    System Idle Process (1) 97.5%, WINWORD.EXE (1) 1.8%, (other) (42) 0.7%
Memory usage:    69.781% (359424k / 515072k)
Swap: 179.968% (1140736k / 633856k)

MySQL Statistics
MySQL 5.0.x
Connections per second:    0.0195
Kilobytes received per second:    0.1366
Kilobytes sent per second:    1.3672
Queries per second:    0.6026
Percentage of slow queries:    0
Opened vs. Open tables:
(table_cache)    1361.4848 (should be <= 80)
Table cache usage:
(table_cache)    0.043 (should be >= 0.5 and <= 0.9)
Key buffer read hit rate:
(key_buffer_size)    0.0128 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size)    0.1226 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size)    9807.8333 (should be >= 30 )
Thread cache usage:
(thread_cache_size)    0.2 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size)    0.7783 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer)    0 (should be <= 0.001)
Query cache enabled:
(query_cache_type)    1 (should be >= 1 and <= 1)
Query cache miss rate:
(query_cache_limit)    0.4307 (should be <= 0.5)
Query cache prune rate:
(query_cache_size)    0 (should be <= 0.05)

STATUS

PHPINFO

Dedicated Host Server.

thanks
Logged


Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.4 | SMF © 2006, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks

TinyPortal v0.9.7 © Bloc
Valid XHTML 1.0! Valid CSS!