通过 ps -ef |grep mysql 查找MySQL的信息,结果如下:
[root@localhost mrs_dev]# ps -ef |grep mysql
root 936 1 0 Jun13 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql 1133 936 0 Jun13 ? 01:21:27 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 4928 4883 0 14:57 pts/0 00:00:00 grep mysql
分析查询结果
mysql 1133 936 0 Jun13 ? 01:21:27 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
1. -datadir=/var/lib/mysql 很明显 -datadir就是数据库文件存储地址
打开/var/lib/mysql 这个地址
[root@localhost sbin]# cd /var/lib/mysql
[root@localhost mysql]# ls
auto.cnf ca.pem client-key.pem ibdata1 ib_logfile1 mysqld_safe.pid mysql.sock.lock private_key.pem server-cert.pem sys
ca-key.pem client-cert.pem ib_buffer_pool ib_logfile0 ibtmp1 mysql mysql.sock performance_schema public_key.pem server-key.pem
我们可以看到数据库包含的库
2. --log-error=/var/log/mysqld.log 很明显 log-error就是数据库错误日志存储地址
通过 vi /var/log/mysqld.log 可查看mysql运行错误日志
3.--pid-file=/var/run/mysqld/mysqld.pid 这个文件存放的是mysql 的pid
我们使用 cat /var/run/mysqld/mysqld.pid
[root@localhost mysqld]# cat /var/run/mysqld/mysqld.pid
1133
可以看到MySQL的ID为1133
4.--plugin-dir=/usr/lib64/mysql/plugin 这个其实就是MySQL插件的存放地址,这里我们这里看到
debug 文件夹 ,里边存放的是debug插件
innodb_engine.so 我们由此推断 innodb引擎是MySQL事物一个插件
[root@localhost debug]# cd /usr/lib64/mysql/plugin/
[root@localhost plugin]# ll
total 50708
-rwxr-xr-x. 1 root root 86038 Nov 28 2016 adt_null.so
-rwxr-xr-x. 1 root root 40650 Nov 28 2016 auth_socket.so
-rwxr-xr-x. 1 root root 670808 Nov 28 2016 connection_control.so
drwxr-xr-x. 2 root root 4096 May 3 16:44 debug
-rwxr-xr-x. 1 root root 15645986 Nov 28 2016 group_replication.so
-rwxr-xr-x. 1 root root 343512 Nov 28 2016 ha_example.so
-rwxr-xr-x. 1 root root 685137 Nov 28 2016 innodb_engine.so
-rwxr-xr-x. 1 root root 761474 Nov 28 2016 keyring_file.so
-rwxr-xr-x. 1 root root 293528 Nov 28 2016 keyring_udf.so
-rwxr-xr-x. 1 root root 637537 Nov 28 2016 libmemcached.so
-rwxr-xr-x. 1 root root 7945238 Nov 28 2016 libpluginmecab.so
-rwxr-xr-x. 1 root root 16892 Nov 28 2016 locking_service.so
-rwxr-xr-x. 1 root root 49314 Nov 28 2016 mypluglib.so
-rwxr-xr-x. 1 root root 38158 Nov 28 2016 mysql_no_login.so
-rwxr-xr-x. 1 root root 22598217 Nov 28 2016 mysqlx.so
-rwxr-xr-x. 1 root root 46913 Nov 28 2016 rewrite_example.so
-rwxr-xr-x. 1 root root 619923 Nov 28 2016 rewriter.so
-rwxr-xr-x. 1 root root 693981 Nov 28 2016 semisync_master.so
-rwxr-xr-x. 1 root root 152509 Nov 28 2016 semisync_slave.so
-rwxr-xr-x. 1 root root 205419 Nov 28 2016 validate_password.so
-rwxr-xr-x. 1 root root 346295 Nov 28 2016 version_token.so
[root@localhost plugin]#