If you ever do parallel processing of your binlogs, make sure you pass TZ environment variable to mysqlbinlog, otherwise it will stat(/etc/localtime) for each event (OS assumes you might change system timezone any nanosecond) Lots of parallel filesystem activity on the same file will end up contending on a kernel mutex, so mysqlbinlog will be mostly spinning and doing nothing else. Even with single thread theres considerable performance difference. Also: https://facebook/10152018519901696 Brought to you by where did this row change come from department.
Posted on: Wed, 21 May 2014 00:38:58 +0000