performance mysql

Tuning mysql Network Performance Debugging Tool article bitsCN.com this article is an article about Linux system network performance management skills, this section describes how to use route, netstat, and tcpdump network management testing tools

Debugging Tool for tuning mysql Network Performance: This article describes the network performance management skills of Linux systems, this section describes how to use route, netstat, and tcpdump network management testing tools and their

Eight methods to optimize MySQL database performance: bitsCN.com 1. select the most suitable field attributeMySQL can support access to large data volumes, but generally, the smaller the table in the database, the faster the query will be executed

Use mysqlshowprofiles to analyze SQL performance bitsCN.com Mysql show profiles is added after 5.0.37 to analyze SQL performance. to use this function, make sure that the version is later than 5.0.37. Check my database version mysql> Select version (

You can use the SQL Server regulator (SQLServerProfiler) tool to collect important information about the current server activity. The information tracked by this Profiler tool (including the real load of the database) can be used in multiple

At the early stage of application system development, due to the relatively small amount of data in the development database, the performance of SQL statement writing is not good for Querying SQL statements and writing complex views, however, after

This article mainly introduces MySQL transaction isolation and its impact on performance. it has some reference significance in MySQL optimization, you can refer to the SQL standard to define four types of isolation levels, including specific rules

Five configuration parameters that affect MySQL Performance: bitsCN.com The following articles mainly introduce the five configuration parameters that closely affect MySQL Performance. I saw the five configuration parameters that closely affect

Autocommit MySQL is automatically submitted by default. You can view and modify it using the following command: Mysql> show variables like 'autocommit ';+ --------------- + ------- +| Variable_name | value |+ --------------- + ------- +|

In the early development of the application system, because the development of database data is relatively few, for query SQL statements, complex view of the compilation, just start will not realize the performance of the various writing of SQL

The MySQL query cache saves the full results of the query return. When the query hits the cache, the result is immediately returned, skipping the parsing, optimization, and execution phases. The query cache tracks each table involved in the query,

As long as the description of several day-to-day use of the query can be optimized place, only special circumstances can be used, do not expect any circumstances are set up, optimization is a long process of practice! Optimization of maximum and

I. Pitfalls in Design 1, too many columns The MySQL storage Engine API works by copying data between the server layer and the storage engine layer through a row buffer format, and then decoding the buffered content into columns at the server layer.

In practical applications, there are 3 ways to analyze a single query SQL performance: Show status, show profiles, and slow query logs. First, use show profile 1, the default is disabled, open in the session #开启profileSet profiling=1; 2. When a

I. Analysis of MySQL Query 1, first from the slow query start, slow query is the lowest cost, the most accurate measurement of query Time tool. A, start MySQL slow query, modify my.conf [Mysqld] #开启慢查询 log_slow_queries = on #指定日志文件存放位置, can be

There are some configuration items that affect how MySQL synchronizes data to disk and how to do recovery operations. This write operation has a great impact on performance because it is designed to expensive I/O operations, usually ensuring that

The best way to understand indexes is to combine examples and then analyze an example. Suppose you want to design an online dating site with many columns, including country, region, city, sex, eye color, and so on. The Web site must support a

Configuring a MySQL server is inseparable from the configuration file, and then it starts with this section of the content. Be sure to know the location of the configuration file first, and if you don't know, you can try the following:

One, compressed index MyISAM uses prefix compression to reduce the size of the index, by default compressing only strings, but by setting it can also compress integers. Compression can use less space, at the expense of some operations that may be

The advantages of the index 1, the index can greatly reduce the amount of data the server needs to scan 2, the index can help the server avoid sorting and temporary tables. 3, the index can turn I/O into sequential I/O Second, indexing strategy