I have two blogs .. of many that I have created over time, but these are the first two back in May 2005 and shared the same same MySQL database. The MySQL database is well over 600MB in size and just the queries with these files are "driving up the server load and the CPU usage due to the number of records/tables it has to run through in the query. It has nothing to do with the amount of traffic your site receives, the server and the network can handle it. Its not a day to day issue, but an issue nonetheless." (their words)
The files in question are from the WP-ShortStat plugin .. the ??_ss_search and ??_ss_stats .. the ss_search files are about 1MB each in size, but the other ss_stats tables are the big ones.
hbsmc_ss_stats - 94.6MB - 434,076 records
wp_ss_stats - 207.9MB - 941,588 records
Can I just deactivate my Wp-SHORTSTAT plugin .. then go into myPHP and EMPTY these two tables, then reactivate the WP-Shortstat plugin and start over? Or will that cause damage? I'm even having problems backing up the mysql database.