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
2229 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
MySQL performance tuning
mikej117
over 8 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
Parents
0
Eduardo Fuentes
Appian Employee
over 8 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
Reply
0
Eduardo Fuentes
Appian Employee
over 8 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
Children
No Data