July 04, 2008, 23:40:34 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Revenue sharing launched. This is offered as a "thank you" for being a member of webmasterstalks.com community! If you have an Adsense/Yahoo publisher account then you can start right away !
 
  Home   Forum   Help Search Directory Calendar Login Register    RSS 2.0 feedAtom feed


News
Revenue sharing launched. This is offered as a "thank you" for being a member of webmasterstalks.com community! If you have an Adsense/Yahoo publisher account then you can start right away !
Pages: [1]
  Print  
Author Topic:

High Value of Opened vs Open Tables

 (Read 1607 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!