Title: big table
Last modified: May 16, 2021

---

# big table

 *  Resolved [Sergio Alfaro](https://wordpress.org/support/users/rafasshop/)
 * (@rafasshop)
 * [5 years ago](https://wordpress.org/support/topic/big-table/)
 * Hello
 * I noticed that the wp_pantheon_sessions table have more than 9 million rows and
   is using near of 2.6Gb of data.
 * Is there any way to automatically delete old sessions to avoid bigger table?
 * Is save to trunk the table?
 * Thanks!

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [Daniel Bachhuber](https://wordpress.org/support/users/danielbachhuber/)
 * (@danielbachhuber)
 * [5 years ago](https://wordpress.org/support/topic/big-table/#post-14452275)
 * Hey [@rafasshop](https://wordpress.org/support/users/rafasshop/),
 * Old sessions should be automatically deleted by WP Native PHP Sessions. In your
   case, it sounds like they might not be. You can [check this thread](https://github.com/pantheon-systems/wp-native-php-sessions/issues/179)
   for a potential resolution to the problem.
 * If you’d like to manually delete the sessions, you can adapt the SQL query used
   in garbage collection: [https://github.com/pantheon-systems/wp-native-php-sessions/blob/0cdcfaff9bed6e143ae37c9b2a460faa1ddc6270/inc/class-session-handler.php#L108](https://github.com/pantheon-systems/wp-native-php-sessions/blob/0cdcfaff9bed6e143ae37c9b2a460faa1ddc6270/inc/class-session-handler.php#L108)
 * I don’t think I’d suggest truncating the entire table. It’s probably best to 
   only delete the older sessions.
 * Hope this helps!

Viewing 1 replies (of 1 total)

The topic ‘big table’ is closed to new replies.

 * ![](https://ps.w.org/wp-native-php-sessions/assets/icon-256x256.png?rev=3411177)
 * [Native PHP Sessions](https://wordpress.org/plugins/wp-native-php-sessions/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-native-php-sessions/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-native-php-sessions/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-native-php-sessions/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-native-php-sessions/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-native-php-sessions/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Daniel Bachhuber](https://wordpress.org/support/users/danielbachhuber/)
 * Last activity: [5 years ago](https://wordpress.org/support/topic/big-table/#post-14452275)
 * Status: resolved