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)
Year-to-Date on Synapse Analytics 5: Using Window Functions
For one of our Just-BI customers we implemented a Year-to-Date calculation in a Azure Synapse Backend. We encountered a couple of approache...
-
Like all procedural database languages I know, the MySQL stored procedure language supports explicit cursors . I just wrote "explicit c...
-
To whom it may concern, this is a quick note to bring the xmondrian project to your attention. Introduction: Open Source OLAP, Mondrian,...
-
Just the previous week, Anders mentioned the sql_mode with regard to Joomla . Past week, Shlomi 's started a nice discussion pertaini...
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