Vyladění výkonu databáze s velkým objemem průmyslových dat
Loading...
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