Форум пользователей MySQL

sv · 17.05.2017 19:47:29

Podskajite kak otsledit izmeneniya v tablice. To est menya interesute kto delaet insert i s kakogo ip
Ispolzoval pt-query-digest. No ona krivaya i ne pokazivaet nujnie mne izmeneniya

Delal tak

tcpdump -s 65535 -x -nn -q -tttt port 3306 > mysql.tcp.txt

pt-query-digest --limit=100% --type tcpdump mysql.tcp.txt |less

mysqlbinlog mysql-bin.000441 > mysql-bin.000441.txt

pt-query-digest --limit=100% --type binlog mysql-bin.000685.txt |less

sv · 18.05.2017 17:21:36

Vse okazalos prosto. Nado byilo vklyuchit general_log

Форум пользователей MySQL

#1 17.05.2017 19:47:29

Monitoring of table changes

#2 18.05.2017 17:21:36

Re: Monitoring of table changes

Board footer