SHOW VARIABLES LIKE '%local%';
时间: 2024-05-25 17:07:43 浏览: 182
这是一条MySQL语句,可以用来查看所有以“local”为关键字的系统变量和用户变量。下面是该语句的示例和结果:
```sql
SHOW VARIABLES LIKE '%local%';
```
结果:
```
+--+--------------------------------------------------------+
| Variable_name | Value |
+----------+
| have_ssl_local_engine | DISABLED |
| local_infile | ON |
| local_infile_timeout | 3600 |
| local_net_timeout | 60 |
| master_info_repository | FILE |
| mysql_firewall_local_rules | |
| mysqlx_local_bind_address | * |
| mysqlx_local_socket | /var/lib/mysql/mysqlx.sock |
| performance_schema_events_waits_history_long_size | 10000 |
| rpl_semi_sync_master_local_bind_address | |
| rpl_semi_sync_master_local_service | |
| rpl_semi_sync_master_local_wait_for_slave_count | 2 |
| rpl_semi_sync_master_local_wait_no_slave | ON |
| rpl_semi_sync_master_local_wait_point | AFTER_SYNC |
| rpl_semi_sync_slave_local_service | |
| rpl_semi_sync_slave_trace_level | 32 |
| rpl_semi_sync_slave_trace_service_name | |
| tls_verify_server_cert | OFF |
+----------+
```
阅读全文