performance mysql

Case Combing time: 2013-9-25 written in the previous words: In slow-scan optimization 1 and 2 have repeatedly emphasized the importance of explain, but sometimes the naked eye can not see how the explain Results to guide optimization,

Analysis of the Impact of MySQL transaction isolation level on its performance MySQL transaction isolation level is divided into four levels: 1. READUNCOMMITTED & nbs .. Analysis of the Impact of MySQL transaction isolation level on its performance

[Slow query optimization] use MySQL subqueries with caution, especially when you see the DEPENDENTSUBQUERY tag bitsCN.com case study: Preface: I have repeatedly stressed the importance of explain in slow query optimization 1 and 2, but sometimes

MySQL may use temporary tables when executing SQL queries. Generally, using temporary tables means low performance. MySQL temporary tables can be divided into: Memory temporary tables and disk temporary tables, Disks MySQL may use temporary tables

The principle of MYSQL master-slave replication has been clearly explained in the real home Article high-performance Mysql master-slave architecture replication principles and configuration details. Here I will record my operations and my own

http://afei2.sinaapp.com/Book "MySQL must know", very thin, can be read quickly. MySQL performance tuning and architecture design is thin enough to be read quickly. "High-performance MySQL (third edition)", a few of Ali's DBAs

written in the previous words: In slow-scan optimization 1 and 2 have repeatedly emphasized the importance of explain, but sometimes the naked eye can not see how the explain Results to guide optimization, this time also need some other

This time in watching "High performance MySQL", see the storage engine this place feel a lot of details are unfamiliar, so summarize small remember someIn order to adapt to a variety of operating environments, MySQL offers a variety of storage

Objective A few days to take a time to "high-performance MySQL" looked at the index is very important, and then summed up to consolidate knowledge. This article uses the InnoDB storage engine as an index. Because this article does not say that the

1. BackgroundBased on the MySQL InnoDB source code, this paper makes some simple research on how to realize InnoDB non-locking consistency reading.2. Basic Concepts 2.1 hidden fieldsThe implementation of MVCC in MySQL is mentioned in section 1.4 of

The local computer fails to start the MySQL service error 1067 process terminated unexpectedly this situation is generally a My.ini file configuration errorFirst find this file: Default installation pathC:/Program Files/mysql/mysql Server

MySQL's common storage engines are MyISAM, InnoDB, MEMORY, and MERGE. InnoDB provides transaction security tables, and other storage engines are non-transaction security tables. MyISAM is the default storage engine of MySQL. MyISAM does not support

MySQL's common storage engines are MyISAM, InnoDB, MEMORY, and MERGE. InnoDB provides transaction security tables, and other storage engines are non-transaction security tables. MyISAM is the default storage engine of MySQL. MyISAM does not support

Recently, I have been getting familiar with MySQL and it is imminent to understand how to optimize it. To do this, you must first sharpen the tool. Recently, I plan to learn about several frequently used tools to optimize MySQL. Today, I will give a

The previous article briefly introduced the usage of the EXPLAIN statement. Today we will introduce the following: Slow query log Enable slow query log Save slow query logs to the table Slow query log analysis Percona Toolkit Install

The following articles mainly describe the actual operation steps for MySQL to query cache and the description of more than 20 application codes of MySQL to query cache, the following describes how to view the cache size and monitor its performance.

Index optimization for mysql performance optimization, As a free and efficient database, mysql is the first choice. Good secure connection, built-in query parsing, SQL statement optimization, use read/write locks (refined to rows), transaction

Mysqlprofileexplainslow_query_log Analysis and Optimization queries often encounter some SQL problems in performance tests. In fact, the most problems encountered during performance tests over the past few years are the database, which is either

The MYSQL service cannot be started on the local computer. Error 1067: unexpected termination of the process. INI file configuration error first find this file: default installation path C: ProgramFilesMySQLMySQLServer5.1my. ini open this file and

MySQL Performance author: mysqltuner. pl bitsCN.com MySQL Performance author: mysqltuner. pl Performance mysql [root@even ~]# wget http://mysqltuner.pl/mysqltuner.pl[root@even ~]# chmod +x mysqltuner.pl [root@even ~]# cp mysqltuner.pl