Description

This article compares the efficiency and speed of the GenericSQLInsertThreadReceiver and the GenericSQLInsertV2Receiver in specific scenarios. It explains how the performance tests were conducted to evaluate the time and speed required for creating database tables as the number of columns increases. The results show that the efficiency of the GenericSQLInsertThreadReceiver increases with an increase in the number of table columns due to its ability to process data using multiple data collectors, buckets, and values across multiple threads. In contrast, the performance of the GenericSQLInsertV2Receiver decreases as the number of table columns increases since it processes values in a single-threaded manner.


Table Of Results From Performance Tests

The table below contains the results of the performance test.


Performance Test Criteria

The following criteria were defined to effectively test the veracity of these two Receivers.

  1. There will be three levels of data insertion: 10,000, 100,000, and 1,000,000 values, respectively.
  2. There will be 6 performance tests for each insertion level, and the number of table columns will increase from 25 to 150 in increments of 25. 
  3. For the GenericSQLInsertV2Receiver, there will be a total of 15 performance tests.
  4. For the GenericSQLInsertThreadReceiver, there will be a total of 90 performance tests.
  5. There will be 105 tests, all in total.
  6. The parameters for the GenericSQLInsertV2Receiver will be identical for all tests.
  7. The parameters for the GenericSQLInsertThreadReceiver are the same for the number of buckets and the number of values per bucket. However, the number of data controllers increases by 1 as the number of table columns increases by 25.


Test Result Observations

  1. Having a higher number of data collectors does not necessarily lead to greater efficiency as the quantity of table columns decreases. In fact, the opposite may occur. The reason for this is that the data collectors process and prepare data at a much faster rate than the database can handle the batches, which leads to the JVM managing more objects in memory, performing more garbage collection, and slowing down the over-processing of data.
  2. When inserting 10,000 values into any table, the tests where there is more than one data collector are not applicable. This is because each data collector has 10 buckets that can hold 1,000 values each. Therefore, the first data collector will process all 10,000 values.
  3. At 50 table columns or more, the GenericSQLInsertThreadReceiver was more efficient in all test cases.
  4. At 25 table columns or less, the GenericSQLInsertV2Receiver was more efficient. In fact, with 25 table columns or less, the GenericSQLInsertThreadReceiver was much less efficient on all tests except when three data collectors were used, and even then, it was only on par.  
  5. Most tests show that three data collectors are optimal, but when the number of data columns is 150 or more, five data collectors are better.


Test Parameters

The performance tests utilized the hardware, OS, database, and GenRocket domain parameters defined below.


Hardware & OS Parameters

  • Macbook Pro M1 Max
  • Main OS Mac Sonoma 14.3.1 64-bit
  • 10 CPUs
  • 64GB RAM
  • 2TB SSD
  • Running within a Parallels VM
  • Linux Ubuntu 22.04.4 LTS 64-bit
  • 4 CPUs
  • 20 GB RAM
  • 274.9 GB of the SSD


Database Parameters

  • Database - Mysql Ver 15.1 Distrib 10.6.16-MariaDB, for debian-linux-gnu (aarch64)
  • Database Engine - InnoDB
  • Five Test Tables
    • load_tester_25  - 1 Bigint Primary Id column, 25 Bigint columns
    • load_tester_50  - 1 Bigint Primary Id column, 50 Bigint columns
    • load_tester_75  - 1 Bigint Primary Id column, 75 Bigint columns
    • load_tester_100 - 1 Bigint Primary Id column, 100 Bigint columns
    • load_tester_125 - 1 Bigint Primary Id column, 125 Bigint columns
    • load_tester_150 - 1 Bigint Primary Id column, 150 Bigint columns


GenRocket Domain Models

  • Six Domains
  • id Attribute - Uses the RangeGen Generator
  • col* Attributes - Use the RandomGen Generator


Image of the Parallels VM Where Tests Where Run


MySQL / MariaDB DDLs

The following DDLs define the Innodb tables created for performance testing with the GenericSQLInsertV2Receiver and the GenericSQLInsertThreadReceiver.


Table load_tester_25

