Comprehensive reference for MySQL and MariaDB linting and analysis tools.
BeforeMerge offers hundreds of code review rules, guides, and detection patterns to help your team ship better code.
A reference guide covering the essential tools for linting MySQL and MariaDB databases.
SQL linter with MySQL/MariaDB dialect support.
pip install sqlfluff
# Lint MySQL files
sqlfluff lint --dialect mysql migration.sql
# Auto-fix
sqlfluff fix --dialect mysql migration.sqlConfiguration (.sqlfluff):
[sqlfluff]
dialect = mysql
templater = raw
max_line_length = 120
[sqlfluff:rules:capitalisation.keywords]
capitalisation_policy = upperAnalyze slow query logs for performance issues.
# Install Percona Toolkit
apt-get install percona-toolkit # Debian/Ubuntu
brew install percona-toolkit # macOS
# Analyze slow query log
pt-query-digest /var/log/mysql/slow.log
# Focus on specific queries
pt-query-digest --filter '$event->{fingerprint} =~ m/SELECT/' slow.logNon-blocking schema changes for MySQL.
# Install
brew install gh-ost # macOS
# Perform an online migration
gh-ost \
--host=localhost \
--database=mydb \
--table=users \
--alter="ADD COLUMN bio TEXT" \
--executept-online-schema-change \
--alter "ADD COLUMN bio TEXT" \
D=mydb,t=users \
--execute# Check all tables
mysqlcheck --all-databases --check
# Optimize tables
mysqlcheck --all-databases --optimize
# Analyze tables (update index statistics)
mysqlcheck --all-databases --analyze# Check for upgrade issues
mysqlsh -- util check-for-server-upgrade
# Schema analysis
mysqlsh -- util dumpSchemas mydb --outputUrl=schema-dump/