日韩国产精品99成人不卡在线无毒|狠狠躁夜夜爽一级二级精品|亚洲日日噜噜孕妇中文字幕|日韩久草中文三级片

mysql 22:57:49> show variables like '%buffer%size%';
+-------------------------------+-------------+
| Variable_name                 | Value       |
+-------------------------------+-------------+
| bulk_insert_buffer_size       | 8388608     |
| clone_buffer_size             | 4194304     |
| innodb_buffer_pool_chunk_size | 134217728   |
| innodb_buffer_pool_size       | 21474836480 |
| innodb_change_buffer_max_size | 25          |
| innodb_log_buffer_size        | 8388608     |
| innodb_sort_buffer_size       | 1048576     |
| join_buffer_size              | 16777216    |
| key_buffer_size               | 134217728   |
| myisam_sort_buffer_size       | 134217728   |
| preload_buffer_size           | 32768       |
| read_buffer_size              | 16777216    |
| read_rnd_buffer_size          | 33554432    |
| sort_buffer_size              | 16777216    |
+-------------------------------+-------------+
14 rows in set (0.00 sec)

mysql 22:57:45> show variables like '%cache%size%';      
+----------------------------+----------------------+
| Variable_name              | Value                |
+----------------------------+----------------------+
| binlog_cache_size          | 32768                |
| binlog_stmt_cache_size     | 32768                |
| host_cache_size            | 1003                 |
| innodb_ft_cache_size       | 8000000              |
| innodb_ft_total_cache_size | 640000000            |
| key_cache_block_size       | 1024                 |
| max_binlog_cache_size      | 18446744073709547520 |
| max_binlog_stmt_cache_size | 18446744073709547520 |
| thread_cache_size          | 64                   |
+----------------------------+----------------------+
9 rows in set (0.01 sec)

 show tables like '%memory%';
+-----------------------------------------+
| Tables_in_performance_schema (%memory%) |
+-----------------------------------------+
| memory_summary_by_account_by_event_name |
| memory_summary_by_host_by_event_name    |
| memory_summary_by_thread_by_event_name  |
| memory_summary_by_user_by_event_name    |
| memory_summary_global_by_event_name     |
+-----------------------------------------+
5 rows in set (0.00 sec)

select substring_index(event_name,'/',2) as code_area, sys.format_bytes(sum(current_alloc)) as current_alloc from sys.x$memory_global_by_current_bytes group by substring_index(event_name,'/',2) order by sum(current_alloc) desc ;

+---------------------------+---------------+
| code_area                 | current_alloc |
+---------------------------+---------------+
| memory/innodb             | 21.11 GiB     |
| memory/performance_schema | 283.57 MiB    |
| memory/mysys              | 130.72 MiB    |
| memory/sql                | 74.98 MiB     |
| memory/temptable          | 67.00 MiB     |
| memory/mysqld_openssl     | 1.96 MiB      |
| memory/myisam             |  696 bytes    |
| memory/csv                |   88 bytes    |
| memory/blackhole          |   88 bytes    |
| memory/vio                |    8 bytes    |
+---------------------------+---------------+
10 rows in set (0.01 sec)