Jump to Navigation
Languages
Search form
About us
Services
Software
Resources
Metadata
MariaDB and MySQL PERFORMANCE_SCHEMA Hints
Sun, 2013-07-14 09:29
—
oli
Table of Contents
Accounts not properly closing connections
Unused indexes
Who created temporary (disk) tables
Accounts which never connected since last start-up
Users which never connected since last start-up
Totally unused accounts (never connected since last restart and not used to check Stored Program or View privileges) since last start-up
SHOW FULL PROCESSLIST
Storage Engines per schema
Tables without a Primary Key
Bad SQL queries of users
SHOW PROFILE
in
PERFORMANCE_SCHEMA
SELECT
,
INSERT
,
UPDATE
and …
tags:
performance
schema
performance_schema
hint
index
galera
rbr
replication
primary key
sys
lock
locking
metadata
Read more
about MariaDB and MySQL PERFORMANCE_SCHEMA Hints
About us
News
About FromDual
Contact
Partner
References
Newsletter
Press
Services
Consulting
Support
MySQL
DB Development
Remote-DBA
Training
Training Modules
Class Schedule
for Developer
for Administrators
Galera Cluster
Software
Performance Monitor
Ops Center
Backup and Recovery Manager
MyEnv
Download
Resources
Blog
Presentations
SQL Formatter
Database Health Check
Performance Tuning Key
Consulting tools
MySQL Configuration
Download
Recent content
