Read about postgresql performance tuning parameters, The latest news, videos, and discussion topics about postgresql performance tuning parameters from alibabacloud.com
Oracle is a high-performance database software. The user can adjust the parameters to achieve the optimization of performance. Performance optimization is mainly divided into two parts:
First, the database administrator through the adjustment of system parameters to achieve
alarm tcp:time wait bucket table overflow. However, you can increase concurrency and save ports.Net.ipv4.tcp_max_tw_buckets = 8000Increase the range of available ports, as the effect impliesNet.ipv4.ip_local_port_range = 1024 65000Last two parameters I forgot what it meant, but also add it:)Net.ipv4.tcp_keepalive_time = 1200Net.ipv4.tcp_max_syn_backlog = 81920At this point, your Nginx server can be happy to run up!Redis Server kernel TuningJust one.V
Mysql mytop of performance tuning tools installation and use of
1. Mytop of the
http://yunpan.cn/cVG3uSs2Jtt9h access Password 7ef1
2. Install Mytop first Necessary Components .
Yum-y Install Perl-dbd-mysql Perl-dbiperl-termreadkeyIf you are prompted to locate the installation package , you can first installYum–y Install Epel-releaseEpel-release This can be used to the
Tuning system performance using SAR in LinuxKeywords: SARThe SAR default is not installed under Linux, we need to install manually, it is generally recommended source mode installation, download similar sysstat-6.1.3.tar.gzYou can then use the Configure make make install.Common formats for the SAR command line:SAR [Options] [-A] [-o file] t [n]In the command line, the N and t two
global status like ' handler_read% '; + ——————— –+ ————-+ | variable_name | Value | + ——————— –+ ————-+ | Handler_read_first | 5803750 | | Handler_read_key | 6049319850 | | Handler_read_next | 94440908210 | | Handler_read_prev | 34822001724 | | Handler_read_rnd | 405482605 | | Handler_read_rnd_next | 18912877839 | + ——————— –+ ————-+ For each field explanation see http://hi.baidu.com/thinkinginlamp/blog/item/31690cd7c4bc5cdaa144df9c.html, call up the number of query requests completed by the se
relatively small value, the process and the number of threads is a more appropriate value. System calls are also, each time the system function is called, our code will enter the kernel space, resulting in context switching, this is very resource-intensive, but also try to avoid frequent calls to system functions. Too many context switches means that most of your CPU is wasted in context switching, resulting in less time for the CPU to do serious work, and the CPU not being fully utilized, is u
[HKEY_Local_Machine\system\CurrentControlSet\services\tcpip\parameters]"TcpNumConnections" =dword:00fffffe; Modify the maximum usage value of the paged pool is reclaimed by the system[HKEY_Local_Machine\system\CurrentControlSet\control\sessionManager\memoryManagement]"Poolusagemaxium" =dword:00000032; repair system supports maximum network throughput[HKEY_Local_Machine\system\CurrentControlSet\services\lanmanserver]"MaxFreeConnections" =dword:00001000
: Checking URLsCompression: Boot compressioncompressionminsize:2048 when the return content is greater than or equal to 2kb boot compression, to the client in the decompressionCompressablemimetype: Compression typeIi. springboot Item 1, JVM parametersSpringboot starts directly with the jar package and adds parameters to the start command, here is an example:nohup java -server -Xms4096m -Xmx4096m -Xmn1024m -Xss256K -XX:+DisableExplicitGC -XX:MaxTenurin
; set [global] Variable name = value;Permanently definedVim/etc/my.cnf[Mysqld]Variable name = value....: Wq#systemctl Restart MysqldMySQL architecture?Connection poolSQL interfaceAnalyzerOptimizerQuery cacheStorage EngineFile systemManagement toolsHow does the MySQL service process query requests?4 The SQL query command of the query database written by the program is unreasonable, resulting in slow database processingEnable slow query log on the database server: Records SQL commands that display
Detailed understanding and performance tuning of the JVM's garbage collection mechanism (ii) 2008-05-28 16:39
ReproducedGC Overview of 1.JVM The GC, or garbage collection mechanism, is the memory that the JVM uses to free objects that are no longer in use. The Java language does not require the JVM to have a GC, nor does it specify how the GC works. However, the common JVM has a GC, and most G
From a large perspective, Netty performance is mainly reflected in: 1.io threading Model using reactor mode, synchronous non-blocking. This determines that more can be done with the least amount of resources. 2. Memory 0 copies use direct caching 3. Memory pool design application memory can be reused, mainly direct memory. The internal implementation is to manage memory allocations with a binary lookup tree. 4. The serialization processing socket read
configuration is more suitable for situations where the system memory capacity is more abundant.
Due to the limitation of the overall memory capacity of the system, it is not possible to increase the value of the above parameters indefinitely (since tuning this part of the lock memory related parameters will inevitably affect other memory-related settings),
variable value can be used to improve performance. By comparing variables in Connections and Threads_created states, you can see the role of this variable. I set it to 80. Key Parameter 9: the number of seconds the wait_timeout server waits for action on a connection before closing it. The default value is 28800. I will change it to 7200. Note: you can modify the parameters by modifying the/etc/my. cnf fil
Key mysql database performance optimization parameters and mysql Server optimization bitsCN.com
Key parameters for mysql database performance optimization and mysql Server Optimization
Key parameter 1: back_log
The number of connections that MySQL can have. When the main MySQL thread receives a lot of connection re
JVM parameters are used in many places, such as when you run Ant Check-style, run and hang, and throw a OutOfMemory error.When you search the Internet, they will tell you that you should modify the ANT_OPTS environment variable, plus "-xmx512m".For example, JBoss or Tomcat has a startup script (Startup.bat, etc.), which also uses the JVM parameters. And the Eclipse.ini of Eclipse.The JVM
Secrets of Kafka performance parameters and stress tests
The previous article Kafka high throughput performance secrets introduces how Kafka is designed to ensure high timeliness and high throughput. The main content is focused on the underlying principle and architecture, belongs to the theoretical knowledge category. This time, from the perspective of applicati
1. Monitor Resin Parameters
1. Add the following segments to the resin. conf file:
When you access http: // domain name/resin-status, you can monitor the performance of resin.
2. You can also use the resin-Admin Function. You need to add the following code in resin. conf:
-Administration application/resin-Admin
-
-Password is the MD5 hash of the password.
-Localhost is true to limit acce
1.
Name
Parameters
Position
Role
Cache
Max-beans-in-cache
Weblogic-ejb-jar.xml
The size of the entity bean cache space, if the cached space is too small, some beans are stranded in the database and must be reloaded from the database the next time they are called
"%java_home%/bin/java"-hotspot-xms512m-xmx512m-classpath%classpath%-
startwls.cmd/startwls.sh
To achieve high-
default. As of 5.1.21 and the version with the Google patch installed, this option can be set in microseconds. this is a great feature, because once you have eliminated all queries whose query time exceeds 1 second, the adjustment is very successful, which helps you eliminate the problem SQL before the problem increases.
3. log_queries_not_using_indexes
Enabling this option is a good idea. it actually records the query that returns all rows.
Summary
We have introduced five categories of MySQL
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.