I have a problem in our share-hosting. MySQL (using MariaDB) not able to stop and start. What a problem is?.
Symptoms:
1. using 'innodb' as 'storage-engine' in 1 or more database
2. have 'log-bin=mysql-bin' inside '/etc/my.cnf' and or '/etc/my.cnf.d/my.cnf'
3. many files named as 'mysql-bin.*' inside '/var/lib/mysql'
4. this 'mysql-bin' files eat disk usage --> in my server until disk usage until 100%
Solutions:
1. Change 'log-bin=mysql-bin' to '#log-bin=mysql-bin'
2. restart mysql with 'sh /script/restart-mysql'
3. delete all 'mysql-bin' files with 'rm -rf /var/lib/mysql/mysql-bin.*'
-------
Note:
- log-bin only needed for 'replications' purpose