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