mysql.md

MySQL

Contents

• MySQL Sample Database
• MySQL Index
  • Creating indexes
  • Removing indexes
  • Listing table indexes
  • Unique indexes
  • Prefix indexes
  • Invisible indexes
  • Descending indexes
  • Composite indexes
  • Clustered indexes
  • Index cardinality
  • USE INDEX hint
  • FORCE INDEX hint
• MySQL Functions
  • Aggregate Functions
  • Control Flow Functions
  • Comparison Functions
  • Date Functions
  • String Functions
  • Math Functions
  • Window Functions
• MySQL my.cnf
• MySQL Docker
• Locks

Reference Manual

Installing and Upgrading MySQL

• 2.2 Installing MySQL on Unix/Linux Using Generic Binaries
• 2.5 Installing MySQL on Linux
  • 2.5.1 Installing MySQL on Linux Using the MySQL Yum Repository
• 2.10 Postinstallation Setup and Testing

MySQL Programs

• 4.2 Using MySQL Programs
  • 4.2.2 Specifying Program Options
    • 4.2.2.2 Using Option Files
• 4.3 MySQL Server and Server-Startup Programs
  • 4.3.1 mysqld — The MySQL Server
  • 4.3.2 mysqld_safe — MySQL Server Startup Script
  • 4.3.3 mysql.server — MySQL Server Startup Script
  • 4.3.4 mysqld_multi — Manage Multiple MySQL Servers
• 4.4 MySQL Installation-Related Programs
  • 4.4.5 mysql_secure_installation — Improve MySQL Installation Security
• 4.5 MySQL Client Programs
  • 4.5.4 mysqldump — A Database Backup Program
  • 4.5.7 mysqlslap — Load Emulation Client

SQL Statements

• 13.7 Database Administration Statements
  • 13.7.1 Account Management Statements
    • 13.7.1.1 ALTER USER Statement
    • 13.7.1.2 CREATE USER Statement
    • 13.7.1.3 DROP USER Statement
    • 13.7.1.4 GRANT Statement
    • 13.7.1.5 RENAME USER Statement
    • 13.7.1.6 REVOKE Statement
    • 13.7.1.7 SET PASSWORD Statement

The InnoDB Storage Engine

• 14.18 InnoDB Backup and Recovery

Grafana

• Grafana

Runtime Environment

• MySQL 5.x
• MySQL 8.x
• CentOS 6.10