MySQL

Content

• MySQL - List Connections and Users
• MySQL - Generate deadlock

Basic Commands

mysql -h HOST -u admin -p
 
show databases;
create database DB;
use DB;
show tables;
 
show status where `variable_name` = 'Threads_connected';
show processlist;
SHOW ENGINE INNODB STATUS;
 
-- list tables
select distinct table_name from information_schema.tables;

Logging

mysql> SHOW VARIABLES LIKE "general_log%";
mysql> SET GLOBAL general_log = 'ON';
less $general_log_file

Mysql Import/ Export (Dump)

mysqldump \
  --databases DB \
  --triggers --routines \
  --set-gtid-purged=OFF \
  -h host -u admin -p -r "/tmp/dump.sql"
 
mysql -h HOST -u admin -p < /tmp/dump.sql

Kubernetes Pod

apiVersion: v1
kind: Pod
metadata:
  name: mysql-8-0-22
  # namespace: dev
spec:
  containers:
    - name: mysql-8-0-22
      image: mysql:8.0.22
      # resources:
      #   requests:
      #     cpu: 100m
      #     memory: 128Mi
      command: ["tail", "-f", "/dev/null"]