iTuned: a tool for configuring and visualizing database parameters

9 years 10 months ago
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...
Vamsidhar Thummala, Shivnath Babu
Added 06 Dec 2010
Updated 06 Dec 2010
Type Conference
Year 2010
Authors Vamsidhar Thummala, Shivnath Babu
Comments (0)