• Skip to main content
  • Skip to primary sidebar

DBA Diaries

Thoughts and experiences of a DBA working with SQL Server and MySQL

10 Database Performance Monitoring Tools You Can Get For Free

June 28, 2014 by Andy Hayes Leave a Comment

Database performance monitoring is something every DBA worth their salt should be doing on a regular basis. It should be adopted as a proactive task to help identify issues early on before they become too serious and be part of a post code deployment monitoring process. Bundled in with linux based operating systems are a heap of great tools that you can use as a DBA to … [Read more...] about 10 Database Performance Monitoring Tools You Can Get For Free

When are Innodb Table Statistics Updated?

June 18, 2014 by Andy Hayes Leave a Comment

Innodb statistics are used by the query optimizer to assist it in choosing an efficient query execution plan. They are estimated values relating to each Innodb table and index. But what updates them? Let's take a look. Operations that update Innodb table statistics Typically this happens during metadata statements such as SHOW INDEX or SHOW TABLE STATUS. It also occurs w … [Read more...] about When are Innodb Table Statistics Updated?

How to Kill All MySQL Processes For a Specific User

June 17, 2014 by Andy Hayes Leave a Comment

So here is a scenario, you have a number of poorly performing MySQL database queries which are consuming resources on your server. Users are complaining and you need to do something fast. Having viewed the output of SHOW FULL PROCESSLIST, you can see that they are coming from one user and have been running for a long time. You need a way to kill all MySQL processes … [Read more...] about How to Kill All MySQL Processes For a Specific User

MySQL SHOW USERS? – How to List All MySQL Users and Privileges

June 16, 2014 by Andy Hayes 2 Comments

mysql show users

There are a number of useful SHOW commands in MySQL. Sadly, there isn't one for mysql SHOW USERS nor is there one for mysql LIST USERS. This is a little inconsistent when you consider that there are other commands such as SHOW DATABASES, SHOW VARIABLES, SHOW TABLES, SHOW GRANTS and others. However there are ways to do it. You can get back a list of MySQL user accounts by qu … [Read more...] about MySQL SHOW USERS? – How to List All MySQL Users and Privileges

List Tables for a Specific Database Using MySQL SHOW TABLES

June 15, 2014 by Andy Hayes Leave a Comment

This post demonstrates how to list all tables for a specific MySQL database. I will use SHOW TABLES for this. First, login as user root to your MySQL instance. [sourcecode language='sql'] mysql -uroot -pYourPassword [/sourcecode] Now change to the database you want to show tables for. [sourcecode language='sql'] USE mysql; [/sourcecode] Database changed Now … [Read more...] about List Tables for a Specific Database Using MySQL SHOW TABLES

« Previous Page
Next Page »

Primary Sidebar

Categories

  • All Articles (84)
  • Career Development (8)
  • MySQL Administration (18)
  • MySQL Performance (2)
  • SQL Server Administration (24)
  • SQL Server News (3)
  • SQL Server Performance (14)
  • SQL Server Security (3)
  • SQL Tips and Tricks (21)

Top 10 Popular Posts

  • Using sp_change_users_login to fix SQL Server orphaned users
  • MySQL SHOW USERS? – How to List All MySQL Users and Privileges
  • How to shrink tempdb
  • How to Transfer Logins to Another SQL Server or Instance
  • How to Delete Millions of Rows using T-SQL with Reduced Impact
  • T-SQL – How to Select Top N Rows for Each Group Using ROW_NUMBER()
  • New T-SQL features in SQL Server 2012 – OFFSET and FETCH
  • How to Kill All MySQL Processes For a Specific User
  • Using exec sp_who2 to help with SQL Server troubleshooting
  • How to fix “conversion failed when converting date and/or time from character string”

Recent Posts

  • How to fix “conversion failed when converting date and/or time from character string”
  • Using SQL GROUPING SETS for Multiple GROUP BY Queries in a Single Query
  • How to Setup MySQL Master Master Replication
  • How To Use SQL to Convert a STRING to an INT
  • How to set up MySQL Replication Tutorial

Search

Connect

  • Twitter
  • Facebook
  • RSS

About

  • Cookie Policy
  • Disclaimer
  • About
Copyright ©