Startup was very slow on instances with a large number of tables

MySQL & MariaDB
21

No. All 8.0 defaults.

1 Like
22

Hitting a similar issue, so I hope this would help a bit and not pollute this thread.

After a crash of PXC, restarting one node with safe_to_bootstrap=1 takes ages.

Looking at the MySQL datadir, it’s running in circles with dblwr and undo files:

total 4351432
-rw-r-----  1 mysql mysql          65536  7 nov.  07:55 #ib_16384_18.dblwr
-rw-r-----  1 mysql mysql          65536  7 nov.  07:55 #ib_16384_16.dblwr
-rw-r-----  1 mysql mysql          65536  7 nov.  07:55 #ib_16384_14.dblwr
-rw-r-----  1 mysql mysql          65536  7 nov.  07:55 #ib_16384_12.dblwr
-rw-r-----  1 mysql mysql          65536  7 nov.  07:55 #ib_16384_10.dblwr
-rw-r-----  1 mysql mysql          65536  7 nov.  07:55 #ib_16384_8.dblwr 
-rw-r-----  1 mysql mysql          65536  7 nov.  07:55 #ib_16384_6.dblwr 
-rw-r-----  1 mysql mysql          65536  7 nov.  07:55 #ib_16384_4.dblwr 
-rw-r-----  1 mysql mysql          65536  7 nov.  07:55 #ib_16384_2.dblwr
-rw-r-----  1 mysql mysql          65536  7 nov.  07:55 #ib_16384_0.dblwr
-rw-r-----  1 mysql mysql          65536  7 nov.  07:55 #ib_16384_22.dblwr
-rw-r-----  1 mysql mysql          65536  7 nov.  07:55 #ib_16384_20.dblwr
-rw-r-----  1 mysql mysql       50331648  7 nov.  07:55 undo_002

In the recovery log:

2022-11-07T07:42:11.775268+01:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-07T07:55:48.850047+01:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

(13 min 30 sec)

In the mysql.log (after the recovery is successful):

2022-11-07T07:56:04.514058+01:00 3 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-07T07:56:21.578864+01:00 3 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

(17 sec)

Around 670 files in the MySQL datadir, whole database size is around 25GB (including InnoDB and Galera files)

1 Like
23

Hello @blade106,
You might have a different issue. 670 files is not a lot of files. After a crash, InnoDB is performing crash recovery which is different (and also takes time) from the issue described by the original poster of this thread. I suggest you open a different thread for your issue.

2 Likes
24

Hi Matthew,

I performed the test with MySQL 5.7 and the same PROD database and in linux the problem did not occur.

On linux MySQL boot time fixed at 20s.

So there really is a problem with MySQL on Windows Server. But Oracle did not accept the opening of the Bug.