卧槽,mysql启动不了了,,排查好久还是不行

AYrm

docker跑的mysql,,mjj帮忙看下

2023-07-12T02:22:13.451832649Z 2023-07-12 02:22:13+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:22:13.649282410Z 2023-07-12 02:22:13+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-07-12T02:22:13.657589728Z 2023-07-12 02:22:13+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:22:13.830518212Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-07-12T02:22:14.001969205Z 2023-07-12T02:22:13.999226Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-12T02:22:14.001988572Z 2023-07-12T02:22:13.999241Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-12T02:22:14.002005635Z 2023-07-12T02:22:13.999245Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-12T02:22:14.002008460Z 2023-07-12T02:22:13.999260Z 0 [Warning] [MY-000081] [Server] option 'thread_stack': unsigned value 65536 adjusted to 131072.
2023-07-12T02:22:14.002010684Z 2023-07-12T02:22:13.999272Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-07-12T02:22:14.002012568Z 2023-07-12T02:22:14.000144Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2023-07-12T02:22:14.002014481Z 2023-07-12T02:22:14.000178Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 1
2023-07-12T02:22:14.778839922Z 2023-07-12T02:22:14.778660Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-12T02:38:55.642015975Z 2023-07-12 02:38:55+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:38:55.843810885Z 2023-07-12 02:38:55+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-07-12T02:38:55.851698545Z 2023-07-12 02:38:55+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:38:56.028181486Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-07-12T02:38:56.207121749Z 2023-07-12T02:38:56.204049Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-12T02:38:56.207150254Z 2023-07-12T02:38:56.204066Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-12T02:38:56.207154301Z 2023-07-12T02:38:56.204071Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-12T02:38:56.207157147Z 2023-07-12T02:38:56.204085Z 0 [Warning] [MY-000081] [Server] option 'thread_stack': unsigned value 65536 adjusted to 131072.
2023-07-12T02:38:56.207159521Z 2023-07-12T02:38:56.204098Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-07-12T02:38:56.207162336Z 2023-07-12T02:38:56.205236Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2023-07-12T02:38:56.207164551Z 2023-07-12T02:38:56.205297Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 1
2023-07-12T02:38:56.394137661Z 2023-07-12T02:38:56.393982Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-12T02:41:25.077172346Z 2023-07-12 02:41:25+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:41:26.317304877Z 2023-07-12 02:41:26+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-07-12T02:41:26.325838935Z 2023-07-12 02:41:26+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:41:26.501392859Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-07-12T02:41:26.673532544Z 2023-07-12T02:41:26.670624Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-12T02:41:26.673692493Z 2023-07-12T02:41:26.670654Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-12T02:41:26.673727931Z 2023-07-12T02:41:26.670659Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-12T02:41:26.673731818Z 2023-07-12T02:41:26.670675Z 0 [Warning] [MY-000081] [Server] option 'thread_stack': unsigned value 65536 adjusted to 131072.
2023-07-12T02:41:26.673740335Z 2023-07-12T02:41:26.670689Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2023-07-12T02:41:26.673743351Z 2023-07-12T02:41:26.670726Z 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-07-12T02:41:26.673745895Z 2023-07-12T02:41:26.670810Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 1
2023-07-12T02:41:26.897202989Z 2023-07-12T02:41:26.897006Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-07-12T02:47:29.006489337Z 2023-07-12 02:47:29+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:47:29.226627031Z 2023-07-12 02:47:29+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-07-12T02:47:29.237383828Z 2023-07-12 02:47:29+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.31-1.el8 started.
2023-07-12T02:47:29.409320378Z '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-07-12T02:47:29.580966846Z 2023-07-12T02:47:29.577361Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-12T02:47:29.581010659Z 2023-07-12T02:47:29.577380Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-12T02:47:29.581014398Z 2023-07-12T02:47:29.577385Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2023-07-12T02:47:29.581016912Z 2023-07-12T02:47:29.577400Z 0 [Warning] [MY-000081] [Server] option 'thread_stack': unsigned value 65536 adjusted to 131072.
2023-07-12T02:47:29.581019116Z 2023-07-12T02:47:29.577435Z 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-07-12T02:47:29.581034756Z 2023-07-12T02:47:29.577517Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31) starting as process 1
2023-07-12T02:47:30.560387390Z 2023-07-12T02:47:30.560168Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

AYrm

@晴晴晴 @cscool @251768938
统一回复下,,,启动了, 是数据库表太大了, 初始化时间很长,,30分钟

AYrm

DushuAPP 发表于 2023-7-12 22:58
mysql单表大了很容易crash，所以分表存储是很有必要的。

现在是用id分区这个方案,,分了1024个区

DushuAPP

mysql单表大了很容易crash，所以分表存储是很有必要的。

AYrm

DushuAPP 发表于 2023-7-12 22:44
建议分表存储。

好的 ,, 已经在准备迁移数据了

DushuAPP

建议分表存储。

AYrm

vm.sg 发表于 2023-7-12 22:39
为什么不分成虚拟机来跑？

,,现在改,,有点麻烦了,,准备再加一台机来重新改虚拟机跑

vm.sg

AYrm 发表于 2023-7-12 22:17
,,,一个一亿数据的表,,,,还有两个三千万的左右数据的表,,
128g内存,,cpu是5800u 单核性能确实不行, ...

为什么不分成虚拟机来跑？

AYrm

DushuAPP 发表于 2023-7-12 18:58
应该是配置太差。本身docker的效率也不行。

,,,一个一亿数据的表,,,,还有两个三千万的左右数据的表,,
128g内存,,cpu是5800u 单核性能确实不行,
硬盘是4个4tssd组的raid5


,,我也想起来,,他启动的时候cpu确实起不来

AYrm

squalll 发表于 2023-7-12 18:39
效果如何了？（如果担心我说的删除临时文件夹内全部文件准确性可以百度） ...

刚开电脑 已经快速启动 谢谢大佬

DushuAPP

aoerboquartz 发表于 2023-7-12 18:56
你这个库多大啊？居然30分钟？

应该是配置太差。本身docker的效率也不行。