Inquire about mysql memory leak
I'm using the following version of mySQL. $ mysql -V mysql Ver 15.1 Distrib 10.3.39-MariaDB, for Linux (x86_64) using readline 5.1
In the shell script set to deamon, one DB Query syntax is repeated infinitely every three seconds, and the memory of the shell script continues to grow. Script contains only one command.
/bin/mysql -h$DB_IP -u$USER_ID -p$USER_PW --port $DB_PORT -D $DB_NAME "select @@hostname" > /dev/null 2>&1
I think memory leak occurs, is there any memory leak related information or bug patch information in that version of mysql?
Answer Answered by Kristian Nielsen in this comment.
You write that it is the memory of the shell script that continues to grow.
This is unlikely to be related to the mysql client program (or mysql/mariadb server) in any way, since the /bin/mysql program runs in a separate process from the shell script.
Memory associated with the process running the shell script can only be allocated from within that process, it cannot be affected by processes spawned by the shell script.