浅析MySQL数据库常用管理

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqld --console
070608 14:12:04 [Warning] Changed limits: max_open_files: 2048  max_connections:
 800  table_cache: 619
070608 14:12:05  InnoDB: Started; log sequence number 0 956199
070608 14:12:05 [Note] mysqld: ready for connections.
Version: '5.0.27-community'  socket: ''  port: 3306  MySQL Community Edition (GPL)

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqld
   --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini"
070608  9:32:34 [Warning] Changed limits: max_open_files:
  2048  max_connections: 800 table_cache: 619

C:\Program Files\MySQL\MySQL Server 5.0\bin> mysqld --verbose –help

mysql> SHOW VARIABLES;
mysql> SHOW VARIABLES LIKE 'key_buffer_size';
+-----------------+----------+
| Variable_name   | Value    |
+-----------------+----------+
| key_buffer_size | 32505856 |
+-----------------+----------+
1 row in set (0.06 sec)

mysql> show variables like 'sort_buffer%';
+------------------+----------+
| Variable_name    | Value    |
+------------------+----------+
| sort_buffer_size | 10485760 |
+------------------+----------+
1 row in set (0.09 sec)

mysql> SET sort_buffer_size = 5 * 1024 * 1024;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like 'sort_buffer%';
+------------------+---------+
| Variable_name    | Value   |
+------------------+---------+
| sort_buffer_size | 5242880 |
+------------------+---------+
1 row in set (0.00 sec)

mysql> SHOW STATUS;
+-----------------------------------+-----------+
| Variable_name                     | Value     |
+-----------------------------------+-----------+
| Aborted_clients                   | 0         |
| Aborted_connects                  | 0         |
| Binlog_cache_disk_use             | 0         |
| Binlog_cache_use                  | 0         |
| Bytes_received                    | 144       |
| Bytes_sent                        | 13078     |

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin -uroot -p shutdown
Enter password: ******