- 博客(3)
- 资源 (2)
- 收藏
- 关注
原创 如何干净的清除Slave同步信息
mysql> show master status; +------------------+-----------+--------------+------------------+-------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set
2013-10-24 09:45:06 12875
原创 mysqldump备份恢复--一致性
mysqldump --lock-all-tables --flush-logs --master-data=2 --all-databases > backup.sql mysqldump --single-transaction --flush-logs --master-data=2 --databases db1 db2 db3 > backup.sql
2013-10-12 15:56:30 1809
转载 v$session_wait
SELECT event, sum(decode(wait_time,0,1,0)) "Curr", sum(decode(wait_time,0,0,1)) "Prev", count(*)"Total" FROM v$session_wait GROUP BY event ORDERBY count(*);
2013-10-09 15:28:12 623
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人