Tuning

What Does Tuning Mean?

Database tuning is the process performed by database administrators of optimizing performance of a database. In the enterprise, this usually means the maintenance of a large database management system (DBMS) such as Oracle or MySQL. This includes optimizing the performance of the database itself as well as the underlying hardware.

Advertisements

Techopedia Explains Tuning

Since many businesses rely on complex database management systems, it is important to keep them running efficiently. Tuning means examining all parts of a database system, including all hardware and software, to minimize bottlenecks and keep query response times as short as possible.

Tuning encompasses the selection of hardware for servers, setting up RAID systems, deploying clusters and configuring operating systems as well as the database itself for optimum performance. Database tuning is typically done by database administrators or system administrators. Because it is such a complex process, research is being done into automating database tuning with machine learning.

Advertisements

Related Terms

Latest Database Terms

Related Reading

Margaret Rouse

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical, business audience. Over the past twenty years her explanations have appeared on TechTarget websites and she's been cited as an authority in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine and Discovery Magazine.Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages. If you have a suggestion for a new definition or how to improve a technical explanation, please email Margaret or contact her…