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!
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.
MySQL Connect is happening in San Francisco from Saturday September 21st - Monday September 23rd.
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.
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.