CREATE TABLE 
    load_tester_25 
    ( 
        id    bigint NOT NULL AUTO_INCREMENT, 
        col1  bigint NOT NULL, 
        col2  bigint NOT NULL, 
        col3  bigint NOT NULL, 
        col4  bigint NOT NULL, 
        col5  bigint NOT NULL, 
        col6  bigint NOT NULL, 
        col7  bigint NOT NULL, 
        col8  bigint NOT NULL, 
        col9  bigint NOT NULL, 
        col10 bigint NOT NULL, 
        col11 bigint NOT NULL, 
        col12 bigint NOT NULL, 
        col13 bigint NOT NULL, 
        col14 bigint NOT NULL, 
        col15 bigint NOT NULL, 
        col16 bigint NOT NULL, 
        col17 bigint NOT NULL, 
        col18 bigint NOT NULL, 
        col19 bigint NOT NULL, 
        col20 bigint NOT NULL, 
        col21 bigint NOT NULL, 
        col22 bigint NOT NULL, 
        col23 bigint NOT NULL, 
        col24 bigint NOT NULL, 
        col25 bigint NOT NULL, 
        PRIMARY KEY (id) 
    ) 
    ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
SQL


Table load_tester_50

CREATE TABLE 
    load_tester_50 
    ( 
        id    bigint NOT NULL AUTO_INCREMENT, 
        col1  bigint NOT NULL, 
        col2  bigint NOT NULL, 
        col3  bigint NOT NULL, 
        col4  bigint NOT NULL, 
        col5  bigint NOT NULL, 
        col6  bigint NOT NULL, 
        col7  bigint NOT NULL, 
        col8  bigint NOT NULL, 
        col9  bigint NOT NULL, 
        col10 bigint NOT NULL, 
        col11 bigint NOT NULL, 
        col12 bigint NOT NULL, 
        col13 bigint NOT NULL, 
        col14 bigint NOT NULL, 
        col15 bigint NOT NULL, 
        col16 bigint NOT NULL, 
        col17 bigint NOT NULL, 
        col18 bigint NOT NULL, 
        col19 bigint NOT NULL, 
        col20 bigint NOT NULL, 
        col21 bigint NOT NULL, 
        col22 bigint NOT NULL, 
        col23 bigint NOT NULL, 
        col24 bigint NOT NULL, 
        col25 bigint NOT NULL, 
        col26 bigint NOT NULL, 
        col27 bigint NOT NULL, 
        col28 bigint NOT NULL, 
        col29 bigint NOT NULL, 
        col30 bigint NOT NULL, 
        col31 bigint NOT NULL, 
        col32 bigint NOT NULL, 
        col33 bigint NOT NULL, 
        col34 bigint NOT NULL, 
        col35 bigint NOT NULL, 
        col36 bigint NOT NULL, 
        col37 bigint NOT NULL, 
        col38 bigint NOT NULL, 
        col39 bigint NOT NULL, 
        col40 bigint NOT NULL, 
        col41 bigint NOT NULL, 
        col42 bigint NOT NULL, 
        col43 bigint NOT NULL, 
        col44 bigint NOT NULL, 
        col45 bigint NOT NULL, 
        col46 bigint NOT NULL, 
        col47 bigint NOT NULL, 
        col48 bigint NOT NULL, 
        col49 bigint NOT NULL, 
        col50 bigint NOT NULL, 
        PRIMARY KEY (id) 
    ) 
    ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
SQL


Table load_tester_75

