[consulting] quick advice on db flush

[Nancy Wichmann]

You can clear the cache tables without problem, but they will fill back up quickly. The access log may be cleared, but may affect activity reports about your site. Do NOT clear the search index unless you want site search to break. Node revisions rows may be selectively deleted, but you need to know what you are doing.

If you are running Drupal 7, you should be using INNODB, which shouldn't fragment as badly as MYISAM, which is used in Drupal 6. The latter's tables can be deflated by using the OPTIMIZE command.

 
Nancy





>________________________________
> From: Paola Di Maio
>
>
>I have cleared the cache ad watchdog tables, approx 6 gb but
>the db size has not gone down one bit
>any ideas why?
>can someone advise if I can empty the following tables
>
>>
>>without killing the site?
>>
>>
>>access log
>>search index
>>cache  filter
>>node revisions
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/consulting/attachments/20131010/25c50042/attachment.html