mysql起動構成の表示方法

1316 ワード

1、ps -ef|grep mysql
ss:mysql wqp$ ps -ef|grep mysql
  501 11054     1   0 12:27   ttys002    0:00.02 /bin/sh /usr/local/Cellar/mariadb/10.1.13/bin/mysqld_safe --datadir=/usr/local/var/mysql --pid-file=/usr/local/var/mysql/ss.pid
  501 11169 11054   0 12:27   ttys002    0:00.39 /usr/local/Cellar/mariadb/10.1.13/bin/mysqld --basedir=/usr/local/Cellar/mariadb/10.1.13 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mariadb/10.1.13/lib/plugin --log-error=/usr/local/var/mysql/ss.err --pid-file=/usr/local/var/mysql/ss.pid --socket=/tmp/mysql.sock --port=3306
  501 11181 10425   0 12:30   ttys002    0:00.00 grep mysql
  501 10214 10198   0 10:39   ttys004    0:00.02 mysql -uroot -px

2、show variables
SHOW VARIABLES;

3、位置付けmy.cnfの位置表示構成
locate my.cnf;

4、mysqld --print-defaults
ss:~ wqp$ mysqld --print-defaults
mysqld would have been started with the following arguments:
--port=3306 --socket=/tmp/mysql.sock --skip-external-locking --key_buffer_size=16M --max_allowed_packet=1M --table_open_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --log-bin=mysql-bin --binlog_format=mixed --server-id=1