Learning Mysql

| Qcache_queries_in_cache | 73 |
| Qcache_total_blocks | 178 |
+-------------------------+----------+
8 rows inset 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 |
| backlog | 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 inset sec)
The mysqladmin variables command produces the same result from the command line:

Download 4.24 Mb.

Share with your friends: