week-1

Week #1

Overview

In this week, you will learn how run the TPC-C benchmark on MySQL 5.7. Follow the guide below. If you have any questions, don't hesitate to get in touch with me via email (Mijin An / [email protected])

NOTE: This lab is based on the Linux environment. If you don't have a Linux machine, use VirturalBox. (Recommend Ubuntu 18.04)

Instructions

Mount devices (Optional)

• If you have more than one storage device on your PC, read and try this guide to separate data and log devices

1. Install MySQL 5.7 and TPC-C

• Follow the installation guide to install and run TPC-C benchmark on MySQL 5.7

2. Run the TPC-C benchmark

• Run the benchmark and analyze the results freely
• Refer to the performance analysis guide to gather performance metrics while running the TPC-C benchmark on MySQL 5.7