InnoDB has proven to be a reliable data storage engine for
modern, high concurrency database systems. It is fully ACID
compliant, and supports a wide range of isolation modes, from
READ-UNCOMMITEED to SERIALIZABLE.

InnoDB multiversion concurrency control (MVCC) enables records
and tables to be updated without the overhead associated with
row-level locking mechanisms. The MVCC implementation in InnoDB
largely eliminates the need to lock tables or rows during
updates, and enables good performance for high concurrency
workloads.

Optimization involves improving the performance of a database
server and queries that run against it. Optimization reduces
query execution time and optimized queries benefit everyone that
uses the server. When the server runs more smoothly and processes
more queries with less, it performs better as a whole. To learn
more about how a MySQL developer can make a difference with
optimization, take the MySQL Developers training course.

This 5-day instructor-led course is available as:

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 timezones.

In-Class Event: Travel to an education center to attend an
event. Below is a selection of the …

Benchmarking lets you test how a system responds when it is given
work to do, and removes the guesswork from your performance
tuning efforts. The workloads you use when benchmarking are very
different from real life deployments, which can be extremely
variable. If you remember this, benchmarking is extremely useful,
enabling you to measure current performance and determine the
performance impact of any changes. Such changes could be the
addition of new hardware or opening up your application to more
users.

Benchmarking is one of the topics that you can learn more about
by taking the MySQL Performance Tuning course. You can take
this course in the following formats:

Whether you are a database administrator, database application
developer, web developer, system administrator or system
architect, if you are working with a database system such as the
MySQL Server, you will want to ensure the best possible
performance.

To learn about the great performance you can get from a MySQL
Database, visit Dimitri's blog.

If you have experience maintaining a database server, can use
MySQL tools and have knowledge of general SQL statements and SQL
tuning principles, consider taking the MySQL Performance Tuning course. In this 4-day
instructor-led course, you will learn about:

In this 4-day instructor-led course you will learn practical,
safe and highly efficient ways to optimize performance for the
MySQL Server. It will help you develop the skills needed to use
tools for monitoring, evaluating and tuning MySQL.

You can take this course via the following delivery
methods:Training-on-Demand:

Take this course at your own pace, starting training
within 24 hours of registration.

Live-Virtual Event: Follow a live-event from your own desk;
no travel required. You can choose from a …

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.