Tags | Domains | Searches | Statistics | Options | Advanced Search
|
Tags | Domains | Searches | Statistics | Options | Advanced Search |
Pythian Group Blog - Oct 1, 2008
The unsung heroes of InnoDB are the logfiles. They are what makes InnoDB automatic crash recovery possible. Database administrators of other DBMS may be familiar with the concept of a “redo” log. When data is changed …
Also tagged: mysql, innodb, log, group blog posts, redo, server variables
Pythian Group Blog - Aug 13, 2008
This post is for those who think Consistent Gets is the only thing that matters. It’s not. That’s why Statspack and AWR provide not only the top queries sorted by Consistent Gets but also Sorted by IO, CPU, Cluster …
Also tagged: oracle, trust, hash join, consistent gets
Pythian Group Blog - Jul 25, 2008
Recently, I had an opportunity to tune latch contention for cache buffers chain (CBC) latches. The problem was high CPU-usage combined with poor application performance. A quick review of the statspack report for 15 …
Also tagged: oracle, latch contention, buffer chain latches
Pythian Group Blog - Jun 27, 2008
In this blog entry, I will discuss strategies and techniques to resolve ‘log file sync’ waits. This entry is intended to show an approach based upon scientific principles, not necessarily a step-by-step guide. Let’s …
Also tagged: performance, oracle, root cause analysis, lgwr, log file sync
Pythian Group Blog - May 22, 2008
Welcome ASH Masters! I have already mentioned about the excellent work that Kyle Hailey did around Active Session History (ASH). Kyle has also created ASHMON. The latest news — there is a new web site — …
Also tagged: performance, oracle, ash, group blog posts
Pythian Group Blog - Apr 22, 2008
At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets. They were very nice, printed in full color and laminated to ensure you can spill your coffee* on it and it will survive. For …
Also tagged: performance, tutorial, optimization, guide, mysql, cheatsheet, tune, optimize, group blog posts, non tech articles, explain
Pythian Group Blog - Mar 7, 2008
Have you ever heard the one about throwing hardware at a software problem? In one of my previous blog posts, I mentioned something along the lines of—well I’ll just cut and paste . . . In my experience, the solution to …
Also tagged: hardware, oracle, basics, rac, group blog posts
Pythian Group Blog - Mar 4, 2008
First of all “the before” time is over — I’m done with my presentation. It’s been the first slot of the day — 8:30 and Cary Milsap was presenting in another hall so what chances do I have to get people in? It turned …
Also tagged: performance, oracle, conferences, presentations, dallas, workload, rac, load balancing, group blog posts, hotsos