Author Topic: Runaway Civi entries in the Drupal sessions table, why? (Read 913 times)

mdlueck · February 18, 2011, 08:12:23 am

I noticed that there are many MANY CiviCRM records in our Drupal sessions table. That table grows in size about 1MB to 2MB per day, and never drops.

I am poised to enact a weekly TRUNCATE TABLE of that table! Any wiser suggestions?

Perhaps is there a way to selectively delete "older" records and leave "current" ones?

It only appears to be an issue on our one Drupal instance that has CiviCRM installed. No other sites have "runaway sessions table" troubles.

ken · February 18, 2011, 03:49:24 pm

I just did an analysis of our session table.

There are 2376 rows in the table. Based on the contents of the "session" column, 2257 are related to CiviCRM, 5 to other modules, and 114 are blank. When I export it to CSV the resulting file is 689Kb.

The oldest row is two days old, so there doesn't appear to be a problem with sessions accumulating. While I don't have @mdlueck's problem it does seem a large number of session records.

Ken

xavier · February 19, 2011, 04:12:30 am

Hi,

Don't know if it is related but on a dev site where I am the only connected, still get loads of anonymous users beside the admin one I'm logged with.

X+

mdlueck · February 28, 2011, 11:32:08 am

Since no "better" suggestions were shared, I instituted a weekly "TRUNCATE TABLE `sessions`;" as a band-aid to mask this problem.

CiviCRM Community Forums (archive)

News:

Author Topic: Runaway Civi entries in the Drupal sessions table, why? (Read 913 times)

mdlueck

Runaway Civi entries in the Drupal sessions table, why?

ken

Re: Runaway Civi entries in the Drupal sessions table, why?

xavier

Re: Runaway Civi entries in the Drupal sessions table, why?

mdlueck

Re: Runaway Civi entries in the Drupal sessions table, why?