iTuned: a tool for configuring and visualizing database parameters

iTuned is a tool that takes a SQL workload as input and recommends good settings for database configuration parameters such as buffer pool sizes, multi-programming level, and number of I/O daemons. iTuned also provides response-surface and sensitivityanalysis plots that help database users analyze the impact of each parameter. iTuned has the following novel features: (i) a technique called Adaptive Sampling that proactively brings in appropriate data through planned experiments to find high-impact parameters and high-performance parameter settings, (ii) an executor that supports on-line experiments in production database environments through a cycle-stealing paradigm that places minimal overhead on the production workload, and (iii) portability across different database systems. This demonstration will focus on the interesting use-case scenarios of iTuned, and show its effectiveness on recommending configuration settings for popular database benchmarks. Categories and Subject Descript...

• Type: Conference
• Year: 2010
• Where: SIGMOD
• Authors: Vamsidhar Thummala, Shivnath Babu
• Keywords: Database, Database Configuration Parameters, Parameter, SIGMOD 2010