I'm using BlueG's MySQL plugin version R41-4 and MySQL 8.0.35 on my Ubuntu 22.04.
Every hour, the RAM usage of my mysqld process slowly increases. I have running queries every minute to update business earnings, and at this point, I assume that the problem is due to these minute-by-minute updates.
So, my question is, what is the best MySQL native function for this case? Currently, I'm using mysql_query to update every minute.
Honestly, I also use mysql_query for all queries in my script, and I'm unsure when to use mysql_tquery or mysql_pquery.
I'm also curious about why the RAM usage of my mysqld process always increases?