Computer Man

in my case, the mariadb / mysql is 32bit, as you knew 32bit only support about 3GB RAM, so instead of allocated 4GB，I changed it to...

The best bet: Turn off query cache: find my.ini in windows, or my.conf in linux add line in mysqld [mysqld] … query_cache_type=0 query_cache_size=0 0 is off...

It is in google drive aaappp

https://officecdn.microsoft.com/db/492350f6-3a01-4f97-b9c0-c7c6ddf67d60/media/en-us/ProPlus2021Retail.img

innodb_flush_log_at_trx_commit to 2 can improve the performance of MySQL and solve the problem of excessive handle usage.

Comment byu/aaapppleee from discussion inmariadb

Turn it off, it causes performance loss. query_cache_type = 0 query_cache_size= 0 0 is off 1 is on