best operations management books

Tags: multiple mysql configuration port slow query log basic SQL statement Internet password Backup Get in Mysql:mysql–uroot–p. Restart database: [[email protected] ~]#/etc/init.d/mysqld restart1.Mysql forgot root password View MySQL's database Change root password2.skip-name-resolve (skip domain name resolution, only allow IP parsing, MySQL speed boost)SKIP-INNODB (skip Data Engine)3. Configure slow query log (view SQL statement run efficiency) 1 seconds, one record.4.innodb and MyISAM　http:/

permission to access the data table1143: The current user does not have permission to access fields in the datasheet1146: Data table does not exist1147: User access to the data table is undefined1149:sql statement Syntax error1158: Network error, read error, please check network connection status1159: Network error, read timeout, check network connection status1160: Network error, write error, please check network connection status1161: Network error, write timeout, please check network connect

, localhost by default--no-data,-D: Export table structure only--password[=password],-p[password]: password--port=port_num,-P Port_num: Port number when making TCP/IP connections--quick,-Q: Quick Export--tables: Overwrite--databases or-b option, followed by parameter is considered as table name--user=user_name,-u user_name: User name--xml,-X: Export as XML fileExtract:Import data:Since mysqldump exports a complete SQL statement, it is easy to import the data using the MySQL client program:MySQL

5.7 cloning a virtual machine 1) Close the virtual machine to be cloned2) Find clone options3) Welcome page4) cloning a virtual machine5) set to create a full clone6) set the cloned virtual machine name and storage location7) waiting to be cloned8) Click Close to complete cloning9) Modify the IP of the virtual machine after cloning[[email protected]/] #vim/etc/udev/rules.d/70-persistent-net.rulesGo to the following page, delete eth0 the row, modify eth1 to eth0, and copy the physical IP address