Posted by Coder.
Results > Posts Filed Under > Databases
Nov
2
Posted by Coder.
Oracle Enterprise Manager Java Application Diagnostic Expert (JADE)
Oracle Enterprise Manager Java Application Diagnostic Expert (JADE) improves the availability, performance and provides in-depth diagnostics for Java applications with low overhead. It enables:
1. Production diagnostics with no application instrumentation, saving time in reproducing problems
2. Visibility into Java activity including in-flight transactions, allowing administrators to proactively identify issues rather than diagnosing after-the-fact (application hangs, crashes, memory leaks, locks)
3. Tracing of transactions from Java to Database and vice-versa, enabling faster resolution of problems that …
Nov
1
Posted by Coder.
Performance Agora: ORACLE Scalability Oracles
Cary Milsap, “Optimizing Oracle Performance” (O’Reilly, 2003). On p. 361, there is a definition of scalability expressed in terms of the response time (R). [ed. scalability: The rate of change of response time with respect to some specified parameter. For example, one may speak of the scalability of a query with respect to the number of rows returned, the scalability of a system with respect to the number of CPUs …
Oct
3
Posted by Coder.
Cary Millsap, former VP of Oracle’s System Performance Group and the cofounder of Hotsos.
…doing things an application doesn’t need to do is exactly what makes it slow, unscalable, and—in the end—economically inefficient.
Don’t run reports that nobody reads.
Don’t generate more output than you need.
Don’t execute a business process any more often than the business needs.
Don’t write SQL that visits more blocks in the database buffer cache than necessary.
Don’t update a column’s value to the same value it already has.
Push data when …
Jan
23
Posted by coder.
developerWorks : Blogs : Grady Booch
Distributed two-phase commit will be avoided by recoverable messaging to applications (via services) that consult and modify the database and send a recoverable reply. Database size will become a non-issue. We’ll see lots of low-latency asynchronous replication of reference data among databases serving various applications and their associated service interfaces.
Jan
6
Posted by coder.
This case study gives a high level overview of Google’s setup for user authentication, interesting read.
… user authentication is a transactional event that requires fast, reliable, scalable, persistence and robust high-availability. To deliver this level of service, Google Accounts uses Berkeley DB HA for the storage and retrieval of user data and for replication, thereby ensuring scalability and availability.
Dec
23
Posted by Coder.
MySQL AB :: How to Monitor MySQL’s performance
…how you can monitor the database performance of your MySQL installation. Monitoring is always an iterative and continuous process. You need to learn what patterns are OK for your database and what are the signs of slight problems or even dangerous situations.Below are the main items you can use to monitor your system:
mysqladmin extended (absolute values)
mysqladmin extended -i10 -r (relative values)
mysqladmin processlist
mysql -e “show innodb status”
OS data. vmstat/iostat
MySQL error log
InnoDB tablespace info.
Dec
3
Posted by Coder.
When tuning a database for better performance, one area to examine is the proximity of the database to the application. Can the database be located on the same server as the application? Will a database server located far away from the application server cause performance degradation? To answer these questions, a series of measurements were conducted to determine performance impact based on the distance between the application and database servers. This paper discusses the results of our tests.
IBM Redbooks | …