v1.7.19 minor message oddity

[davidfavor]

In my.cnf settings are...

innodb_buffer_pool_size        = 12G 
innodb_buffer_pool_instances   = 12
innodb_log_file_size           = 1G

Emitted suggested tunings...

Variables to adjust:
    query_cache_size (=0)
    query_cache_type (=0)
    query_cache_limit (> 0B, or use smaller result sets)
    innodb_log_file_size should be (=1G) if possible, so InnoDB total log files size equals to 25% of buffer pool size.

This seems incorrect, since innodb_log_file_size is already set to 1G.

Checking variables, correct my.cnf value seems to have been ingested...

# db-variables | grep innodb_log_file_size
innodb_log_file_size	1073741824

[gessel]

I'm seeing this too, at least two variables (the other two above, query_cache_limit and innodb_log_file_size are being correctly parsed in my install):

Variables to adjust:
    query_cache_size (=0)
    query_cache_type (=0)

but configured as:

 # grep query_cache_  /usr/local/etc/mysql/my.cnf
 query_cache_limit = 2M
 query_cache_size = 64M
 query_cache_type = 1

And verified as interpreted by:

 # mysqladmin -u root -p variables | grep query_cache_
| log_slow_filter                                        | admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,not_using_index,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| query_cache_limit                                      | 2097152                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| query_cache_min_res_unit                               | 4096                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| query_cache_size                                       | 67108864                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| query_cache_strip_comments                             | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| query_cache_type                                       | ON

MariaDB version

# pkg version -v | grep maria
mariadb104-client-10.4.13_2        =   up-to-date with index
mariadb104-server-10.4.13_2        =   up-to-date with index

MySQLTuner version:

# pkg version -v | grep tuner
mysqltuner-1.7.17                  =   up-to-date with index

[jmrenouard]

Hi @gessel Hi @davidfavor

Can you perform tests with last version: 17.25+ ?

Thanks
@jmrenouard

[davidfavor]

Messages seem much clearer now.

Thanks!