CREATE TABLE 
    load_tester_75 
    ( 
        id    bigint NOT NULL AUTO_INCREMENT, 
        col1  bigint NOT NULL, 
        col2  bigint NOT NULL, 
        col3  bigint NOT NULL, 
        col4  bigint NOT NULL, 
        col5  bigint NOT NULL, 
        col6  bigint NOT NULL, 
        col7  bigint NOT NULL, 
        col8  bigint NOT NULL, 
        col9  bigint NOT NULL, 
        col10 bigint NOT NULL, 
        col11 bigint NOT NULL, 
        col12 bigint NOT NULL, 
        col13 bigint NOT NULL, 
        col14 bigint NOT NULL, 
        col15 bigint NOT NULL, 
        col16 bigint NOT NULL, 
        col17 bigint NOT NULL, 
        col18 bigint NOT NULL, 
        col19 bigint NOT NULL, 
        col20 bigint NOT NULL, 
        col21 bigint NOT NULL, 
        col22 bigint NOT NULL, 
        col23 bigint NOT NULL, 
        col24 bigint NOT NULL, 
        col25 bigint NOT NULL, 
        col26 bigint NOT NULL, 
        col27 bigint NOT NULL, 
        col28 bigint NOT NULL, 
        col29 bigint NOT NULL, 
        col30 bigint NOT NULL, 
        col31 bigint NOT NULL, 
        col32 bigint NOT NULL, 
        col33 bigint NOT NULL, 
        col34 bigint NOT NULL, 
        col35 bigint NOT NULL, 
        col36 bigint NOT NULL, 
        col37 bigint NOT NULL, 
        col38 bigint NOT NULL, 
        col39 bigint NOT NULL, 
        col40 bigint NOT NULL, 
        col41 bigint NOT NULL, 
        col42 bigint NOT NULL, 
        col43 bigint NOT NULL, 
        col44 bigint NOT NULL, 
        col45 bigint NOT NULL, 
        col46 bigint NOT NULL, 
        col47 bigint NOT NULL, 
        col48 bigint NOT NULL, 
        col49 bigint NOT NULL, 
        col50 bigint NOT NULL, 
        col51 bigint NOT NULL, 
        col52 bigint NOT NULL, 
        col53 bigint NOT NULL, 
        col54 bigint NOT NULL, 
        col55 bigint NOT NULL, 
        col56 bigint NOT NULL, 
        col57 bigint NOT NULL, 
        col58 bigint NOT NULL, 
        col59 bigint NOT NULL, 
        col60 bigint NOT NULL, 
        col61 bigint NOT NULL, 
        col62 bigint NOT NULL, 
        col63 bigint NOT NULL, 
        col64 bigint NOT NULL, 
        col65 bigint NOT NULL, 
        col66 bigint NOT NULL, 
        col67 bigint NOT NULL, 
        col68 bigint NOT NULL, 
        col69 bigint NOT NULL, 
        col70 bigint NOT NULL, 
        col71 bigint NOT NULL, 
        col72 bigint NOT NULL, 
        col73 bigint NOT NULL, 
        col74 bigint NOT NULL, 
        col75 bigint NOT NULL, 
        PRIMARY KEY (id) 
    ) 
    ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
SQL


Table load_tester_100

CREATE TABLE 
    load_tester_100 
    ( 
        id     bigint NOT NULL AUTO_INCREMENT, 
        col1   bigint NOT NULL, 
        col2   bigint NOT NULL, 
        col3   bigint NOT NULL, 
        col4   bigint NOT NULL, 
        col5   bigint NOT NULL, 
        col6   bigint NOT NULL, 
        col7   bigint NOT NULL, 
        col8   bigint NOT NULL, 
        col9   bigint NOT NULL, 
        col10  bigint NOT NULL, 
        col11  bigint NOT NULL, 
        col12  bigint NOT NULL, 
        col13  bigint NOT NULL, 
        col14  bigint NOT NULL, 
        col15  bigint NOT NULL, 
        col16  bigint NOT NULL, 
        col17  bigint NOT NULL, 
        col18  bigint NOT NULL, 
        col19  bigint NOT NULL, 
        col20  bigint NOT NULL, 
        col21  bigint NOT NULL, 
        col22  bigint NOT NULL, 
        col23  bigint NOT NULL, 
        col24  bigint NOT NULL, 
        col25  bigint NOT NULL, 
        col26  bigint NOT NULL, 
        col27  bigint NOT NULL, 
        col28  bigint NOT NULL, 
        col29  bigint NOT NULL, 
        col30  bigint NOT NULL, 
        col31  bigint NOT NULL, 
        col32  bigint NOT NULL, 
        col33  bigint NOT NULL, 
        col34  bigint NOT NULL, 
        col35  bigint NOT NULL, 
        col36  bigint NOT NULL, 
        col37  bigint NOT NULL, 
        col38  bigint NOT NULL, 
        col39  bigint NOT NULL, 
        col40  bigint NOT NULL, 
        col41  bigint NOT NULL, 
        col42  bigint NOT NULL, 
        col43  bigint NOT NULL, 
        col44  bigint NOT NULL, 
        col45  bigint NOT NULL, 
        col46  bigint NOT NULL, 
        col47  bigint NOT NULL, 
        col48  bigint NOT NULL, 
        col49  bigint NOT NULL, 
        col50  bigint NOT NULL, 
        col51  bigint NOT NULL, 
        col52  bigint NOT NULL, 
        col53  bigint NOT NULL, 
        col54  bigint NOT NULL, 
        col55  bigint NOT NULL, 
        col56  bigint NOT NULL, 
        col57  bigint NOT NULL, 
        col58  bigint NOT NULL, 
        col59  bigint NOT NULL, 
        col60  bigint NOT NULL, 
        col61  bigint NOT NULL, 
        col62  bigint NOT NULL, 
        col63  bigint NOT NULL, 
        col64  bigint NOT NULL, 
        col65  bigint NOT NULL, 
        col66  bigint NOT NULL, 
        col67  bigint NOT NULL, 
        col68  bigint NOT NULL, 
        col69  bigint NOT NULL, 
        col70  bigint NOT NULL, 
        col71  bigint NOT NULL, 
        col72  bigint NOT NULL, 
        col73  bigint NOT NULL, 
        col74  bigint NOT NULL, 
        col75  bigint NOT NULL, 
        col76  bigint NOT NULL, 
        col77  bigint NOT NULL, 
        col78  bigint NOT NULL, 
        col79  bigint NOT NULL, 
        col80  bigint NOT NULL, 
        col81  bigint NOT NULL, 
        col82  bigint NOT NULL, 
        col83  bigint NOT NULL, 
        col84  bigint NOT NULL, 
        col85  bigint NOT NULL, 
        col86  bigint NOT NULL, 
        col87  bigint NOT NULL, 
        col88  bigint NOT NULL, 
        col89  bigint NOT NULL, 
        col90  bigint NOT NULL, 
        col91  bigint NOT NULL, 
        col92  bigint NOT NULL, 
        col93  bigint NOT NULL, 
        col94  bigint NOT NULL, 
        col95  bigint NOT NULL, 
        col96  bigint NOT NULL, 
        col97  bigint NOT NULL, 
        col98  bigint NOT NULL, 
        col99  bigint NOT NULL, 
        col100 bigint NOT NULL, 
        PRIMARY KEY (id) 
    ) 
    ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
