摘要:
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)可以在配置文件中加入:log_bin_trust_function_creators = 1已经运行的Mysql,可以直接show variables like 阅读全文
摘要:
例如:PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 3 DAY); 阅读全文
摘要:
-- mysql慢查询日志相关参数-- 慢查询日志时间show variables like "long_query_time"; -- 将时间设置为2sset global long_query_time=2; -- 是否开启慢查询日志show variables like "slow_query_log";-- 打开慢查询日志set global slow_query_log='ON'; -- 查询一下文件show variables like "%slow%";使用mysqldumpslow可以将日志转化为可读格 阅读全文