How does Amazon RSD view slow_log
This article mainly shows you "Amazon RSD how to view slow_log", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "Amazon RSD how to view slow_log" this article.
Amazon RSD View slow_log
Amazon RSD does not provide SSH direct access to db server.
However, Amazon RDS Command Line Toolkit is provided, but it is not so convenient to adjust some system parameters of mysql.
Here we mainly record the operation of viewing slow_log.
1 、 Amazon RDS Command Line Toolkit
Http://aws.amazon.com/developertools/2928
This machine decompresses, the configuration environment variable can be used. For more information, please see http://docs.amazonwebservices.com/AmazonRDS/latest/CommandLineReference/StartCLI.html
2. Create a DB Parameter group
$rds-create-db-parameter-group-db-parameter-group-name testgroup
3. Modify the parameter group of db instance
$rds-modify-db-instance DBInstanceIdentifier-db-parameter-group-name testgroup
4. Modify the relevant system parameter www.2cto.com in testgroup
/ / record SQL statements that do not use indexes
$rds-modify-db-parameter-group upondefault-- parameters "name=log_queries_not_using_indexes,value= [color = red] on [/ color], method=immediate"
/ / set the time threshold for slow query to 1 second.
$rds-modify-db-parameter-group upondefault-parameters "name=long_query_time,value=1,method=immediate"
/ / record slow query SQL statement
$rds-modify-db-parameter-group upondefault-- parameters "name=slow_query_log,value= [color = red] on [/ color], method=immediate"
Because the above three parameters are all dynamic, it is not necessary to restart DB instance.
5. Access mysql server through the client.
$mysql-h hostname-uusername-ppassword
Mysql > use mysql; www.2cto.com
Mysql > show tables
+-+
| | Tables_in_mysql |
+-+
| | columns_priv |
| | db |
| | event |
| | func |
| | general_log |
| | help_category |
| | help_keyword |
| | help_relation |
| | help_topic |
| | host |
| | ndb_binlog_index |
| | plugin |
| | proc |
| | procs_priv |
| | rds_sysinfo |
| | servers |
| | slow_log |
| | tables_priv |
| | time_zone |
| | time_zone_leap_second |
| | time_zone_name |
| | time_zone_transition |
| | time_zone_transition_type |
| | user |
+-+
The slow_log table above is the table that needs to be viewed. The records in this slow_log table cannot be deleted.
Because slow_log actually maps to a csv file. But with this, we can quickly
Locate the sql that slows down the system performance.
Mysql > select * from slow_log order by query_time desc limit 100
Recording slow_log will affect the performance of the system and can be turned off after recording for a period of time.
Rds-modify-db-parameter-group upondefault-- parameters "name=log_queries_not_using_indexes,value= [color = red] off [/ color], method=immediate"
Rds-modify-db-parameter-group upondefault-- parameters "name=slow_query_log,value= [color = red] off [/ color], method=immediate"
The above is all the contents of the article "how to check slow_log by Amazon RSD". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!
