How to Enable Query Cache in MariaDB for Performance in CWP/hestiacp/Centos/Ubuntu
Sandeep B. Today we’ll learn how you can enable query cache in MariaDB server, it has several caching mechanisms to improve performance the query…
MySQL
Optimize Mariadb/MySQL server for 4 GB RAM VPS
If you have a MariaDB/MySQL VPS server with 4GB of RAM, you can optimize its performance by following these steps: If you’re…
Enable Slow Query Log in MariaDB for Performance
In this tutorial we’ll learn how to enable slow query log in MariaDB server. Slow queries are often the main reason behind…
Upgrade/Install Mariadb 10.11 In CWP/Centos 7/8 stream/AlmaLinux 7/8/RockyLinux 7/8
In this tutorial I’ll guide you on how to upgrade/install MariaDB to latest Mariadb10.11 on Centos 7/8/el8 this tutorial will also work…
How to Disable MySQL Strict Mode CWP/Centos/Ubuntu/AlmaLinux
Today we’ll learn how you can easily disable mysql strict mode in MySQL/MariaDB Server on any Linux os such as Centos/Ubuntu/RHEL/AlmaLinux and…
Optimize and Repair MySQL Database via CLI CWP/Centos/Ubuntu/EL7/EL8
Today we’ll learn how we can optimize and repair MySQL databases via command line interface, probably you’ve already optimized and repaired dbs…
How to Reset root password in MariaDB 10.5/10.4 and Mysql 8.0
In this tutorial I’ll provide you the steps to reset root password for MySQL 8.0 and MariaDB 10.4 easily and efficiently. Since…
How to import large MySQL database via command line on CWP, VestaCP and Cpanel server
In this tutorial we’ll learn how to import large mysql databases via ssh terminal command line interface. Large mysql database is the…
Update/Upgrade to MariaDB 10.6/10.5/10.4 on VestaCP/CWP/CentOS 8 Stream/CentOS 7
In this tutorial I’ll guide you on how to upgrade/install MariaDB to latest Mariadb10.4 on Centos 7 this tutorial will also work…