1 / 9

Auto Tuning: Maximizing Performance and Efficiency in Database Systems

This paper explores the various issues and considerations involved in auto tuning database systems, including trade-off decisions, selection of functionality, dynamic resource allocation, and discovery processes. It also discusses the importance of high-level abstractions and trade-off models in optimizing performance.

afranks
Download Presentation

Auto Tuning: Maximizing Performance and Efficiency in Database Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. No Knobs Dave DeWitt and Dieter Gawlick Lowell 2003

  2. A List of Issues • Auto Tuning • Trade-off decisions • Selection of functionality • Discovery Lowell 2003

  3. Auto Tuning • Dynamic allocation of existing resources • CPUs (blades), CPU cycles, processes, memory, storage, bandwidth, … • Index management, materialized view, query optimization, query re-write, … • Integrated with failure reaction (Disposable disks (RAID), disposable computers (blades)) • Low variance in response time • Advisors for need/impact of new resources Lowell 2003

  4. Auto Tuning • Single/multiple database(s)/database instance(s) • Two computer centers • Few blade computers in each • This is mostly engineering work • Keep knobs • Make use optional, maybe set by/through applications • Prepare code • Monitor, adjust • All database vendors are working hard on it Lowell 2003

  5. Auto Tuning • Research questions? • What to do with a bad query/program? • Reports are not the solution • 80% case: • How do we know that we are at 80%? • Maybe we are at 1/10% of optimum Lowell 2003

  6. Trade-off Decisions • Which application/task/user is most important? • To be defined on high level • Rules and regulation • Generic applications should set this should set this • Business value of application • Business transactions or part thereof • Generic • Content dependent • Organization • People (static resources) Lowell 2003

  7. Trade-off Decision • To be used as input for auto tuning • A model for high level abstractions would be helpful - Research issue? Lowell 2003

  8. Selection of Functionality • Feature Enabling • Option • Customization, preferences • Sources • Rules and regulations • Domain, enterprise, department, people • (Security) • Should be closely tied to model for trade-off decisions Lowell 2003

  9. Discovery • Low level discovery process • New/broken disks, blades, … • Depending on naming conventions and standards • Mostly a systematic engineering effort • High level discovery process • Semantic transformation , … Lowell 2003

More Related