On 6/15/22 03:10, Radisson via Dng wrote:
Hello list,
i would like to start my mysqld 8.0 in background because it takes
several minutes to start.
Does someone have a solution ?
re,
pr
_______________________________________________
Dng mailing list
[email protected]
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng
Disclaimer:
I know nothing about mysql and next to nothing about databases.
I found the startup time rather intriguing as Postgres starts nearly
instantaneously.
I found this reply to a similiar post on stackexchange.
>I have a large ibdata1 file (20GB) even with file per table activated
>Turned out that mysql scan all the undo looking for uncommitted
transactions.
>Since I had a very large undo space in the ibdata, I moved to use undo
tablespaces. Setting up the >undo truncate option keeps my undo
tablespace very small.
>Now my db opens in 2-3mn top!
Now, why any database leaves uncommitted transactions around after
shutdown is a question for another time.
Hope this was of some value.
Regards,
Ken
_______________________________________________
Dng mailing list
[email protected]
https://mailinglists.dyne.org/cgi-bin/mailman/listinfo/dng
