Mysql日常运维

Mysql

1、初始化

mysql_install_db --datadir=/mydata_s1

---

2、启动

/usr/bin/mysqld_safe --defaults-file=my.cnf

---

3、登录

1）获取初始密码

cat /var/log/mysqld.log |grep password

2）登入数据库

mysql -S /mydata/mysql.sock  -uroot -p

3）ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

alter user 'root'@'localhost' identified by '123456';

---

4、排查mysql哪个sql占用cpu高

1）top 查父进程

2）top -Hp 父进程

3）查操作系统线程对应语句的信息

SELECT a.name,
       a.thread_id,
       a.thread_os_id,     
       a.processlist_id,   
       a.type,            
       b.user,           
       b.host,            
       b