MySQL

Good mysql Union table multi-Table query. In previous queries, you can directly select * from tablea as a, tableb. as B where. cc = B. cc. today, I will share a novel way of writing, and the execution efficiency of hundreds of thousands of data is

SQL optimization suggestion Memorandum 1. SQL comments generally do not increase performance overhead, and can enhance readability 2. The transaction should be brief www.2cto.com 3. Avoid cursor operations because the cursor occupies a large amount

MYSQL's MERGE storage engine MYSQL engine is not generally many. This time we talk about MERGE, which has many special features: the www.2cto.com MERGE engine type allows you to MERGE many tables with the same structure into one table. Then, you can

Some Problems in mysqlslap output information: After adding debug-info to mysqlslap, in addition to the direct test results, some information about the test environment is also output. Www.2cto.com mainly includes: system time: time spent in kernel

ERROR 1201 (HY000): The problem of cocould not initialize master info structure today encountered an ERROR 1201 (HY000): cocould not initialize master info structure during MySQL master-slave replication. the reason for this problem is that you have

How to view mysql connection parameters 1. view the details of all current connections :. /mysqladmin-uadmin-p-h10.140.1.1 processlist www.2cto.com 2. view only the current number of connections (Threads is the number of connections .) :.

Mysql exercise Alter usage summary alert usage Summary: alter database syntax alter database is used to change the global features of a DATABASE. These features are stored in the db. opt file in the database directory. To use alter database, you

It is important to specify the encoding and sorting rules when creating a database in MYSQL. Many developers use the default encoding, but from my experience, coding databases can avoid garbled characters caused by import and export. Www.2cto.com

MySQL query optimization: Connection query sorting limit (join, order by, limit statements) does not know if anyone has encountered such a disgusting problem: two tables are connected for query and limit, and the SQL efficiency is very high,However,

To solve the problem that other MySQL machines cannot connect to mysql, we recently encountered various problems during MySQL configuration. Let's summarize them. After installing www.2cto.com mysql, the local machine can be connected, but other

Mysql max_allowed_packet queries and modifies the size of data packets received by the server according to the configuration file. Sometimes large inserts and updates are limited by the max_allowed_packet parameter, resulting in failure. View the

Mysql index learning Notes 1. advantages and disadvantages of indexes: speeding up the query speed and downgrading: it affects the rate of table deletion and modification operations and increases the file size (the index file may be larger than the

Mysql for cainiao: adding, modifying, and deleting ColumnsTest data:   I. Column addition:1. alter table name column DeclarationThe added columns are at the end of the table by default.   2. You can use "after" to specify which columns are behind

Mysql Chinese garbled characters and export as SQL statements and Excel problems solvedI wrote a crawler based on Heritrix over the past few days and used mysql to import and export data. When I encountered some garbled code problems, it was hard to

Common Xtrabackup parameters during Hot Backup are as follows: -- defaults-file = # default configuration file path. If the parameter is not set, xtrabackup searches for the configuration file/etc/my. cnf,/etc/mysql/my. cnf,/usr/local/etc/my. cnf ,~

How does MySQL modify the character set of a table and the character set of a field? If you want to change the character set of the table's default character set and all character columns to a new one, use the following statement: alter table

EXPLAIN for query optimization different SQL statement writing methods often lead to great performance differences. How can we know the SQL query execution overhead? MySQL provides the EXPLAIN keyword for us. When you add the EXPLAIN keyword before

[Architecture] MySQL Log File-slow query log as the name suggests, in the slow query log, a threshold value can be set for a query with a long execution time. All SQL statements whose running time exceeds the threshold value are recorded in the slow

In the hot standby server, switching SQL from the master node fails in the master node. When a Hot Standby server needs to be switched in time, the original Server Load balancer under the master node also needs to be switched to the new master

How to smoothly "restart" mysql note that the restart in the title is a mysql server in the production environment with quotation marks. Generally, it is necessary to avoid restarting as much as possible, but it is time-consuming to face the slow