O'Reilly logo

MySQL by Robert D. Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15. Improving Import and Export Operations

MySQL’s import and export functionality offer tremendous convenience and reliability for the database administrator, especially for those faced with maintaining sizable databases. However, they are also unparalleled in their ability to be both painfully slow for the administrator as well as an aggravating source of widespread system sluggishness for all users. Fortunately, MySQL lets you have more control than you might realize when it comes to these types of activities.

This chapter investigates the most optimal procedures to follow when performing any kind of large data movement operation. This chapter begins by researching how to make exports as fast as possible. Next, it reviews the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required