search cancel

How to Recognize Larger MySQL Disk Volume

book

Article ID: 257393

calendar_today

Updated On:

Products

CA API Gateway

Issue/Introduction

We recently were able to expand the size of the disk volumes upon which the MySQL DB resides in our AWS based API Gateway appliances (/var/lib/mysql) from approximately 20 GB to 500 GB (a 25 times increase).   Though we have rebooted the gateways that have expanded drives, they still see the maximum database size as unchanged from its earlier size.   This results in the GW stopping audit logging when the new volume is only 4% full (we have audit.managementStrategy = BYPASS).

How can we make the GW recognize the increase in available disk space? 

Environment

Release : 10.1

Resolution

When using LVM to expand the disk space mysql wont show any additional space until increasing the size of the ibdata in the /etc/my.cnf

# more /etc/my.cnf | grep -i ibd
innodb_data_file_path=ibdata:100M:autoextend:max:15776M

Max size is set to 15/16M. This needs to be increased and restart mysql to see any size gain in the mysql and calculation of the audit usage thresholds.