SQL


Table load_tester_125

CREATE TABLE 
    load_tester_125 
    ( 
        id     bigint NOT NULL AUTO_INCREMENT, 
        col1   bigint NOT NULL, 
        col2   bigint NOT NULL, 
        col3   bigint NOT NULL, 
        col4   bigint NOT NULL, 
        col5   bigint NOT NULL, 
        col6   bigint NOT NULL, 
        col7   bigint NOT NULL, 
        col8   bigint NOT NULL, 
        col9   bigint NOT NULL, 
        col10  bigint NOT NULL, 
        col11  bigint NOT NULL, 
        col12  bigint NOT NULL, 
        col13  bigint NOT NULL, 
        col14  bigint NOT NULL, 
        col15  bigint NOT NULL, 
        col16  bigint NOT NULL, 
        col17  bigint NOT NULL, 
        col18  bigint NOT NULL, 
        col19  bigint NOT NULL, 
        col20  bigint NOT NULL, 
        col21  bigint NOT NULL, 
        col22  bigint NOT NULL, 
        col23  bigint NOT NULL, 
        col24  bigint NOT NULL, 
        col25  bigint NOT NULL, 
        col26  bigint NOT NULL, 
        col27  bigint NOT NULL, 
        col28  bigint NOT NULL, 
        col29  bigint NOT NULL, 
        col30  bigint NOT NULL, 
        col31  bigint NOT NULL, 
        col32  bigint NOT NULL, 
        col33  bigint NOT NULL, 
        col34  bigint NOT NULL, 
        col35  bigint NOT NULL, 
        col36  bigint NOT NULL, 
        col37  bigint NOT NULL, 
        col38  bigint NOT NULL, 
        col39  bigint NOT NULL, 
        col40  bigint NOT NULL, 
        col41  bigint NOT NULL, 
        col42  bigint NOT NULL, 
        col43  bigint NOT NULL, 
        col44  bigint NOT NULL, 
        col45  bigint NOT NULL, 
        col46  bigint NOT NULL, 
        col47  bigint NOT NULL, 
        col48  bigint NOT NULL, 
        col49  bigint NOT NULL, 
        col50  bigint NOT NULL, 
        col51  bigint NOT NULL, 
        col52  bigint NOT NULL, 
        col53  bigint NOT NULL, 
        col54  bigint NOT NULL, 
        col55  bigint NOT NULL, 
        col56  bigint NOT NULL, 
        col57  bigint NOT NULL, 
        col58  bigint NOT NULL, 
        col59  bigint NOT NULL, 
        col60  bigint NOT NULL, 
        col61  bigint NOT NULL, 
        col62  bigint NOT NULL, 
        col63  bigint NOT NULL, 
        col64  bigint NOT NULL, 
        col65  bigint NOT NULL, 
        col66  bigint NOT NULL, 
        col67  bigint NOT NULL, 
        col68  bigint NOT NULL, 
        col69  bigint NOT NULL, 
        col70  bigint NOT NULL, 
        col71  bigint NOT NULL, 
        col72  bigint NOT NULL, 
        col73  bigint NOT NULL, 
        col74  bigint NOT NULL, 
        col75  bigint NOT NULL, 
        col76  bigint NOT NULL, 
        col77  bigint NOT NULL, 
        col78  bigint NOT NULL, 
        col79  bigint NOT NULL, 
        col80  bigint NOT NULL, 
        col81  bigint NOT NULL, 
        col82  bigint NOT NULL, 
        col83  bigint NOT NULL, 
        col84  bigint NOT NULL, 
        col85  bigint NOT NULL, 
        col86  bigint NOT NULL, 
        col87  bigint NOT NULL, 
        col88  bigint NOT NULL, 
        col89  bigint NOT NULL, 
        col90  bigint NOT NULL, 
        col91  bigint NOT NULL, 
        col92  bigint NOT NULL, 
        col93  bigint NOT NULL, 
        col94  bigint NOT NULL, 
        col95  bigint NOT NULL, 
        col96  bigint NOT NULL, 
        col97  bigint NOT NULL, 
        col98  bigint NOT NULL, 
        col99  bigint NOT NULL, 
        col100 bigint NOT NULL, 
        col101 bigint NOT NULL, 
        col102 bigint NOT NULL, 
        col103 bigint NOT NULL, 
        col104 bigint NOT NULL, 
        col105 bigint NOT NULL, 
        col106 bigint NOT NULL, 
        col107 bigint NOT NULL, 
        col108 bigint NOT NULL, 
        col109 bigint NOT NULL, 
        col110 bigint NOT NULL, 
        col111 bigint NOT NULL, 
        col112 bigint NOT NULL, 
        col113 bigint NOT NULL, 
        col114 bigint NOT NULL, 
        col115 bigint NOT NULL, 
        col116 bigint NOT NULL, 
        col117 bigint NOT NULL, 
        col118 bigint NOT NULL, 
        col119 bigint NOT NULL, 
        col120 bigint NOT NULL, 
        col121 bigint NOT NULL, 
        col122 bigint NOT NULL, 
        col123 bigint NOT NULL, 
        col124 bigint NOT NULL, 
        col125 bigint NOT NULL, 
        PRIMARY KEY (id) 
    ) 
    ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
