Covering NoSQL, Relational Database, Data Visualization, and Reporting.
For the last month or so. There has been a debate amongst, my peers and I, on which is the better file system on Linux and how to benchmark and test it. So digging through my back log of emails I notice that Linux Magazine was running a series on the this some topic. So I thought I would sure.
Lies, Damn Lies and File System Benchmarks
Metadata Performance of Four Linux File Systems
Metadata Performance Exploration Part 2: XFS, JFS, ReiserFS, ext2, and Reiser4
This morning I was asked by one of the other Engineers in my group about an easy way to analyze all the tables in a database. So I pointed him to mysqlcheck. Which is a great command line client for performing table mainteneance on mysql database tables. It checks, repairs, optimizes, or analyzes tables, all from the command line. Like any other program it has a ton of flags, but here are three general ways to invoke it.
shell> mysqlcheck [options] db_name [tables]
shell> mysqlcheck [options] –databases db_name1 [db_name2 db_name3…]
shell> mysqlcheck [options] –all-databases
For more information check out.
So here’s the story; I’m horrible at grammar, spelling and pretty much anything else to do with the English language, but I decided to start a blog anyway. Foolish human.. 🙂
This will be a pretty boring blog to most of you since it will be a technical blog, with a few rants from yours truly. So, if you are a geek or a nerd, great, if not, go herehttp://www.life.com, a great site I helped build.