#nav-small-js {display:none;}

MySQL Snippets

MySQL Snippets/

ANALYSE

DBMS Snippets

ANALYSE MySQL

Backup Restore

DBMS Snippets

mysqldump MySQL

Benutzer, Rechte

SHOW GRANTS FOR user

DBMS Snippets

GRANT MySQL

Binary Logs

SHOW BINARY LOGS

DBMS Snippets

Logs MySQL

Data Dictionary

SHOW DATABASES|TABLES DESCRIBE

DBMS Snippets

SHOW MySQL

Datenbanken verschieben

Datenbank auf andere Partition verschieben (Linux)

DBMS Snippets

MySQL

Dynamisches SQL

SELECT CONCAT(‘ALTER TABLE ‘, table_schema ,’.',table_name, ' ENGINE=InnoDB;')

DBMS Snippets

SELECT MySQL

Explain

EXPLAIN EXTENDED select * from tbl_name where … like ‘%';

DBMS Snippets

EXPLAIN MySQL

Flush

DBMS Snippets

FLUSH Logs MySQL

INFORMATION_SCHEMA

SELECT … FROM information_schema.columns

DBMS Snippets

Information Schema MySQL

mysisamchk

DBMS Snippets

mysisamchk MySQL

mysqlanalyze

mysqlanalyze -p –all-databases mysqlanalyze -p –databases db1 db2 db3

DBMS Snippets

mysqlanalyze MySQL

mysqlcheck

mysqlrepair # = The default option is –repair mysqlanalyze # = The default option is –analyze mysqloptimize # = The default option is –optimize mysqlcheck -u root -p -–databases …

DBMS Snippets

mysqlcheck MySQL

mysqloptimize

mysqloptimize -p database_name table_name1 table_name2 table_name3

DBMS Snippets

mysqloptimize MySQL

Open Tables

SHOW OPEN TABLES

DBMS Snippets

SHOW MySQL

OPTIMIZE

DBMS Snippets

OPTIMIZE MySQL

Profiles

DBMS Snippets

SHOW MySQL

Prozesse

SHOW FULL PROCESSLIST

DBMS Snippets

SHOW MySQL

Replikation

Master mit Slaves (Read Only)

DBMS Snippets

SHOW CHANGE MySQL

Schlüssel

information_schema.key_column_usage

DBMS Snippets

Information Schema MySQL

Slow Log

SET GLOBAL slow_query_log =on

DBMS Snippets

Logs MySQL

SQL loggen

DBMS Snippets

Logs MySQL

Status

DBMS Snippets

SHOW MySQL

Storage Engines

DBMS Snippets

ALTER MySQL

Variablen

SHOW GLOBAL VARIABLES

DBMS Snippets

SHOW MySQL