isfernand

SELECT table_name AS "Table",
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)",
table_rows as '# rows'
FROM information_schema.TABLES
WHERE table_schema = "database"
ORDER BY (data_length + index_length) DESC;

isfernand

use <database>;

SET group_concat_max_len = 4294967295; -- to overcome default 1KB limitation

SELECT CONCAT(
         'SELECT * FROM ('
       ,  GROUP_CONCAT(
            'SELECT ', QUOTE(TABLE_NAME), ' AS `table`,',QUOTE(COLUMN_NAME), 'AS `column`',
             ',COUNT(`', REPLACE(COLUMN_NAME, '`', '``'), '`) AS `count`,', QUOTE(COLUMN_TYPE), 'AS `column_type`'
          , 'FROM `', REPLACE(TABLE_NAME, '`', '``'), '`'

isfernand

MySQL Download URL

https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.56-linux-glibc2.5-x86_64.tar.gz

Open the terminal and follow along:

• Uninstall any existing version of MySQL

sudo rm /var/lib/mysql/ -R

isfernand

Project Title

One Paragraph of project description goes here

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.

Prerequisites

isfernand

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname