Tag: MySQL

Open Source Bridge, day 1 keynote

Hacker Lounge – open 22 hours a day (closed between 6 and 8 fit cleaning). Android app Session notes link on each page, takes you to thewiki. #osb11 is the official hashtag Friday is unconference (I won’t be here on…

Read More >

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,…

Read More >

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.

Read More >

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.

Read More >

Upgrade to MySQL 5.1.56 on Bacula server using 5.0.x and MyISAM tables

In this blog, i’m going to review a recent MySQL upgrade I have done on one of the systems I am involved in administering. This is a real world example of an upgrade project, and hopefully when we’re done, there may even be an overall performance boost.

Read More >

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.

Read More >

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…

Read More >

Status Update on How MySQL Handles the Partition(s) for Maintenance

Let us talk how OPTIMIZE partitions doesn’t work and what to do. I have set up a simple test instance with two tables, and use my stresstool (java), to fill the tables and play with the inserting threads.

Read More >

Pythian Webinar Update: Exadata, MySQL HA, Exalogic, ASM & more…

Please join Pythian for our next series of live and recorded webinars and have the chance to ask questions directly of our DBA experts. If you miss a session, you can always check out select recorded webinars here

Read More >

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

Social media is buzzing with the news and views of bloggers. From the database side of this glorious media, we have picked out some of the gems for you in this edition of Log Buffer, which is the Log Buffer #223.

Read More >
Page 31 of 87« First Page...10...2930313233...40...Last Page »