Archive for July 1st, 2011
Lots of this was taken from here: http://www.pantz.org/software/mysql/mysqlcommands.html Figured since I referenced it so much … Show replication slave status. mysql> show slave status; Show process list. mysql> show processlist; (show full proccesslist;) Show variables. mysql> show variables like ‘%collation%’; To login (from unix shell) use -h only if needed. # [mysql dir]/bin/mysql -h hostname -u [ READ MORE ]
Get every new post delivered to your Inbox.