a month ago
I'm using Railway's managed MySQL service and I'd like to enable the performance_schema feature for query performance monitoring and memory usage analysis.
Currently when I run:
SHOW VARIABLES LIKE 'performance_schema';
It returns OFF, which means I'm unable to query tables like:
- performance_schema.memory_summary_global_by_event_name
- performance_schema.events_statements_summary_by_digest
According to MySQL 8.0 official documentation (https://dev.mysql.com/doc/refman/8.0/en/performance-schema-startup-configuration.html), enabling performance_schema requires adding performance_schema=ON to my.cnf under the [mysqld] section, followed by a server restart — which isn't possible in a managed environment without direct access to the configuration file.
Could you please:
- Enable performance_schema on my MySQL instance, or
- Let me know if there's a way to configure this through Railway's dashboard?
Thank you.
1 Replies
a month ago
This thread has been opened as a bounty so the community can help solve it.
Status changed to Open Railway • 30 days ago
a month ago
Currently, databases on Railway are unmanaged, you have total control over your database. You can modify the config files as you like since you have shell access to the container; just navigate to service settings> console, or ssh into the container using railway cli (https://docs.railway.com/cli).
Attachments