Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Load Data Fast!

Load Data Fast!

 25 April - 3:50 PM - 4:40 PM @ Ballroom A
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Developer
Topics:
MySQL

Description

We all have tasks from time to time for bulk-loading external data into MySQL. What's the best way of doing this? That's the task I faced recently when I was asked to help benchmark a multi-terabyte database. We had to find the most efficient method to reload test data repeatedly without taking days to do it each time. In my presentation, I'll show you several alternative methods for bulk data loading, and describe the practical steps to use them efficiently. I'll cover SQL scripts, the mysqlimport tool, MySQL Workbench import, the CSV storage engine, and the Memcached API. I'll also give MySQL tuning tips for data loading, and how to use multi-threaded clients.

Speakers

Bill Karwin's picture

Bill Karwin

Senior Database Architect, SchoolMessenger

Biography:

Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.

Share this talk