Databases Reference
In-Depth Information
| Qcache_queries_in_cache | 73 |
| Qcache_total_blocks | 178 |
+-------------------------+----------+
8 rows in set (0.00 sec)
Qcache_hits
indicates how many queries have been answered directly from the cache.
Over time, you should see a fair number of hits.
The Old Variables Format
You may encounter an older way of specifying variable values from the command line
and in the options file. Under the old way, you'd use the
set-variable=
option from
the command line, as in:
$
mysqld_safe --set-variable=sort-buffer-size=1048576
or in an options file, as in:
set-variable=sort_buffer_size=1048576
This format still works but has been deprecated since MySQL version 4.1. In the new
format, you omit the
set-variable=
; we recommend you use the new method where
possible.
Checking Server Settings
The
SHOW VARIABLES
command lists detailed server configuration settings, including
things like the server version, paths to the different directories and files used by the
server, and maximum concurrent connections. We'll show only a few of them here; try
them on your own server:
mysql>
SHOW VARIABLES;
+---------------------------------+-----------------------------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| version_compile_os | mandriva-linux-gnu |
...
| wait_timeout | 28800 |
+---------------------------------+-----------------------------------------------+
185 rows in set (0.01 sec)
The
mysqladmin variables
command produces the same result from the command line: