# mysql_tpcc_2024

**Repository Path**: zcpan/mysql_tpcc_2024

## Basic Information

- **Project Name**: mysql_tpcc_2024
- **Description**: codebase for polardb x tianchi database competition
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 153
- **Created**: 2024-10-11
- **Last Updated**: 2024-10-11

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

![plot](./img/banner.png)

# Tianchi x PolarDB: Tuning MySQL in TPC-C

The competition is Aiming to optimize MySQL to get better performance in the TPC-C benchmark scenario.

## Quick Start

1. Fork the current repository and set it to private.

2. Add `polardb-tianchi (polardbtianchi)` as an observer to your gitee repo.

![gitee](./img/gitee.jpg)

3. Write your own repo address into `sample_submit.txt` then submit only `sample_submit.txt` to tianchi competition. (only ssh address is supported)

4. Wait for your first score!

## Coding

- `ROUND1/` **dir for tianchi competition round1**. [ROUND1](./ROUND1/README.md) for more details.
- `mysql-server/` MySQL codebase base on [mysql-server](https://github.com/mysql/mysql-server/tree/mysql-8.4.0) commit-id: dc86e412f18
- `benchmarksql/` benchmark program base on [benchmarksql](https://github.com/petergeoghegan/benchmarksql) commit-id: f2f39cf
- `docs/` documents and references
- `test/` dir contains local test scripts, which can be run locally before submit.

## Tips

- Learn about how the new-generation Intel EMR accelerates database applications: [PDF](docs/Intel_EMR_for_Database.pdf)
- Learn about TPC-C Specs: [PDF](docs/tpc-c_v5.11.0.pdf)