Database slow query log analysis, using the Pt-query-digest tool.
Native System, MAC10.11.5. Installation Reference Blog: http://blog.csdn.net/wireless_com/article/details/51615627
Issue 1: Run:perl-mcpan-e "Install DBD:: MySQL" error, "Dyld:library not Loaded:libmysqlclient.18.dylib".
Workaround: ① Add "Export dyld_library_path= $DYLD _library_path:/usr/local/mysql/lib" in ~/.bash_profile,
② Execution:sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib
Issue 2: In the execution above ② times wrong, operation not permitter. Switching to the root user also has the same error.
Workaround: Mac El Capitan
joins Rootless机制
, no longer able to read and write many paths. It is not possible to set root permissions.
Close rootless is OK.
PS: Turn off rootless: Enter Mac Recovery mode (press and hold command+r when restarting), then open terminal and enter "Csrutil disable".
Summary of issues encountered with Mac (10.11.5) installation Pt-query-digest