maria-developers team mailing list archive

[jerome brauge <j.brauge@xxxxxxxxxxx>]

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.