快速学习-Linux操作MySQL指令集合

    1  ifconfig
    2  vi /etc/sysconfig/network-scripts/ifcfg-eth0 
    3  vi
    4  vi /etc/udev/rules.d/70-persistent-net.rules 
    5  reboot
    6  ifconfig
    7  vi /etc/sysconfig/network-scripts/ifcfg-eth0 
    8  reboot
    9  ifconfig
   10  service iptables stop
   11  chkconfig iptables off
   12  reboot
   13  ifconfig
   14  vi /etc/my.cnf
   15  service mysqld restart
   16  mysql -uroot -p
   17  ll
   18  mkdir sakila
   19  ll
   20  cd sakila/
   21  rz
   22  yum install lrzsz
   23  rz
   24  ll
   25  pwd
   26  ll
   27  cd ..
   28  ll
   29  pwd
   30  mkdir data
   31  cd data/
   32  pwd
   33  mkdir /usr/local/data
   34  pwd
   35  cd /usr/local/data
   36  ll
   37  pwd
   38  vi /etc/my.cnf
   39  tail -50f /var/lib/mysql/mysql-host-slow.log 
   40   mysqldumpslow -h
   41   mysqldumpslow -v
   42   mysqldumpslow -h
   43   mysqldumpslow -t 10
   44   mysqldumpslow -t 10 /var/lib/mysql/mysql-host-slow.log
   45   mysqldumpslow -h
   46   mysqldumpslow -v
   47   mysqldumpslow -t 10 /var/lib/mysql/mysql-host-slow.log
   48  pt-query-digest -h
   49  yum install perl-DBI
   50  yum install perl-DBD-MySQL
   51  yum install perl-Time-HiRes
   52  yum install perl-IO-Socket-SSL
   53  wget http://pkgs.repoforge.org/perl-TermReadKey/perl-TermReadKey-2.30-1.el3.rf.x86_64.rpm
   54  wget https://www.percona.com/downloads/percona-toolkit/2.2.14/RPM/percona-toolkit-2.2.14-1.noarch.rpm
   55  rpm -ivh percona-toolkit-2.2.14-1.noarch.rpm
   56  wget https://www.percona.com/downloads/percona-toolkit/2.2.16/RPM/percona-toolkit-2.2.16-1.noarch.rpm && yum localinstall -y  percona-toolkit-2.2.16-1.noarch.rpm
   57  /usr/local/bin/pt-query-digest   /var/lib/mysql/mysql-host-slow.log
   58  pt-summary
   59  pt-diskstats
   60  pt-mysql-summary --user=root --password=admin
   61  pt-query-digest  /var/lib/mysql/mysql-host-slow.log
   62  yum list installed | grep mysql
   63  yum -y remove mysql-libs.x86_64
   64  wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
   65  yum install wget
   66  wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
   67  rpm -ivh mysql-community-release-el6-5.noarch.rpm
   68  yum repolist all | grep mysql
   69  yum install mysql-community-server -y
   70  chkconfig --list | grep mysqld
   71  chkconfig mysqld on
   72  chkconfig --list | grep mysqld
   73  service mysqld start
   74  mysql_secure_installation
   75  mysql -uroot -p 
   76  mysql -uroot -p yes
   77  mysql_secure_installation
   78  mysql -uroot -p 
   79  hatlt
   80  halt;
   81  netstat -nltp
   82  mysql -uroot -p
   83  wget https://www.percona.com/downloads/Percona-XtraDB-Cluster-56/Percona-XtraDB-Cluster-5.6.39-26.25/binary/tarball/Percona-XtraDB-Cluster-5.6.39-rel83.1-26.25.1.Linux.x86_64.ssl101.tar.gz
   84  ll
   85  tar -zxvf Percona-XtraDB-Cluster-5.6.39-rel83.1-26.25.1.Linux.x86_64.ssl101.tar.gz
   86  ll
   87  mv Percona-XtraDB-Cluster-5.6.39-rel83.1-26.25.1.Linux.x86_64.ssl101 pt-tools
   88  ll
   89  cd pt-tools/
   90  ll
   91  cd bin/
   92  ll
   93  cd ..
   94  ll
   95  cd sql-bench
   96  ll
   97  cd ..
   98  ll
   99  cd mysql-test/
  100  ll
  101  cd ..
  102  pt-query-digest --help
  103  pt-table-checksum --help
  104  pt-duplicate-key-checker --help
  105  pt-duplicate-key-checker -uroot -padmin -h 127.0.0.1
  106  cd ~
  107  pt-duplicate-key-checker -uroot -padmin -h 127.0.0.1
  108  pt-index-usage -uroot -padmin slow_query_log
  109  pt-index-usage -uroot -padmin /var/lib/mysql/mysql-host-slow.log
  110  /var/lib/mysql/mysql-host-slow.log
  111  pt-index-usage -uroot -padmin /var/lib/mysql/mysql-host-slow.log
  112  halt
  113  vi /etc/sysctl.conf 
  114  vi /etc/security/limits.conf 
  115  pt-index-usage -uroot -padmin /var/lib/mysql/mysql-host-slow.log
  116  /usr/sbin/mysqld --verbose --help | grep -A 1 'default options'
  117  mysql -uroot -p
  118  halt
  119  vi pet.txt
  120  ll
  121  pwd
  122  vi pet.txt 
  123  mysqldump
  124  mysqldump -uroot -p anlimal pet >pet.txt 
  125  ll
  126  more aa.txt 
  127  history