- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
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.
Contenuto pertinente
- Perché non riesco ad accedere o visualizzare i dati di Performance Insights in Amazon RDS per MySQL?AWS UFFICIALEAggiornata 3 anni fa
- AWS UFFICIALEAggiornata 4 mesi fa
- AWS UFFICIALEAggiornata 2 anni fa
Hello Joseph,
First, thank you for your response to my question. I would like to list and discuss the points you mentioned: