MySQL常用指令,java,php程序员,数据库工程师必备。程序员小冰常用资料整理MySQL common commands (for reference)The most common display commands are:1. Display the list of databases.show databases;2. Display the data table in the library:Use MySQL;Show tables;3, display the
1. Full backup and incremental backup 1.1 full-scale backupFull-volume data is all the data in the database, and a full backup is the backup of all the data in the database.Back Up all libraries:mysqldump -uroot -p123456 -S /data/3306/mysql.sock -F -
How to configure MySQL database server on CentOS
BitsCN.com accidentally found CentOS Professional Forum, remember: http://www.centospub.com
As a result, the initial learning configuration
This environment:
CentOS system,
Mysql-server (version
1. download MySql
1. download MySql
Open http://www.mysql.com/downloads/mysql/#downloads download in browser
My downloaded version is Red Hat 5 version of http://www.mysql.com/downloads/mirror.php? Id = 407552
Upload the file to the server, or
mysql> show global status; Can list MySQL server running various status values, my personal preferred usage is show status like ' query value% '; One, slow query mysql> show variables like '%slow% '; +------------------+-------+ | variable_name
Backup features:
A quick copy of the file, which can only run on the machine where the database directory is located, perform lock tables and UNLOCK tables online, and restore with only copy backup files to source directory coverage.
Insufficient:
1. View MySQL server configuration informationMysql> Show variables;2. View the various status values running on the MySQL serverMysql> show global status;3, slow query1. mysql> show variables like ‘%slow%‘; 2. +------------------+-------+ 3. |
The Lock Tables command locks the table for the current thread. Here are 2 types of locks, one is read lock, with command lock tables TableName read, another is write lock, with command lock tables tablename Write. The following are described
1. Enter the Mysqladmin processlist into the Mysql/bin catalogue;
2. Start MySQL, enter show Processlist;
If you have SUPER permissions, you can see all of the threads, otherwise you can only see the thread that you originated (this is the current
MySQL performance tuning and Architecture Design-Chapter 1 Performance Design-MySQL Replication and replication Optimization
Chapter 1 scalability design-MySQL Replication
Preface:
MySQL Replication is a unique feature of MySQL. It can completely
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.