MySQL and MySQL Community information

Improve Performance of a MySQL Database with Partitioning

You can improve the performance of a MySQL Database by using partitioning, that is assigning specific table rows into subsets of rows. Partitioning can help in many different situations including improving the efficiency of large tables by:

  • Breaking data into smaller groups for more efficient queries
  • Adhering to file-system file size limits
  • Speeding up runtimes for maintenance and deleting rows

To learn much more about partitioning and other key topics, take the very popular MySQL for Database Administrators training course.

You can take this 5-day instructor-led course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material through streaming video and booking time on a lab environment to get hands-on experience at your own convenience
  • Live-Virtual Event: Attend a live class from your own desk, no travel required. Choose from a selection of events on the schedule to suit different time zones including the 5th October 2015 for delivery in French and the 4th, 11th, and 18th May, 8th June, 13th July, 17th August, and 21th September 2015 in English.
  • In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.


 Location  Date  Delivery Language
Capetown, South Africa 11 May 2015 English
Pretoria, South Africa 17 August 2015 English


 Location  Date  Delivery Language
Sao Paulo, Brazil
13 April 2015 Brazilian Portuguese
Mexico City, Mexico
22 June 2015 Spanish
San Pedro Garza Garcia, Mexico
20 April 2015 Spanish
Lima, Peru 13 April 2015 Spanish
Roseville, MN, United States 15 June 2015 English
Saint Charles, MO, United States 11 May 2015 English
Columbus, OH, United States 22 June 2015 English


 Location  Date  Delivery Language
Shanghai, China
6 July 2015 Simplified Chinese
Causeway Bay, Hong Kong
11 May 2015 English
Bangalore, India
18 May 2015 English
Seoul, Korea
6 April 2015 Korean
Kuala Lumpur, Malaysia
17 August 2015 English
Petaling Jaya, Malaysia
11 May 2015 English
Pulau Pinang, Malaysia
17 August 2015 English
Pasig City, Philippines
8 June 2015 English
6 April 2015 English
Bangkok, Thailand
15 June 2015 English

 Location  Date  Delivery Language
Brisbane, Australia 27 April 2015 English
Melbourne, Australia 18 May 2015 English


 Location  Date Delivery Language
Brussels, Belgium
4 May 2015 English
Hvidovre, Denmark 8 June 2015 English
London, England
13 April 2015 English
Espoo, Finland
8 June 2015 English
Dublin, Ireland
25 May 2015 English
Milan, Italy
15 June 2015 Italian
Rome, Italy
15 June 2015 Italian
Utrecht, Netherlands
4 May 2015 English
Oslo, Norway
4 May 2015
Edinburgh, Scotland
25 October 2015
Glasgow, Scotland
11 May 2015 English
Madrid, Spain
18 May 2015 Spanish
Kista, Sweden 8 June 2015 English
Basel, Switzerland 4 May 2015 German
Bern, Switzerland 4 May 2015 German
Zurich, Switzerland 4 May 2015 German
Istanbul, Turkey 20 May 2015 Turkish
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

The MySQL for Database Administrators course is the recommended training for those preparing to take the MySQL 5.6 Database Administration OCP certification exam.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.