Category: MySql

MySql

Clear out MySql/MariaDB binary log files

I came across the following error while resroting a databsae in MariaDB. This is due to the excesive binary logs which are generated by database server. From MariaDB documentation – The binary log contains a record of all changes to the databases, both data and structure, as well as how long each statement took to execute. It …

Apache, CentOS/Rocky Linux, Cloud Linux, Control Panel, CPanel / WHM, DirectAdmin, Installation, MySql

How to set max_open_files in MariaDB / MySQL in CentOS 7

Set the system wide open file limit: vi /etc/security/limits.conf Change/Add the following: * soft nofile 1024000 * hard nofile 1024000 * soft nproc 10240 * hard nproc 10240 Now do this for /etc/sysctl vi /etc/sysctl Add the following fs.file-max = 1024000 Set the changes sysctl -w fs.file-max=1024000 sysctl -p # check changes cat /proc/sys/fs/file-max Set …

MySql

How to ‘safely’ delete Mysql relay-bin log file??

Disk is getting full. When using du, I could see my MySQL log folder is taking up all the disk. These files are not mysql-bin files, instead, these are mysql-relay-bin files. How can I truncate or purge these files? Mysql creates mysql-bin files which are called binary files for MySQL on the master side. It …

Linux, MySql

How to repair MySQL databases and tables on LINUX servers

In this article, we wish to provide you some helpful understandings on ways to repair work MySQL data source and table. This is most likely among one of the most typical, yet troublesome elements you might need to handle regularly. As you understand the MySQL data source is upgraded from time by time. MySQL handles …

freebsd, MySql

Error The Server Quit Without Updating Pid File

This detailed guide is mainly for FreeBSD, however the idea coincides for Linux. Every once a while, when I upgrade my FreeBSD box, the system prefers to shutdown my MySQL web server. Therefore, I need to begin it again after the upgrade is done. Sadly, the update process isn’t smooth every time. Sometimes it will …