Web Threads

Recently I needed to empty the Drupal sessions and cache tables which had grown to some million+ rows and were causing weekly database errors on a busy health community website. In PhpMyAdmin, permissions to empty tables weren’t available.

I searched for a quick way to easily clear the table and found that truncate does the job and the permissions to do this was there even though it was not listed in the options of phpmyadmin.

TRUNCATE TABLE `drupal_sessions`

I also added a Drupal plugin to do database maintenance weekly to prevent this happening again. Sure enough, the site has been behaving and performing much better since, knock on wood.

Like

Unlike

Written by Web Threads

Follow Web Threads on Twitter