Tables keep on crashing

[pietpetoors]

Is there a way I can turn off the function which shows how many people are online

On my shop the tables of the DB keeps on crashing and each time it is the who is online tables.

130807 14:51:17 [ERROR] /usr/libexec/mysqld: Table './pieter_direct/whos_online' is marked as crashed and should be repaired
130807 14:51:27 [ERROR] /usr/libexec/mysqld: Table './pieter_direct/whos_online' is marked as crashed and should be repaired
130807 14:51:30 [ERROR] /usr/libexec/mysqld: Table './pieter_direct/whos_online' is marked as crashed and should be repaired

[DrByte]

It's odd that it's crashing so frequently, and worth figuring out "why".

But if your intention is to just disable it, you can make the following change to one file:
/includes/init_includes/init_special_funcs.php
Lines 18-19 can be commented-out by simply adding // to the beginning as shown here:

/**
 * require the whos online functions and update
 */
//require(DIR_WS_FUNCTIONS . 'whos_online.php');
//zen_update_whos_online();

You should of course also turn off the whos-online sidebox via Admin->Tools->Layout Boxes Controller

Then repair the whos-online table again so that it's not in a bad state. Even truncating it would be wise too.

[pietpetoors]

Thanx.
If I do want to investigate why this happens, where do I start?
What are common causes I have to look for?

[DrByte]

Find out exactly what was happening when the table crashed.

ya, that's complicated.

[HeathenMagic]

Hello there,

Thanks for the fix. I just got this today, and I get it about once a year. Was on two separate hosts so far. But am glad I can turn it off in case it happens again