mysql performance

Home page of http://blog.csdn.net/uestc_huan/article/category/536350 Bo Masterhttp://blog.csdn.net/uestc_huan/article/details/6071081 Blog AddressThis article does not explain how MySQL server parameters are set from a DBA perspective, but from the

Yesterday in the test operation of the database encountered two problems forgot to record, today add up, connect to the article1. Installing the test database Sakila times wrong. Mysql server has gone away problem. Workaround:View show global

Optimization of Max ()For example: Explain select Max (' Payment_date ') from payment; The number of rows that can be viewed to row is very much, which means that the entire table is scanned.Add an index to payment_date.CREATE INDEX Idx_payment on

Address of this articleShare an outline:1. Optimize your query for query caching 2. EXPLAIN your SELECT query 3. Use LIMIT 1 4 when only one row of data is used. Jianjian index 5 for search word. In the join table, use a fairly type of example and

2.1mysql Physical File composition 2.1.1 Log files:1. View MySQL config file: mysql--verbose--help | Grep-a 1 ' Default options ';1, error log:--log-error[=file_name] Specify error log location2, binary log:--log-bin[=file_name] If file_name is not

Scene:Simulate a day's data, each 10 seconds, traverse 1000 devices, each device simulates a real-time data, the total amount of data is: 24*60*60/10*1000 = 8.64 million records.------------------------------------------------------------------------

Today, database operations are increasingly becoming a performance bottleneck for the entire application, which is especially noticeable for web applications. It's not just about the performance of the database that DBAs need to worry about, it's

As we have just said, there will inevitably be some disappointments in our lives. For example, we use a string-type field as the primary key. On the surface, this is not satisfactory. However, it turns out to be useful. As we have just said, there

[SQL] MySQL performance optimization 1. Optimize the query cache. Most MySQL servers have enabled the query cache. This is one of the most effective ways to improve performance, and it is processed by the MySQL database engine. When many identical

MySQL performance computing ##################################### ######################################## ##### QPS (Queries Per Second): mysql> show /*! 50000 global */status like 'questions'; mysql> show /*! 50000 global */status like 'querys';

Table_cache is a very important MySQL performance parameter. It is called table_open_cache in Versions later than 5.1.3. Table_cache is mainly used to set the number of table caches. Since each client connection accesses at least one table, the

Four years ago, when I first came into contact with MySQL, the version was 4.1. At that time, I felt how this database was" Four years ago, when I first came into contact with MySQL, the version was 4.1. At that time, I felt how this database was"

It has been 10 months since I planned to write this book last year before and after now, and now the manuscript has been published and printed in the printing factory. According to the plan of the Publishing House, as long as there is no exception

On the surface of the database table, there is an index and error prevention mechanism. However, a simple query takes a long time. Web applications may run well in the development environment, but are equally bad in the product environment. If you

MySql Performance Tuning (5) demonstration of using a proper lock mechanism for table locks, mysql Tuning MySql locks take the following forms: 1. Table-level locks; low overhead, fast locking; no deadlock; large lock granularity, the highest

MySql Performance Tuning (4) Quick table structure modification and mysql Tuning 1. Modify the varchar type To meet your needs, change varchar (6) To varchar (8). A better method is not to use altertable modify, but to use the following

Mysql optimization and mysql Performance Optimization 1. view the mysql server configuration information show variables. You can also use show variables like 'key % '. 2. view the status values of the mysql server running show status, which is the

MySQL Performance-Schema (1) configuration table, performanceschema Performance-schema was first introduced in MYSQL 5.5, but now more metrics are added to performance-Schema in MYSQL 5.6 and 5.7, and more statistics are available, more and more

When MySQL becomes the database of more and more web2 sites, when the site is getting bigger and bigger, the traffic is increasing, and the number of users is increasing, the database is often the first to become the bottleneck of the system, how to

MySQL performance query and Configuration Overview View MySQL database performance:Show proceelist view the database connection status and total number of connectionsShow globalstatus like 'max _ used_connections '; view the maximum response