vanke垃圾日志删除

删除垃圾库：

sys_Interface_Log_209885	DROP TABLE	`	;		DROP TABLE `sys_Interface_Log_209885`;
sys_Interface_Log_209895	DROP TABLE	`	;		DROP TABLE `sys_Interface_Log_209895`;
sys_Interface_Log_209905	DROP TABLE	`	;		DROP TABLE `sys_Interface_Log_209905`;
sys_Interface_Log_209915	DROP TABLE	`	;		DROP TABLE `sys_Interface_Log_209915`;
sys_Interface_Log_209925	DROP TABLE	`	;		DROP TABLE `sys_Interface_Log_209925`;
sys_Interface_Log_209935	DROP TABLE	`	;		DROP TABLE `sys_Interface_Log_209935`;
sys_Interface_Log_209945	DROP TABLE	`	;		DROP TABLE `sys_Interface_Log_209945`;
sys_Interface_Log_209955	DROP TABLE	`	;		DROP TABLE `sys_Interface_Log_209955`;
sys_Interface_Log_209965	DROP TABLE	`	;		DROP TABLE `sys_Interface_Log_209965`;
sys_Interface_Log_209975	DROP TABLE	`	;		DROP TABLE `sys_Interface_Log_209975`;
sys_Interface_Log_209985	DROP TABLE	`	;		DROP TABLE `sys_Interface_Log_209985`;
sys_Interface_Log_209995	DROP TABLE	`	;		DROP TABLE `sys_Interface_Log_209995`;

删除垃圾日志：

DELETE  from sys_Interface_Log_201605 where
api ='cst_status_roombuilding'  LIMIT 10000;

cst_status_order
cst_status_contract
cst_status_getin
cst_status_roombuilding

统计：

SELECT a.api,count(*) from sys_Interface_Log_201605 a
GROUP BY a.api 
HAVING count(*);