forked from zhouxh19/workload-performance
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathconfig.ini
92 lines (87 loc) · 4.75 KB
/
config.ini
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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
[predictor]
# SELECT count(*) FROM INFORMATION_SCHEMA.INNODB_METRICS where status='enabled';
predictor_output_dim = 65
# predictor_epoch
predictor_epoch = 100
[database_tune]
# Host IP Address
host = 172.27.58.68
# Host Port Number
port = 3306
# Database User Name
user = root
# Database Name
database = sysbench
# Database Password
password = dbmind20202020
# Limit for the requests (queries) in a workload'
num_event = 1000
# Read percentage
p_r_range = 0.6
# Update percentage
p_u_index = 0.2
# Insert percentage
p_i = 0.1
# Delete percentage
p_d = 0.1
# Iteration Number
num_trial = 500
# Maximum sample number cached in RL
maxlen_mem = 2000
# maxlen_predict_mem
maxlen_predict_mem = 2000
learning_rate = 1e-3
epsilon_decay = 1e-3
# Sample threshold to train RL
train_min_size = 3
# Training finish if the accumulated score is over the value
stopping_score = 90
# Training finish if the throughput improvement percentage is over the value
stopping_throughput_improvement_percentage = 0.52
# Training Performance Comparision
linelist = ['res_predict-1619930491','res_random-1619930491']
# [Latency, Throughput]
performance_metric = ['Latency']
# workload_file, like workload_file_example.txt
workload_file_path = /workload_read_10000.txt
# thread_num
thread_num = 141
# thread_num dependent on the max connections 1/true 0/false
thread_num_auto = 1
[knob_config]
innodb_io_capacity = {'type':'infer','min_value': 20,'max_value': 400,'length':1}
max_connections = {'type':'infer','min_value': 12,'max_value':800,'length':1}
innodb_buffer_pool_size = {'type':'infer','min_value': 1048576,'max_value': 2147483648,'length':1048576}
table_open_cache = {'type':'infer','min_value':1,'max_value':4000,'length':1}
innodb_thread_concurrency = {'type':'infer','min_value': 1,'max_value': 999,'length':2}
innodb_concurrency_tickets = {'type':'infer','min_value': 10,'max_value': 8000,'length':1}
# you should increase the value of the table_open_cache variable if the numer of opened tables is large
#table_open_cache = {'type':'infer','min_value':1,'max_value':4000,'length':1}
# The maximum permitted number of simultaneous client connections
#max_connections = {'type':'infer','min_value': 12,'max_value':1000,'length':1}
# The minimum size of the buffer that is used for plain index scans, range index scans, and joins that do not use indexes and thus perform full table scans.
#join_buffer_size = {'type':'infer','min_value': 16384,'max_value': 134217728,'length':16384}
# The size of the buffer that is allocated when preloading indexes.
#preload_buffer_size = {'type':'infer','min_value': 16384,'max_value': 1073741824,'length':16384}
# Each session that must perform a sort allocates a buffer of this size.
#sort_buffer_size = {'type':'infer','min_value': 32768,'max_value': 134217728,'length':16384}
# The size of the cache to hold changes to the binary log during a transaction.
#binlog_cache_size = {'type':'infer','min_value': 16384,'max_value': 134217728,'length':16384}
# The cutoff on the size of index values that determines which filesort algorithm to use.
#max_length_for_sort_data = {'type':'infer','min_value': 4,'max_value': 8388608,'length':1}
# This variable limits the total number of prepared statements in the server. Setting the value to 0 disables prepared statements.
# max_prepared_stmt_count = {'type':'infer','min_value': 1000,'max_value': 2097152,'length':1}
# The number of times that any given stored procedure may be called recursively. The default value for this option is 0, which completely disables recursion in stored procedures. The maximum value is 255.
#max_sp_recursion_depth = {'type':'infer','min_value': 1,'max_value': 255,'length':1}
# The maximum number of simultaneous connections permitted to any given MySQL user account. A value of 0 (the default) means “no limit.”
# max_user_connections = {'type':'infer','min_value': 20,'max_value': 4294967295,'length':1}
# If this value is greater than 1, MyISAM table indexes are created in parallel.
#myisam_repair_threads = {'type':'infer','min_value': 1,'max_value': 4294967295,'length':1}
#for test use ,innodb_buffer_pool_instances&innodb_buffer_pool_chunk_size is read only
#read_buffer_size = {'type':'infer','min_value': 16777216,'max_value': 8589934592,'length':16384}
# The size of buffer pool (bytes). A larger buffer pool requires less disk I/O to access the same table data more than once.
#innodb_buffer_pool_size = {'type':'infer','min_value': 1048576,'max_value': 2147483648,'length':1048576}
#innodb_thread_concurrency = {'type':'infer','min_value': 0,'max_value': 16,'length':2}
#innodb_concurrency_tickets = {'type':'infer','min_value': 10,'max_value': 8000,'length':1}
#innodb_io_capacity = {'type':'infer','min_value': 20,'max_value': 400,'length':1}
#key_buffer_size={'type':'infer','min_value': 16384,'max_value': 1073741824,'length':16384}