MySQL标签存档订阅
mysql主从出错：Replicate_Wild_Ignore_Table: Last_Errno: 1418 Last_Error: Error ‘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_tr ust_function_creators variable)’ on query. Default database: ‘test123’. Query: ‘CREATE DEFINER=`root`@`%` FUNCTION `hello`(s char(20)) RETURNS char(50) CHARSET utf8mb4
报错信息： Replicate_Wild_Ignore_Table: Last_Errno: 141… 继续阅读 mysql主从出错：Replicate_Wild_Ignore_Table: Last_Errno: 1418 Last_Error: Error ‘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_tr ust_function_creators variable)’ on query. Default database: ‘test123’. Query: ‘CREATE DEFINER=`root`@`%` FUNCTION `hello`(s char(20)) RETURNS char(50) CHARSET utf8mb4
- 发表于：
-
作者：
sre
- 分类： SRE
- 标签： MySQL
- 发表评论: mysql主从出错：Replicate_Wild_Ignore_Table: Last_Errno: 1418 Last_Error: Error ‘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_tr ust_function_creators variable)’ on query. Default database: ‘test123’. Query: ‘CREATE DEFINER=`root`@`%` FUNCTION `hello`(s char(20)) RETURNS char(50) CHARSET utf8mb4
sh: 1: mysql_config: not found
apt-get install libmysqlclient-dev
confluence 您的数据库必须使用’READ-COMMITTED’作为默认隔离级别
参照： https://blog.csdn.net/jiangwei0910410003/artic… 继续阅读 confluence 您的数据库必须使用’READ-COMMITTED’作为默认隔离级别
- 发表于：
-
作者：
- 分类： SRE
- 标签： https, MySQL
- 发表评论: confluence 您的数据库必须使用’READ-COMMITTED’作为默认隔离级别
CURRENT_TIMESTAMP自动维护写入时间
设计表时时间字段用CURRENT_TIMESTAMP，在代码中无需再手动给参数赋值了。 CURREN… 继续阅读 CURRENT_TIMESTAMP自动维护写入时间
- 发表于：
-
作者：
joker
- 分类： SRE
- 标签： https, MySQL
- 发表评论: CURRENT_TIMESTAMP自动维护写入时间
1030 Got error 28 from storage engine
服务器磁盘满了： /dev/xvda2 193G 183G 17M 100% /data 清理bin… 继续阅读 1030 Got error 28 from storage engine
MySQL使用xtrabackup备份时报错’Too many open files’
报错信息 2019-04-25 14:04:48 7fd5e9b0a720 InnoDB: Oper… 继续阅读 MySQL使用xtrabackup备份时报错’Too many open files’
- 发表于：
-
作者：
- 分类： SRE
- 标签： MySQL, xtrabackup
- 发表评论: MySQL使用xtrabackup备份时报错’Too many open files’
mysqldump导出通配符表
mysqldump -uxx -pxx a $(mysql -uxx -pxx -Da -Bse “… 继续阅读 mysqldump导出通配符表
docker安装lnmp
左大使出品 一、添加 别名：vim /root/.bashrc alias grep=’grep -… 继续阅读 docker安装lnmp
MySQL date_format函数
语法DATE_FORMAT(date,format) 例如： select date_format(… 继续阅读 MySQL date_format函数
- 发表于：
-
作者：
- 分类： SRE, 开发
- 标签： MySQL
- 发表评论: MySQL date_format函数
[Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[Err] 1055 – Expression #1 of ORDER BY clause is n… 继续阅读 [Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
- 发表于：
-
作者：
- 分类： SRE
- 标签： https, MySQL, sql
- 发表评论: [Err] 1055 – Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
run mangosone in kubernetes
主页 先在各节点拉取3个镜像： ssorriaux/mangosone-database-mysql… 继续阅读 run mangosone in kubernetes
- 发表于：
-
作者：
- 分类： SRE
- 标签： kubernetes, mangos, MySQL
- 发表评论: run mangosone in kubernetes
ERROR 2006 (HY000) at line 1: MySQL server has gone away
调大超时时间： wait_timeout = 28800 interactive_timeout =… 继续阅读 ERROR 2006 (HY000) at line 1: MySQL server has gone away
- 发表于：
-
作者：
- 分类： SRE
- 标签： https, MySQL
- 发表评论: ERROR 2006 (HY000) at line 1: MySQL server has gone away
[Err] 1418 – 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)
mysqldump: Error: Binlogging on server not active
去掉备份命令中的–master-data=
- 发表于：
-
作者：
- 分类： SRE
- 标签： https, MySQL
- 发表评论: mysqldump: Error: Binlogging on server not active
mysqlslap进行mysql性能测试
mysqlslap是mysql自带的基准测试工具 官网 对数据库做一个简单的自动测试: [root@… 继续阅读 mysqlslap进行mysql性能测试
sysbench: error while loading shared libraries: libperconaserverclient.so.20: cannot open shared object file: No such file or directory
[root@db sysbench-master]# locate libmysqlclient.s… 继续阅读 sysbench: error while loading shared libraries: libperconaserverclient.so.20: cannot open shared object file: No such file or directory
kubernetes使用ceph rbd存储pv
创建ceph-secret这个k8s secret对象，这个secret对象用于k8s volume… 继续阅读 kubernetes使用ceph rbd存储pv
- 发表于：
-
作者：
cider
- 分类： SRE
- 标签： ceph, kubernetes, MySQL
- 发表评论: kubernetes使用ceph rbd存储pv
kubernetes部署percona:5.7.22单实例 Deployment
apiVersion: v1 kind: Namespace metadata: name: tes… 继续阅读 kubernetes部署percona:5.7.22单实例 Deployment
- 发表于：
-
作者：
- 分类： SRE
- 标签： cpu, kubernetes, MySQL, requests
- 发表评论: kubernetes部署percona:5.7.22单实例 Deployment
kubernetes安装wordpress
kubectl create ns test1 pvc: apiVersion: v1 kind: … 继续阅读 kubernetes安装wordpress
- 发表于：
-
作者：
- 分类： SRE
- 标签： kubernetes, MySQL, wordpress
- 发表评论: kubernetes安装wordpress