Wednesday, August 15, 2018
Home Tags MySQL

Tag: MySQL

MySQL Database

Query Database and Table Size in MySQL

A nice thing about MySQL is that it stores everything inside information_schema, and we can make use of it to calculate database size and...
MySQL Database

Kill process in MySQL processlist

When you want to diagnose MySQL database, you might want to have a look at all current connection or processes show up on process...
MySQL Database

Retrieve all tables having specified columns in MySQL

Just a simple trick to retrieve all tables in database that have columns with specified names. SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS ...

Follow Me