github.com/dolthub/dolt/go@v0.40.5-0.20240520175717-68db7794bea6/performance/import_benchmarker/testdata/ci.yaml (about)

     1  opts:
     2    seed: 0
     3  tests:
     4  - name: "pk type"
     5    repos: &repos
     6    - name: dolt_cli
     7    - name: dolt_server
     8      server:
     9        port: 3308
    10        args: [ "--port", "3308" ]
    11    - name: mysql
    12      external-server:
    13        name: test
    14        host: 127.0.0.1
    15        user: root
    16        password: password
    17        port: 3309
    18    tables:
    19      - name: "int"
    20        schema: |
    21          create table xy (
    22            x int primary key,
    23            y varchar(30)
    24          );
    25      - name: "float"
    26        schema: |
    27          create table xy (
    28            x float primary key,
    29            y varchar(30)
    30          );
    31      - name: "varchar"
    32        schema: |
    33          create table xy (
    34            x varchar(20) primary key,
    35            y varchar(30)
    36          );
    37  - name: "config width"
    38    repos: *repos
    39    tables:
    40      - name: "2 cols"
    41        schema: |
    42          create table xy (
    43            x int primary key,
    44            y varchar(30)
    45          );
    46      - name: "8 cols"
    47        schema: |
    48          create table xy (
    49            x int primary key,
    50            y int,
    51            z int,
    52            w int,
    53            a int,
    54            b int,
    55            c int,
    56            d int
    57          );
    58      - name: "32 cols"
    59        schema: |
    60          create table xy (
    61            a1 int primary key,
    62            a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int, a10 int, a11 int,
    63            a12 int, a13 int, a14 int, a15 int, a16 int, a17 int, a18 int, a19 int, a20 int, a21 int,
    64            a22 int, a23 int, a24 int, a25 int, a26 int, a27 int, a28 int, a29 int, a30 int, a31 int,
    65            a32 int
    66          );
    67  - name: "col type"
    68    repos: *repos
    69    tables:
    70      - name: "varchar"
    71        schema: |
    72          create table xy (
    73            x int,
    74            y varchar(30)
    75          );
    76      #  - name: "geometry"
    77      #    schema: |
    78      #      create table xy (
    79      #        x int primary key,
    80      #        y geometry
    81      #      );
    82      - name: "datetime"
    83        schema: |
    84          create table xy (
    85            x int primary key,
    86            y date
    87          );
    88  - name: "secondary index"
    89    repos: *repos
    90    tables:
    91      - name: "no secondary"
    92        schema: |
    93          create table xy (
    94            x int primary key,
    95            y varchar(30),
    96            z varchar(30),
    97            w varchar(30)
    98          );
    99      - name: "one index"
   100        schema: |
   101          create table xy (
   102            x int primary key,
   103            y varchar(30),
   104            z varchar(30),
   105            w varchar(30),
   106            index x (x)
   107          );
   108      - name: "two index"
   109        schema: |
   110          create table xy (
   111            x int primary key,
   112            y varchar(30),
   113            z varchar(30),
   114            w varchar(30),
   115            index x (x),
   116            index y (y)
   117          );
   118      - name: "four index"
   119        schema: |
   120          create table xy (
   121            x int primary key,
   122            y varchar(30),
   123            z varchar(30),
   124            w varchar(30),
   125            index x (x),
   126            index y (y),
   127            index z (z),
   128            index w (w)
   129          );
   130  - name: "blob"
   131    repos: *repos
   132    tables:
   133      - name: "no blob"
   134        schema: |
   135          create table xy (
   136            x int primary key,
   137            y varchar(30),
   138            z varchar(30),
   139            w varchar(30)
   140          );
   141      - name: "1 blob"
   142        schema: |
   143          create table xy (
   144            x int primary key,
   145            y blob,
   146            z varchar(30),
   147            w varchar(30)
   148          );
   149      - name: "2 blobs"
   150        schema: |
   151          create table xy (
   152            x int primary key,
   153            y blob,
   154            z blob,
   155            w varchar(30)
   156          );
   157  - name: "row count"
   158    repos: *repos
   159    tables:
   160      - name: "400k"
   161        rows: 400000
   162        schema: |
   163          create table xy (
   164            x int primary key,
   165            y varchar(30)
   166          );
   167      - name: "800k"
   168        rows: 800000
   169        schema: |
   170          create table xy (
   171            x int primary key,
   172            y varchar(30)
   173          );
   174      - name: "1.6mm"
   175        rows: 1600000
   176        schema: |
   177          create table xy (
   178            x int primary key,
   179            y varchar(30)
   180          );
   181  - name: "sorting"
   182    repos: *repos
   183    tables:
   184      - name: "shuffled 1mm"
   185        shuffle: true
   186        rows: 1000000
   187        schema: |
   188          create table xy (
   189            x int primary key,
   190            y varchar(30)
   191          );
   192      - name: "sorted 1mm"
   193        shuffle: false
   194        rows: 1000000
   195        schema: |
   196          create table xy (
   197            x int primary key,
   198            y varchar(30)
   199          );
   200  - name: "batching"
   201    repos:
   202    - name: dolt_server
   203      server:
   204        port: 3308
   205        args: [ "--port", "3308" ]
   206    - name: mysql
   207      external-server:
   208        name: test
   209        host: 127.0.0.1
   210        user: root
   211        password: password
   212        port: 3309
   213    tables:
   214      - name: "LOAD DATA"
   215        fmt: "csv"
   216        rows: 10000
   217        schema: |
   218          create table xy (
   219            x int primary key,
   220            y varchar(30)
   221          );
   222      - name: "batch sql"
   223        fmt: "sql"
   224        rows: 10000
   225        batch: true
   226        schema: |
   227          create table xy (
   228            x int primary key,
   229            y varchar(30)
   230          );
   231      - name: "by line sql"
   232        fmt: "sql"
   233        rows: 10000
   234        schema: |
   235          create table xy (
   236            x int primary key,
   237            y varchar(30)
   238          );