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.
Subscribe to:
Post Comments (Atom)
DuckDB Bag of Tricks: Reading JSON, Data Type Detection, and Query Performance
DuckDB bag of tricks is the banner I use on this blog to post my tips and tricks about DuckDB . This post is about a particular challenge...
4 comments:
As always, Roland, awesome job!
Thanks for the support Jay!
I'm honoured.
This is really quite cool, very helpful to conceptualize what's in the INFORMATION_SCHEMA.
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!
Post a Comment