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…
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…
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…
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…
MYSQL/Mariadb 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…
How to Restore One Database From All Database mysqldump
In this tutorial we are going to learn how to restore single MySQL database from a mysql backup file, which contains multiple databases. What if you backed up all databases…
How to install mytop on CentOS 7 to monitor MySQL processes
Mytop is an open source, command line tool used for monitoring MySQL performance. Mytop program provides a command-line shell interface to monitor real time MySQL/MariaDB threads, queries per second, process…
Install and Configure MySQL Workbench on Ubuntu Linux
MySQL workbench is a graphical application that lets us manage data and perform administrative tasks on MySQL databases. In this tutorial, we will see how to install the program on…