Gustavo Gama gustavobgama

🏠

Working from home

I am a 38 years old software engineer, with a computer science degree. I am also married and have two cats.

gustavobgama / createDatabase.sh

Created September 19, 2013 21:06

Create database

mysql --user=user --password=password -e 'CREATE DATABASE IF NOT EXISTS db_name DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;'

gustavobgama / MySQLShowProcessList

Created May 28, 2013 13:23

Show mysql processlist with periodical refresh

watch -n1 'mysql --user=user --password=password database --execute="SHOW PROCESSLIST"'

gustavobgama / ViewSizeOfDir

Created May 7, 2013 19:17

View used size of directory

du -hs /path/to/folder

gustavobgama / ShowMyIsamTables.sql

Last active December 16, 2015 02:29

How to show MyIsam tables

SELECT TABLE_SCHEMA, TABLE_NAME FROM information_schema.TABLES WHERE ENGINE LIKE 'myisam';