- 博客(4)
- 收藏
- 关注
RSS订阅原创 Lost connection to MySQL server at 'reading initial communication packet', system error: 111 (MySQL
DataClient.cpp: 220|get_all_msgpolicy; SQLException [TCS_Mysql::connect]: mysql_real_connect: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 (MySQL er
2018-01-31 09:21:17
4851
原创 MySQL error code 1217 (ER_ROW_IS_REFERENCED): Cannot delete or update a parent row: a foreign key co
开发环境从库复制出错，错误信息如下：mysql> show slave status\G;Last_Errno: 1217Last_Error: Error 'Cannot delete or update a parent row: a foreign key constraint fails' on query.# perror 1217MySQL error code
2018-01-31 09:07:37
1164
原创 MySQL逻辑备份单表恢复
假设要从一个MySQL整库的逻辑备份中恢复其中的一张表，如何做到快速恢复呢？下面通过巧妙利用授权的方式，快速从逻辑备份中恢复想要的表。一. 数据库备份mysqldump -ubackup -ppassword -S /data/3316/logs/mysql.sock -B --flush-privileges --single-transaction --master-dat
2018-01-12 17:39:57
358
原创 Percona Server is not running with jemalloc
Server version: 5.7.20-18-log Percona Server (GPL), Release 18, Revision 7ce54a6deef安装tokudb引擎遇到如下错误：ps-admin --enable -uroot -pChecking SELinux status... FO: SELinux is disabled.
2018-01-04 10:42:07
788
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人