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:

Anonymous said...

As always, Roland, awesome job!

rpbouman 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.

rpbouman 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!

SAP HANA Trick: DISTINCT STRING_AGG

Nowadays, many SQL implementations offer some form of aggregate string concatenation function. Being an aggregate function, it has the effe...