Abstract
An accurate use of the ability to steer computer efficiency is essential from the database point of view. Effective resource allocation is dependent on the performance indicators gathered from
running systems. There must be an appropriate balance between accurate measurements, performance
indicators and speed of the reallocation algorithms of the computing resources. The extended measurement
of efficiency which the authors propose for applications is: the average number of queries within a time unit
for particular groups of users. This paper presents an analysis of using the Workload Manager utility in the
AIX 5L operating system to improve the efficiency of applications in the MySQL database environment,
and an analysis of methods which allows the use of Workload Manager for steering efficiency dynamically.
Go to article