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     : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to