Linux Performance Tuning and Stabilization Tips

Presentation: external link
Average rating: ****.
(4.56, 18 ratings)

Many people know Linux terminologies such as ext3, tmpfs, cfq io scheduler, OOM killer, etc. But many times it is not appropriately configured. In this session, the speaker will show Linux performance tuning and stabilization practices for MySQL. The following topics will be covered.

  • Filesystem (ext3, xfs, tmpfs, etc)
  • Swap and memory management, how to prevent OOM killer
  • I/O scheduler settings
  • Demistifying iostat and vmstat
  • Practical Linux kernel configurations
  • Profiling MySQL/Linux activities with SystemTap
  • RAID (1+0 vs 5), Logival Volume Manager (LVM) and Partition Management (/, /data, /tmp, etc)

You will be interested in this session if you do not have clear answers to the following questions.

  • Is setting swap size to zero fine? Why is it dangerous? How much swap space should I allocate?
  • sync-binlog=1 is really slow. Can it be faster by using a filesystem other than ext3?
  • I allocate only one Linux partition at / . Is it fine?
  • What is the most appropriate I/O scheduler for MySQL? Does it depend on Linux and MySQL version? Is cfq fine for both single-threaded and multi-threaded applications)?
  • What is vm.swappiness? What is vm.overcommit_memory?
  • What do r/s, wMB/s, %svctm and %util from iostat really mean?
  • Is it possible to count up how many times rr_unpack_from_buffer() (MySQL internal function) was called?
Photo of Yoshinori Matsunobu

Yoshinori Matsunobu

DeNA

Yoshinori Matsunobu is a Principal Consultant at Sun Microsystems, mainly engaging into consulting services in Japan and Asian countries. He have written a lot of MySQL books, having broad-ranging MySQL technical experties, especially DBA, performance tuning, high availability, i18n and MySQL Cluster.

Comments on this page are now closed.

Comments

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/16/2010 8:03pm PDT

The video for this presentation is at www.youtube.com/watch?v=owH...

Staffan Flink
04/14/2010 11:59am PDT

Great presentation with many useful tips. Keep up the good work.

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.