| |
All of the following articles may be viewed free of charge. You have permission to distribute these materials within your company; but you may not, however, re-publish any articles without first asking for permission.
Thanks, Guy.
Tuning MySQL SQL Code
Quest-Pipelines, June 2008
|
Excerpt:This paper covers the tools and various methods available for tuning poorly executing MySQL SQL code. MySQL has a well deserved reputation as a light-weight and efficient database server capable of meeting the requirements of even the most demanding high volume web applications. Nevertheless, as the part of your application that does virtually all the disk IO, it's going to be the source of a significant proportion of your application response time. Therefore, if you want your application to meet its full performance potential, you should not shirk on tuning the MySQL SQL code. ...
|
Systematic Oracle Performance Tuning
SELECT Magazine, Q4 2006
|
Excerpt:
A mission critical application system is experiencing unsatisfactory performance. As an experienced Oracle performance specialist, you are called in to diagnose the problem. You’re well versed in modern wait-based performance profiling oriented performance diagnostics (such as “YAPP” 1), so the first thing you want to determine is which wait category is consuming the bulk of non-idle time. Looking at V$SYSTEM_EVENT, you immediately see that the database is spending the vast majority of it’s time within ‘ db file sequential read ’ events. Furthermore, the average time for each of these events – which represent single block reads against database files – is more than 20ms which is far higher than the service time you expect from the expensive and sophisticated disk array supporting the application.
|
Can your project win the database race?
Software Test and Performance, Nov 2005
|
Excerpt:
Most mission-critical business applications have at their core a relational database that maintains key persistent information. The performance of that relational database is absolutely critical -- often the most important factor in the overall performance of the application. For this reason, when testing a database-driven application, it pays to give special attention to database performance. ...
|
Resolving Oracle latch contention
Quest-Pipelines, April 2005
|
Excerpt:
This paper presents an overview of how the Oracle RDBMS uses latches to protect shared memory, the typical causes of and solutions to latch contention, and summarizes some research conducted at Quest Software that suggests that manipulating the (now) undocumented parameter “_spin_count” can be effective in relieving otherwise intractable latch contention problems. ...
|
Recent Application Insight Articles:
|
 |
|