Learn – MySQL QueriesA list of commonly used MySQL queries to create database, use database, create table, insert record, update record, delete record, select record, truncate table and drop table are given below.1) MySQL Create Database
Blocked queries: Blocked queries can occur because a transaction in InnoDB is waiting for another transaction to release a lock. Queries can also be blocked… Read More »Finding Mysql blocking queries and Deadlocks
To Show Databases show databases; To change database schema for query use sys To Show all processes running in mysql select * from processlist\G To… Read More »Mysql statements usefull statements for DBA
Install MySQL using configuration file sudo su sudo apt-get install gedit cd /opt tar xf /home/oem/Downloads/mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz mkdir /usr/local/mysql chmod 764 /usr/local/mysql ln -s /opt/mysql-5.7.29-linux-glibc2.12-x86_64/* /usr/local/mysql… Read More »Installation and Configurations of Mysql instance
Running Multiple MariaDB Instances on Linux Mint Today lets explore how to run multiple instances of the MariaDB database server software on the same computer/server.… Read More »Running Multiple MariaDB Instances on Linux Mint