MariaDB updated this morning and as the graph illustrates, server memory consumption tripled. MariaDB would normally have a steady footprint below 500 Mb and now it’s 4 Gb. Which is the entire amount allocated to innodb_buffer_pool_size. Previously, I thought this number is what would be available but now it seems 10.11.12 is grabbing all of it.
I’m no db wiz but I have what I thought were configuration sweet spots that sustained a relatively small database for the past several months running 10.11 releases. Any ideas on what’s going on with 10.11.12?
Fwiw, this morning Nodeworx sent an alert about yum update failing:
Errors during downloading metadata for repository ‘mariadb-10.11’: - Status code: 404… Cannot download, all mirrors were already tried without success…
Lines like this are in the syslog going back 24-36 hours but the update finally ran this morning. Once alerted I checked and refreshed the system health page and the error was gone and the update appeared done. No biggy, I thought, until I noticed the memory spike. A brief shutdown had no effect and neither did reinstalling all of MariaDB.
Hello–
The system mysql instance is technically outside of the scope of our support, so I’m not sure offhand.
I do see that they just pushed an update to 10.11 on the 6th–there were a LOT of changes, though I’m not sure off the top of my head if any of the changes would cause memory to spike: Changes and Improvements in MariaDB 10.11 - MariaDB Knowledge Base
I’m not seeing anyone really talking about a spike after that update with a quick google, but it’s also possible that it’s too soon for folks to notice.
Have you checked any mariadb logging or in /var/log/messages to see if there is an excess of things running, or anything like that?
Thanks,
-Jenna
Just sitting there with no connections or queries, htop shows MariaDB using >50% of system memory while everything else looks normal. General/error/slow logs haven’t shown me anything pertinent, yet.
I will study this new release and follow up if I figure out anything. For the record, I’ll add that there’s also more CPU usage and swapping than usual.
Thank you!
System memory usage remains a lot higher than usual but down by a hefty chunk since the big spike. The database server is no worse off and running low on memory isn’t a concern like it was earlier.
Possibly what I saw has to do with a memory management change to 10.11.12, specifically the memory pressure interface mentioned in the release notes.
