1 categories of variable 1.1 variables
System variables:
Global variables:
Session Variables:
Custom variables:
User variables:
Local variables:
1.2 Basic introduction to System
Configure MySQL master-slave under native DockerInstall the Docker MySQL container first$ docker pull MySQL:5.6Pull two identical versions of MySQLStart MySQL separately and set the root user password to admin:// Master MySQL 3307:3306-d-e
The MySQL database was initialized with a hint of Perl and data missing::d umperYou need to install two packages at this time,Yum Install PerlYum Install autoconfPrompt InnoDB database file size error when initializing MySQL database 2018-08-28 18:01
Turn on slow query logAdd two configuration parameters under the [mysqld] line in the configuration file my.cnf or My.iniSlow_query_log = on #开启慢查询long_query_time=1 #设置慢查询时间 1 s Slow_query_log_file="d:/phpstudy/mysql/data/slow_query.log"
MySQL server is the most popular database management system.A database is a warehouse that organizes, stores, and manages data according to its structure.MySQL database is the data in the form of a table, each behavior record name, each column
I. Specifying a pathIn the previous article, the binary package was unzipped, all put in the/usr/local/mysql directory, at the time of installation to specify the base directory and data directory,--basedir=/usr/local/mysql--datadir=/usr/local/mysql/
Before I installed the MySQL database, because my MySQL is not installed in the standard/usr/local/mysql directory, but installs in the/usr/local/development/ The mysql-5.5.25 directory causes the error to report that the/usr/local/mysql directory
--Authorize a user (Zhangsan) password 123, you can do all the operations on all the libraries, all the tables.Mysql> Grant All on * * to [e-mail protected] '% ' identified by ' 123 ';Query OK, 0 rows affected (0.17 sec)-The refresh takes effect,
Example tablecreate table tb_demo( id int unsigned auto_increment primary key, title varchar(50) not null default '', contents text, add_time int unsigned default 0);Inserting test datainsert into tb_demo (title,contents,add_time) values ('#1
Four types of features:Atomicity (atomicity): All operations in a transaction are treated as a collation, either complete or all rolled back.Consistency (consistency): The data in the database is logically consistent before and after the operation.
Compiling the installation database (MySQL)First download the MySQL tar package,www.mysql.com DownloadI'm using mysql5.6.41 's tar package.Put the bag in the/usr/local directory.useradd -s /sbin/nologin mysql 创建mysql用户mkdir -p /data/mysql/data
The syntax for the aggregation operation is as follows:--SELECT [field1,field2,...... fieldn] Fun_name-From TableName--[WHERE where_contition]--[GROUP by Field1,field2,...... fieldn--[with ROLLUP]]--[Having where_contition]--The following
error message:Error Updating database. Cause:com.mysql.jdbc.PacketTooBigException:Packet for query is too large (5872 > 1024). You can change this value on the server by setting the Max_allowed_packet ' variable.Workaround:Go to MySQLEnter show
Basic command:1 command to add '; ' Indicates the end of the command -2mysql> statusCheck current login information, MySQL version information -3Mysql> Helpfrequently used help commands -4Mysql> select version ();MySQL version information -5Mysql>
Choose the right data typeWhen using MySQL to create a data table, you will encounter a problem, how to choose the appropriate data type for the field. For example, to create an employee information table, each field can be defined in many different
1 Download and install the official MySQL Yum RepositoryDownload Install Yum Repository Wget-i-C http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpmYum Installation Yum-y Install mysql57-community-release-el7-10.noarch.rpmStart
In the project to do, you draw the area graph, and store it up, there is the need for updates, the storage file is not, think of the database now support the spatial database.MySQL is now used to continue to use MySQL to store and manage spatial
The index condition push (ICP) is an optimization of how MySQL uses an index to retrieve rows from a table. Without an ICP, the storage Engine traverses the index to find rows in the base table and returns them to the MySQL server, which evaluates
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