Hi,
I'd like to know what is the best way to track memory consumption /leak in
mariadb.
Our application use intensively stored procedure and with only 35 connection we
have to restart mariadb each 1.5 hours because it use 15Go of memory very fast.
Mysqladmin doesn't show excessive memory consumption :
| Max_used_connections | 42
|
| Memory_used | 2422894288
|
| Memory_used_initial | 291786624
|
But
[root@vmdevmdb ~]# ps -up 20039
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
mysql 20039 10.5 73.8 14574168 12000852 ? Ssl 14:30 11:19
/usr/sbin/mysqld
--> 12Go of resident memory in only 11 minutes of cpu.
Best regards
Jérôme.
Ce message et les pièces jointes sont confidentiels et établis à l'attention
exclusive de ses destinataires. Toute utilisation ou diffusion, même partielle,
non autorisée est interdite. Tout message électronique est susceptible
d'altération; CEGID décline donc toute responsabilité au titre de ce message.
Si vous n'êtes pas le destinataire de ce message, merci de le détruire et
d'avertir l'expéditeur.
This message and any attachments are confidential and intended solely for the
addressees. Any unauthorized use or disclosure, either whole or partial is
prohibited. E-mails are susceptible to alteration; CEGID shall therefore not be
liable for the content of this message. If you are not the intended recipient
of this message, please delete it and notify the sender.
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
