Jump to Navigation
Home

Languages

  • English

Login

Search form

  • About us
  • Services
  • Tools
  • Resources
  • Download

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
Subscribe to RSS - Metadata

  • 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

  • Tools

    • Performance Monitor
    • Ops Center
    • MyEnv
    • SQL Formatter
    • Database Health Check
    • Performance Tuning Key
    • Consulting tools
    • MySQL Configuration

  • Resources

    • Blog
    • Forum
    • Presentations

  • Download

  • Recent content

Trademarks

RSS LinkedIn X / Twitter Xing Facebook Flickr Google+ twitter

MySQL, InnoDB and Oracle are registered trademarks of Oracle Corp. MariaDB is a trademark of Monty Program AB. All other trademarks are property of their respective owners. Other product or company names mentioned may be trademarks or trade names of their respective owner.