Discover weblogic performance tuning, include the articles, news, trends, analysis and practical advice about weblogic performance tuning on alibabacloud.com
First, diagnostic tools
1. Warning Log file
Warning log files contain system information and error logs that contain important errors (such as: ORA-600) and block checksum error messages (ora-1578,ora-1498). Monitor database operations such as CREATE DATABASE, STARTUP, SHUTDOWN, ARCHIVE log, and RECOVER, and record Non-default initialization parameter values. When Log_checkpionts_to_alert is set to true, the warning log file also records the start and end times of checkpoints, incomplete checkpo
MySQL performance tuning and Architecture Design-the idea and solution of the High Availability design in Chapter 17th, mysql Tuning
Chapter 1 High Availability design ideas and solutions
Preface:
The database system is the core part of an application system. To ensure the overall availability of the system, the database system cannot have any problems. For an en
. NET Performance Tuning series articles
Series Article Index
. NET Performance tuning: Use of the ANTS performance Profiler
. NET Performance Tuning two: Code metrics with Vis
The individual believes that JVM tuning is primarily addressed by the following methods1. Set the appropriate maximum heap memory (maximum and value for Cenozoic and Laosheng generations) and minimum heap memory (the operating system memory size consumed by JVM startup), and set the scale allocation of the heap.2, set up the suitable new generation because of its impact on the system performance and GC reco
Even experienced Java Web developers will be amazed at the huge leap in the development portal. Behind the simple, beautiful interface that end users see is the power and complexity of commercial products such as the BEA WebLogic Portal. Diagnosing performance problems can be especially difficult when the portal application is in the production phase.
This article assumes that you are already familiar with
Performance optimization is to improve the system performance, reduce energy usage, or reduce the impact of applications on other parts. If the optimization is hasty or there is no measurement, of course, performance optimization may have a bad effect.
Performance optimization is to improve the system
Database Tuning tutorial (4) Explain performance analysis command, tuning explain
In the previous chapter, we learned how to find slow queries and record statements into logs. How can we know where statement problems occur after slow queries are found. This chapter describes how to use the database performance analysis
:37YesOrchid Island Main 15:34:51Oh.Orchid Island Main 15:35:12Other, not quite understand your data in the situation, not very good fine optimization.Orchid Island Main 15:35:44Should still be quick.Snow Leopard 15:36:34GoodSnow Leopard 15:36:36Let me seeOrchid Island Main 15:37:16For example: The index of the other two tablesSnow Leopard 15:37:31WellOrchid Island Main 15:37:43The full table scan, although the table is small, but to 0.5s, should also be a small proportion.Snow Leopard 15:37:55I
Cache Size| Query_cache_type | On | cache type, determines what queries are cached| Query_cache_wlock_invalidate | OFF | when other clients are writing to the MyISAM table If the query cache is returned , the cache result, or wait for the write operation to complete the reread table to get results+------------------------------+---------+Mysql> show global Status Like "qcache%";+-------------------------+-------+| variable_name | Value |+-----------------------
can avoid Key lookup is perfect, let's revise non-clustered index to include it in the index with the Include keyword His fields are:[SQL]
DROP INDEX idx_non_clust_salesorddetaildemo_modifieddate on salesorddetaildemo
GO
CREATE nonclustered INDEX idx_non_clust_salesorddetaildemo_modifieddate on salesorddetaildemo (ModifiedDate)
INCLUDE
(
ProductID,
UnitPrice
)
GO
--Clear the cache, only for the development environment!
DBCC Freeproccache
DBCC dropcleanbuffers
GO
Performance bottlenecks:Slow, write faster than read The main performance indicators:Frequency of visits,The number of concurrent connections,Cache Hit Ratio,Index use,Slow log opening and analysis,Query log, querying logThreads_cached: Whether the connection thread cache is turned onThread_cache_size: The size of the number of thread cachesQuery_cache_size: Query Cache SizeJoin_buffer_size:join Buffer Size
MySql Performance Tuning (5) demonstration of using a proper lock mechanism for table locks, mysql Tuning
MySql locks take the following forms:
1. Table-level locks; low overhead, fast locking; no deadlock; large lock granularity, the highest probability of lock conflict, the lowest concurrency. The MyISAM engine belongs to this type.
2. Row-level locks: high ove
MySql Performance Tuning (4) Quick table structure modification and mysql Tuning
1. Modify the varchar type
To meet your needs, change varchar (6) To varchar (8). A better method is not to use altertable modify, but to use the following steps:
A. Create A temporary table and set varchar to varchar (8) as follows:
B. Replace the. frm table stru
Build high performanceASP. NETSite Chapter 5-Performance Tuning Overview (previous)
During this time, the seriesArticleI reorganized it. The previous introduction to performance optimization was not very clear. It can be said that starting from this article, it is the beginning of a complete series.
Links to articles:
Build high performanceASP. NETSit
In use. NET to start and develop the application quickly, the next problem may be the performance tuning aspects of the program, and performance tuning can sometimes involve all aspects of the problem, such as the program host system, database, network environment, and so on, and when the program is unusually large and
The performance tuning of Enterprise Java applications is a daunting, sometimes futile task, caused by the complexity of modern applications and the lack of formal tuning methods. Modern enterprise applications are quite different from those applied ten years ago, and these applications now support multiple inputs, multiple outputs, complex frameworks, and busine
QQ group 288567073, no commercial advertising, daily dry e-book + video sharingLychee FM Mobile Client search for "Play talk show" to subscribe to usVideo Summary home: http://edu.51cto.com/lecturer/index/user_id-4626073.htmlfirst, the problem phenomenonDuring the testing of the system, it was found that the large Concurrencythe Weblogic system deployed by the Windows platformPerformance system deployment webl
High-performance ASP. NET Site build series Article Directories
During this time, I reorganized the series of articles, and the previous introduction to performance optimization was not very clear. It can be said that starting from this article, it is the beginning of a complete series.
The topics in this chapter are as follows:
General performance
MySQL performance tuning and Architecture design--9th chapter The performance optimization of MySQL database schema designPreface: Many people think that performance is optimized in the process of writing code (program code or database code), in fact, this is a very big misunderstanding. The real impact of the most
Note: This article is the third of our series of PHP performance analysis, click here to read PHP performance analysis first: Xhprof Xhgui Introduction, or PHP performance analysis second: In-depth study of Xhgui.In the first chapter of this series, we introduced Xhprof. In the second chapter, we studied the Xhgui UI, and now the last one, let's use Xhprof/xhgui
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.