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...
-
Just the previous week, Anders mentioned the sql_mode with regard to Joomla . Past week, Shlomi 's started a nice discussion pertaini...
-
Every now and then, people are puzzled by the precise status and extent of MySQL support for dynamic SQL. Statement Handling MySQL support ...
-
To whom it may concern - a quick hands-on guide for running the Pentaho BI server behind a proxy Prerequisites This post assumes you're ...
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