Yoshinori Matsunobu (Sun Microsystems) speaks at the 2010 O’Reilly User Conference & Expo Slides: www.slideshare.net From the official conference website at en.oreilly.com Many people know Linux terminologies such as ext3, tmpfs, cfq io scheduler, OOM killer, etc. But many times it is not appropriately configured. In this session, the speaker will show Linux performance tuning [...] [...more]
InnoDB has an oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood. From the docs: “The number of threads that can enter InnoDB concurrently is determined by the innodb_thread_concurrency variable. A thread is placed in a queue when it tries to enter InnoDB if the number of threads has already reached the concurrency limit. When a thread [...] [...more]
Jimmy Yang (Oracle Corporation) speaks at the 2010 O’Reilly MySQL Conference and Expo Slides – assets.en.oreilly.com From the official conference website at en.oreilly.com Monitoring server through system monitor counter is a mechanism being widely used by all major DBMS to measure, analyze and tune the complicated server installation. A quick overview of the monitoring information [...] [...more]
A Perspective on Database Performance Tuning Last month, I covered IBM DB2 10 for z/OS: Justifying the Upgrade , and spoke briefly about the performance enhancements in that release that can help in justifying the upgrade to hard-nosed business execs looking for real return on investment for infrastructure projects. Read more on Database Journal [...more]
A Perspective on Database Performance Tuning Last month, I covered IBM DB2 10 for z/OS: Justifying the Upgrade , and spoke briefly about the performance enhancements in that release that can help in justifying the upgrade to hard-nosed business execs looking for real return on investment for infrastructure projects. Read more on Database Journal [...more]
