Inadvertently see the right way about MySQL, while there is free time to study up, found that there are quite a lot of places on the internet is not detailed enough, the study time also stuck for a while.Usage Prerequisites:
Operating
There are several types of data that represent dates and times in MySQL. Where year represents the years, date represents the dates, time represents the times, and datetime and timestamp represent dates and practices. Their comparison is as
Isolation level of the transaction: READ UNCOMMITTED (UNCOMMITTED)At this level, the changes in the transaction, even if not committed, are visible to other transactions, and the transaction can read uncommitted data. Read COMMITTED (submit
Navicat you choose to dump the structure and data, the resulting SQL file will be larger, because each piece of data will generate an SQL statement, it will cause the use of source restore will be very slow slow very slow,Files that are exported
View query cache condition:mysql> show variables like '%query_cache% '; (Query_cache_type for on indicates already on) +------------------------- -----+----------+| Variable_name | Value |+------------------------------+----------+
Operation Steps:1, Session 1 execution:Start transaction;Select *from T1;2, Session 2 after the completion of the 1th step execution:drop table T1;At this point the DROP statement for session 2 is blocked. So how to analyze view metadata lock?Method:
For the convenience of installation now there are many green version of the MySQL installation package, downloaded after the decompression can be used, but MySQL download directly run or a little problem, you need to register MySQL as a system
MySQL export fast, import a particularly slow solution:Add two parameters to import: Max_allowed_packet; Net_buffer_length--max_allowed_packet the maximum size of the buffer between client/server communication;--net_buffer_length TCP/IP and socket
1. Syntax: Select field list from table name [WHERE clause][group by clause][having clause][order by clause];Annotations:1. The default is to start with the first record ascending,2.desc is descending from the first record3.order by the back can be
1. Display Databaseshow databases;2. Select DatabaseUse database name;3. Display the tables in the databaseShow tables;4, display the structure of the data tabledescribe table name; 5. Display the records in the table SELECT * FROM table name6.
1. Storage structureMyISAM: Each MyISAM is stored on disk as three files. The first file name begins with the name of the table, and the extension indicates the file type. frm file stores the table definition. The data file has an extension of. MYD (
Language classification
1>, DDL (Data Definition Language)A data definition language that defines and manages all objects in a database. Example: Create, Alter, Drop.2>, DML (Data munipulation Language)A data manipulation language used to
Original link: https://m.aliyun.com/bbs/read/300762.htmlMySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limits. Here are 101 tips for adjusting and optimizing MySQL
By default, MySQL only lets you log on locally, and if you want to turn on remote connections, you need to modify the/etc/mysql/my.conf file.I. Modification of/ETC/MYSQL/MY.CONFFind bind-address = 127.0.0.1 this lineChange to bind-address =
This article draws on a number of tutorials already available here to do a groomingThe Chinese configuration reference on the server: http://blog.csdn.net/typa01_kk/article/details/49192245MySQL Configuration Chinese reference:
Detailed analysis of binlog_format mode and configuration in mysql, mysqlbinlog_format
There are three main methods for mysql replication: SQL statement-based replication (SBR), row-based replication (RBR ), mixed-based replication (MBR ). There are
Centos7 mobile mysql5.7.19 data storage location operation method, centos7mysql5.7.19
Scenario: as the data volume increases, the disk of mysql is full and data needs to be moved to a large disk.
Method:
1. Disable mysql Service
service mysqld stop
How to insert batch data to the MySQL database under Node. js, node. jsmysql Database
In the project (nodejs), you need to insert multiple pieces of data to the database at a time. The database is mysql. because of the poor performance of loop
How to solve the problem after entering the password in the MySQL database and entering the password in mysql
Share the problem and solution after entering the password in the MySQL database
1 case study
I have been using the MySQL database to
Mysql master-slave synchronization configuration and mysql master-slave Synchronization
1. Install mysql on two Ubuntu machines1. Check whether mysql is installed in the system.
This is already installed
Run the preceding command if no
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