Vyladění výkonu databáze s velkým objemem průmyslových dat

Loading...
Thumbnail Image

Downloads

4

Date issued

Authors

Víta, Viktor

Journal Title

Journal ISSN

Volume Title

Publisher

Vysoká škola báňská - Technická univerzita Ostrava

Location

Signature

Abstract

The subject of the submitted dissertation is the tuning of the database output for a large capacity of industrial data, whitch have been provided from the information system of the preparation plant in the mine in Darkov. The task of dissertation was to carry out the sets of tests and follow-up adjustment of parameters whitch would lead to the optimum run of the database system. In my dissertation I have focused on the analysis of effects on database output, the analysis of individual types of indexes and not least on the measurement of the effect of the adjusted parameters on real data from the industry. As follows I have recomended the specific adjustment of invidual parameters. The most important results from the exucuted tuning of the database for the large volume of data have been emphasized in the last part.

Description

Import 11/07/2012

Subject(s)

MySQL, engine, InnoDB, database, index, data types

Citation