• About
  • Contact us

MySQL Step-by-Step Blog

MySQL Step-by-Step Blog

Monthly Archives: July 2015

Useful queries on MySQL information_schema

15 Wednesday Jul 2015

Posted by Moll in MySQL, MySQL Operations

≈ 8 Comments

Tags

Abdel-Mawla Gharieb, Galera Cluster, information_schema, MySQL, MySQL Replication, pt-online-schema-change

MySQL information_schema comes with useful information about the database instance, status, … etc. which is needed for daily DBA work.
There are some simple queries on the information_schema that I use on my daily basis in which I’m writing this post for my reference and maybe a good reference for someone else too …

Finding tables without Primary or Unique Keys:

PKs are so important, especially, for InnoDB tables as MySQL uses PKs as a clustered index and having no PKs might lead to severe performance problems.

Continue reading →

Advertisement

Subscribe

  • Entries (RSS)
  • Comments (RSS)

Archives

  • August 2019
  • May 2018
  • April 2017
  • January 2017
  • December 2016
  • November 2016
  • April 2016
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015

Categories

  • MySQL
    • Backup and Recovery
    • High Availability (HA)
    • MySQL Cluster
    • MySQL Operations
    • MySQL Replication
    • Sharding

Meta

  • Register
  • Log in
Follow MySQL Step-by-Step Blog on WordPress.com

Website Powered by WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • MySQL Step-by-Step Blog
    • Join 25 other followers
    • Already have a WordPress.com account? Log in now.
    • MySQL Step-by-Step Blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar