本帖最后由 堡塔运维香菜卷 于 2023-4-9 14:53 编辑
这次用宝塔，用的最新版的php,mysql
发现mysql老是出问题，
经常自己停止服务。。
日志如下：
2023-03-19T08:14:41.926980Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
2023-03-20T11:21:33.496990Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-03-20T11:21:33.508349Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-03-20T11:21:33.530209Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 243893
2023-03-20T11:21:33.778607Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-03-20T11:21:35.529043Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-04-08T13:52:10.468044Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-04-08T13:52:10.470270Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-04-08T13:52:10.472208Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 666808
2023-04-08T13:52:10.551662Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-08T13:52:11.899983Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-04-08T13:52:12.177818Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-04-08T13:52:12.259998Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-04-08T13:52:12.284488Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-04-08T13:52:12.355760Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-04-08T13:52:12.356090Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-04-08T13:52:12.409149Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
2023-04-08T16:13:08.011914Z 112 [Warning] [MY-010058] [Server] Hostname 'zg-1220d-137.stretchoid.com' does not resolve to '192.241.207.99'.
2023-04-08T16:19:30.465622Z 113 [Warning] [MY-010055] [Server] IP address '205.210.31.38' could not be resolved: Name or service not known
2023-04-08T17:45:58.315467Z 114 [Warning] [MY-010057] [Server] IP address '34.78.38.154' has been resolved to the host name '154.38.78.34.bc.googleusercontent.com', which resembles IPv4-address itself.
2023-04-08T21:56:49.716135Z 1011 [Warning] [MY-010055] [Server] IP address '149.110.146.122' could not be resolved: Name or service not known
2023-04-09T01:33:03.130957Z 1106 [Warning] [MY-010058] [Server] Hostname 'zg-1220g-197.stretchoid.com' does not resolve to '162.243.132.18'.
2023-04-09T02:44:37.370349Z 1123 [Warning] [MY-010058] [Server] Hostname 'zg-1220a-91.stretchoid.com' does not resolve to '162.243.147.13'.
2023-04-09T04:11:15.035519Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-04-09T04:11:15.037924Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-04-09T04:11:15.045225Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 680185
2023-04-09T04:11:15.300482Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-09T04:11:16.161362Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-04-09T04:11:17.719345Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-04-09T04:11:17.898126Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-04-09T04:11:17.927678Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-04-09T04:11:18.182075Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-04-09T04:11:18.183479Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-04-09T04:11:18.309135Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
2023-04-09T04:11:47.310038Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-04-09T04:11:47.311966Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-04-09T04:11:47.313170Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 680249
2023-04-09T04:11:47.443445Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-09T04:11:48.132215Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-04-09T04:11:48.565650Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-04-09T04:11:48.663358Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-04-09T04:11:48.680272Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2023-04-09T04:11:48.788861Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2023-04-09T04:11:48.789472Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2023-04-09T04:11:48.863943Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.24' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
2023-04-09T04:12:06.066096Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-04-09T04:12:06.074359Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-04-09T04:12:06.075274Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 680316
2023-04-09T04:12:06.148306Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-04-09T04:12:06.822197Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-04-09T04:12:07.364151Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2023-04-09T04:12:07.631623Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2023-04-09T04:12:07.682795Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
请问要如何解决？
谢谢。
|
|
运维要高效，装宝塔
