Database Design

Design

• Design - The PlaneShift database schema. (This section is under GPL)

Useful queries

Here are some useful queries.

Howtos

• Howto add a spell to the database.

Database Performance Monitoring

Tried Percona: https://www.percona.com/

CREATE USER 'percona'@'%' IDENTIFIED BY PASSWORD 'percona';

GRANT SELECT ON performance_schema.* TO percona@'%';

GRANT SELECT, PROCESS, REPLICA MONITOR ON planeshift_prod2.* TO percona@'%';

I've edited this file:

/etc/mysql/my.cnf

and added this:

[mysqld]
performance_schema=ON
performance-schema-instrument='statement/%=ON'
performance-schema-consumer-statements-digest=ON
innodb_monitor_enable=all

restarted the service

service mysqld restart