MySQL

Liveblogging: A dozen databases in 45 minutes

Actually, the slide is 12 databases in 25 minutes (and 20 minutes of theory) by Eric Redmond (@inviite). Complex data:  A lot of data isn’t really complex, it’s just modeled in a complex way. “Complexity is a symptom of confusion, not a cause” Jeff Hawkins. NoSQL Linear Scalability Ability to be Distributed Low Latency  …

Log Buffer #225, A Carnival of the Vanities for DBAs

March of bloggers goes on and so is the unstoppable production of the blog posts. It’s getting more exciting week after week watching the new and old bloggers adding spice to the database blogosphere. This edition of Log Buffer brings some of the simmering and scintillating posts from around the globe in Log Buffer #225.

Silent MyISAM Table Definition Changes and mysqldump

While trying to move a schema from one MySQL server to another, I encountered a very odd issue. The schema to be moved contained both MyISAM and InnoDB tables, so the only option I had was to dump the schema using mysqldump on the source server and import it on the destination server. I did some digging and found that the problem was that the MyISAM engine silently changed the table definition without any indications. Here are some solutions.

Log Buffer #224, A Carnival of the Vanities for DBAs

There are many variates of mangoes and its hard to pick from them as they all are so sweet and eye catching. Same is the case with the database related blogs, when it comes to selection for the edition of Log Buffer. So once again here you are, about to savor the sweet blogs in Log Buffer #224.

PalominoDB Nagios Plugin for MySQL

This post has sample configurations, and an update, to the Nagios plugin called mysql_health_check.pl that PalominoDB has developed.  Presentation slides, the presentation video, the whitepaper and the download link to the actual Nagios check are always up-to-date at http://palominodb.com/about-us/projects. There has been exciting news for the Nagios plugin PalominoDB developed for MySQL — we now have…

Designing Index to Eliminate Sorting

Using algorithm described in “Relational Database Index Design and the Optimizers by Tapio Lahdenmaki and Mike Leach”, I quickly came up with two indexes and while first one looked fine, I was really confused by the second one for the elimination of the sort. Let me show an example, not copy one from the book, but rather show a test I did with MySQL.

Page 28 of 85« First Page...10...2627282930...40...Last Page »