test> show global variables like 'use_stat_tables';

+-----------------+------------------------+

| Variable_name   | Value                  |

+-----------------+------------------------+

| use_stat_tables | PREFERABLY_FOR_QUERIES |

+-----------------+------------------------+

1 row in set (0.001 sec)

test> set global use_stat_tables=PREFERABLY;

Query OK, 0 rows affected (0.000 sec)

test> analyze table temp;

+-----------+---------+----------+----------+

| Table     | Op      | Msg_type | Msg_text |

+-----------+---------+----------+----------+

| test.temp | analyze | status   | OK       |

+-----------+---------+----------+----------+

1 row in set (0.001 sec)

test> ^DBye

$ sudo mysql test

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 185804

Server version: 10.6.20-MariaDB-log MariaDB Server

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

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

test> analyze table temp;

+-----------+---------+----------+-----------------------------------------+

| Table     | Op      | Msg_type | Msg_text                                |

+-----------+---------+----------+-----------------------------------------+

| test.temp | analyze | status   | Engine-independent statistics collected |

| test.temp | analyze | status   | OK                                      |

+-----------+---------+----------+-----------------------------------------+

2 rows in set (0.002 sec)

test> set global use_stat_tables=PREFERABLY_FOR_QUERIES;                   

Query OK, 0 rows affected (0.000 sec)

test> analyze table temp;

+-----------+---------+----------+-----------------------------------------+

| Table     | Op      | Msg_type | Msg_text                                |

+-----------+---------+----------+-----------------------------------------+

| test.temp | analyze | status   | Engine-independent statistics collected |

| test.temp | analyze | status   | OK                                      |

+-----------+---------+----------+-----------------------------------------+

2 rows in set (0.002 sec)

test> ^DBye 

$ sudo mysql test

Reading table information for completion of table and column names         

You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 185809

Server version: 10.6.20-MariaDB-log MariaDB Server

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

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

test> analyze table temp;

+-----------+---------+----------+----------+

| Table     | Op      | Msg_type | Msg_text |

+-----------+---------+----------+----------+

| test.temp | analyze | status   | OK       |

+-----------+---------+----------+----------+

1 row in set (0.001 sec)