XF 1.4 MYSQL xf_session issues

Getting a ton of these errors in mysql

[ERROR] /usr/libexec/msyqld Table ' ./dugout/xf_session' is marked as crashed and should be repaired

Ultimately mysql is stopping a couple times a day. But the site is working inbetween
 
MySQL doing unclean shutdowns will cause tables to crash. You can repair the table in phpMyAdmin or your DBA tool of choice.

If you want to prevent it from crashing in the future you should look into and correct whatever is causing MySQL to shutdown unexpectedly.
 
If you check your MySQL logs it should help to determine why it's terminating unexpectedly. It's more than likely a configuration issue (too much memory, etc).
 
MySQL configuration set to use "too much memory," not the system having too much memory. In my follow-up I did clarify MySQL was running out of memory.
 
So, while on this conversation, my MYSQL ver is 5.5.14

Should I upgrade it? I think latest out there is stabe is 5.6.24 maybe?

Also, my PHP version is 5.3.6

My xenforo ver is 1.4.6
 
If you don't have any scripts that are dependent on a lower level of PHP then I would suggest upgrading it at the least.
On mySQL, it's really up to you. I like (personally) to try to keep the latest stable release on my system.
 
Top Bottom