Database Design: Difference between revisions
Jump to navigation
Jump to search
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
== Design == | == Design == | ||
* [[DatabaseDesign|Design]] - The PlaneShift database schema. ( | * [[DatabaseDesign|Design]] - The PlaneShift database schema. (This section is under GPL) | ||
== Useful queries == | |||
Here are some [[useful queries]]. | |||
== Howtos == | == Howtos == | ||
* [[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@'%'; | |||
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 | |||
[[Category:Engine documents]] | |||
Latest revision as of 20:32, 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@'%';
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