MySQL Cheatsheet for SQL DBAs

SHOW VARIABLES – This is like sp_configure or sys.configurations

SHOW STATUS – This like sys.dm_os_%. Basically, all runtime counters for the database engine components.

SHOW PROCESSLIST – This is like sp_who2

SHOW TABLE STATUS – This is like sp_help

These can be filtered like this: SHOW VARIABLES LIKE ‘%innodb%’

Those are the big ones. The full list can be found here.

email it! |   |   |   |  | 

Permalink     2 Comments  

Rate this Post: 12345
COMMENTS:

Comments from the following blog entry: http://www.brentozar.com/archive/2009/02/sqlserverpedia-blog-syndication-faq/

posted @ Wednesday, February 04, 2009 2:20 PM

---

"In that light, a SQL Server DBA might want to broaden his or her skillset.
Jason Massie offers a brief MySQL Cheatsheet for SQL DBAs."

Log Buffer #134

posted @ Friday, February 06, 2009 2:45 PM by Log Buffer

---

Name (required)

Email (required)

Website

Notify me of followup comments via e-mail

Simple BBCode can be used like [url=http://example.com]Example[/url] and [B]