今天来说说我在mysql上踩的一个坑,河河河河河。。。。
今天因为要去搞主从库备份,但是有一个问题是,主从库备份的时候,要保持数据的一致(目前我的做法这里是这样的,应该有更好的方法可以修改)。因为我们的数据库是有好多人在一起用的,而且还有定时器在往里边刷数据。这真是一个蛋疼的时候。
这时候我先看了看我的数据库的链接,都是在进行什么操作。使用了命令:show processlist 去查看数据谷中的进程如何。
mysql> show processlist;
+-------+-----------+---------------------+-----------+-------------+-------+-----------------------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-----------+---------------------+-----------+-------------+-------+-----------------------------------------------------------------------+------------------+
| 43 | mysqluser | 172.16.10.191:46434 | NULL | Binlog Dump | 39481 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL |
| 61524 | root | 172.18.34.34:50288 | NULL | Sleep | 1232 | | NULL |
| 62167 | root | 172.18.34.13:60514 | yree | Sleep | 850 | | NULL |
| 63458 | root | 172.16.10.183:34377 | MEIZU_BRO | Sleep | 31 | | NULL |
| 63461 | root | 172.16.10.183:34395 | MEIZU_BRO | Sleep | 24 | | NULL |
| 63462 | root | 172.18.34.34:51643 | MEIZU_BRO | Sleep | 21 | | NULL |
| 63463 | root | 172.18.34.34:51644 | MEIZU_BRO | Sleep | 21 | | NULL |
| 63464 | root | 172.18.34.34:51645 | MEIZU_BRO | Sleep | 21 | | NULL |
| 63465 | root | 172.18.34.34:51646 | MEIZU_BRO | Sleep | 21 | | NULL |
| 63466 | root | 172.18.34.34:51647 | MEIZU_BRO | Sleep | 21 | | NULL |
| 63467 | root | 172.18.34.34:51648 | MEIZU_BRO | Sleep | 21 | | NULL |
| 63468 | root | 172.18.34.34:51649 | MEIZU_BRO | Sleep | 21 |