Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
8 subscribers
Views
2206 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
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?
OriginalPostID-234531
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