Blog Archives

Create schema vs create database

CREATE DATABASE creates a database with the given name. To use this statement, you need the CREATE privilege for the database. CREATE SCHEMA is a synonym for CREATE DATABASE as of MySQL 5.0.2.

Posted in Data Warehouse, ETL, MySQL, PostgreSQL

How to see whats running in MySQL

Short List Show Processlist; Detailed List Show full Processlist; If you like the linux TOP or HTOP try this: watch -n1 ‘echo “show processlist” | mysql -uyourusername -pyourpass | grep -v “show processlist”‘ Save it as a .file. but make

Tagged with:
Posted in Data Warehouse, ETL, Linux, MySQL, SQL