https://mdat.biz/dairynews/2019/02/12/696/

クエリーキャッシュ

SHOW VARIABLES LIKE '%query_cache%';
+------------------------------+---------+
| Variable_name                | Value   |
+------------------------------+---------+
| have_query_cache             | YES     |
| query_cache_limit            | 1048576 |
| query_cache_min_res_unit     | 4096    |
| query_cache_size             | 0       |
| query_cache_strip_comments   | OFF     |
| query_cache_type             | ON      |
| query_cache_wlock_invalidate | OFF     |
+------------------------------+---------+

innodb_buffer_pool_size

MariaDB [(none)]> SELECT @@global.innodb_buffer_pool_size;
+----------------------------------+
| @@global.innodb_buffer_pool_size |
+----------------------------------+
|                        134217728 |
+----------------------------------+

1 row in set (0.00 sec)

innodb_log_buffer_size

 MariaDB [(none)]> SELECT @@global.innodb_log_buffer_size;  +---------------------------------+  | @@global.innodb_log_buffer_size |  +---------------------------------+  | 8388608 |  +---------------------------------+

max_allowed_packet

innodb_log_file_size

MariaDB [(none)]> SELECT @@global.innodb_log_file_size;
+-------------------------------+
| @@global.innodb_log_file_size |
+-------------------------------+
|                       5242880 |
+-------------------------------+

トップ   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS