• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 MYSQL xf_session issues

#1
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
 

Jeremy P

Well-known member
#2
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.
 

Jeremy P

Well-known member
#4
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).
 

Jeremy P

Well-known member
#10
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.
 
#11
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
 

Tracy Perry

Well-known member
#12
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.