系统表介绍
variables_by_thread 显示线程变量信息
| 列名 | 含义 |
|---|---|
| THREAD_ID | 线程标识符 |
| VARIABLE_NAME | 变量名 |
| VARIABLE_VALUE | 变量值 |
实例
mysql> select * from variables_by_thread limit 10 ;
+-----------+-----------------------------------------+----------------+
| THREAD_ID | VARIABLE_NAME | VARIABLE_VALUE |
+-----------+-----------------------------------------+----------------+
| 38 | auto_increment_increment | 1 |
| 38 | auto_increment_offset | 1 |
| 38 | autocommit | ON |
| 38 | big_tables | OFF |
| 38 | binlog_direct_non_transactional_updates | OFF |
| 38 | binlog_format | ROW |
| 38 | binlog_row_image | FULL |
| 38 | binlog_rows_query_log_events | OFF |
| 38 | block_encryption_mode | aes-128-ecb |
| 38 | bulk_insert_buffer_size | 8388608 |
+-----------+-----------------------------------------+----------------+
10 rows in set (0.00 sec)