a p1 mysql启动

[root@bogon mysql]# /data/app/mysql/bin/mysqld_safe --user=mysql&  安全方式启动 [root@bogon mysql]# /data/app/mysql/share/mysql/mysql.server [start|stop|restart]   推荐这种方式

2 创建数据库插入表

mysql> create database bbs;

Query OK, 1 row affected (0.01 sec)

mysql> use bbs;

Database changed

mysql> create table t1 (name varchar(20),age int(3),job varchar(20));

Query OK, 0 rows affected (0.10 sec)

mysql> insert into t1 values("xiaochang",20,"IT");

Query OK, 1 row affected (0.00 sec)

mysql> show tables;

+---------------+

| Tables_in_bbs |

+---------------+

| t1            |

+---------------+

1 row in set (0.00 sec)

mysql> select * from t1;

+-----------+------+------+

| name      | age  | job  |

+-----------+------+------+

| xiaochang |   20 | IT   |

+-----------+------+------+

1 row in set (0.00 sec)

重点：

在mysql外面插入1000条语句

[root@bogon ~]# for i in `seq 10 1000`;do mysql -uroot -p123456 -e "use bbs;insert into t1 values('xiaoliu$i',20,'IT' );";done

注意：`seq 10 1000`之间的｀ 这个标点符号是1旁边的那个，一定要注意

3 慢查询

mysql> select * from t1 where name like "%xiaoliu1%";

a 查看当前mysql慢查询

mysql> show variables like "%slow%";   //查看当前mysql慢查询

+---------------------------+-------------------------------+

| Variable_name             | Value                         |

+---------------------------+-------------------------------+

| log_slow_admin_statements | OFF                           |

| log_slow_slave_statements | OFF                           |

| slow_launch_time          | 2                             |

| slow_query_log            | OFF                           |

| slow_query_log_file       | /var/lib/mysql/bogon-slow.log |

+---------------------------+-------------------------------+

5 rows in set (0.01 sec)

b 开启慢查询日志方法

mysql> set global slow_query_log=on;

Query OK, 0 rows affected (0.01 sec)

mysql> show variables like "%slow%";

+---------------------------+-------------------------------+

| Variable_name             | Value                         |

+---------------------------+-------------------------------+

| log_slow_admin_statements | OFF                           |

| log_slow_slave_statements | OFF                           |

| slow_launch_time          | 2                             |

| slow_query_log            | ON                            |

| slow_query_log_file       | /var/lib/mysql/bogon-slow.log |

+---------------------------+-------------------------------+

| slow_launch_time | 2 |  超过2秒定义为慢查询。

| slow_query_log | OFF |  慢查询关闭状态。

| slow_query_log_file | /data/mysql/var/db-Test2-slow.log | 慢查询日志的文件。

c  

mysqldumpslow分析日志

[root@bogon mysql]# mysqldumpslow -s r -t 10 /var/lib/mysql/bogon-slow.log 

Reading mysql slow query log from /var/lib/mysql/bogon-slow.log

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), 0users@0hosts

3  mysql启动命令

 [root@bogon log]# service mysqld start

 Redirecting to /bin/systemctl start  mysqld.service

 [root@bogon log]# service mysqld stop

Redirecting to /bin/systemctl stop  mysqld.service


4 mysql查询日志

  如果不知道mysql的log日志在哪里，找到my.cnf里面会有定义

  yum安装的log在[root@bogon log]# cd /var/log/

  [root@bogon log]# tail -fn 100 mysqld.log |more  //查看日志信息

  [root@bogon log]# cat /dev/null >mysqld.log      //将log文件写空

5 在mysql外面查询主从是否正常（以数值的方式）

[root@192 ~]# mysql -uroot -p123456 -e "show slave status\G"|grep "Yes"|wc -l

Warning: Using a password on the command line interface can be insecure.

2

[root@192 ~]# mysql -uroot -p123456 -e "show slave status\G"|grep -c "Yes"

Warning: Using a password on the command line interface can be insecure.

2