October 3 2014

Huge WordPress wp_wps_logs database table

Recently while cleaning up my WordPress database, I noticed that the wp_wps_logs table was over 470MB in size. After a bit of research, I realised this was due to an old plugin that I once used – iThemes Security (formerly Better WP Security). I no longer used this so I needed to get the database size down.

Through cPanel, I opened myPhPAdmin.  On the left I navigated to the wp_wps_logs table then clicked on the Operations tab in the top right. Scrolling down to the bottom of the page, there is the option to Empty the table (TRUNCATE). Once I truncated the table, my database size was down to about 20MB!


I use a maximum of one Google Ad per post to help offset some of my blog hosting costs.


Tags: , , , ,

Posted October 3, 2014 by danovich in category "Geek

Leave a Reply