Percona Live MySQL User's Conference, San Francisco, April 10-12th, 2012 Book: "Pentaho Kettle Solutions", Matt Casters, Roland Bouman, & Jos van Dongen, Wiley 2010 Book: "Pentaho Solutions", Roland Bouman & Jos van Dongen, Wiley 2009

Saturday, March 11, 2006

MySQL 5.1. Information schema now clickable!

I just uploaded the first clickable version of the diagram of the MySQL 5.1. information_schema database. Its right here: http://www.xcdsql.org/MySQL/information_schema/5.1/MySQL_5_1_INFORMATION_SCHEMA.html.

Apart from adding the new information schema tables (PARTITIONS, FILES, PLUGINS, PROCESSLIST, ENGINES) I also touched up the layout, modified the pagesize (in the visio file; you can now print it on A3 without much hassle), and added a relationship between SCHEMATA and TRIGGERS.

I will be maintaining both the 5.0 and the 5.1 version of the diagram from now on.

4 comments:

Jay Pipes said...

As always, Roland, awesome job!

Roland Bouman said...

Thanks for the support Jay!

I'm honoured.

Mike Kruckenberg said...

This is really quite cool, very helpful to conceptualize what's in the INFORMATION_SCHEMA.

Roland Bouman said...

Thanks Mike!

Really appreciate your kind words; I think it's really cool to get this kind of feedback of both authors of Pro MySQL (Apress, 2005)!

Feather in my cap, proud to wear it. Thanks!