Oracle University now features Live Virtual Classes where you
interact directly with trainers through lectures and labs. The
trainers are Oracle University expert instructors who deliver an
educational experience that is comparable to our traditional
in-class training—without the need for expensive travel.
So Go Virtual, the following MySQL Live Virtual Classes
are now available:
- MySQL for Database Administrators
- MySQL for Beginners
- Introduction to MySQL 5.5
- …
Free Summer learning on MySQL Oracle
University
Register now!
Free Summer learning on MySQL Oracle
University
Register now!
Want to learn how to improve your performance with MySQL? Sign up
for the recently revamped MySQL Performance Tuning course.
This course brings you more in-depth hands-on experience with
techniques for tuning a MySQL Server.
This course is designed for database administrators, database
developers and system administrators who are responsible for
managing, optimizing, and tuning a MySQL server. Students taking
this course can benefit from:
- Understanding the basics of performance tuning
- Using performance tuning tools
- Tuning the MySQL Server instance to improve performance
- Improving performance of tables based on the storage engine being used
- Implementing proper Schema Design to improve performance
- Improving the …
Want to learn how to improve your performance with MySQL? Sign up
for the recently revamped MySQL Performance Tuning course.
This course brings you more in-depth hands-on experience with
techniques for tuning a MySQL Server.
This course is designed for database administrators, database
developers and system administrators who are responsible for
managing, optimizing, and tuning a MySQL server. Students taking
this course can benefit from:
- Understanding the basics of performance tuning
- Using performance tuning tools
- Tuning the MySQL Server instance to improve performance
- Improving performance of tables based on the storage engine being used
- Implementing proper Schema Design to improve performance
- Improving the …
A customer of ours had an interesting problem regarding a query
that was taking too long, around 55s. Looking at the query with
the query profiler we found that it was spending most of its time
in the "statistics" phase. Now the query was pretty complex, it
contained nearly 20 tables with INNER JOINs, LEFT JOINs and even
some subqueries. However the tables were small and fetching all
the data shouldn't have taken the 55 seconds the query was
taking. The problem was that the optimiser was spending too much
time evaluating and finding the optimal execution plan.
There are two options in MySQL with which you can control the
optimiser's behaviour a bit. The first one is
optimizer_prune_level. The pruner discards non-optimal execution
plans early without evaluating them fully. It is turned on by
default and is not recommended to turn off unless there's a
really good reason. For testing purposes we turned the pruner off
for this query, but …
Looking to join Oracle’s MySQL team? Our training team is hiring a MySQL curriculum developer!
You can find the job description and apply here.
While the job description refers to Dublin as location, applicants can actually be based pretty much anywhere. Your curriculum development/design experience, database & MySQL expertise and proficiency in English will matter most than location.
If you have experience in designing and developing training courses, and are passionate about databases in general and MySQL in particular, we look forward to hearing from you!
Looking to join Oracle’s MySQL team? Our training team is hiring a MySQL curriculum developer!
You can find the job description and apply here.
While the job description refers to Dublin as location, applicants can actually be based pretty much anywhere. Your curriculum development/design experience, database & MySQL expertise and proficiency in English will matter most than location.
If you have experience in designing and developing training courses, and are passionate about databases in general and MySQL in particular, we look forward to hearing from you!
After quite a bit of work, we have now finally released our High
Availability for MySQL training course. This course focuses on
the different ways of achieving high availability for MySQL
servers. When creating the course we had to study a wide range of
different options to see what we would include as a possible
solution to the course. The course will cover the usual suspects
such as standard MySQL replication (including the semi-synch
mode), MySQL Cluster, disk-clustering and DRBD which has long
been used together with MySQL. We also cover some more unorthodox
HA solutions for MySQL, such as Schoner Active Clustering,
Continuent Tungsten etc.
To learn more or to register for one of our High Availability
classes, please visit our training page
For Finnish or Northern European readers of this blog, I just wanted to advertise that there is a great MySQL training coming up in Helsinki on the 3rd week of August. The trainer will be Oli Sennhauser from Switzerland. Oli is a former collague of mine from MySQL AB and is now an independent MySQL consultant - one of the best in Europe! The curriculum is targeted at developers (more dev than ops) that are already familiar with using MySQL, and will help you get a deeper understanding of InnoDB internals, high availability, caching and other advanced topics.
You can check it out or register at the Citrus website.