Tag: MySQL

What Happens when InnoDB Fails to Start

Today I’ve spent some time (more than this issue was worth, actually) on a client’s system trying to find out why table was not accessible and failed. The error message suggested something went very wrong with .frm file and I already started thinking about restoring the table from backup, when I noticed that accessing any InnoDB table was producing same error. A quick check of the error log showed that when MySQL server was restarted some time ago InnoDB failed to initialize due to a memory issue.

Read More >

Zabbix Templates for MySQL

We recently had a client come to us, and ask us to improve their MySQL monitoring inZabbix. So, we did. The approach we took was to port the MySQL script from the superb mysql-cacti-templates project to work with Zabbix. This works out well, because…

Read More >

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

Welcome to Log Buffer, the weekly round up of news and happenings in the database world.

Read More >

Call for Papers – NoCOUG 2011

North California Oracle User Group are planning their 2011 conferences and are looking for good presentations! We are a very friendly local user group, so if you live in NorCal and never presented before – this is a great place to start! We love seeing new presenters and we even have a public speaking expert on our board who loves giving feedback when requested. Of course, we are nice to seasoned gurus too.

Read More >

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 >
Page 36 of 65« First Page...10...3435363738...50...Last Page »