OurSQL Episode 150: MySQL Connect

This week we talk about MySQL Connect sessions. Ear Candy is the mysqladmin "relative" command, and At the Movies is Manipulating JSON with MariaDB and MySQL. Listen to hear how to win a free pass!

Events
DB Hangops - every other Wednesay at noon Pacific time

FrOSCon - Aug 24-25th, 2013 in St. Augustin, Germany.

Oracle is having a MySQL OTN Virtual Developer Day August 31st.

Upcoming MySQL events


MySQL Connect
is happening in San Francisco from Saturday September 21st - Monday September 23rd.

Training
SkySQL Trainings

Tungsten University trainings

Oracle's MySQL Trainings

Percona Trainings

MySQL Connect
MySQL Connect
Content Catalog for MySQL Connect

We have a few passes we can give away, so if you can cover the cost of travel, let us know why you want to go to MySQL Connect using any of our feedback mechanisms - email us, twitter, facebook or Google Plus forums, or call the comment line - and we'll pick some winners.

Ear Candy
mysqladmin "relative" command

$ mysqladmin extended-status

Show the status variables changes in 5 seconds:
$ mysqladmin extended-status --relative --sleep 5

Show only what's changed:
$ mysqladmin extended-status --relative --sleep 5  | grep -v " 0 "

$ mysqladmin extended-status --relative --sleep 5  | grep -v " 0 " | grep -i binlog
| Binlog_commits                           | 17845926             |
| Binlog_group_commits                     | 17821781             |
| Binlog_snapshot_position                 | 25346269             |
| Binlog_bytes_written                     | 56939386003          |
| Binlog_cache_disk_use                    | 26736                |
| Binlog_cache_use                         | 17781508             |
| Binlog_stmt_cache_disk_use               | 4571                 |
| Binlog_stmt_cache_use                    | 64469                |

[that's the first 5 seconds, and after the 2nd 5 seconds, we saw:]

| Binlog_commits                           | 133                  |
| Binlog_group_commits                     | 132                  |
| Binlog_snapshot_position                 | 514853               |
| Binlog_bytes_written                     | 514853               |
| Binlog_cache_use                         | 133                  |

[and after the third set of 5 seconds, we saw this:]

| Binlog_commits                           | 21                   |
| Binlog_group_commits                     | 21                   |
| Binlog_snapshot_position                 | 10310                |
| Binlog_bytes_written                     | 10310                |
| Binlog_cache_use                         | 21                   |

At the Movies
This week in At the Movies, we present Anders Karlsson of SkySQL talking about Manipulating JSON with MariaDB and MySQL at the 2013 SkySQL and MariaDB Solutions Day.

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast

Trackback URL for this post:

http://technocation.org/trackback/1255