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: Processing PGN chess games with DuckDB - Rolling up each game's lines into a single game row (6/6)
DuckDB bag of tricks is the banner I use on this blog to post my tips and tricks about DuckDB . This post is the sixth installment of a s...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGuuJUZ8fDs8U5cvRtVp2IF4_HcWEdhJ0hGXOAWs43IMJylYfOrd6RmnL_-3dAP3dcJC9crlA6JW-48nPKAT-uivPghYHyaMRAqoaZ9OyI-AYdJd4NySE6cu0TPR0N-iC9kssuimGrbLYJEJHMDJDu-69nexFcYbthqohm2Jx5lXHZFBboIi_v/s320/DuckDB_Logo.png)
-
Every now and then, people are puzzled by the precise status and extent of MySQL support for dynamic SQL. Statement Handling MySQL support ...
-
Handling cursor loops in MySQL keeps puzzling people . Single Cursor Loops The common case is to have a simple cursor loop. Each record is ...
-
Yesterday, I was on the freenode ##pentaho irc channel when Andres Chaves asked me how to calculate the N th percentile in MySQL. He saw ...
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