MySQL

Oracle is not removing InnoDB!

was asked “What’s the deal with Oracle removing InnoDB?”  I had not heard this, so I did some research.  It took less than 5 minutes to figure out what happened, and it was easy to see where the confusion is. On the MySQL products page at http://mysql.com/products/ the matrix of MySQL editions includes “MySQL Classic” which…

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.

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 use. The basic idea is to compare the size of the file(s) on disk with…

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 use. The basic idea is to compare the size of the file(s) on disk with…

OpenSQLCamp Boston in Detail

In short: Register / see who’s coming Schedule (will be filled in with presentations before Saturday noon) Session ideas (45-minute sessions) Friday, October 15th – 6-10 pm, WorkBar Boston, 711 Atlantic Ave, Boston, in the basement.  Socializing, swag, raffles, dinner, beer and soft drinks.  Take public transit (South Station on the Red Line subway or Silver…

Slow Query Log in MySQL 5.1 Cheat Sheet

I try to eliminate warnings and errors in the error log as much as possible – not just fixing actual issues, but also to eliminate the noise in the error log.  As I have been doing 5.1 upgrades lately, I have been seeing a lot of the following errors in the error log when upgrading:…

Page 35 of 85« First Page...10...3334353637...40...Last Page »