{"id":6955,"date":"2017-09-07T15:28:04","date_gmt":"2017-09-07T15:28:04","guid":{"rendered":"https:\/\/www.cloudiqtech.com\/?p=6955"},"modified":"2019-09-13T06:01:58","modified_gmt":"2019-09-13T06:01:58","slug":"mysql-aurora-database-troubleshooting","status":"publish","type":"post","link":"https:\/\/www.cloudiqtech.com\/mysql-aurora-database-troubleshooting\/","title":{"rendered":"MYSQL \/ AURORA Database Troubleshooting"},"content":{"rendered":"\n
Here is a look at some of the common queries that will be useful when troubleshooting AURORA database.<\/p>\n
SELECT SUBSTRING(HOST, 1, 10) , DB,USER , COUNT(*) AS Count\n FROM information_schema.processlist \n group by SUBSTRING(HOST, 0, 10) , DB,USER \n ORDER BY Count desc ;\n -- '10.10.50.22', 'Portal', 'webguest-dev', '46'<\/code><\/pre>\n\n Aurora Max Connections<\/h5>\n select AURORA_VERSION();\n select * from mysql.slow_log \n where sql_text not like '%LOAD DATA%'\n order by query_time desc\n limit 1000 ;\n \n select count(*) from mysql.general_log \n where user_host not like 'rdsadmin%'\n and user_host not like '[rdsadmin]%'\n and event_time > '2017-06-15 18:51:14';\n \n select current_timestamp();\n \n desc mysql.general_log ;\n \n select @@MAX_CONNECTIONS\n -- '4000'\n \n select * from mysql.general_log \n where command_type like '%Connect%';\n \n select * from mysql.general_log_backup \n where command_type like '%Connect%' ;\n \n SHOW GLOBAL STATUS LIKE '%Connection_errors%';\n \n SHOW STATUS WHERE `variable_name` = 'Threads_connected';<\/code><\/pre>\n <\/div>\n","protected":false},"excerpt":{"rendered":"Here is a look at some of the common queries that will be useful when troubleshooting AURORA database. Number of Connections by Host SELECT SUBSTRING(HOST, 1, 10) , DB,USER , COUNT(*) AS Count FROM information_schema.processlist group by SUBSTRING(HOST, 0, 10) , DB,USER ORDER BY Count desc ; — ‘10.10.50.22’, ‘Portal’, ‘webguest-dev’, ’46’ Aurora Max Connections […]<\/p>\n","protected":false},"author":3,"featured_media":7402,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"brizy-blank-template.php","format":"standard","meta":{"inline_featured_image":false},"categories":[30],"tags":[],"yoast_head":"\n
MYSQL \/ AURORA Database Troubleshooting | CloudIQ Tech<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\n\t\n\t\n\t\n