Oracle Database 10g Performance Tuning tips and techniques is recommended. For Oracle performance test, diagnosis, analysis, and optimization, see!
Chapter 2 Basic index principles (beginner developer and beginner dBA). For Oracle index optimization, refer!
Chapter 4 tuning the database with initialization parame
connection Ports Netstat-taupe d.half-closed connections Half-closed connection NETSTAT-TAPN | grep time_wait13.16Tuning TCP Socket creationCreateTCPSocketsThe number of A.TCP connection (SYN) reconnection net.ipv4.tcp_syn_retries defaults to 5 B. The length of the reconnect queue Net.ipv4.tcp_max_syn_backlog default to 1024 , discard after this value C. Re-use TCP connection net.ipv4.tcp_tw_recycle default is 0 off, 1 open13.17Tuning TCP Socket keepaliveAdjustmentTCPSocket Survival TimeA. How
Most developers take for granted that performance optimization is complex and requires a lot of experience and knowledge. Well, you can't say it's completely wrong. Optimizing your application for optimal performance is not an easy task. But that doesn't mean that if you don't have the knowledge, you can't do anything. Here are 11 easy-to-follow recommendations and best practices to help you create a well-p
analysis of Web container thread pool server > Application server > (server name) >
Thread pool > Webcontainer minimum Size: 10
Maximum size: 50 monitor Web container thread pool maximum by TPV (within acceptable time range), set EJB cache server > Application server > (server name) > EJB tell cache set > EJB cache setting > Cache large Small cache Size: 2053
Purge interval: 3000 For example through TPV monitoring found that Ejbstore () has a high call rate and CPU utilization is very low, can
This article mainly tells you about the 20 frequently-encountered problems in DB2 Performance Tuning. If you are curious about the 20 frequently-encountered problems in DB2 performance tuning, the following articles will unveil its secrets. The following is a detailed description of the article. I hope you can learn fr
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..
IOS Performance Tuning series: use Zombies to dynamically analyze zombie objects in the memory and optimize zombies
Hardware wide: The fourth article in the IOS Performance Tuning series, which is expected to be updated continuously over 20 articles.
The first two articles, IOS Per
Performance Tuning is not a simple task. There is no omnipotent solution at all, but you can use some basic principles to implement it.
In general, performance tuning is the role of DBA. however, DBA does not have time to carefully check every change made to the stored procedure. so learning some basic
The class "Performance Tuning for large-scale and high-traffic Internet sites" is the last good class I attended. I thought this class was mostly about background services, in fact, I am mainly talking about client optimization. I mainly talk about 14 standards. I vaguely felt where I met these 14 standards. Then I checked google, it is true that these 14 items are not new, but they are not too concerned 《
Performance issues with Java EE applications are a very important issue for serious projects and products. In particular, enterprise-class applications, concurrent users, a large number of data transmission, business logic complex, occupy more system resources, so performance problems in enterprise-class applications become critical, it and the stability of the system has a direct link. More importantly, th
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
into 1000 only one property.3. When we display a list of CLR objects (such as list) in a list (such as a ListBox), the ListBox also dynamically reflects this change if you want to modify the list object. At this point, we should use a dynamic ObservableCollection object binding. Instead of updating Itemsource directly. The difference between the two is that updating itemsource directly causes WPF to discard all the data that is already in the listbox and then reload all of it from the list. The
Chapter 2 procedural performance tuning of PL/SQL applications
I. Reasons for PL/SQL Performance problems
When the execution efficiency of PL/SQL-based applications is low, it is usually caused by poor SQL statements and programming methods, poor understanding of PL/SQL basics or misuse of shared memory.
Bad SQL statements in PL/SQL
PL/SQL programming see
As an excellent web framework, ANGLARJS can greatly simplify the burden of front-end development. Recently Sebastian Fröstl in a blog post "Angularjs performance tuning for Long Lists" that anglarjs in the processing of large lists containing complex data structures, they run very slowly. He also shared the solution in the text. The following is a translation of the text.
Anglarjs is great, but it can run
are some bugs, is not necessarily applicable to the core of the online system.3. DRBD Disk Network mirroring schemeAdvantage: Software is powerful, data is mirrored across physical hosts at the underlying fast device level, and different levels of synchronization can be configured according to performance and reliability requirements. IO operations are kept in order to meet the database's demanding data consistency.Disadvantage: Non-Distributed File
Some small aspects of database Performance tuning:1. 1 Performance IndexDatabase performance is generally measured in two metrics: response time and throughput. The faster the response, the greater the throughput and the better the database performance. Response time and thr
Label:Original: SQL Server performance Tuning (i)--judging system resource bottleneck from waiting stateView the status of all SQL Server tasks at that time (sleeping, runnable, or running) through the DMV2005, 2008 provides the following three view Tudon detailed query:
DMV
Use
Sys.dm_exec_requests
Returns information about each request that is executed in SQL Serve
Original article: http://www.mastertheboss.com/jboss-performance/jboss-as-7-performance-tuning
JBoss Application Server Tuning
Although many architects and software engineers agree that the performance of about 70-80% of applications depends on the code of the application it
rich, powerful, and flexible, and you can do a variety of tasks with it, and in this article we'll discuss some tips for improving the performance of Linux servers.1. Tuning the Linux kernel elevator algorithm for disk I/OAfter selecting the file system, there are some kernel and mount options that may affect its performance, one of which is the elevator algorit
last few lines of each test result. Pay special attention to the memory, which easily exceeds the memory configuration]
Using login values from ~ /. My. cnf-Initial login attempt failed-Testing for stored webmin passwords:None FoundCocould not auto detect login info!Found potential sockets:/tmp/mysql. sockUsing:/tmp/mysql. sock
# I believe you can understand the following items, but I will not explain them.Wocould you like to provide a different socket? : [Y/N] nDo you have your login handy? [Y
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.