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@'%';