In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud. Other posts have addressed MySQL parameters, like Alexander’s blog MySQL 5.7 Performance Tuning Immediately After Installation. That post remains highly relevant for the latest versions of MySQL, 5.7 and 8.0. Here we will focus more on the Linux operating system parameters that can affect database performance.

Server and Operating System

Here are some Linux parameters that you should check and consider modifying if you need to improve database performance.

…

Welcome to a new weekly column on the Percona blog. My name is Colin Charles, Percona Chief Evangelist, and I have been involved in MySQL, MariaDB Server and the open source community for over a decade. Now I am at Percona, and this is my weekly column.

When you start a column, you have ask yourself what you’ll be writing about. Keeping the focus on the reader is what’s crucial. With this in mind, I plan to cover happenings, pointers and maybe even musings in this column. It’s August, and while many are away on summer vacations, there’s still plenty happening in the database world. So maybe this will be a little like the now-defunct, Weekly MySQL News. It will be broader than just MySQL, however, and focus on open source databases (after all, Percona’s mission is to …

I'm not the only one to have noticed this, but I spent a sufficient amount of time banging my head against a wall finding this out that I thought it important to make more people aware of this.

While trying to validate new database hardware we were seeing some serious performance issues in production.  Most MySQL benchmarks using sysbench or pt-playback couldn't reproduce it, but a simple sysbench 16 threaded filio test on the mysql partition showed about 1/3 the throughput we would expect.   The fact that much of the hardware was new as well as the OS we were using made tracking down the cause difficult (changing from CentOS 5.5 to Scientific Linux 6.)

Finally some of our ops people working on different systems started noticing similar issues, and they uncovered the XFS issue.  Sure enough -- when took existing hardware, upgraded to SL6 and ran the same sysbench filio test we immediately saw a …

Topics for this podcast:

*Oracle, Java, the Apache Software Foundation and open source
*An update on some open source database and data management players
*CorraTech grows with support for open source application alternatives
*Red Hat-Makara acquisition analysis and impact
*Linux kernel report shows strong support, but what now for Novell?

iTunes or direct download (29:31, 5.1MB)

I track security updates for the following vendors: Apple, Cisco, FreeBSD, Microsoft, Red Hat, and Sun Microsystems. I chose these vendors based on my own needs for the networks and systems I manage. I've also found that updates from these vendors tend to catch the major updates necessary for common software applications. If you have other vendors you would like me to provide updates for, send me a message.

If you have an interest in information security from both a technical and managerial level, check out Principles of Information Security. It does an excellent job of presenting material for both audiences.

Red Hat, Inc.

• RHSA-2010:0108 Moderate: NetworkManager security update
• …

Some weeks ago Luke Kaines stated his observation that “requiring copyright attribution is a greater sin than providing commercial add-ons”.

His perspective was based on the theory that requiring copyright assignment restricts the developer community, a theory that was apparently repeated by Dave Neary during the recent OSBC event (I missed that session due to our CAOS client lunch).

Daniel Chalef of KnowledgeTree provided some evidence of Dave’s perspective and also the contrary view that the assignment of copyright is critical not just for vendor-dominated projects but also for community projects such as The Mozilla Foundation, The …

IBM to acquire Sun? TomTom countersues Microsoft. Sun unveils Open Cloud Platform. Oracle’s contributions to the Linux kernel. SpringSource updates Tool Suite. And more.

Follow 451 CAOS Links live @caostheory

IBM to acquire Sun?
No prizes for guessing the big story this week as the Wall Street Journal reported that IBM was in talks to buy Sun for $6.5bn, according to “people familiar with the matter”. Raising the game, the New York Times reported that the purchase price was nearer $7bn citing “a person with knowledge of the negotiations”.

The media exploded with …