Join for free and connect with our local tech scene

Stay on top of the latest companies and upcoming events with our weekly newsletter, and be counted among the people building the future of your local tech community.

Boston, MA /

common_schema: DBA'S Framework for MySQL

Ike Walker, Database Architect at Flite, talks about the common_schema project: a self contained schema which includes a set of sophisticated views, routines and a specialized scripting language (QueryScript), simplifying MySQL server administration and analysis.

common_schema is aimed to be imported onto any MySQL server, on any platform. Along with INFORMATION_SCHEMA and PERFORMANCE_SCHEMA, common_schema becomes a valuable tool for one's server. In this session we will see how common_schema adds new capabilities to the MySQL server or otherwise makes complex tasks easy. We will review:

* How to install (import) common_schema

* Schema analysis views

* Process & security views and routines

* Status monitoring and transaction analysis

* SQL generating views and eval()

* QueryScript: an SQL based scripting language

We will see how common_schema/QueryScript assist in common tasks such as alleviating load from heavyweight queries, killing queries/connections, analyzing deadlocks, managing tables on multiple databases, iterating, scripting and more.

------------- Logistics -------------

MIT's map with the building (E51) highlighted: http://whereis.mit.edu/map-jpg?selection=E5...

MIT's map with the Kendall square T stop highlighted: http://whereis.mit.edu/map-jpg?selection=L5... (the stop is in red on that map, and you can see E51 in the bottom right)

MIT's maps with parking lot information: http://whereis.mit.edu/map-jpg?selection=P4... and http://whereis.mit.edu/map-jpg?selection=P5...

Note that MIT lots are free to park in after 3 pm or so, even if it says "reserved for faculty"

Free pizza and soda will be served, so please RSVP accurately.

To RSVP anonymously, please login to the Meetup site with the e-mail address "admin at sheeri dot com" and the password "guest". For more information, see: http://www.meetup.com/mysqlbos/calendar/

Comments

Sign in to comment.