mysql root@localhost:(none)> show variables like 'innodb_buffer%'
+-------------------------------------+----------------+
| Variable_name | Value |
+-------------------------------------+----------------+
| innodb_buffer_pool_chunk_size | 134217728 |
| innodb_buffer_pool_dump_at_shutdown | ON |
| innodb_buffer_pool_dump_now | OFF |
| innodb_buffer_pool_dump_pct | 25 |
| innodb_buffer_pool_filename | ib_buffer_pool |
| innodb_buffer_pool_in_core_file | ON |
| innodb_buffer_pool_instances | 1 |
| innodb_buffer_pool_load_abort | OFF |
| innodb_buffer_pool_load_at_startup | ON |
| innodb_buffer_pool_load_now | OFF |
| innodb_buffer_pool_size | 134217728 |
+-------------------------------------+----------------+
11 rows in set
Time: 0.019s
mysql root@localhost:(none)> select @@innodb_buffer_pool_size
+---------------------------+
| @@innodb_buffer_pool_size |
+---------------------------+
| 134217728 |
+---------------------------+
1 row in set
Time: 0.008s
mysql root@localhost:(none)> set global innodb_buffer_pool_size=805306368
Query OK, 0 rows affected
Time: 0.006s
mysql root@localhost:(none)> select @@innodb_buffer_pool_size
+---------------------------+
| @@innodb_buffer_pool_size |
+---------------------------+
| 805306368 |
+---------------------------+
1 row in set
Time: 0.008s
mysql root@localhost:(none)> show variables like 'log_error%'
+----------------------------+----------------------------------------+
| Variable_name | Value |
+----------------------------+----------------------------------------+
| log_error | /var/log/mysqld.log |
| log_error_services | log_filter_internal; log_sink_internal |
| log_error_suppression_list | |
| log_error_verbosity | 2 |
+----------------------------+----------------------------------------+
4 rows in set
Time: 0.009s
mysql root@localhost:(none)> show variables like 'log_bin%'
+---------------------------------+-----------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------+
| log_bin | ON |
| log_bin_basename | /var/lib/mysql/binlog |
| log_bin_index | /var/lib/mysql/binlog.index |
| log_bin_trust_function_creators | OFF |
| log_bin_use_v1_row_events | OFF |
+---------------------------------+-----------------------------+
5 rows in set
Time: 0.009s
mysql root@localhost:(none)> show variables like 'slow_quer%'
+---------------------+-------------------------------------+
| Variable_name | Value |
+---------------------+-------------------------------------+
| slow_query_log | OFF |
| slow_query_log_file | /var/lib/mysql/dbhost-2020-slow.log |
+---------------------+-------------------------------------+
mysql root@localhost:(none)> show variables like 'general%'
+------------------+--------------------------------+
| Variable_name | Value |
+------------------+--------------------------------+
| general_log | OFF |
| general_log_file | /var/lib/mysql/dbhost-2020.log |
+------------------+--------------------------------+
111
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
