Monitoring queries that are causing system bottlenecks is a common and extremely useful task. MySQL comes by default with the mysqladmin utility, which allows you to perform administrative tasks such as checking the MySQL server’s configuration, status, creating a database and so on. How to monitor Queries in real time using mysqladmin ? Given the
Accidents happen. Losing or forgetting a password is not uncommon. In this brief guide, we’ll teach you how to change the MySQL root password on Linux servers. First of all, make sure you are logged in as root. We will edit the file “ /etc/my.cnf ” file and add the following directive at the end
Instead of dumping all the tables, as an alternative we can copy the necessary files from the MySQL “data” folder, and then restore these files in your new WAMP installation. Copy all the files with the prefix “ib” and all the folders that correspond to the databases you want to back up, just as
The SQL language allows tables to be joined, but sometimes these commands are forgotten and/or we get confused about the real purpose of each one. Let’s take a look at the image below, representing the various forms of JOINS: INNER JOIN Intersection between tables. Example: SELECT <colunas> FROM Table_A A INNER JOIN Table_B B ON
