performance mysql

Original: High-performance MySQL main memory architectureMySQL Replication(master and Slave Fundamentals and Configuration) master-Slave MySQL working principle:1: Process:(1) MySQL Replication (replication) is an asynchronous replication that

"High Performance MySQL" is a classic good book, from the application layer to the database to the hardware platform, a variety of tuning skills, FAQs are all mentioned. The database of various conceptual skills usually have contact, such as index,

Schema and data type optimization Select an optimized data typeHere are some simple principles: Smaller is usually betterIn general, you should try to use the smallest data types that can be stored correctly. Such as: only need to store 0-20

High performance MySQL reading notes chapter fourth--schema and data type optimization reading notesGood logical and physical design is the cornerstone of high performance, and the schema should be designed according to the query statement that the

1 , MySQL query cacheMany database products are able to cache the execution plan of a query, and the SQL parsing and execution plan generation phases can be skipped for the same type of SQL. MySQL also has a different type of cache: Cache the full

1. LockWhy do I need a lock? Because the database wants to solve concurrency control problems. At the same time, there may be multiple clients working on the same row of records in the table, such as some reading the row data, and other attempts to

High-performance MySQL transaction:Concept: A transaction is a set of atomic SQL queries, a separate unit of work. Statements within a transaction either execute successfully or all fail. Bank Transfer is a classic example of how important it is to

MySQL has a large number of parameters that can be modified--but should not be modified at random. Usually only the basic items are configured correctly (in most cases only a few parameters are really important) and more time should be spent on

High-Performance MySql evolution (14th): Replication (Replication) bitsCN.com Overview The built-in replication function of Mysql is the basis for building large and high-performance applications. This distribution mechanism replicates data from a

High-performance MySQL Reading Notes-lock, transaction, isolation level1. Why should I lock the lock? Because the database needs to solve the concurrency control problem. At the same time point, multiple clients may operate on the same row of

High-Performance MySQL front-end Vtocc bitsCN.com Vtocc is the first available product of vitess. as the front-end of MySQL, it provides an RPC Interface to receive and convert SQL statements. It provides efficient multi-channel large-scale database

High-Performance MySql evolution (10): Limitations of the query optimizer bitsCN.com The article "common methods of the query optimizer" lists some common optimization methods of the optimizer. The query optimizer also has some limitations while

High-Performance MySql evolution (11): Optimization of common query statements bitsCN.com Summarize the optimization methods of common query statements.1 COUNT 1. Functions of COUNT · COUNT (table. filed) indicates the number of records for which

High-Performance MySQL reading notes find out who holds the lock bitsCN.com problem background: in actual use of MySQL, if the access volume is large, it is likely that there will be a large number of Locked state processes, however, it is not easy

First: Chapter One1: Using TransactionsTransaction ; Select * from T1; commit;2: View transaction statusMysql>Show variables like 'autocommit';+---------------+-------+|Variable_name|Value|+---------------+-------+|Autocommit| on |+-------------

6th, optimize the configuration https://www.cnblogs.com/musings/p/5913157.html1: The server reads the configuration file, which can be queried using the following commandAdmin@iZwz92c0zpe8t65qe996ckZ:~$ which mysqld/usr/sbin/ MysqldUsing the MYSQLD

MySQL supports a large number of data types, so choosing the right data type is critical to getting high performance. Then understand the pros and cons of various types first!First, type introduction1. Integral type　　The integral type is:

MySQL server logical architecture diagram is as follows:Currently working with version 5.5, version 5.5 starts MySQL to start with InnoDB as the default storage engine, and InnoDB tables are based on clustered indexes.MySQL Storage Engine lock

MySQL Replication(master and Slave Fundamentals and Configuration) master-Slave MySQL working principle:1: Process:(1) MySQL Replication (replication) is an asynchronous replication that replicates from one MySQL node to another MySQL node. The

Type-relatedInt (1) and int (20) have the same meaning for storage and computation, and he does not limit the legal scope of a value, but some interactive tools are used to display the number of charactersThe default is signed, can be specified as