MySQL

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.

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 this install (admittedly a very recent one) Server version: 5.1.51-rel11.5-log Percona Server (GPL), 11.5, Revision…

Events and Replication, part 1

MySQL events have been in GA for 2 years.  Events are not used as much as I would like — often organizations will have cron jobs or scheduled tasks to perform ETL, maintenance and small aggregation tasks.  For example, a website that shows how many users are logged in might update a “cache table” with…

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.

Page 34 of 85« First Page...10...3233343536...40...Last Page »