This will be the quick one to give you an idea how you can workaround memory leaks coming from long-running sessions, in case you are using ProxySQL.
Continue reading “THD::variables – ProxySQL to the rescue”Tag: memory leak
Memory leak in MySQL 8 with indexed generated virtual columns
Some time ago we have observed that memory for some MySQL instances has been constantly eaten away. Investigation pointed us to memory/innodb/memory area and databases with tables having generated virtual columns, which in addition were used in indexes. It was affecting both 8.0.25 and 8.0.28 instances (we haven’t checked the other versions), both master and its replicas.
Change is the only constant... 