Everything MySQL

A great place to be!

All Blog Posts Tagged 'mysql' (7)

MySQL & Hadoop talk at Oracle Open World

I recently gave a talk about importing and exporting data between MySQL and Hadoop at Oracle Open World.  Here are the slides for that talk:

MySQLandHadoopNov2011.pdf

Added by Sarah Sproehnle on October 13, 2011 at 1:54pm — No Comments

MySQL Sunday - Oracle Open World

The first ever MySQL Sunday is coming soon to the Bay Area. There are plenty of great speakers with new and interesting material to choose from. Come join us at Oracle's Open World conference and make sure to check out the MySQL Sunday page.

This is going to be a great event that you don't want to miss!

Have a great day and see you there.

Chris

Added by Chris on July 14, 2010 at 11:00am — No Comments

Hadoop for MySQL people

There's a lot of buzz lately about Hadoop. If you're completely new to Hadoop, I recommend the free videos from Cloudera (http://www.cloudera.com/resources/?type=Training). If you have a vague idea and want to play around, it's easy!


First, download Cloudera's training VM which has a small Hadoop cluster already installed and running:…
Continue

Added by Sarah Sproehnle on June 23, 2010 at 6:04pm — No Comments

What's faster than REPAIR?

After Chris' great post, What's faster than ALTER, I got thinking about REPAIR. REPAIR TABLE can be slow, but may seem necessary if your table is corrupt.



A little background:

MyISAM tables are prone to corruption if they are receiving updates/inserts/deletes/etc and your server crashes. Doing a REPAIR TABLE can generally "fix" them, but it can take time. The larger the table,… Continue

Added by Sarah Sproehnle on September 16, 2009 at 9:00pm — 6 Comments

Using TMPFS for MySQL's tmpdir

There have been a lot of systems I have looked at where the Created_tmp_disk_tables was very high. MySQL has good documentation on how it uses memory, specifically temp tables, here.



I would like to talk about not "why" MySQL does this but how to speed up the performance when MySQL internally or users create temporary tables to disk. A great solution is TMPFS, a quick how to is… Continue

Added by Chris on September 12, 2009 at 9:27pm — 3 Comments

What's faster than ALTER?

Well, the answer I always get is "DROP". Then I would say... "what if you wanted to preserve your data?" It is very common for DBAs to think only in terms of what is obviously available in MySQL, ALTER, than all of the tools that are really there. I have been placed in situations in many companies where ALTER was just not the way to go.



Given the amount of MySQL usage throughout the WEB2.0/IT industry and the fact that data sets seem to keep growing... I have come up with a great… Continue

Added by Chris on September 10, 2009 at 2:30pm — 8 Comments

Partitioning by dates: the quick how-to

There is thorough documentation about the Partitioning feature in MySQL 5.1. There are also nice articles like this one by Robin. However, I thought it would be useful to have a quick "how-to" guide to partitioning by dates. I'll use the world schema to keep it easy.



Partitioning a… Continue

Added by Sarah Sproehnle on September 8, 2009 at 12:18pm — 8 Comments

RSS

© 2024   Created by Chris.   Powered by

Badges  |  Report an Issue  |  Terms of Service