Page 250 - Srednje skole - radovi

MYSQL MONITORING

Autor: Nikola Ilić, uĉenik drugog razreda ETŠ “Nikola Tesla”, Beograd
Mentor: Mateja Opaĉić, asistent pripravnik u univerzitetu “Metropolitan”, Beograd

REZIME

Database monitoring predstavlja prikaz svih desavanja na odredjenoj bazi padataka, odnosno
na njenim tabelama, u realnom vremenu. Sistem se sastoji od grafickih i tabelarnih prikaza

rada MySQL baze podataka. Ovaj projekat je napisan u PHP-u i koristi MySQL bazu, uz
blagu primenu JavaScript-a i AJAX-a.

Osnovna svrha i cilj ovoga projekta, jeste da na najefikasniji naĉin prikaze desavanja na

konkretnoj bazi i omoguci korisnicima uvid u rad iste. Sistem registruje UPDATE, INSERT
ili DELETE SQL komande, i u istom trenutnu ih belezi i ispisuje na stranici, u cilju stvaranja

statistickih podataka odredjene baze.

Kljuĉne reĉi:baze podataka, tabele, monitoring, grafik, php, mysql

SUMMARY

Database monitoring represent a view of all events on particular database, i.e. on its tables in

real-time. System consists of graphic and tabular display of work of MySQL database. This
project is written in PHP and uses MySQL database, with little implementation of JavaScript

and AJAX.

Main purpose of this project is to, on the most efficiently way, display all events on
chosen database and allow users access to the work of the same.System register UPDATE,

INSERT or DELETE SQL commands, and at same time record and write them on the page, in

purpose of creating statistics of certain database.

Keywords: databases, tables, monitoring, graph, php, mysql