Just another WordPress site
In what is quite possibly the most comprehensive look at the financial cost of being Batman, Movieclips Trailers analyzed the Christopher Nolan Batman trilogy and compared Batman’s gear to current market prices to come up with the definitive price it would take to be the dark knight. The final tally? $79,237,480.98. Not too expensive for a billionaire, right?
     |
common_schema 2.2 is released. This is shortly after the 2.1 release; it was only meant as bug fixes release but some interesting things came up, leading to new functionality.
Highlights of the 2.2 release:
Better QueryScript isolation & cleanup: isolation improved across replication topology, cleanup done even on error
Added TokuDB related views
split with “index” hint (Ike, this is for you)
table_rotate(): a logrotate-like mechanism for tables
better throw()
Drill down:
Better QueryScript isolation & cleanup
common_schema 2.1 introduced persistent tables for QueryScript. This also introduced the problem of isolating concurrent scripts, all reading from and writing to shared tables. In 2.1 isolation was based on session id. However although unique per machine, collisions were possible across replication topology: a script could be issued on master, another on slave (I have such use cases) and both use same (local) session id.
With 2.2 isolation is based on server_id & session id combination; this is unique across a replication topology.
Until 2.1, QueryScript used temporary tables. This meant any error would just break the script, and the tables were left (isolated as they were, and auto-destroyed in time). With persistent tables a script throwing an error meant legacy code piling up. With common_schema 2.2 and on MySQL >= 5.5 all exceptions are caught, cleanup is made, leaving exceptions to be RESIGNALled.
TokuDB views
A couple TokuDB related views help out in converting to TokuDB and in figuring out tables status on disk:
sql_alter_table_tokudb will help you out to generate the complex ALTER statement to TokuDB engine if you happen to used COMPRESSED InnoDB tables with KEY_BLOCK_SIZE specified. The view generates a complex DROP KEYs & ADD KEYs statementl this is due to bug …
tokudb_file_map simplifies the INFORMATION_SCHEMA.Tokudb_file_map table: the original view is not normalized and is difficult to interpret and follow when your table had many indexes or is partitioned (I will write more on this shortly). with common_schema’s tokudb_file_map you get, per table, the list of files representing that table, along with a couple Shell commands to tell you the thing you want to know most: “what is the size of my TokuDB table on disk?”
split
QueryScript’s split device now supports the “index” parameter (or hint), which instructs the split() operation to use an explicitly named index. If used, the index must exist and must be UNIQUE.
table_rotate()
Rotate your tables a-la logrotate with table_rotate(): generate a new, identical, empty table, version your table, pushing older versions along the line; optionally drop older versions. You get the picture. Got some nice use case behind this on cleaning up a test database.
throw()
On MySQL >= 5.5 throw() uses SIGNAL. No more weird “table `Unknown column ‘$t’ in ‘field list’` does not exist” messages. Just plain old:
ERROR 1054 (42S22): Unknown column ‘$t’ in ‘field list’
Get it
common_schema is free and open source. It is licensed under GPL v2. This is where you can find and download latest common_schema release.
Your input is welcome! Please submit your bugs, or otherwise share your experience with common_schema.
via Planet MySQL common_schema 2.2: better QueryScript isolation & cleanup; TokuDB; table_rotate, split params
Deep down we all know we shouldn’t crank our music or listen to headphones with the volume really high, but we still do. And if you’ve ever wondered if years of hard rock has done any serious damage, here’s an easy way to find out.
| |
via Gizmodo Test How Old Your Ears Are (And How Much Damage You’ve Done to Them)
For a TV show, Game of Thrones has clearly mastered the art of special effects. The quality of its visuals is simply spectacular. From the beautiful castles and boorish giants and nipple cutting we already know are fake to the amazing tricks of turning day into a bustling night camp and making snow impossibly glisten, the world they are able to create is simply amazing. And so damn real. This reel from SpinVFX shows some of the special effects used in Game of Thrones Season 3. [SpinVFX, Jose Antonio Espejo via The Mary Sue]
| |
via Gizmodo The Special Effects of Game of Thrones Are Still Unbelievably Amazing
Summer is swiftly coming to an end. One of the ways to enjoy the last of the warm weather weekends is to take an afternoon by the lake or river and make a rope swing. Safety is paramount, and close behind is gaining maximum height and velocity. We show you how to do both. See […]
| |
via The Art of Manliness How to Make a Rope Swing and Fly Like Tarzan: An Illustrated Guide
The renowned Getty Museum today launched an effort to “make available all images of public domain artworks in the Gettyís collections.” The museum has released 4,689 high-resolution images of the collection free to use, modify, and publish for any purpose. In exchange for the download, the museum requests a description of how the image will be used….
| |
via MacNN | The Macintosh News Network Getty Museum releases 4,689 artworks as digital download, more to come
It’s a problem that has plagued men ever since Western society decided the male of our species had to wear pants instead of breezy togas or kilts. I’m talking about swamp crotch: an uncomfortably moist nether region in which irritating chafing and stickage become commonplace and a distinct vinegar odor permeates from your groin. Outbreaks […]
| |
via The Art of Manliness Preventing Swamp Crotch: 10 Products “Scientifically” Tested
Dilbert readers – Please visit Dilbert.com to read this feature. Due to changes with our feeds, we are now making this RSS feed a link to Dilbert.com.
via Dilbert Daily Strip Comic for August 14, 2013
