Jump to Navigation

Languages

Login

Search form

About us
Services
Tools
Resources
Download

Rbr

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

Read more about MariaDB and MySQL PERFORMANCE_SCHEMA Hints

MariaDB and MySQL Upgrade Problems

Thu, 2011-09-08 20:09 — oli

Table of Contents

Reasons to Upgrade MariaDB or MySQL
How to Upgrade to MariaDB or MySQL
MariaDB and MySQL Reserved Keywords
MariaDB and MySQL Problems we hit in real life

tags:

Read more about MariaDB and MySQL Upgrade Problems

About us
Services
Tools
Resources
Download
Recent content

Trademarks

RSS LinkedIn X / Twitter Facebook Flickr Bluesky YouTube Mastodon Matrix PeerTube Codeberg

MySQL, InnoDB and Oracle are registered trademarks of Oracle Corp. MariaDB®, the sea lion logo and MaxScale® are registered trademarks of MariaDB Corp. 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.