This document is to help develop and OPS to use MySQL database in accordance with the specification, improve the level of research and development writing SQL. Committed to providing a secure, stable, high-performance database environment. naming
First, System variablesDescription: Variables are defined by the system, not user defined, and belong to the server levelNote: Global variables need to be added to the GLOBALS keyword, session variables need to be added to the sessions keyword, if
Solution 1:1. Turn off MySQL# Service Mysqld Stop2. Blocking permissions# Mysqld_safe--skip-grant-tables3. Start a new terminal input# mysql-u Root MySQLMysql>update Mysql.user Set Authentication_string=password (' 123456 ') where user= ' root
In the Apache, PHP, MySQL architecture, MySQL has the greatest impact on performance and is a key core. For the discuz! Forum program is also the case, MySQL settings are reasonable optimization, directly affect the speed and capacity of the forum!
I. OverviewIn the database, the data belongs to the shared resources, in order to guarantee the consistency of concurrent access, the validity of the lock is generated. Next, we focus on the features of the MySQL lock mechanism, common locking
Use of Mysqldumpslow:For example, we want to query the first 5 log messages by time, in the following format:Mysqldumpslow-s t-t 5/var/log/mysql/slowquery_20180303.logParameter description:-S: Sort by lock time L, number of records returned R, query
Set a password for the root user of MySQL1. The newly installed MySQL does not have a password set2. Set the password*************************************************************************************************************** *********************
About MySQL deleting data after the physical space is not released OPTIMIZE TABLE When you delete a large amount of data in your library, you may find that the data file size is not reduced. This is caused by a fragment left in the data file after
When we use MySQL to import large file SQL, we may report the MySQL server has gone away error, the problem is that the default value of Max_allowed_packet configuration is too small, only need to increase the value of the key after the import again
Based on point-in-time and location recoveryThe use of binary log can be implemented based on time and location recovery, for example, due to the deletion of a table by mistake, the full recovery is useless, because there is still error in the log,
The whole MHA cluster environment construction process demonstrates one. Lab Environment DescriptionInstalling the MHA operation stepsThe MHA node contains three scripts, dependent on the Perl module.Save_binary_logs: Save and copy the lost primary
Database-relational database (RDBMS): Oracle mysql DB2 SQL Server Sybase ... Advantages: Easy to understand, easy to use, consistent data, read and write real-time data consistent: The transaction either all succeeds, or all fails; in our database,
MySQL [email protected]-PEnter Password:ERROR 1862 (HY000): Your password has expired. To log the must change it using a client that supports expired passwords.ModifyVim/etc/my.cnfdatadir=/home/mysql/dataport = 3306user =
Source organized in Https://www.cnblogs.com/wanghuaijun/p/6398240.htmlUnder Virtual machine CentOS6.8Run the command first to see if the directory exists in the MySQL folder: Cd/usr/local re-enter LLIf there isExecute the Delete command
MySQL comes with tool use introduction:1) MySQL command: MySQL command is the most used command tool, providing users with a command line interface to operate the server to manage MySQL.Command format:Usage:mysql [Options][database]Example: Mysql-e "
Master-Slave Introduction
MySQL master-slave is also called replication, AB replication. Simply said that A and b two machines from the back, on a to write the data, the other B will follow the writing data, the two data in real-time
工欲善其事, its prerequisite! The operation of the database also requires good tools, learning process has been using NAVICAT to operate, feeling very useful.Always use mouse punctuation is also more trouble, so search summary of the use of shortcut keys,
Key characteristics of Mycat key Features
Support SQL92 Standard
Common SQL syntax support for MySQL, Oracle, DB2, SQL Server, PostgreSQL, etc. db
Adhere to MySQL native protocol, cross-language, cross-platform, cross-database generic
When creating a table, there is a field of type timestamp, and the default value is ' 1970-01-01 00:00:01 ', which cannot be inserted字段 timestamp NOT NULL DEFAULT ‘1970-01-01 00:00:01‘Workaround:Set MySQL time_zone to UTC time zoneset global
Python simulation data (MySQL database) data simulationPurpose: Simulates the insertion and querying data of multiple tables, then tests server performance and collects data through benchmark scripts, simulating simulations.
Note:If you
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