开发同事QQ说测试库链接不上,测试了下真的不能链接上, 刚刚重启过的,咋回事呢?

然后用自己的MYSQL WORKBEAN去链接 报SOCK 错误

不可能,绝对不能, 都搞了那么多年了不是初级MYSQL DBA,

PS 后发现 丢两个MYSQL实例, 

然后想KILL 掉一个,结果也报错 啥 ID 不存在, 仔细看 ID输入没错啊

再PS下 发现ID 变掉了.

再尝试SYSTEMCTL STOP MYSQLD  OK 没问题, 干净 清爽. 立马在工作群AT运维去看是什么问题, 运维都不看一下,连我截图的信息都不看, 就怼回来, 年轻人太年轻了. 大领导在里面,敢拒绝同事邀请.

不干就自己干了,运维那破事没有什么技术难度的嘛! 只要花时间就行.

[root@localhost lib]# find / -name mysqld.service
/sys/fs/cgroup/systemd/system.slice/mysqld.service
/etc/systemd/system/multi-user.target.wants/mysqld.service
/usr/lib/systemd/system/mysqld.service

# Needed to create system tables
ExecStartPre=/usr/bin/mysqld_pre_systemd

# Start main service
ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS

# Use this to switch malloc implementation
EnvironmentFile=-/etc/sysconfig/mysql

# Sets open_files_limit
LimitNOFILE = 5000

Restart=on-failure

RestartPreventExitStatus=1

启动服务不断的重启,

再看看我们的MYSQL 日志

mysqld: Table 'mysql.plugin' doesn't exist
2022-09-03T08:28:36.511535Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

妈妈的 怎么会是插件表丢失呢? 就重启了下而已

然后查找解决方案 都说要初始化数据库, 不是吧? 这样原来的数据咋办呢?

我们先修改服务设置,不让它起两个,

结果 惊喜连连

2022-09-03T08:29:13.692834Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.35-log) starting as process 21543 ...
2022-09-03T08:29:13.697840Z 0 [Note] InnoDB: PUNCH HOLE support available
2022-09-03T08:29:13.697889Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-03T08:29:13.697895Z 0 [Note] InnoDB: Uses event mutexes
2022-09-03T08:29:13.697899Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-09-03T08:29:13.697904Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-03T08:29:13.697908Z 0 [Note] InnoDB: Using Linux native AIO
2022-09-03T08:29:13.698576Z 0 [Note] InnoDB: Number of pools: 1
2022-09-03T08:29:13.698760Z 0 [Note] InnoDB: Using CPU crc32 instructions
2022-09-03T08:29:13.785245Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2022-09-03T08:29:13.891570Z 0 [Warning] InnoDB: Failed to allocate 138412032 bytes. errno 12
2022-09-03T08:29:13.891619Z 0 [Warning] InnoDB: Using conventional memory pool
2022-09-03T08:29:13.929661Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-03T08:29:13.960761Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-09-03T08:29:13.974054Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-09-03T08:29:14.118124Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-03T08:29:14.118252Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-03T08:29:14.208577Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-09-03T08:29:14.211142Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-09-03T08:29:14.211169Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-09-03T08:29:14.211406Z 0 [Note] InnoDB: Waiting for purge to start
2022-09-03T08:29:14.261896Z 0 [Note] InnoDB: 5.7.35 started; log sequence number 363744518023
2022-09-03T08:29:14.262131Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-09-03T08:29:14.262619Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-09-03T08:29:14.263755Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220903 15:29:14
2022-09-03T08:29:14.267174Z 0 [Warning] InnoDB: Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
mysqld: Table 'mysql.plugin' doesn't exist
2022-09-03T08:29:14.267245Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2022-09-03T08:29:14.292977Z 0 [Warning] InnoDB: Cannot open table mysql/gtid_executed from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
mysqld: Table 'mysql.gtid_executed' doesn't exist
2022-09-03T08:29:14.293013Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-09-03T08:29:14.295841Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-09-03T08:29:14.295873Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-09-03T08:29:14.295879Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-09-03T08:29:14.295907Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-09-03T08:29:14.309023Z 0 [Warning] CA certificate ca.pem is self signed.
2022-09-03T08:29:14.309169Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-09-03T08:29:14.310215Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-09-03T08:29:14.310329Z 0 [Note] IPv6 is available.
2022-09-03T08:29:14.310368Z 0 [Note]   - '::' resolves to '::';
2022-09-03T08:29:14.310398Z 0 [Note] Server socket created on IP: '::'.
2022-09-03T08:29:14.344134Z 0 [Warning] InnoDB: Cannot open table mysql/server_cost from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
2022-09-03T08:29:14.344217Z 0 [Warning] Failed to open optimizer cost constant tables

2022-09-03T08:29:14.409038Z 0 [Warning] InnoDB: Cannot open table mysql/time_zone_leap_second from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
2022-09-03T08:29:14.409085Z 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2022-09-03T08:29:14.417584Z 0 [Note] Failed to start slave threads for channel ''
2022-09-03T08:29:14.568229Z 0 [Note] Event Scheduler: Loaded 0 events
2022-09-03T08:29:14.568495Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.35-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
2022-09-03T08:29:31.353895Z 2 [Warning] IP address '192.168.0.226' could not be resolved: Name or service not known
2022-09-03T08:29:33.378939Z 11 [Warning] IP address '192.168.0.225' could not be resolved: Name or service not known

报错了能咋地? 照样可以起来