News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Open tables problem with 1.1 RC2

Started by minstrel, August 06, 2006, 01:17:12 PM

Previous topic - Next topic

minstrel

SMF Version: SMF 1.1 RC2
http://forum.psychlinks.ca/status.php returns this:

Load averages: 2.00, 2.73, 3.55
Current processes: 175 (96 sleeping, 37 running, 42 zombie)
Processes by CPU: author.exe (12) 117.0%, shtml.exe (4) 23.0%, httpd (37) 11.4%, mysqld (12) 1.2%, perl5.8.3 (3) 0.9% 
Memory usage: 87.278% (1827544k / 2093932k)
Swap: 0.007% (300k / 4194176k) 

Connections per second:  1.2509 
Kilobytes received per second:  6.9904 
Kilobytes sent per second:  6.2673 
Queries per second:  38.053 
Percentage of slow queries:  0 
Opened vs. Open tables: (table_cache)  1755.0977 (should be <= 80)  
Table cache usage: (table_cache)  1 (should be >= 0.5 and <= 0.9) 
Key buffer read hit rate: (key_buffer_size)  0.0203 (should be <= 0.01) 
Key buffer write hit rate: (key_buffer_size)  0.0211 (should be <= 0.5) 
Thread cache hit rate: (thread_cache_size)  158.4335 (should be >= 30 ) 
Thread cache usage: (thread_cache_size)  0.75 (should be >= 0.7 and <= 0.9) 
Temporary table disk usage: (tmp_table_size)  0.2846 (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.2207 (should be <= 0.5)

When I check for forum errors in the ACP, I periodically get a LONG list of messages tagged as "not in the cache".

What is causing this and how do I fix it? I've read the thread on converting to InnoDB from MyISAM -- assuming my host supports this (waiting for an answer), will this help or will it make anything worse? or is this a different issue altogether?

Ben_S

Open tables can be solved by increasing the table_cache, although I wouldn't worry about it too much.

Subjects not in the cache is an RC2 bug that isn't critical and will be fixed with RC3.
Liverpool FC Forum with 14 million+ posts.

minstrel

Quote from: Ben_S on August 07, 2006, 07:30:58 AMOpen tables can be solved by increasing the table_cache, although I wouldn't worry about it too much.

How do I do that?

QuoteSubjects not in the cache is an RC2 bug that isn't critical and will be fixed with RC3.

How soon can we expect RC3?

Ben_S

1> Only your host can, it's a MySQL setting.

2> When it's as bug free as possible, probably within the month.
Liverpool FC Forum with 14 million+ posts.


Amacythe

Quote from: Ben_S on August 07, 2006, 10:31:40 AM
2> When it's as bug free as possible, probably hopefully within the month.

Advertisement: