forked from mysql/mysql-docker
-
Notifications
You must be signed in to change notification settings - Fork 7
/
Copy pathautobench_dbt2.conf
59 lines (49 loc) · 2.24 KB
/
autobench_dbt2.conf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
#############################
#### Software definition ####
#############################
MYSQL_BIN_INSTALL_DIR=/srv/hops/mysql
BENCHMARK_TO_RUN="dbt2"
#########################################
#### Storage definition (empty here) ####
#########################################
#################################
#### MySQL Server definition ####
#################################
SERVER_HOST="%s"
MYSQL_USER="%s"
MYSQL_PASSWORD="%s"
NDB_MULTI_CONNECTION="%s"
# PARAMETER EXAMPLE DESCRIPTION
#################################################################################################
# TASKSET "numactl"
# SERVER_HOST "172.31.23.248;172.31.31.222"
# SERVER_PORT "3316"
# SERVER_BIND "0"
# SERVER_CPUS "9-17,27-35"
# MYSQL_USER "mysql"
# MYSQL_PASSWORD "unsafe-password"
# NDB_MULTI_CONNECTION "4" Number of slots in the config.ini per MySQL server
# Essentially how many connections we allow per IP with a
# MySQL server. This allows us to scale to up to 32 CPUs
# per MySQL VM/container/IP.
##############################
#### NDB node definitions ####
##############################
NDB_MGMD_NODES="%s"
# PARAMETER EXAMPLE DESCRIPTION
#################################################################################################
# USE_SUPERSOCKET "yes"
# USE_SHM "yes"
# NDBD_NODES "172.31.23.248;172.31.31.222"
# NDB_MGMD_NODES "172.31.23.248:3001" The management connection string; a list of IPs of all the
# management servers
# NDB_TOTAL_MEMORY "64G"
# NDBD_BIND "0,1"
# NDBD_CPUS "0-6,18-24"
# NDB_SPIN_METHOD "DatabaseMachineSpinning"
##############################
#### Benchmark definition ####
##############################
DBT2_TIME="30"
DBT2_WAREHOUSES="%s"
DBT2_DATA_DIR=/home/mysql/benchmarks/dbt2_data