setting in my.cnf changed, but Mysqltunner does not update

[alexlii1971]

Hello,

I updated the the content in my.cnf, and also reboot the server, and cleared on cache on server end, but it seems not updated in Mysqltuner, and it still show:

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    MySQL was started within the last 24 hours: recommendations may be inaccurate
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=OFF
    Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU
Variables to adjust:
    skip-name-resolve=OFF
    query_cache_limit (> 4M, or use smaller result sets)
    query_cache_size (=0)
    query_cache_type (=0)
    table_definition_cache (400) > 795 or -1 (autosizing if supported)
    innodb_buffer_pool_size (>= 2.9G) if possible.
    innodb_log_file_size should be (=256M) if possible, so InnoDB total log file size equals 25% of buffer pool size.

But, in Mariadb, it show:

 mariadb
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 101
Server version: 10.6.14-MariaDB-1:10.6.14+maria~ubu2204-log mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 
MariaDB [(none)]> 
MariaDB [(none)]> SHOW VARIABLES LIKE 'query_cache_size';
+------------------+----------+
| Variable_name    | Value    |
+------------------+----------+
| query_cache_size | 67108864 |
+------------------+----------+
1 row in set (0.001 sec)

Any way to fix ?

Thanks

[jmrenouard]

Hi @alexlii1971

As explained in USAGE
Allow MySQL server to run for at least 24-48 hours before trusting suggestions

I will close this issue because MT is not suitable for this kind of situation

IHMO, be patient :)

[jmrenouard]

Hi @alexlii1971

Can you give us my.nf content added or changed ?

[jmrenouard]

IHMO, this is a MariaDB issue
if query_cache_size=0 this variables should be displayed with 0 as value

[jmrenouard]

Hi @alexlii1971

As you can see in your feedback

MariaDB [(none)]> SHOW VARIABLES LIKE 'query_cache_size';
+------------------+----------+
| Variable_name    | Value    |
+------------------+----------+
| query_cache_size | 67108864 |
+------------------+----------+
1 row in set (0.001 sec)

This result for MariaDB show us that MT can't do anything about this issue
This is a MariaDB issue feel free to open a ticket here: https://jira.mariadb.org/projects/MDEV/issues/