Showing entries 21 to 30 of 112
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: tuning (reset)
Linux performance tuning tips for MySQL

Because most MySQL production systems probably run on Linux, I’ve decided to place the most important Linux tuning tips that will help improve MySQL performance. There is nothing new here, most of them are well known, however, I’ve decided to collect those Linux configuration tips into 1 blog post.

Filesystem

  • ext4 (or xfs), mount with noatime
  • Scheduler – use deadline or noop
# echo deadline >/sys/block/sda/queue/scheduler
add "elevator=deadline" to grub.conf

(For more info see Linux Schedulers in TPCC like benchmark)

Memory

  • Swappiness and NUMA:
# echo 0 > /proc/sys/vm/swappiness
add "vm.swappiness = 0" to /etc/sysctl.conf
  • Set numa interleave all
[Read more]
Optimizing MySQL Database Operations for Better Performance

If you are responsible for a MySQL Database, you make choices based on your priorities; cost, security and performance.

To learn more about improving performance, take the MySQL Performance Tuning course

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 …
[Read more]
MySQL Brings Huge Performance Improvements with Each Release

The MySQL engineering team constantly works to bring you huge performance improvements with each new release of MySQL. Here are four ways to help you get the most from these improvements

Tap into Sveta Smirnova's MySQL performance expertise on October 1st 2013 at 10am Central European Time, by attending the 1-day virtual seminar, Troubleshooting MySQL Performance with Sveta Smirnova. Sveta starts with basics, working towards more advanced cases that DBAs usually need years of experience to identify or solve. Click here to learn more about this seminar and to register for the event.

The …

[Read more]
Tune MySQL for Top-Level Performance

In 4 days, the MySQL Performance Tuning training teaches you practical, safe and highly efficient ways to optimize performance for the MySQL Server. It will help you:

  • Evaluate the architecture
  • Understand and use the tools.
  • Configure the database for performance.
  • Tune application and SQL code.
  • Tune the server.
  • Examine the storage engines.
  • Assess the application architecture.
  • Understand general tuning concepts.

You can take this instructor-led course as a:

  • Training-on-Demand offering: Start training within 24 hours of regsitration, taking this course at your own pace through streaming video of instructor delivery and …
[Read more]
3 Simple Patterns for Tighter MySQL Code

Join 8000 others and follow Sean Hull on twitter @hullsean. SQL is derided by many and for good reason. It’s key to scalability yet terribly difficult to write good code. Here’s a few quick tips to write tighter queries in MySQL 1. Get rid of those Subqueries! Subqueries are a standard part of SQL, unfortunately […]

The post 3 Simple Patterns for Tighter MySQL Code appeared first on Scalable Startups.

Tuning MySQL Database to Access Really High Performance

MySQL continues to improve in terms of performance. To get the best out of MySQL, you must learn to analyze your system and use tools to monitor, evaluate and tune the MySQL Server.

The MySQL Performance Tuning training is a 4-day instructor-led course which teaches you to configure the database for performance, tune application and SQL code, tune the server, examine storage engines and assess the application architecture.

You can take this course through the following event types:

  • Training-on-Demand: Start training within 24 hours of registration. Follow this course at your own pace through streaming video of instructor delivery and scheduling time to do lab exercises at a time that suits you.
  • Live-Virtual: Attend …
[Read more]
The write cache: Swap insanity tome III

Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup phase and hence its rather complex configuration.

Probably most readers of this blog know (or should know) about Linux swappiness setting, which basically controls how important is the file cache for Linux. Basically, with InnoDB, since the file cache is not important we add “vm.swappiness = 0″ to “/etc/sysctl.conf” and run “sysctl -p” and we are done.

Swappiness solves part of the swapping issue but not all. With Numa systems, the picture is more complex and swapping can occur because of a memory imbalance between the physical cpus, the sockets and not cores. Jeremy Cole explained this here and …

[Read more]
Get Even More from MySQL With MySQL Performance Tuning Training

With each release, the MySQL database brings you even better performance. To get the most from your MySQL servers, performance tuning is important. And what better route than to take the MySQL for Performance Tuning training course.

In this four-day instructor-led class you will learn to:

  • Understand the basics of Performance Tuning
  • Use the tools of performance tuning
  • Tune the MySQL server instance to improve performance
  • Improve performance of tables
  • Implement proper Schema Design to improve performance
  • Improve the performance of MySQL queries

This course is available as:

  • Training-on-Demand: Start training within 24 hrs of registering and follow the course at your own pace and from your own desk.
[Read more]
Optimize MySQL Performance with the Authentic MySQL Training

The MySQL database provides top-level performance. Here are two courses to help you get the most out of your MySQL system.

Troubleshooting MySQL Performance With Sveta Smirnova

This 1 day seminar is an opportunity to interact with Sveta Smirnova, MySQL engineer, expert on MySQL Performance and author of MySQL Troubleshooting.

Sign up for this seminar scheduled for February 28th, 2013 in London, England

Sveta will start from basics, working towards more advanced cases that DBAs would usually need years of experience to identify or …

[Read more]
Get The Most From MySQL Database With MySQL Performance Tuning Training

Get the most from MySQL Server's top-level performance by improving your understanding of performance tuning techniques.

MySQL Performance Tuning Class

In this 4 day class, you'll learn practical, safe, highly efficient ways to optimize performance for the MySQL Server. You can take this class as:

  • Training-on-Demand: Start training within 24 hours of registering and follow the instructor-led lecture material through streaming video at your own pace. Schedule time lab-time to perform the hands-on exercises at your convenience.
  • Live-Virtual Class: Follow the live instructor led class from your own desk - no travel required. There are already a range of events on the schedule to suit different timezones and with delivery in languages including English and German.
  • In-Class Event: Travel to a training center to follow this class.

For more information on this class, to see the …

[Read more]
Showing entries 21 to 30 of 112
« 10 Newer Entries | 10 Older Entries »