En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

How can I see and terminate the active sessions on my mariadb?

0

Hi! We have a Mariadb rds (db.m5.xlarge) and lately I've seen that under "Current activity" the amount of sessions goes crazy high which creates a big problem for our app as it starts refusing new connections. When this is happening the CPU Util% remains low. My question is, how can I see and possibly terminate sessions through cli or the console?

Appreciate your help!

  • Arthur Lopes
    il y a 9 mois

    Closing connections server side is just a paliative solution. I highly suggest you to find which proccess are keeping open connection e fix it.

Sujets
Base de données
Balises
MariaDB
Langue
English
Jose Cifuentes
demandé il y a 9 mois377 vues
1 réponse
0

Hello.

The number of sessions can be checked with the following command.

show status like 'Threads_connected';

You can check the process being processed with the following command.

show processlist;

You can erase the process by specifying the process ID with the following command.

kill processId;
profile picture
EXPERT
Riku_Kobayashi
répondu il y a 9 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents