<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:12pt"><div><span>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.</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: arial,helvetica,sans-serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: arial,helvetica,sans-serif; background-color: transparent; font-style: normal;"><span>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.<br></span></div><div> </div><div><font color="#ff007f" size="4" face="bookman old style, new york, times, serif"><i><b>Nancy</b></i></font><br></div><br><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div class="y_msg_container"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Paola Di Maio</font><br>
<div id="yiv2123189438"><div><br>I have cleared the cache ad watchdog tables, approx 6 gb but<div>the db size has not gone down one bit</div><div>any ideas why?</div><br>can someone advise if I can empty the following tables</div><div class="yiv2123189438gmail_extra"><div class="yiv2123189438gmail_quote"><blockquote class="yiv2123189438gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><br><div dir="ltr"><div>without killing the site?</div><div><br></div><div><div>access log</div><div>search index</div><div>cache filter</div><div>node revisions</div>
</div><span class="yiv2123189438HOEnZb"></span></div>
</blockquote></div></div></div></div> </div> </div> </blockquote></div> </div></body></html>