idx_sessions growing and growing

[Mickey]

Hello,

My website was out of order, and I found it was due to the table idx_sessions in the database.
This website is working well for years, and I have note seen such a bug on my other websites (using the same version of IndexU : 5.41).

I deleted and recreated the table idx_sessions. The web site worked again but I see that hundreds of new records are created very quickly in idx_sessions. So, I suppose it's the cause of the "crash" which happened today.

I do not give permission for creating administrators accounts. And I have not seen new accounts.

So, what could be the cause of teh growing number of records in the idx_sessions table ?
Is there somebody trying to hack my website ?
Is it due to a robot ?

The web site was out of order for many hours. And the table started growing immediately after it started again.

Thanks for your solutions...

[Bruceper]

creating administrators accounts?

idx_sessions are where the PHP sessions are stored. If you have lots then you have lots of visitors. Whether they're legitimate or not doesn't matter to PHP, it open a session for each user.

If you're really concerned write a small php script to flush idx_sessions and run it via cron every 4 hours.

[blacknight]

So is it safe to empty that table?

I've got about 75 megs in one install, which is more annoying than anything else

[Bruceper]

Yes, truncate it (flush it) and it'll be fine.

[blacknight]

Thanks
DB size is a LOT smaller