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 );