MySQL performance tuning

mikej117 over 7 years ago

I discovered the Status screen on the MySQL Database console (phpMyAdmin) which is offering some recommendations for analysing and improving performance issues. One of these recommendations was to turn on 'slow query logging', which I hope would capture the SQL queries that are running slowly. I'd like to use this information to determine where to add table indexes.
However, I found that I don't have sufficient privileges to modify the database system variables to enable this logging. The database is hosted on an Appian cloud server. Is there a way to grant access, or do I need to raise a support request?

Discussion posts and replies are publicly visible

0 Eduardo Fuentes
Appian Employee
over 7 years ago

That setting is not a configurable one for Appian Cloud. However, Appian has logs to measure the performance of database related operations that Appian generates forum.appian.com/.../Logging.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mikej117 over 7 years ago

Thanks Eduardo. I was hoping to be able to get the DB to show me the query plan for the slow queries.
Is there a way to access that information? Or should I try to convert the pseudo-code in file perf_monitor_rdbms.csv into SQL and get the query plan via phpMyAdmin?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 7 years ago

You can request to increase the logging level if you wanted to see the queries that Appian is executing, the output is verbose though so if you request that it'd be for just a short period of time to avoid excessive disk space usage.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mikej117 over 7 years ago

OK, thanks Eduardo.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel