XF 1.4 MYSQL xf_session issues

[Andy Larkins]

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]

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.

 

[Andy Larkins]

it was suggested that we had to run mysql_update. Did that...we shall see

 

[Jeremy P]

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).

 

[Andy Larkins]

Too much memory?

 

[Jeremy P]

If MySQL runs out of memory to allocate it will shutdown uncleanly. This would be indicated by an OOM error in the logs.

 

[TPerry]

That would me not enough memory... OOM (Out Of Memory)....

 

[Jeremy P]

That's what I said?

 

[TPerry]

That's what I said?

Nope.. you said too much memory, not not enough.
Last time I checked, mySQL liked lots of memory if you would throw it at it and only complained when you were stingy with memory (placing memory constraints on it).

It's more than likely a configuration issue (too much memory, etc)

 

[Jeremy P]

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.

 

[Andy Larkins]

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

 

[TPerry]

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.