Hi, ... I am confronting a problem on my hosting server.
All my websites on this server are going down and coming back, and going down and coming back.
This has been going on since last wednesday.
It seems that the httpd service is stopping.
Also it seems that the problem is related to a so called TABLE CACHE. and that my mysql configuration file is much smaller than it should be.
This all seems to be caused by one of my websites on this server which is running joomla.
Check this error message out:
TABLE CACHE
Current table_cache value = 64 tables
You have a total of 3463 tables
You have 64 open tables.
Current table_cache hit rate is 1%
, while 100% of your table cache is in use
You should probably increase your table_cache
This also seems to explain why "tmp table" is showing up so frequently with the user webcur_lps.
I need someone with experience to solve this problem for me ASAP.