'sys_sessions' table is pain in the ass

Hi,

I found out that the table "sys_sessions" is 

over-floated with data and its crash my website and stack mySQL .

I am actually going to re-install dolphin because of this problem.

Why is this table exists and why

it has so much data?

What did go wrong? (i did not touched nothing)

sys_sessions table is pruned upon cron run, if it's over-floated then crontab isn't setup or isn't functioning properly.

can i delete the table content manually? 

i see error  "#144 - Table './a3/sys_sessions' is marked as crashed and last (automatic?)" repair failed and cant do anything about it

boonex pls see this as a system bug and fix it

Yes, you can delete this table and create again, or just truncate it. 

 How can i check this actually working?

  Ok, thanks.

 i need to know if cron is working properly. how can i see it?

It could be that the cron job is not properly set up.  Most control panel have it so that you can get an email when the cron job runs.  Are you seeing any error emails or such.  If you are not getting any notices from the control panel and you think the cron job is correct, you could edit the cron.php file to send you an email or to write to a file.

thanks gg i crontab it and it's fine

If you are unsure if the cron.php is actually being executed, then you can have it send you an email. If you have your cron job set to run every minute, you will get one of these emails each minute until you edit the cron.php file and remove the code.

 $to = "recipient@example.com"; $subject = "Cron Job"; $body = "cron.php was executed"; mail($to, $subject, $body);