mysql_vs_postgresql/benchmark_config_2.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
dbdriver: postgres
datasource: "host=large03 dbname=mysql_vs_pgsql user=testuser password=Rewghikpatgiwy"
stages:
- stage: JustStarted
  rps: 0
  concurrency: 128
  duration: 1000m
  runonce: []
  repeat:
  - scenario: populateTheDB
    queries:
    - query: simpleInsertUser
      sql: INSERT INTO users(user_name) VALUES($1)
      params:
        - param: UserName
          type: string
          generator: RandUUID
      update: true
    - query: simpleInsertUserMessage
      sql: INSERT INTO messages(user_id, ctime, message) VALUES($1,$2,$3)
      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 INTO friends(user_id, friend_id) VALUES($1,$2) ON CONFLICT DO NOTHING
      params:
        - param: UserId
          type: int
          generator: RandToFirstQueryCallCounter
        - param: FriendId
          type: int
          generator: RandToFirstQueryCallCounter
      update: true
      randrepeat: 1024
    probability: 1
  pause: false
- stage: StopForReconfig
  pause: true
- stage: OrderAdded
  rps: 0
  concurrency: 128
  duration: 1000m
  runonce: []
  repeat:
  - scenario: populateTheDB
    queries:
    - query: simpleInsertUser
      sql: INSERT INTO users(user_name) VALUES($1)
      params:
        - param: UserName
          type: string
          generator: RandUUID
      update: true
    - query: simpleInsertUserMessage
      sql: INSERT INTO messages(user_id, ctime, message) VALUES($1,$2,$3)
      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($1,$2)
      params:
        - param: UserId
          type: int
          generator: RandToFirstQueryCallCounter
        - param: FriendId
          type: int
          generator: RandToFirstQueryCallCounter
      update: true
      randrepeat: 1024
    probability: 1
  pause: false