- Le plus récent
- Le plus de votes
- La plupart des commentaires
From your description, I assume that the database instance in question is a Reader instance. Are you executing any SQL queries on this reader instance? Please note that the Performance Insights graph only displays the database load from active sessions on the database instance. If there are no active sessions on the replica instance, the graph will appear empty, as shown in the screenshot. I suspect that the load generated in the last 5-10 minutes is due to the replica processes applying SQL queries to synchronize with the primary database. So I think there is no issue with you performance insights graph. If you want to check the DB load of the writer instance select the writer in the drop down.
Ok. It is strange that you don't see DB load in the PI graph even if you have active db connections running some SQLs on the reader/replica instance. Performance Insights samples the state of connected sessions in your DB instance every second. Unless your sessions are disconnected for less than a second, it is very unlikely that those are missed from the graph. I suggest to reverify the correct reader endpoint in the application. Also check the active session on the database by connecting to the database directly and run the SQL queries. e..g, if your db engine is MySQL you can use below query SHOW FULL PROCESSLIST; if it is postgresql: SELECT * FROM pg_stat_activity; If you find the active sessions but can't see through Performance Insights, I suggest to open a case with AWS support.
Joseph, I followed your suggestion and checked using the query. It confirmed that the queries are running normally. However, we are unable to open a support case as you advised, because our current Support Plan is BASIC, which does not allow us to do so. That's why we are seeking help on re:post.SHOW FULL PROCESSLIST;
I see. I am out of ideas now. Interested see if anyone else faced the similar issue and found a solution.
Contenus pertinents
- demandé il y a un an
- demandé il y a 2 mois
- demandé il y a un an
- demandé il y a 7 mois
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
Hello Joseph,
First, thank you for your response to my question. I would like to list and discuss the points you mentioned: