面对一个全新的环境,作为一个mysql dba,首先应该了解什么?（转载）-凯发app官方网站

mysql> status
 
--------------
mysql  ver 14.14 distrib 5.1.34, for unknown-linux-gnu (x86_64) using  editline wrapper
connection id:                25874330
current database:       
current user:               
ssl:                        not in use
current pager:                stdout
using outfile:                ''
using delimiter:        ;
server version:                5.1.34-log source distribution
protocol version:        10
connection:                localhost via unix socket
server characterset:        utf8
db     characterset:        utf8
client characterset:        utf8
conn.  characterset:        utf8
unix socket:                /tmp/mysql.sock
uptime:                        13 days 14 hours 18 min 36 sec
threads: 7  questions: 190708290  slow queries: 19  opens: 57835  flush tables: 1 
open tables: 84  queries per second avg: 162.344
--------------

mysql> show engines;
 
------------ --------- ---------------------------------------------------------------- -------------- ------ ------------
| engine     | support | comment                                                        | transactions | xa   | savepoints |
------------ --------- ---------------------------------------------------------------- -------------- ------ ------------
| innodb     | yes     | supports transactions, row-level locking, and foreign keys     | yes          | yes  | yes        |
| mrg_myisam | yes     | collection of identical myisam tables                          | no           | no   | no         |
| blackhole  | yes     | /dev/null storage engine (anything you write to it disappears) | no           | no   | no         |
| csv        | yes     | csv storage engine                                             | no           | no   | no         |
| memory     | yes     | hash based, stored in memory, useful for temporary tables      | no           | no   | no         |
| federated  | no      | federated mysql storage engine                                 | null         | null | null       |
| archive    | yes     | archive storage engine                                         | no           | no   | no         |
| myisam     | default | default engine as of mysql 3.23 with great performance         | no           | no   | no         |
------------ --------- ---------------------------------------------------------------- -------------- ------ ------------
8 rows in set (0.00 sec)
 
mysql> show plugins;
 
------------ ---------- ---------------- --------- ---------
| name       | status   | type           | library | license |
------------ ---------- ---------------- --------- ---------
| binlog     | active   | storage engine | null    | gpl     |
| partition  | active   | storage engine | null    | gpl     |
| archive    | active   | storage engine | null    | gpl     |
| blackhole  | active   | storage engine | null    | gpl     |
| csv        | active   | storage engine | null    | gpl     |
| federated  | disabled | storage engine | null    | gpl     |
| memory     | active   | storage engine | null    | gpl     |
| innodb     | active   | storage engine | null    | gpl     |
| myisam     | active   | storage engine | null    | gpl     |
| mrg_myisam | active   | storage engine | null    | gpl     |
------------ ---------- ---------------- --------- ---------

mysql> show variables like 'have_ndbcluster';
----------------- -------
| variable_name   | value |
----------------- -------
| have_ndbcluster | no    |
----------------- -------
1 row in set (0.00 sec)

show slave status\g;
show master status\g;

mysql> show variables like 'log%';
--------------------------------- ----------------------
| variable_name                   | value                |
--------------------------------- ----------------------
| log                             | off                  |
| log_bin                         | on                   |
| log_bin_trust_function_creators | off                  |
| log_bin_trust_routine_creators  | off                  |
| log_error                       | /dir/hostname.err    |
| log_output                      | file                 |
| log_queries_not_using_indexes   | off                  |
| log_slave_updates               | off                  |
| log_slow_queries                | on                   |
| log_warnings                    | 1                    |
--------------------------------- ----------------------

mysql> show triggers;
mysql> show procedure status;

mysql> show variables like 'have_part%';
------------------- -------
| variable_name     | value |
------------------- -------
| have_partitioning | yes   |
------------------- -------
1 row in set (0.00 sec)
 
mysql> select table_name from information_schema.partitions where partition_name is not null;

mysql> select * from information_schema.user_privileges where privilege_type='super';
mysql> select host,user,password from mysql.user where password='';
------------- ------ ----------
| host        | user | password |
------------- ------ ----------
| localhost   | root |          |
| 127.0.0.1   | root |          |
------------- ------ ----------
mysql> delete from mysql.user where password='';flush privileges;