mysql query performance tuning

This article transferred from: http://www.cnblogs.com/chen77716/archive/2010/06/26/2130807.htmlRecent memory leaks due to the project, so large-scale JVM performance tuning, now the experience to do a record.First, JVM memory model and garbage collection algorithm1. According to the Java Virtual Machine specification, the JVM divides the memory into: New (Young Generation) Tenured (old generati

Today we will mainly talk about the DB2 Performance Tuning design and configuration of your database. There are many database design and configuration options that can affect the query performance. For more suggestions on Database Design, see the "Planning your Physical Database Design" Best Practices article. Use con

Web server itself to obtain the best performance, each Apache connection uses a process, so it will not be affected, but a single process Web server, such as Zeus is a file descriptor for each connection, therefore, it is easy to be affected by the default limit.The file opening limit is a limit that can be adjusted using the ulimit command. The ulimit-aS command displays the current limit, and the ulimit-aH command displays the hard limit (before Ke

cache = max memory * 50% Procedure cache size = max memory * 20-30% Number of user connections = N (default = 25) Number of lock = N * Maximum number of locks required by a single user * 120% (Generally, this is difficult to estimate. The reference value provided by senior syabse engineers: 1.8 million for users. I estimate that 100000 is recommended for 10 Gb of data) Number of open objects = 10000 Number of open indexed = 10000 This configuration can basically be used normally. You can down

Guide Performance tuning has always been one of the most important work of operations engineers, if you are in a production environment encountered a slow system response, hard disk IO throughput anomalies, data processing speed is lower than expected, or such as CPU, memory, hard disk, network and other system resources have been exhausted for a long time, Then this article will really help you, if no

Talking about linux performance tuning 9: changing system default limits; talking about linux performance tuning 8: Removing unnecessary overhead http://www.2cto.com/os/201307/228393.html After reading the first two articles, we are trying to save resources for our real services. Problem: our service is actually used..

Processlist-----------------------------------------------------------------------------------------MySQL Cache1.mysql Layer: Query Cache queries caches: stores the full result of a select, and when there is the same query, skips the parsing, optimization, and execution stages, directly returning the result, and when

This article mainly describes the problem of DB2 Performance Tuning. We mainly answer the problems in DB2 performance tuning in a one-Question-and-one manner, the following is a description of the DB2 Performance Tuning problem. I

System performance has always been a hot topic. Do operation of the past few years have been engaged in performance tuning, writing this article is also a summary of the work.The first step in tuning is to say why tuning? That is, the system analysis, analysis also need to h

Transferred from: http://www.cnblogs.com/MR_ke/archive/2010/08/25/1807856.htmlSQL 2005 Performance TuningSQL Server runs for a period of time, and as data accumulates, SQL runs less efficiently, and in order to use business system normal actions, IT departments often need to spend a high price on SQL tuning experts to solve. In fact, tuning is not complex, mainly

SQL Server Performance Tuning 3 Index MaintenancePreface The previous article introduced how to improve database query performance by creating indexes, which is just the beginning. If you do not need proper maintenance in the future, the indexes you have previously created may even become a drag-and-drop attack and a h