MySQL Performance background

Showing running queries in MySQL

show processlist;

http://www.electrictoolbox.com/show-running-queries-mysql/

List all indexes for MySQL databases

SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE

List all indexes of a table

SHOW INDEX FROM dbName.tableName