This week we continue our discussion of Common Schema by finishing up the routines and starting to look at the views it offers. Ear Candy is and At The Movies is
In the news, the OurSQL podcast will change to a monthly format after episode 200. We love doing the podcast, but it is very time consuming and production is expensive. We will still bring quality episodes, they will just be spaced further apart.
OSCon 2014 will be held at the Oregon Convention Center in Portland, Oregon from Sunday July 20th through Thursday July 24th.
FrOSCon 2014 will be held Saturday 23 August - Sunday 24 August at the University of Applied Sciences Bonn-Rhein-Sieg in Germany.
- Numbers table, contains 0 - 4095 - for defining limits to certain functions
- Text routines
- get_option() - for python-style dictionaries
- split_token() - to get a specific token from text
- tokenize() - split your text into tokens, one per record in the result set
- prettify_message() - changes \n to a newline, and puts each item on its own line
- help() - uses prettify_message() to display common_schema documentation
- trim_wspace() - trim all whitespace characters from the beginning and end of a string
- mysql_qualify() - escape with backtics
- Data Dimension Views
- Monitoring Views
- global_status_diff - shows diffs and changes per second and per minute of 2 samples of global status variables
- global_status_diff_clean - same as global status diff, but shows the empty string instead of 0 for the diffs and average values of non-changing variables
- global_status_diff_nonzero - same as global status diff, but does not show non-changing variables
Semi-Sync Replication is Not Slow - an article by Morgan Tocker about how the right set of options can make semi-sync replication can be pretty speedy.
At the Movies
This week in At the Movies we present a video blast from the past. In 2009 at the MySQL Users Conference, Jacek Becla from the Stanford Linear Accelerator Center presented The Science and Fiction of Petascale Analytics.