Category: Computer tips

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

command to run timeshift sudo timeshift –restore