PDA

View Full Version : mysql error: session table full // fixed nevermind


Reeve of shinra
08-28-2004, 06:38 PM
EDIT:

I was getting the following mysql error but it corrected itself when I restarted mysql and apache.

"The table 'session' is full"

Remulon
09-02-2009, 02:25 AM
I am experiencing the same issue as Reeve.

Of course I can empty the table and it will be solved, but that will only fix the issue temporarily.

I notice that I have: 35502 Currently Active Users (10 members and 35492 guests) which seems like a massive (and inhuman) amount of guests.

We have been breaking our "most ever users online" record on a weekly basis for the last few months.

So based on these figures, we assume that there is a large amount of bots/spiders/crawlers etc. included in this guests total.

Has anyone else experienced this type of activity?

Furthermore, does anyone have any suggestions?

R.

Dismounted
09-02-2009, 09:18 AM
Go into "online.php" and search some of the IPs.

Marco van Herwaarden
09-02-2009, 10:43 AM
Make sure that your scheduled tasks are running, 1 of them cleans up the session table.

PS This can also be resoved by restarting MySQL.