One, MySQL forced lock,Set Table1 to read lock, Table2 to write lock, table3 to read lockLock tables [table1] read,[table2] write,[table3] read;UnlockUnlock tablesIi. Mandatory use of indexesForce INDEXSELECT * from TABLE1 Force INDEX (FIELD1) ...
Configure the primary database:my.cnf:server-id = 1log-bin Restart the database login and view the:[[email protected] ~]# mysql -uroot -p199429mysql> show variables like ' Log _bin '; +---------------+-------+| variable_name | value |+----
For Data Segmentation , we may not be familiar with it, but it is also a very important technology for MySQL database, in this article we will describe in detail the MySQL database Data segmentation knowledge, Next, let's take a look at this part of
Recently debugging a few code, need to keep booting off the server and MySQL. After several successive switches, it cannot be started, and it is closed directly after each boot.The first question is whether the port is occupied, after the port is
One requirement for recent projects is to limit the number of operations logs to 100,000, and more than 100,000 to delete the oldest one, saving no more than 100,000 of the logs in the database.My first thought was to do it through a trigger and
Custom functionsCreating a Custom functionCREATE FUNCTION function_nameRETURNS{STRING | Interger | REAL | DECIMAL}Routine_bodyAbout function bodies
The function body consists of a valid SQL statement
The function body can be a simple select
1, the MySQL official website downloads the Mysql-5.5.53-winx64.msi file and saves to the disk corresponding directory.2. Graphical installation of MySQL database:1) Double click Mysql-5.5.53-winx64.msi, the Welcome screen appears, default, Next:2)
@echo Off &setlocal enableextensions::----------Configuration Items----------:: Backup placement path, plus \ Set Backup_path=E:\Backup:: The name of the database to be backed up, with multiple spaces separating set DATABASES=Test:: MySQL user Name
New User:Create user username; --Create an empty password user.Create user username identified by ' password '; -Create a password when creating a new user.Grant Select[,insert ...] on Mysql.user to username identified by ' password '; --Create a
MySQL BASICS (optimization) 2. mysql basics Optimization
1. Try to avoid using it in the where clause! = Or <> operator. Otherwise, the engine will discard the index for full table scanning.
2. To optimize the query, try to avoid full table scanning.
MySQL sets remote connection, mysql
The basic idea is to add a record for the mysql. user table: 'hadoop '@' % '. In this way, the user 'hadoop' on any host can remotely connect to the MySQL database. Enter the following command:
Mysql> insert
Mysql column-to-row and month-to-month group instances, mysql row-to-group instances
As follows:
SELECT count (DISTINCT (. rect_id) zcount,. job_dept, DATE_FORMAT (submit_date, '% Y-% m') zsubmit_date FROM table name a WHERE. statu = 3 AND. rstatu =
Mysql uses init-connect to add the implementation of the access audit function, mysqlinit-connect
Mysql is first initialized through init-connect and then connected to the instance.
We use this to record the user's thread_id, user name, and user
MySQL disables foreign key constraints of sub-tables. mysql disables foreign key constraints.
Preparation:
Define a instructor table and a student table. reference the instructor table ID in the student table.
Create table teachers (teacherID int
Innodb Engine redo file maintenance method, innodb Engine redo Maintenance
To adjust the size and number of redo log files of innodb, follow these steps:
1. Disable mysql
Mysqladmin-h127.0.0.1-P3306-uroot-p shutdown
2. Modify
Summary of several key points of mysql init_connect, mysqlinit_connect
Init_connect
Init_connect is usually used to perform some operations when a connection comes in, such as setting autocommit to 0, for example, recording the ip source and user
MySQL 5.7.17 tutorial for compiling and installing source code in Mac system, mysql5.7.17
1. Download and unzip to:/Users/xiechunping/Softwares/mysql-5.7.17
: Http://ftp.ntu.edu.tw/pub/MySQL/Downloads/MySQL-5.7/mysql-boost-5.7.17.tar.gz
2. Go to the
Detailed description of MySql slow query analysis and enabling slow query log, detailed description of mysql enabling log
I am also studying MySQL performance optimization recently, so I will take a study note today!
In projects developed by our
Mysqldump instances and mysqldump instances are excluded from database backup.
Note:
Use mysqldump-all-databases to export all databases. However, if the master node dumps data from the master database, we do not need or want information_schema or
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