for new TCP connections, which defaults to 0, which means shutdown; Net.ipv4.tcp_tw_recycle = 1 indicates a fast recovery of time-wait sockets in a TCP connection, and the default is 0, which means close; NET.IPV4.TCP_FIN_TIMEOUT=30 modifies the default timeout time for the system . If the above configuration tuning performance is not ideal, you can continue to modify the configuration:Vi/etc/sysctl.co
Linux system Performance Tuning related commands summary:1. PS: See which processes are currently running in the systemCommon commands are PS aux | Grep-i MySQLHttp://www.cnblogs.com/peida/archive/2012/12/19/2824418.html2. Top: Dynamic display of the CPU, memory usage, and load of each programHttp://www.cnblogs.com/ggjucheng/archive/2012/01/08/2316399.html3. Overall load of IO, process IO load, load from a
Tags: mysql, mariadbEvery day seems very busy, in fact, found themselves still very lazy, read a lot of books, not a good read. Recently, not so much work, decided to finish reading a few books, and continue to keep on updating. I hope I can persist in the end! The later content is all about MySQL management (performance tuning, high availability and monitoring), mariadb and MySQL, and your own experiments.
MySQL Management: Performance tuning, high availability and monitoring mini-bookmysql5.5.x Main Improvements1. Use InnoDB storage engine by default2. Make full use of CPU multi-core processing capability3, improve the number of brush write dirty pages and merge the number of inserts, improve I/O4, let Innodb_buffer_pool buffer pool of heat data to survive longer, pollution problems5, InnoDB Data recovery ti
so that you can mark the snapshot information set at important times. A baseline is defined between a pair of snapshots, and the snapshot is identified by their snapshot sequence number. eachThe baseline has only a couple of snapshots. A typical performance tuning practice starts with collecting baseline collections of metrics, making changes, and then capturing another set of baselines. You can compare th
MySQL Performance tuning my.cnf detailedHttps://blog.linuxeye.cn/379.htmlProvides a MySQL 5.6 version suitable for MY.CNF profiles on 1GB memory VPS (click here to download the file):
[Client]
Port = 3306
Socket =/tmp/mysql.sock
[Mysqld]
Port = 3306
Socket =/tmp/mysql.sock
Basedir =/usr/local/mysql
DataDir =/data/mysql
Pid-file =/data/mysql/mysql.pid
user = MySQL
bind-address =
UWP control development-SizeChanged performance tuning, uwpsizechangedIntroduction
In the previous article "UWP control development -- packaging your own controls with NuGet", we mentioned some issues in the layout system and time-use of XAML (rewrite Measure/Arrange or use SizeChanged ?), This blog post briefly describes the behavior of the XAML Layout System and summarizes several rules. Of course, the re
operations, although PHP file operation efficiency is not low;41, optimize the Select SQL statement, as far as possible, as little as possible to insert, update operation (on the update, I was a bad batch);42, as far as possible the use of PHP internal functions (but I have to find a php non-existent function, wasted can write a custom function of time, experience problem ah!);PS: Built-in functions are nearly an order of magnitude more efficient than user-defined functions.43, the loop inside
), or (or), and not (non). Not can be used to negate any logical operation symbol. The following is an example of a NOT clause: ... where not (status = ' VALID ') If you want to use not, you should precede the phrase with parentheses and precede the phrase with the NOT operator. The NOT operator is included in another logical operator, which is the not equal to ( . : Where status For this query, it can be rewritten to not use not: SELECT * FROM employee where salary Although the results of thes
embedded devices, or memory, hard disk space, etc., by using the method of sacrificing CPU, to obtain the original need more memory or hard disk space to complete the work;3. A very simple time to change the space of the algorithm: the implementation of a, b two variable value exchange. The commonly used algorithm is to use the intermediate variables, and the introduction of additional variables means that more space is to be used, the following algorithm, you can eliminate the intermediate var
Official tools: Web address: HTTP://PAN.BAIDU.COM/S/1PKGRSRPOfficial: Https://download.xamarin.com/profiler/profiler-windows.msiXamarin Profiler, using this tool, helps us to tune software performance to find the bottleneck of the application.A high memory-intensive code call is monitored. Quickly resolve code that affects program performance.For the use of this tool, see:https://developer.xamarin.com/guides/cross-platform/deployment,_testing,_and_met
1 , JAVA Performance Tuning-do not use expressions in loop conditionsWhen we learn about Java Performance Tuning, we often see this passage: In the case of No compilation optimization, in the loop, the loop condition will be repeatedly calculated, if you do not use complex expressions, and the loop condition value is n
a text teaches you database performance tuning (attached to a large hospital real case)
Preface
An engineer at Microsoft once had a very figurative metaphor for performance tuning: Peeling onions. I also very much agree, let us to a layer of a layer of the outside its mysterious veil.
six major factors
The followi
Label:MySQL performance checking and tuning methodPublished: October 4, 2009 published by: OurmysqlSource: Sudone.com was read: 3,524 times only 1 ReviewsI have been using MySQL this database software, it works relatively stable, high efficiency. In the face of severe performance problems, there are generally several possibilities:
1, the index is no
, default is 2
Reviews: These two parameters control the merging and splitting of the PG directory, and when the number of files in the directory is less than filestore_merge_threshold that, the object files of the directory are merged into the parent directory, and if the number of files is greater than the directory filestore_merge_threshold*16*filestore_split_multiple , the directory is split into two subdirectories. Set a reasonable value to speed up indexing of object files
]: MySQL 08:32:38> change MASTER toMaster_host= ' 192.168.0.1 ',Master_user= ' Repl ',Master_password= ' PASSWORD ',Master_log_file= ' mysql-bin.000035 ',master_log_pos=399;After executing the change MASTER to command, you can start SLAVE with the following command:[email protected]: MySQL 08:33:49> START SLAVE;At this point, our Replication environment is built. Reader friends can do their own tests to try to build, if you need to understand the MySQL replication build process More detailed ste
different tables or libraries)Five, server side and client interaction optimization:Client tries to reduce requestsLogical processing of the service side as long as possibleServer-side and client-driven push-pull combination (can take advantage of some synchronization mechanisms)Optimization of communication protocols. (Reduce the size of the message)Power usage optimization (try not to use background execution)Vi. Non-technical performance optimizat
IIS Performance Tuning
1. Adjust the IIS cache
The range of HKEY_LOCAL_MACHINE Systemcurrentcontrolsetservicesinetinfoparametersmemorycachesize Memorycachesize is from 0 4GB, The default value is 3072000 (3MB). In general, this value should be set to 10% of the server memory. IIS improves system performance by caching system handles, directory listings, and oth
Detailed configuration:
port= "protocol=" "http/1.1"connectiontimeout= "20000"redirectport= "8443"/>
1, Tomcat's external tuningJava Virtual Machine (JVM) performance optimization allows you to set the size of the virtual machine using memory,-xmsThe size of these two values is generally set as needed. The size of the initialization heap performs the size of the memory that the virtual machine requests to the system at startup. Generally speaking, th
should precede the phrase with parentheses and precede the phrase with the NOT operator. The NOT operator is included in another logical operator, which is the not equal to (... where status For this query, it can be rewritten to not use not:SELECT * FROM employee where salaryAlthough the results of these two queries are the same, the second query scenario is faster than the first query scenario. The second query allows Oracle to use indexes on salary columns, while the first query cannot use i
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.