Databases Reference
In-Depth Information
$
mysqladmin --user=root --password=
the_mysql_root_password
variables
+---------------------------------+-----------------------------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------------------------+
| auto_increment_increment | 1 |
...
| wait_timeout | 28800 |
+---------------------------------+-----------------------------------------------+
From the monitor, you can view a subset of the variables by adding a
LIKE
clause:
mysql>
SHOW VARIABLES LIKE 'k%';
+--------------------------+----------+
| Variable_name | Value |
+--------------------------+----------+
| key_buffer_size | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
+--------------------------+----------+
4 rows in set (0.00 sec)
The
SHOW STATUS
command shows you MySQL server status information:
mysql>
SHOW STATUS;
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 8 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 858887090 |
| Bytes_sent | 8535929437 |
...
| Com_insert | 318046 |
...
| Com_lock_tables | 126 |
...
| Com_select | 4541404 |
..
| Com_unlock_tables | 126 |
| Com_update | 153656 |
| Connections | 238544 |
| Created_tmp_disk_tables | 83154 |
| Created_tmp_files | 47 |
| Created_tmp_tables | 128857 |
...
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 6119 |
| Key_blocks_used | 6698 |
| Key_read_requests | 45921497 |
| Key_reads | 35348 |
| Key_write_requests | 1612717 |
| Key_writes | 986186 |
| Max_used_connections | 15 |
