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.pdfSee More
A great place to be!
-
Sarah Sproehnle
- Female
- San Jose, CA
- United States
- Blog Posts (9)
- Discussions (9)
- Photos
- Photo Albums
- Videos
Sarah Sproehnle's Discussions
Misusing LEFT JOIN
SQL is definitely fun, unless it's not. ;) I've seen many cases where developers misuse a LEFT (or RIGHT) JOIN. Either they don't understand what an outer join is, or they needed an outer join at…Continue
Started Sep 11, 2009
Gifts Received
Sarah Sproehnle has not received any gifts yet
Sarah Sproehnle's Page
Latest Activity
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:…See More
Sarah speaking at the 2010 MySQL User Conference
I'll be giving 2 talks this year. Here's a quick description:Want Faster Queries?Fixing slow queries is often very easy if you know what to look for and it can give huge performance gains. In this talk I'll cover common SQL mistakes, how to identify "bad" queries, indexing techniques, using EXPLAIN to verify execution plan, etc.Get your Replication…See More
"Hey Morgan! Welcome to Everything MySQL! Can't wait to see you at the UC"
"Hi Thomas,
I haven't used the Percona patches, but I have seen similar issues with the stock InnoDB. The UNDO log entries can get written to the ibdata file(s), even though you may be using innodb_file_per_table. It is possible that there are…"
"Hi! For anyone that hasn't heard, the conference is on. Sun is a founding sponsor (like last year). The call for participation is open NOW and ends Jan 27 - so hurry!"
Data type confusion: what is an int(11)?
Over and over I see customers that don't understand what int(11) really means. Their confusion is understandable. Many know what defining a char(10) means (a fixed-sized character string that allows up to 10 characters). However, ints are different.First of all, there are 5 types of integer. They are all fixed size.Type# of bytestinyint1smallint2mediumint3int4bigint8As you can see from the chart, an int is always 4 bytes. That can store signed numbers from -2 billion to +2 billion (and unsigned…See More
"FYI, there was a bug (fixed in the upcoming release of 5.1.41) that caused bad execution plans because the index statistics of only the first partition were used:
http://bugs.mysql.com/bug.php?id=44059"
"Hey Glynn,
Welcome to EverythingMySQL! Great comment on Chris' blog post. I love that we can all collaborate here and bring different ideas to the table."
"THANK YOU!"
"Hi jshoulet,
The row count should be the same in EXPLAIN SELECT and EXPLAIN PARTITIONS SELECT. However, I think what you are noticing is a bug of sorts (though a documented one). In EXPLAIN, the number of rows is an estimate of the number or rows…"
"Can you tell me what the row count is when you use EXPLAIN SELECT vs. EXPLAIN PARTITIONS SELECT? I know that total table rows is used in EXPLAIN PARTITIONS SELECT since v5.1.28 but what about using EXPLAIN SELECT? I've set up test cases in 3…"
Sarah Sproehnle's Blog
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:
Posted on October 13, 2011 at 1:54pm
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 Posted on June 23, 2010 at 6:04pm
Sarah speaking at the 2010 MySQL User Conference
I'll be giving 2 talks this year. Here's a quick description:
Want Faster Queries?
Fixing slow queries is often very easy if you know what to look for and it can give huge performance gains. In this talk I'll cover common SQL mistakes, how to identify "bad" queries, indexing techniques, using EXPLAIN to verify execution plan, etc.…
Continue
Want Faster Queries?
Fixing slow queries is often very easy if you know what to look for and it can give huge performance gains. In this talk I'll cover common SQL mistakes, how to identify "bad" queries, indexing techniques, using EXPLAIN to verify execution plan, etc.…
Continue
Posted on February 22, 2010 at 4:27pm
Data type confusion: what is an int(11)?
Over and over I see customers that don't understand what
First of all, there are 5 types of integer. They are all fixed size.
Continue
int(11) really means. Their confusion is understandable. Many know what defining a char(10) means (a fixed-sized character string that allows up to 10 characters). However, ints are different.First of all, there are 5 types of integer. They are all fixed size.
| Type | # of… |
Posted on October 30, 2009 at 8:04pm — 1 Comment
Comment Wall (1 comment)
- At 12:32pm on September 22, 2009,
Lakshmi said…
- Hey Sarah, interesting blog posts!
© 2024 Created by Chris.
Powered by
