{"version":"1.0","provider_name":"Jui-Nan Lin&#039;s Blog","provider_url":"https:\/\/jnlin.org","author_name":"jnlin","author_url":"https:\/\/jnlin.org\/author\/jnlin\/","title":"\u5229\u7528 Percona Playback warm-up MySQL \u8cc7\u6599\u5eab...","html":"<a href=\"http:\/\/www.percona.com\/doc\/percona-playback\/\">Percona Playback<\/a> \u662f\u4e00\u5957\u53ef\u4ee5\u5c07\u4e8b\u5148\u8a18\u9304\u4e0b\u4f86\u7684 SQL Query Log \u5728\u6307\u5b9a\u7684 MySQL Server \u4e0a\u91cd\u4f5c\u4e00\u6b21\u7684\u5de5\u5177\uff0c\u76ee\u524d\u6700\u65b0\u7684\u7248\u672c\u662f 0.5\uff0c\u652f\u63f4\u8b80\u53d6 slow query log \u6216\u662f tcpdump capture file\u3002Percona \u6a19\u699c\u53ef\u4ee5\u5b8c\u5168\u6309\u7167 Query Log \u7684 Pattern \uff08\u5305\u542b thread concurrency\uff0cquery \u6240\u82b1\u7684\u6642\u9593\u7b49\u7b49\uff09\u4f86\u91cd\u4f5c\u4e00\u6b21 Query\uff0c\u4e0d\u904e\u6e2c\u8a66\u7684\u7d50\u679c\u9084\u662f\u6709\u9ede\u843d\u5dee\u3002\r\n\r\n\u9996\u5148\u5148\u5728 Production \u7684 Server \u4e0a\u9762\u7d00\u9304 Query Log\u3002\u56e0\u70ba Percona Playback 0.5 \u7684 Slow Query Reader \u662f\u721b\u7684\uff08<a href=\"https:\/\/bugs.launchpad.net\/percona-playback\/+bug\/1035217\">bug 1035217<\/a>\uff09\uff0c\u6240\u4ee5\u53ea\u80fd\u7528 tcpdump\uff1a\r\n<code>tcpdump -w log.dump dst port 3306 and dst ip 192.168.1.1<\/code> \r\n\r\n\u8a18\u9304\u5230\u8db3\u5920\u9577\u5ea6\u7684 log \u4e4b\u5f8c\uff0c\u628a log \u653e\u5230\u8981\u6e2c\u8a66\u7684 MySQL \u6a5f\u5668\u4e0a\uff0c\u958b\u59cb\u57f7\u884c percona playback\u3002\u8981\u6ce8\u610f\u7684\u662f\uff0c\u6240\u6709\u7684 Log \uff08\u5305\u542b UPDATE, DELETE, INSERT \u7b49\u7b49\u6703\u4fee\u6539\u8cc7\u6599\u5eab\u5167\u5bb9\u7684 Query\uff09\u90fd\u6703\u88ab\u57f7\u884c\uff0c\u5982\u679c\u8981\u5728 Slave \u4e0a\u8dd1\u7684\u8a71\uff0c\u8a18\u5f97\u8981\u4e8b\u5148\u6ffe\u6389\uff0c\u624d\u4e0d\u6703\u9020\u6210 Master Slave \u4e0d\u540c\u6b65\u7684\u72c0\u6cc1\u3002\r\n<code>percona-playback --input-plugin=tcpdump --tcpdump-filelog.dump --tcpdump-mode=fast --mysql-host=127.0.0.1 --mysql-username=root --mysql-schema=mydb<\/code>\r\n\r\n\u5b98\u65b9\u6587\u4ef6\u662f\u4f7f\u7528 <code>--tcpdump-mode=accurate<\/code>\uff0c\u901f\u5ea6\u6162\u5f88\u591a\uff0c\u4f7f\u7528 <code>--tcpdump-mode=fast<\/code> \u6703\u5feb\u4e0d\u5c11\u3002","type":"rich"}