Database Design: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 10: | Line 10: | ||
* [[HowtoAddASpellToTheDatabase|Howto add a spell to the database.]] | * [[HowtoAddASpellToTheDatabase|Howto add a spell to the database.]] | ||
== Database Performance Monitoring == | |||
Tried Percona: https://www.percona.com/ | |||
<code>CREATE USER 'percona'@'%' IDENTIFIED BY PASSWORD 'percona';</code> | |||
GRANT SELECT ON performance_schema.* TO percona@'%'; | |||
GRANT SELECT, PROCESS, REPLICA MONITOR ON planeshift_prod2.* TO percona@'%'; | |||
[[Category:Engine documents]] | [[Category:Engine documents]] | ||
Revision as of 19:42, 5 October 2024
Design
- Design - The PlaneShift database schema. (This section is under GPL)
Useful queries
Here are some useful queries.
Howtos
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@'%';