mysql performance tuning parameters

message size is greater than this value will be compressed, if the compression function, the default value is 2048.Compressablemimetype: The type of compression that specifies which types of files are compressed to data.Nocompressionuseragents= "Gozilla, Traviata": Compression is not enabled for the following browsers.If the code has been separated, static pages and pictures and other data will not need tomcat processing, then there is no need to configure the configuration in Tomcat compressio

This document describes how to use SQL Plan Management to manage SQL Execution plans. SQL Plan management provides components for capturing, selecting, and evolving SQL Plan information to prevent performance degradation caused by sudden changes in the execution Plan of SQL statements. See http://blog.csdn.net/davidwang9527/article/details/18620953 FOR THE FIRST PART This article includes the following topics:3. Use SQL Plan Baseline with SQL

Although the WebLogic version has now been upgraded to 10.3 and is packaged as Oracle Funsion middleware 11g, the new data is relatively small, sharing a WebLogic Classic version 8.1 performance tuning article. --------------------------------------------------------------------------------------------------------------- ---- Any successful product in the market has good

JVM tuning (the most critical parameters are:-xms-xmx-xmn-xx:survivorratio-xx:maxtenuringthreshold)Generation Size tuning:Avoid the Cenozoic size setting too small, avoid the Cenozoic size settings too large, avoid survivor set too small or too large, reasonable set up the new generation survival cycle.-xmn Adjust the Cenozoic size, the larger the new generation usually means that more objects will be recyc

Linux Performance and Tuning Guide (translation)Figure 1-7 Process address spaceThe process memory area consists of the following parts:Text segmentThis zone is used to store running code.Data segmentThe data segment consists of three regions.-Data: The zone stores the initialized information, such as a static variable.-BSS: The region stores data initialized to 0. The data is initialized to 0.-Heap: This

can use the following query: SELECT * FROM (SELECT *, NTILE (10) OVER (order by Duration) BucketFROM TraceTable) xWHERE Bucket = 10 Note: execution of a large number of seemingly small (or even 0 ms) queries may also lead to performance failures. However, this problem usually requires removing useless interfaces, the system has a systematic solution, instead of tuning through the Transact-SQL query. If

MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limits. Here are 101 tips for adjusting and optimizing MySQL installation. Some of the techniques are specific to the installation environment, but these ideas are generic. I've divided them into several categories to help you master mo

Reprinted: http://hi.baidu.com/springwu/blog/item/267ec345cd9d4628879473ce.html 1. CPU 2. Memory 3. I/O 4. Network 1. CPU We should understand the main parameters of CPU operation: Context switching, running queue, CPU utilization, and average load. (1) Context switching: 1) The CPU command is a context switch from one process (thread) to another. 2) When a process is switched, the current CPU status is stored in the memory. 3) The kernel can also get

For Linux system tuning parameters, all TCP/IP tuning parameters are located in the/proc/sys/net/directory. For example, the following are some of the most important optimization parameters, which are followed by their meanings: 1./proc/sys/net/core/rmem_max-maximum TCP Data

transfer time and other times, from user clicks linked to Web page content transfer, and rendered on the user's computer screen. Delays are measured by time, and can be easily compared, while others are less easily measured and compared, such as IOPS, which you can turn into latency for comparison.In general, we measure performance mainly through response time, rather than how much resources, optimization is essentially under a certain load, as much

Performance Optimization aims to improve performance and reduce the impact of resource consumption and applications on the system. If it is implemented prematurely or without performance evaluation, performance optimization may or must lead to the opposite effect. However, if the system is implemented,

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

MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limits. Here are 101 tips for adjusting and optimizing MySQL installation. Some of the techniques are specific to the installation environment, but these ideas are generic. I've divided them into several categories to help you master mo

Alarm problem:Too many processes onZabbix Poller processes more than 75% busyZabbix unreachable Poller processes more than 75% busy1. The device that collects the data through the Zabbix agent is in the moniting state but at this time the machine freezes or other causes the Zabbix agent to die the server obtains the data, at this time unreachable pollerWill rise.2. The device that collects the data through the Zabbix agent is in the moniting state, but the server gets the data from the agent too

Tags: non-homogeneous project distribution tuning hold writes merge partitions multiple timesReprinted from XiaoruiSome users (especially the external output) when using Maxcompute (original ODPs), due to the use of the product level and level of understanding of the level of implementation, resulting in the implementation of the task is too long, the occupation of more cluster resources, serious will lead to failure, not only need to invest support s

author of the Thank you! For information on JVM performance tuning, please refer to the end of this article.A, JPS (Java Virtual machine Process Status Tool)The JPS is primarily used to output process state information that runs in the JVM. The syntax format is as follows:JPS [Options] [HostID]If you do not specify HostID, the current host or server is assumed to be the default.The command line parameter o

A free ebook that IBM released early on the internet10 years, the reference value is still very big.Domestic translation into Chinese online reading version.See two URLs belowLinux Performance and Tuning guidelinesHttps://www.gitbook.com/book/lihz1990/transoflptg/details=========================================Server Optimization IdeasManage the change processManagement change and

mount option can effectively improve performance if external storage is used.13. Adjust Linux file descriptor limitsLinux limits the number of file descriptors that any process can open, with the default limit of 1024 per process, which may hinder benchmarking clients (such as Httperf and Apachebench) and the Web server itself from getting the best performance, with one process per connection for Apache, S

100 128Fs.file-max = 65536Net.ipv4.ip_local_port_range = 9000 65000Net.core.rmem_default = 4194304Net.core.rmem_max = 4194304Net.core.wmem_default = 262144Net.core.wmem_max = 262144This parameter is saved under/etc/sysctl.conf, and you do not need to restart the OS to modify the file, just use the following command:#/sbin/sysctl-pYou can let the modified parameters take effect.2. Kernel.shmmax parameters2.1 DescriptionSHMMAX Available Physical memory

and the dirty_expire_centisecs setting is large, it may be before the expiration time is reachedDirty data is flushed to disk by Pdflush.2. Parameter TuningIf there is a large amount of dirty data in the system's cached, there are two problems:A.The more data is cached, the greater the risk of data loss.B.IO spikes occur periodically, and the peak time is longer, during which all new write IO performance will be poor (in extreme cases it is directly