Tag: MySQL

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

Winter has started and the holiday season is approaching fast. With the chillness of winter and festive mode induced by the holidays, bloggers across the planet are coming up with more and more exciting ideas. Let’s start with sizzling Log Buffer #207.

Read More >

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

Welcome to Log Buffer, the weekly news blog about blogs in the datasphere.

Read More >

Percona XtraDB Information_schema Changing

I’ve been working a lot with xtradb versions of mysql over the last year, and more and more have begun to attempt to leverage the information_schema instrumentation that has been put in place. Today, I went into a system with…

Read More >

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

A very warm welcome to the Log Buffer, the premier medley of fresh information culled from the blogs related to the technology which stores the world, yes, the databases. In this edition, the Log Buffer #205, we have yet again found the pulse of the industry.

Read More >

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

Welcome to Log Buffer, the weekly roundup of happenings in the database world. Lots to cover this week, so let’s get on with Log Buffer #204. Enjoy!

Read More >

MySQL Troubleshooting for the Obsessive Oracle DBA

One of my favorite customers had a problem. They had to load around 20G of data into a table on MySQL database. The data loaded fine, but when he tried to build few indexes on the database, he got a mysterious error: ERROR 1114 (HY000): The table ‘really_big_table’ is full. The error was mysterious because we had around 1.5T of free space on the disk. Also, if the customer created the indexes before loading the data there was no error. This gave them a work around, but one that slow and annoying. Later, I found out that we are not the first to run into this mystery.

Read More >

How I Find MySQL Fragmentation

Sarah Novotny recently posted InnoDB Tablespace Fragmentation – Find it and Fix it, so I thought I would share how I determine MySQL fragmentation. This works for MyISAM and InnoDB tables, and will work whether or not innodb_file_per_table is in…

Read More >

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

Welcome to Log Buffer. The weekly roundup of posts, and news of what’s happening in the database world.

Read More >

Call for Papers for the O’Reilly MySQL Conference

The call for papers for the O’Reilly MySQL Conference is now open, and closes October 25th.  Submit your proposal now at http://en.oreilly.com/mysql2011/user/proposal/propose/cfp/126!

Read More >

Bloggers Meetup @ Oracle OpenWorld 2010

It’s that time of the year again — Oracle OpenWorld time — and it’s my pleasure to announce our regular Oracle bloggers meetup again this year. We all know that Oracle community has grown this year so we expect to see folks from all the different technologies including MySQL, Java, Sun hardware folks in addition to the core Oracle database and apps crowd.

Read More >
Page 35 of 64« First Page...10...3334353637...40...Last Page »