Re: mysql 8.0.27 went crash

[Peter Brawley]

> The OS I used is Windows Server,it might be no the concept of the swap file.

I'm pretty sure it has virtual memory, uses a pagefile.

Your MySQL instance is configured to use ~93GB. You have 32GB. It swaps, slows down, eventually fails.

You have ~142GB of data & indexes. To guarantee everything is done in RAM you'd need something like that much RAM.

At the very least, I ween, you need more RAM and you need to optimise greedy queries. Consider running the "Optimisation cheatsheet" at https://www.artfulsoftware.com/infotree/mysqltips.php, posting the result here inside BBCode code tags.