CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Runaway Civi entries in the Drupal sessions table, why?
Pages: [1]

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

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Runaway Civi entries in the Drupal sessions table, why?
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.
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: Runaway Civi entries in the Drupal sessions table, why?
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

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Runaway Civi entries in the Drupal sessions table, why?
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+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Runaway Civi entries in the Drupal sessions table, why?
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.
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Runaway Civi entries in the Drupal sessions table, why?

This forum was archived on 2017-11-26.