Tuning database configuration parameters with iTuned
Proceedings of the VLDB Endowment
Automated experiment-driven management of (database) systems
HotOS'09 Proceedings of the 12th conference on Hot topics in operating systems
Skyline and mapping aware join query evaluation
Information Systems
A bayesian approach to online performance modeling for database appliances using gaussian models
Proceedings of the 8th ACM international conference on Autonomic computing
PerfXplain: debugging MapReduce job performance
Proceedings of the VLDB Endowment
| Hi-index | 0.00 |
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 sensitivity-analysis plots that help the end-user 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 the effectiveness of recommended configuration settings on popular database benchmarks.