SQL

Table load_tester_150

CREATE TABLE 
    load_tester_150 
    ( 
        id     bigint NOT NULL AUTO_INCREMENT, 
        col1   bigint NOT NULL, 
        col2   bigint NOT NULL, 
        col3   bigint NOT NULL, 
        col4   bigint NOT NULL, 
        col5   bigint NOT NULL, 
        col6   bigint NOT NULL, 
        col7   bigint NOT NULL, 
        col8   bigint NOT NULL, 
        col9   bigint NOT NULL, 
        col10  bigint NOT NULL, 
        col11  bigint NOT NULL, 
        col12  bigint NOT NULL, 
        col13  bigint NOT NULL, 
        col14  bigint NOT NULL, 
        col15  bigint NOT NULL, 
        col16  bigint NOT NULL, 
        col17  bigint NOT NULL, 
        col18  bigint NOT NULL, 
        col19  bigint NOT NULL, 
        col20  bigint NOT NULL, 
        col21  bigint NOT NULL, 
        col22  bigint NOT NULL, 
        col23  bigint NOT NULL, 
        col24  bigint NOT NULL, 
        col25  bigint NOT NULL, 
        col26  bigint NOT NULL, 
        col27  bigint NOT NULL, 
        col28  bigint NOT NULL, 
        col29  bigint NOT NULL, 
        col30  bigint NOT NULL, 
        col31  bigint NOT NULL, 
        col32  bigint NOT NULL, 
        col33  bigint NOT NULL, 
        col34  bigint NOT NULL, 
        col35  bigint NOT NULL, 
        col36  bigint NOT NULL, 
        col37  bigint NOT NULL, 
        col38  bigint NOT NULL, 
        col39  bigint NOT NULL, 
        col40  bigint NOT NULL, 
        col41  bigint NOT NULL, 
        col42  bigint NOT NULL, 
        col43  bigint NOT NULL, 
        col44  bigint NOT NULL, 
        col45  bigint NOT NULL, 
        col46  bigint NOT NULL, 
        col47  bigint NOT NULL, 
        col48  bigint NOT NULL, 
        col49  bigint NOT NULL, 
        col50  bigint NOT NULL, 
        col51  bigint NOT NULL, 
        col52  bigint NOT NULL, 
        col53  bigint NOT NULL, 
        col54  bigint NOT NULL, 
        col55  bigint NOT NULL, 
        col56  bigint NOT NULL, 
        col57  bigint NOT NULL, 
        col58  bigint NOT NULL, 
        col59  bigint NOT NULL, 
        col60  bigint NOT NULL, 
        col61  bigint NOT NULL, 
        col62  bigint NOT NULL, 
        col63  bigint NOT NULL, 
        col64  bigint NOT NULL, 
        col65  bigint NOT NULL, 
        col66  bigint NOT NULL, 
        col67  bigint NOT NULL, 
        col68  bigint NOT NULL, 
        col69  bigint NOT NULL, 
        col70  bigint NOT NULL, 
        col71  bigint NOT NULL, 
        col72  bigint NOT NULL, 
        col73  bigint NOT NULL, 
        col74  bigint NOT NULL, 
        col75  bigint NOT NULL, 
        col76  bigint NOT NULL, 
        col77  bigint NOT NULL, 
        col78  bigint NOT NULL, 
        col79  bigint NOT NULL, 
        col80  bigint NOT NULL, 
        col81  bigint NOT NULL, 
        col82  bigint NOT NULL, 
        col83  bigint NOT NULL, 
        col84  bigint NOT NULL, 
        col85  bigint NOT NULL, 
        col86  bigint NOT NULL, 
        col87  bigint NOT NULL, 
        col88  bigint NOT NULL, 
        col89  bigint NOT NULL, 
        col90  bigint NOT NULL, 
        col91  bigint NOT NULL, 
        col92  bigint NOT NULL, 
        col93  bigint NOT NULL, 
        col94  bigint NOT NULL, 
        col95  bigint NOT NULL, 
        col96  bigint NOT NULL, 
        col97  bigint NOT NULL, 
        col98  bigint NOT NULL, 
        col99  bigint NOT NULL, 
        col100 bigint NOT NULL, 
        col101 bigint NOT NULL, 
        col102 bigint NOT NULL, 
        col103 bigint NOT NULL, 
        col104 bigint NOT NULL, 
        col105 bigint NOT NULL, 
        col106 bigint NOT NULL, 
        col107 bigint NOT NULL, 
        col108 bigint NOT NULL, 
        col109 bigint NOT NULL, 
        col110 bigint NOT NULL, 
        col111 bigint NOT NULL, 
        col112 bigint NOT NULL, 
        col113 bigint NOT NULL, 
        col114 bigint NOT NULL, 
        col115 bigint NOT NULL, 
        col116 bigint NOT NULL, 
        col117 bigint NOT NULL, 
        col118 bigint NOT NULL, 
        col119 bigint NOT NULL, 
        col120 bigint NOT NULL, 
        col121 bigint NOT NULL, 
        col122 bigint NOT NULL, 
        col123 bigint NOT NULL, 
        col124 bigint NOT NULL, 
        col125 bigint NOT NULL, 
        col126 bigint NOT NULL, 
        col127 bigint NOT NULL, 
        col128 bigint NOT NULL, 
        col129 bigint NOT NULL, 
        col130 bigint NOT NULL, 
        col131 bigint NOT NULL, 
        col132 bigint NOT NULL, 
        col133 bigint NOT NULL, 
        col134 bigint NOT NULL, 
        col135 bigint NOT NULL, 
        col136 bigint NOT NULL, 
        col137 bigint NOT NULL, 
        col138 bigint NOT NULL, 
        col139 bigint NOT NULL, 
        col140 bigint NOT NULL, 
        col141 bigint NOT NULL, 
        col142 bigint NOT NULL, 
        col143 bigint NOT NULL, 
        col144 bigint NOT NULL, 
        col145 bigint NOT NULL, 
        col146 bigint NOT NULL, 
        col147 bigint NOT NULL, 
        col148 bigint NOT NULL, 
        col149 bigint NOT NULL, 
        col150 bigint NOT NULL, 
        PRIMARY KEY (id) 
    ) 
    ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_general_ci;
SQL