SMF Support > SMF 2.0.x Support

caching.

(1/4) > >>

XLimo_Gal:
ok im totally lost here. I am having an issue with being timesd out tryin to get around my forum I went to my hosting with the error cod im getting which is..
Database Error: MySQL server has gone away
File: /home/ddube/public_html/Poker1/Sources/MessageIndex.php
Line: 610
and they came back with..
Unfortunately it would appear that your mysql queries are taking too long to complete, causing the server to kill them off, as mentioned below:
You may want to look into the caching mechanism at http://www.simplemachines.org/community/index.php?topic&0562.0
Let us know if you need anything after installing the caching function
Now I am searching for this cache system they are talkin about but cant seem to find it. I went and looked in the server settings under cahce and this is what it says
I just looked in the admin area server settings for the cache and it says this..

SMF supports caching through the use of accelerators. The currently supported accelerators include:



* APC

* eAccelerator

* Turck MMCache

* Memcached

* Zend Platform/Performance Suite (Not Zend Optimizer)



Caching will only work on your server if you have PHP compiled with one of the above optimizers, or have memcache available.



SMF performs caching at a variety of levels. The higher the level of caching enabled the more CPU time will be spent retrieving cached information. If caching is available on your machine it is recommended that you try caching at level 1 first.



Note that if you use memcached you need to provide the server details in the setting below. This should be entered as a comma separated list as shown in the example below:

"server1,server2,server3:port,server4"



Note that if no port is specified SMF will use port 11211. SMF will attempt to perform rough/random load balancing across the servers.



SMF has not been able to detect a compatible accelerator on your server.

and the cache level says no cacheing in it. Should I set this to level 1 or do I need a smf caching function mod?

They also asked me if I have persistent MySQL connections enabled in SMF and have no idea where to even find that. I am a newbie at this and just getting totally lost here.

Deprecated:
Caching and SQL timeouts are not the same thing as far as my understanding.

You don't want to use persistent SQL in a shared hosting environment, again as far as my understanding.

Please post a phpinfo link. What is a phpinfo() file?

Also, although I haven't used it, it looks like you should download and execute the SQL Status tool and tell us your findings.

It is quite possible that your hosting service is overselling and has overloaded their database servers. Who are you with?

It might be helpful if you post a link to your forum. (Not sure, can't hurt.)

XLimo_Gal:
I am using hostgator and I have tried to get help from them but they say ..

Do you have persistent MySQL connections enabled in SMF? The problem is not that your queries are getting killed but that the MySQL connections are being left open after queries complete.

I checked it and it is diasabled. This started a couple days ago and I have downsized the forum and never had this issue before.and I have one board that i cant get into at all and when i do i get that error and if i delete the board it can fly around the forum. And I have had that board up since day 1 of my forum.

My forums link is  http://freedom2poker.net [nofollow]

Deprecated:
Well first of all, looking at Hostgator's prices and storage/transfer, they are certainly in the right ballpark for being oversellers. Your problem might be caused by their overloading their servers. (That's why I asked who your host was.)

I think you found it, your persistent check box is at Admin -> Configuration -> Server Settings -> Core Configuration. In most cases the box should NOT be checked, unless there is a problem and that fixes it.

If you have SQL problems they could cause almost any weird effect. For example if you are moving or deleting a board and the SQL fails in the middle of a series of queries it could leave that board in limbo, partially moved. I highly recommend you do not make any configuration changes like moving boards until your connection problem is fixed.

phpinfo?

status tool?

XLimo_Gal:
I did the php info like you said to do and it was empty when i looked at it now I dont know if I did it right or not you just make a file on a note pad with this on it correct..<?php phpinfo(); ?> and name it phpinfo.php, Thats what I did. Now I am also having issue with updating the forum to could that have something to do with it? Im gettin 2 test failed errors.

Execute Modification     ./Sources/Subs-Post.php     Test failed
Execute Modification     ./SSI.php     Test failed

Navigation

[0] Message Index

[#] Next page