By default MariaDB will create temporary table structure in /var/tmp and this fills up space of root file system(https://cdn.thegeekdiary.com/). We can change default setting by assigning a custom temp directory in '[mysqld]' section in my.cnf file. MariaDB creates temporary table structure in tmpdir(/var/tmp) directory when there are huge/bulk inserts into table. By default, MariaDB will create temporary table structure in /var/tmp directory. To change the default setting, add a variable tmpdir in [mysqld] section in … [Read more...] about /var/tmp file system getting full due to Mariadb
MariaDB
How to install and configure MariaDB in CentOS / RHEL 7
MariaDB is the default implementation of MySQL in Red Hat Enterprise Linux 7. MariaDB is a community-developed fork of the MySQL database project, and provides a replacement for MySQL. Installing MariaDB 1. As the MariaDB Database Management System (DBMS) is not installed by default on RHEL/CentOS 7, we will start this recipe by installing the required packages. # yum install -y mariadb mariadb-server Here, mariadb-server - is the MariaDB server package mariadb - is the client shell … [Read more...] about How to install and configure MariaDB in CentOS / RHEL 7