1、MySQL二进制日志和主从快速设置
binlog_format=ROW
binlog_row_image=minimal
plugin-load = semisync _master.so
2、Linux快速全局查找大于指定大小的文件
find / -xdev -size +100M -exec ls -l {} \;
3、MySQL查找重复数据和去重
查找重复IMEI的记录
SELECT *
FROM device
GROUP BY imei
HAVING COUNT(imei) > 1;
删除重复的IMEI中id大的记录
DELETE FROM device
WHERE id NOT IN
(
SELECT a.id FROM
(
SELECT MIN(id) id
FROM device
GROUP BY imei
) a
)