Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: master

database: recommondations on database indexes

The web-interface will get slower and slower as more records are added.
As I don't know enough about database, I have to rely on advice from others.

These indexes were recommended by a user of the IPTV-analyzer:
 create index idx_logevent_rtime on log_event(probe_id,record_time);
 create index idx_logevent_mchannel on log_event(multicast_dst,record_time);

Which solved his performance issues.

Signed-off-by: Jesper Dangaard Brouer <brouer@redhat.com>
latest commit 65b2c59ab6
Jesper Dangaard Brouer authored
..
Failed to load latest commit information.
README.wiki
changes-between-versions.wiki db: No need to to DB changes, drop "ok_signal" event_type.
database-schema-0.9.0.sql db: Added file database-schema-0.9.0.sql for tracking v0.9.0
database-schema-0.9.1.sql db: Fix syntax error in database-schema
database-schema-latest.sql
database-upgrade-0.9.0-to-0.9.1.sql db+collector: Complete the rename from mp2t to mpeg2ts
notes_on_database_design.txt database: recommondations on database indexes

README.wiki

Table of Contents

Quick database HOWTO

Create the database

On database server call:

 mysql -u root -p

At the mysql prompt, write:

 drop database if exists tvprobe;
 create database tvprobe;

Grant access to database

At the mysql prompt, write:

 grant all on tvprobe.* to 'tvprobe'@'localhost' identified by 'CHANGEPASSWORD';
 flush privileges;

If you want to, grant remote access:

 grant SELECT, INSERT, UPDATE, EXECUTE on tvprobe.*
       to 'tvprobe'@'HOSTNAME.yourdomain.dk'
       identified by 'CHANGEPASSWORD';
 flush privileges;

Create tables

At the UNIX prompt write:

 mysql -u root -p tvprobe < database-schema-latest.sql
Something went wrong with that request. Please try again.