slow response and server time outs

[TLS Sparky]

Im very often getting slow response and server timeouts/rest.

i installed the status php and this is what it reads.

Operating System:     Red Hat Enterprise Linux ES release 3 (Taroon Update 9)
Processor:    Intel® Xeon® CPU 5130 @ 2.00GHz (1995.054MHz)
Load averages:    3.07, 4.30, 3.57
Memory usage:    92.492% (1900840k / 2055144k)
Swap: 31.243% (326220k / 1044144k)
MySQL Statistics
MySQL 5.0.x
Connections per second:    1.0917
Kilobytes received per second:    1.6491
Kilobytes sent per second:    2.2781
Queries per second:    21.7473
Percentage of slow queries:    0.0001
Opened vs. Open tables:
(table_cache)    29048.4375 (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.0157 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size)    0.4756 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size)    1 (should be >= 30 )
Thread cache usage:
(thread_cache_size)    0 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size)    0.1683 (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.4755 (should be <= 0.5)
Query cache prune rate:
(query_cache_size)    0.0778 (should be <= 0.05)


Not sure what im looking for,  so if someone could help.

Thanks

[Christian A. Herrnboeck]

Hi,


What kind of hosting is this? What kind of usage (members online) does your site experience?


Regards,
Christian

[TLS Sparky]

Its hosted by fasthosts and the forum is new so not many members yet, average is only about 6 online at any one time, we have 33 members at present but this is rising by the day.
I spoke to them and they said that everything was set up right.

im no expert but why are there so many queries being requested and memory usage so high?

any help would be grand 

[Christian A. Herrnboeck]

Hi,


I'd suggest that you go into the Admin panel -> Look and Layout -> Disable Hostname Lookups (check it).


Other than that, it's most likely your hosting provider. If the server is overloaded, then it will cause that.

Remember that the stats you see are for the entire server - not just your site.


Regards,
Christian

[Sarge]

Hello TLS Sparky, are you still experiencing performance issues?

Have you tried Christian's suggestion?

[TLS Sparky]

Hi yeah sorry forgot to report back, well i got totally fed up with fasthosts slow servers and there even slower technical support so i dumped them, moved to Charlottezweb Hosting and i must say its spot on, nice and fast even though all our members are in the uk.

Thanks for the help guys