
Three Methods to Check Uptime of MySQL/MariaDB Database Server on Linux
We all know the purpose of the uptime command in Linux. This is used to check the uptime of the Linux system and how long the system runs without restarting. …
Read MoreLinux and Unix, Open Source, Linux Howtos
We all know the purpose of the uptime command in Linux. This is used to check the uptime of the Linux system and how long the system runs without restarting. …
Read MoreMyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.This will help us to write queries faster and easy which was written in Python …
Read MoreMytop is a console-based (non-gui) tool that display MySQL server performance information like “top”. It will connect to a MySQL server and periodically run the SHOW PROCESSLISTand SHOW STATUS commands …
Read MoreI’m doing some research in owncloud installation and every time i want to clear the database tables so that, i can go forward. Every time i used to drop the …
Read MoreHere i’m going to explain, step’s to reset/clear MySQL (Master-Slave) replication. Two way of RESET is must be handle, so that it will reset/clear properly. Slave Server RESET Master Server …
Read MoreMySQL master-slave replication is a process that automatically copies data from one MySQL database server (master) to one or more MySQL database servers (slaves). MySQL supports various replication methods, but …
Read MoreThere are many ways that we can connect the remote MySQL/MariaDB database. You can use the GUI client called MySQL Workbench. Alternatively, we can access it right from Linux terminal. …
Read MoreSome times we may forget MySQL/MariaDB root user password. It’s happening everywhere. It’s human mistake and it known things. It’s happening for everyone and not only for me. If so, …
Read MoreHere i’m going to explain, step’s to connect the mysql database remotely. 1) If you want to access mysql database remotely, you should have a Static IP so that you …
Read MoreSometimes you may need to check the size of each MySQL/MariaDB database and table to optimize or repair them due to some reason. So, what to do? is there any …
Read More