Mysql Scalability(6)Mysql Trouble Shooting

最新推荐文章于 2021-08-05 14:57:44 发布

原创最新推荐文章于 2021-08-05 14:57:44 发布 · 172 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

Distributed 同时被 2 个专栏收录

160 篇文章

订阅专栏

Database

53 篇文章

订阅专栏

本文介绍了解决MySQL连接丢失错误2013的方法，包括卸载并重新安装MySQL服务器，删除并重新创建数据库，以及配置主从复制。通过一系列步骤确保MySQL服务正常运行。

Mysql Scalability(6)Mysql Trouble Shooting

Error Message
ERROR 2013 (HY000): Lost connection to MySQL server during query

Remove and reinstall the mysql again.
>sudo apt-get autoremove --purge mysql-server
>sudo apt-get remove mysql-server
>sudo apt-get autoremove mysql-server
>sudo apt-get remove mysql-common

>sudo apt-get install software-properties-common
>sudo add-apt-repository ppa:ondrej/mysql-5.6
>sudo apt-get update
>sudo apt-get install mysql-server

drop the database and create it again.

>drop database sillycat;
>create database sillycat;
>use sillycat;
>create table branduser(id int primary key, username char(255), age int);
>insert into branduser(id, username, age) values ( 1, "sillycat", 32);

Then configure them to be master/slave.

The master/slave stop after I restart the server. So we need to turn on the master/slave again.

References:
http://www.mysqlperformanceblog.com/2008/07/04/recovering-innodb-table-corruption/