mysql_vs_postgresql/benchmark_config_1.yml at master · inCaller/mysql_vs_postgresql · GitHub

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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
dbdriver: mysql
datasource: testuser:Rewghikpatgiwy@tcp(large01:3306)/mysql_vs_pgsql
stages:
- stage: JustStarted
  rps: 0
  concurrency: 128
  duration: 1000m
  runonce: []
  repeat:
  - scenario: populateTheDB
    queries:
    - query: simpleInsertUser
      sql: INSERT INTO users(user_name) VALUES(?)
      params:
        - param: UserName
          type: string
          generator: RandUUID
      update: true
    - query: simpleInsertUserMessage
      sql: INSERT INTO messages(user_id, ctime, message) VALUES(?,?,?)
      params:
        - param: UserId
          type: int
          generator: RandToFirstQueryCallCounter
        - param: CTime
          type: timestamp
          generator: Now
        - param: Message
          type: string
          generator: Rand4KText
      update: true
      randrepeat: 10
    - query: simpleInsertUserFriend
      sql: INSERT IGNORE INTO friends(user_id, friend_id) VALUES(?,?)
      params:
        - param: UserId
          type: int
          generator: RandToFirstQueryCallCounter
        - param: FriendId
          type: int
          generator: RandToFirstQueryCallCounter
      update: true
      randrepeat: 1024
    probability: 0.5
  - scenario: ReadFromTheDB
    queries:
    - query: simpleSelectMessages
      sql: select * from messages where user_id in (select friend_id from friends where user_id = ?) # order by ctime # limit 100
      params:
        - param: UserId
          type: int
          generator: RandToFirstQueryCallCounter
        - param: CTime
          type: timestamp
          generator: Now
        - param: Message
          type: string
          generator: Rand4KText
      update: false
    probability: 0.5
  pause: false
- stage: StopForReconfig
  pause: true
<<<<<<< 6e73185157fbad7b1ae97e176d696b9534a149f1
- stage: OrderAdded
  rps: 0
  concurrency: 128
  duration: 1000m
  runonce: []
  repeat:
=======
- stage: LessNewUsers
>>>>>>> new stages
  - scenario: populateTheDB
    queries:
    - query: simpleInsertUser
      sql: INSERT INTO users(user_name) VALUES(?)
      params:
        - param: UserName
          type: string
          generator: RandUUID
      update: true
    - query: simpleInsertUserFriend
      sql: INSERT IGNORE INTO friends(user_id, friend_id) VALUES(?,?)
      params:
        - param: UserId
          type: int
          generator: RandToFirstQueryCallCounter
        - param: FriendId
          type: int
          generator: RandToFirstQueryCallCounter
      update: true
      randrepeat: 1024
    probability: 0.01
  - scenario: newMessage
    queries:
    - query: simpleInsertUserMessage
      sql: INSERT INTO messages(user_id, ctime, message) VALUES(?,?,?)
      params:
        - param: UserId
          type: int
          generator: RandToFirstQueryCallCounter
        - param: CTime
          type: timestamp
          generator: Now
        - param: Message
          type: string
          generator: Rand4KText
      update: true
    probability: 0.4
  - scenario: ReadFromTheDB
    queries:
    - query: simpleSelectMessages
      sql: select * from messages where user_id in (select friend_id from friends where user_id = ?) # order by ctime # limit 100
      params:
        - param: UserId
          type: int
          generator: RandToFirstQueryCallCounter
        - param: CTime
          type: timestamp
          generator: Now
        - param: Message
          type: string
          generator: Rand4KText
      update: false
    probability: 0.5
  pause: false