# sysbench_mycat

**Repository Path**: chenjiangtao/sysbench_mycat

## Basic Information

- **Project Name**: sysbench_mycat
- **Description**: sysbench mycat 配置
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-07-24
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# sysbench
sysbench config 配置

# 修改适用mycat的两个内容 
- 1.去除"create index ....."

sysbench无法在mycat上创建index, 使用mycat全局id

```lua
   con:query(string.format("CREATE INDEX k_%d ON SBTEST%d(k)",
                                table_num, table_num))
``` 


- 2.表名全部改成大写 (mycat的表名都是大写的，所以要全部改成大写)
> sbtest --> SBTEST