Für die MySql Shell:

/* sys_log aufraeumen ... */
DELETE FROM sys_log WHERE sys_log.tstamp < UNIX_TIMESTAMP(ADDDATE(NOW(), INTERVAL -1 MONTH)) ORDER BY sys_log.tstamp ASC;
OPTIMIZE TABLE sys_log;

/* cache* cleanup */

TRUNCATE cache_extensions;
TRUNCATE cache_hash;
TRUNCATE cache_imagesizes;
TRUNCATE cache_md5params;
TRUNCATE cache_pages;
TRUNCATE cache_pagesection;
TRUNCATE cache_typo3temp_log;
TRUNCATE index_fulltext;
TRUNCATE index_grlist;
TRUNCATE index_phash;
TRUNCATE index_rel;
TRUNCATE index_section;
TRUNCATE index_words;
TRUNCATE tx_crawler_queue;