You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Munin is reporting a critical error with "MySQL InnoDB free table space" on all graphs maxed out at 8.0M and average 6.97M on the year graph.
Our dedicated server spec is
Platform: Linux
Operating System: CentOS 7 64-bit
Control Panel: cPanel Pro
CPU: 1x Intel Xeon E3-1230v5 @ 3.4GHz
Memory: 2x 8GB DDR4 U
Hard Drive: 2x 120GB SSD RAID1
Can you advise how we can rectify the error?
Would having a clearout of the DB help and if so how to do that?
I have asked our webhost to advise as well.
Last edited by sdn (02-07-2020 04:15:58)
Offline
Our webhost has replied as follows:
This is a known issue with Munin and the way it interacts with MySQL and InnoDB.
Munin throws a warning whenever there is >2GB of table space and a critical warning at >1GB tablespace remaining.
MySQL defaults to creating a 10MB auto-expanding tablespace ( this can be verified with # mysql -e "SHOW VARIABLES LIKE 'innodb_data_file_path'"
This means InnoDB will perpetually show <10MB of space (resulting in a permanent Munin warning) yet will always seamlessly autoextend as needed.
The way to resolve is for us to simply to disable the alerts through creation of this file:
# vi /etc/munin/plugin-conf.d/mysql_innodb
And placing the following inside
[mysql_innodb]
env.warning 0
env.critical 0
Offline
Thanks for the follow-up. To safely clear space in the database by removing old sessions and carts, execute these commands:
DELETE FROM ecom_cart DELETE FROM core_sessions
FYI: Versions 9.0.2 are very highly optimized in regard to database storage requirements that I doubt you'll find any tables you think are too large. On busy sites we were seeing the core_sessions table expand to over 1 million rows over time and maintaining that level due to the way V8 pruned old entries. The same sites using K9 (9.0.2+) are seeing that same table at 150k rows with four times the traffic. So make sure you're on 9.0.2+, which I believe you are.
Offline