A Log Analyzer for Database Tuning


The KIPS Transactions:PartD, Vol. 11, No. 5, pp. 1041-1048, Oct. 2004
10.3745/KIPSTD.2004.11.5.1041,   PDF Download:

Abstract

Database logs contain various information on database operations, but they are used to recover database systems from failures generally. This paper proposes a log analysis tool that provides useful information for database tuning. This tool provides users with information on workload organization, database schemas, and resources usages of queries. This paper describes the tool in views of its architecture, functions, implementation, and verification. The tool is verified by running the TPC-W benchmark, and representative analysis results are also presented.


Statistics
Show / Hide Statistics

Statistics (Cumulative Counts from September 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


Cite this article
[IEEE Style]
S. H. Lee, S. J. Kim, S. H. Lee, "A Log Analyzer for Database Tuning," The KIPS Transactions:PartD, vol. 11, no. 5, pp. 1041-1048, 2004. DOI: 10.3745/KIPSTD.2004.11.5.1041.

[ACM Style]
Sang Hyup Lee, Sung Jin Kim, and Sang Ho Lee. 2004. A Log Analyzer for Database Tuning. The KIPS Transactions:PartD, 11, 5, (2004), 1041-1048. DOI: 10.3745/KIPSTD.2004.11.5.1041.