First: The firewall used by CentOS 7 is: Firewall not iptablesTo view the ports that are already open: Here I've opened the MySQL port[Email protected] ~]# Firewall-cmd--list-ports3306/tcpOpen port: Prompt success indicates success[Email protected] ~
Integrity constraints---to ensure data integrity and consistencyKEY Point:
Not NULL vs. default
Unique
Primary key
Auto_increment
FOREIGN key
A NOT NULL with default1. Is it possible to emptyNULL NULLNot NULL is not
Download (example: CENTOS7 2.4.4 version, select the appropriate version with https://www.percona.com/downloads/XtraBackup/LATEST/ )wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.4/ binary/redhat/7/x86_64/
Docker container Master node: 172.17.0.9Docker Container Sub-node: 172.17.0.10Asynchronous replication: First confirm that the main library and from the library is consistent, preferably a clean database that has just been initialized if the main
MyISAM and InnoDBMyISAM is the storage engine used before the mysql5.7 version.The advantage is used in the case of high query frequency, such as the data fetch of the website store.The disadvantage is not to support transactions, not suitable for
I. OverviewThe Mysqlshow Client Lookup tool, which can quickly find out which databases exist, the tables in the database, the columns or indexes in the table, are similar to the MySQL client tools, but some features are not available in MySQL
Just starting with MySQL, create a test stored procedure testproc in MySQL Workbench with the following code:
Create PROCEDURE TestProc ()BeginShow variables like '%per_table ';End
Direct Ctrl+shift+enter execution, prompt:
11:00:33 Create
Isolation properties of InnoDB
InnoDB's transaction supports 4 isolation mechanisms, namely READ UNCOMMITTED, read COMMITTED, Repeatable read, and SERIALIZABLE. The default is repeatable READ.
The following is a detailed analysis of the 4 types of
DownloadVisit https://dev.mysql.com/downloads/mysql/Download mysql5.6Unzip after download, see the following directoryInstall start MySQL1.添加环境变量【右键计算机】--》【属性】--》【高级系统设置】--》【高级】--》【环境变量】--》【在第二个内容框中找到 变量名为Path 的一行,双击】 --> 【将MySQL的bin目录路径追加到变值值中,用 ;
1. When working with MySQL, the following error is indicated[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ‘ which is not functionally dependent on columns
First: Chapter One1: Using TransactionsTransaction ; Select * from T1; commit;2: View transaction statusMysql>Show variables like 'autocommit';+---------------+-------+|Variable_name|Value|+---------------+-------+|Autocommit| on |+-------------
Mysql> grant permissions 1, permissions 2,... Permission n on the database name. Table name to User name @ user address identified by ' connection password ';Permissions 1, Permissions 2,... Permission n represents 14 permissions, such as
A. Backup1) Backup tableMYSQLDUMP-UROOT-P Library Name table 1 > E:\backup.sqlMYSQLDUMP-UROOT-P Library Name table 1 table 2 Table 3 > E:\backup.sql2) All tables under the backup libraryMYSQLDUMP-UROOT-P Library name > E:\backup.sql3) backing Up the
Http://www.hellodb.net/2011/07/mysql-linux-hardware-tuning.html
Recently, we have sorted out some experience on optimizing percona, Linux, flashcache, and hardware devices:
Hardware
1. Enable bbwc
Raid cards all have battery backed write cache,
1. Notes on backupIn MySQL 5, if you want to back up data, you must first set the log as follows in my. ini.[Mysqld]
# The TCP/IP Port the MySQL server will listen onPort = 3306Log-bin = "E:/mysql5/log/bin. log"Log-error = "E:/mysql5/log/error.
I recently encountered several times of MySQL service crash and restart. We met twice in a row yesterday.
The first err log:
81122 16:16:47-mysqld got signal 11;
This cocould be because you hit a bug. It is also possible that this binary
Or
Because of the particularity of the hash index structure, the retrieval efficiency is very high, and the index retrieval can be located at a time, unlike B-tree indexes that need to go from the root node to the branch node, the hash index query
Enter Password :******Welcome to the MySQL monitor. commands end with; or \ G.Your MySQL connection ID is 57Server version: 6.0.4-alpha-Community-log MySQL Community Server (GPL)
Type 'help; 'or' \ H' for help. Type '\ C' to clear the buffer.
Mysql>
Performance Comparison Test of MyISAM and InnoDB table storage structures in MySQLMyISAM table. The MyISAM storage format is the default type in MySQL since MySQL version 3.23. It has the following features:■ If the operating system itself allows
When we connect to the MySQL database, we usually add useunicode = true & characterencoding = UTF-8 after the URL, but what do you want to add?
The added function is to specify the encoding and decoding formats of characters.
For example, the
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service