Friday Spotlight: Oracle Linux and MySQL TPC-C Optimizations Whitepaper
By Zeynep Koch on Oct 17, 2014
Happy Friday Oracle Linux fans, this week our spotlight is a new whitepaper that is co- authored by Rick Stehno of Seagate and Avi Miller of Oracle. This paper gives tips to optimize your Oracle Linux, MySQL and the PCIe card which increases the performance of your environment with just few steps:
Oracle Linux and MySQL TPC-C Optimizations When Implementing the Sun Flash Accelerator F80 PCIe Card
Oracle Linux with Unbreakable Enterprise Kernel (UEK) was chosen for this study because of its upstream support for the latest hardware relevant to modern data center operations. In addition, MySQL database workloads benefit from the platform’s deep integration with the solution stack, optimizations resulting from industry collaborations and enhancements in the Unbreakable Enterprise Kernel.
Oracle Linux with the Unbreakable Enteprise Kernel includes extensive performance and scalability improvements to the process scheduler, memory management, file systems, and the networking stack. It was tuned to perform better and faster on leading-edge x86 configurations that feature many CPU cores and large amounts of main memory, and optimized libraries and system calls help to improve performance for MySQL queries. Because of these optimizations and pervasive testing that occurs within Oracle, Oracle Linux is able to address large transaction capacities and scale well as the number of database users or the number of databases increases. This document will present tuning and processes that can be applied to increase TPC-C performance when using the Sun Flash Accelerator F80 PCIe Card.
By following the simple tuning tips outlined in this paper, a successful implementation of the Sun Flash Accelerator F80 PCIe Card with optimal performance can occur in most environments.