my.cnf relatively barren

[jlpeifer]

I'm in the process of troubleshooting a sluggish DA server. Part of this involved running mysqltuner.pl. It made some recommendations for updates to my mysql config. When I located and opened my.cnf I was surprised to see that it contained practically nothing....

[mysqld]
local-infile=0
innodb_file_per_table

[client]
socket=/usr/local/mysql/data/mysql.sock

I'm not mysql fluent, but my understanding is that innodb is the storage engine for mysql and mariaDB... so maybe that's why the my.cnf is barren. But like I said, I'm not mysql fluent.

Here are the recommendations made by mysqltuner.pl ...

skip-name-resolve=ON
tmp_table_size (> 16M)
max_heap_table_size (> 16M)
table_definition_cache (400) > 1337 or -1 (autosizing if supported)
performance_schema=ON
key_buffer_size (~ 24M)
innodb_buffer_pool_size (>= 634.6M) if possible.
innodb_log_file_size should be (=16M) if possible, so InnoDB total log file size equals 25% of buffer pool size.

Where do I make these adjustments if not in my.cnf?

 

[Zhenyapan]

put this to your my.cnf mysqld-section
skip-name-resolve=ON
tmp_table_size=64M
max_heap_table_size=64M
table_definition_cache=1500
key_buffer_size=16M
innodb_buffer_pool_size=1G

 

[BillyS]

You need to provide more information. What version of mariadb / mysql are you using? How large is the database and server? Are all the tables innodb? Most of the defaults today are sufficient, but depending on your configuration, there may be an opportunity to tweak some settings.