Question on large SMF Tables - Which of these can be dropped?

[samurai-lupin]

Yesterday I did some checking on my database size and its tables and found some of them to have grown rather large (compared to the message table which I think is the most essential one). I now wonder if I can drop the content of some of those tables?

I assume that smf_log_boards, smf_log_mark_read and smf_log_topics can be cut by running the mark read for inactive users
script?

However what about these tables:

229M/var/lib/mysql/atanua_foren/smf_ob_googlebot_stats.ibd
45M/var/lib/mysql/atanua_boards/smf_downloaded_attachments.ibd
14M/var/lib/mysql/atanua_boards/smf_log_search_subjects.ibd
13M/var/lib/mysql/atanua_boards/smf_ip_lookup.ibd

I assume their content can also be reset or do they contain anything important?

Thanks for any thought and advice

[Aleksi "Lex" Kilpinen]

smf_ob_googlebot_stats is a mod added table, and holds the visiting times of Googlebot for each topic individually, if I remember correctly.
smf_downloaded_attachments also sounds like a mod table to me, as does smf_ip_lookup - No idea on what those are for.

smf_log_search_subjects is a part of your forum search, and I'd advice you not to touch that one.

[samurai-lupin]

Thank you very much. This has indeed helped me a lot!