Can't enable MySQL

djcart

djcart

Verified User
Joined
Jun 29, 2021
Messages
125
Tries to enable in MySQL Query Cache.
When adding the following lines to my.cnf:

query_cache_type = 1
query_cache_size = 100M
query_cache_limit = 1M

It get an error when rebooting mysql.
The following content appears in the logs.

I can not deal with it.
 

Attachments

  • mysql.jpg
    mysql.jpg
    150.3 KB · Views: 10
I see. I'm trying to improve the performance of my mysql. I am looking for some articles to choose the correct parameters to speed up the operation of databases. Can you recommend something?
 
After the database has been running under normal use for a while, I would suggest running MysqlTuner to check Mysql/MariaDB server settings. It will make recommendations to tune the database.

github.com

GitHub - major/MySQLTuner-perl: MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. - major/MySQLTuner-perl
github.com github.com

Turn off DNS resolution:

skip-name-resolve=1

This will delay writes for up to a couple seconds which can help with heavier write loads.

innodb_flush_log_at_trx_commit = 2

Important that you have sufficient memory and a fast storage system for databases.
 
Did you read the information? You didn't say what you've tried in the past. What have you done so far in terms of tuning?
 
BillyS said:
Czy przeczytałeś informacje? Nie powiedziałeś tego, czego próbowałeś w przeszłości. Co zrobiłeś do tej pory w zakresie tuningu?
Click to expand...
Nie mam doświadczenia. W tej chwili mam serwer z ponad 100 klientami. Szukam rozwiązania, które przyspieszyłoby bazę danych
 
You must log in or register to reply here.
Back
Top