1# test of group commit switching 2 3query: 4 select | insert | update| delete | 5 select | insert | update| delete | 6 select | insert | update| delete | 7 select | insert | update| delete | 8 select | insert | update| delete | 9 select | insert | update| delete | 10 select | insert | update| delete | 11 select | insert | update| delete | 12 select | insert | update| delete | 13 select | insert | update| delete | 14 select | insert | update| delete | 15 select | insert | update| delete | 16 select | insert | update| delete | 17 select | insert | update| delete | 18 select | insert | update| delete | 19 select | insert | update| delete | 20 select | insert | update| delete | 21 select | insert | update| delete | 22 select | insert | update| delete | 23 select | insert | update| delete | 24 select | insert | update| delete | 25 select | insert | update| delete | 26 select | insert | update| delete | 27 select | insert | update| delete | 28 select | insert | update| delete | 29 select | insert | update| delete | 30 select | insert | update| delete | 31 select | insert | update| delete | 32 select | insert | update| delete | 33 select | insert | update| delete | 34 select | insert | update| delete | 35 select | insert | update| delete | 36 select | insert | update| delete | 37 select | insert | update| delete | 38 select | insert | update| delete | 39 select | insert | update| delete | 40 select | insert | update| delete | 41 select | insert | update| delete | 42 select | insert | update| delete | 43 select | insert | update| delete | 44 select | insert | update| delete | 45 select | insert | update| delete | 46 select | insert | update| delete | 47 select | insert | update| delete | 48 select | insert | update| delete | 49 select | insert | update| delete | 50 select | insert | update| delete | 51 select | insert | update| delete | 52 select | insert | update| delete | 53 select | insert | update| delete | 54 select | insert | update| delete | 55 select | insert | update| delete | 56 select | insert | update| delete | 57 select | insert | update| delete | 58 select | insert | update| delete | 59 select | insert | update| delete | 60 select | insert | update| delete | 61 select | insert | update| delete | 62 select | insert | update| delete | 63 select | insert | update| delete | 64 select | insert | update| delete | 65 select | insert | update| delete | 66 select | insert | update| delete | 67 select | insert | update| delete | 68 select | insert | update| delete | 69 select | insert | update| delete | 70 select | insert | update| delete | 71 select | insert | update| delete | 72 select | insert | update| delete | 73 select | insert | update| delete | 74 select | insert | update| delete | 75 select | insert | update| delete | 76 select | insert | update| delete | 77 select | insert | update| delete | 78 select | insert | update| delete | 79 select | insert | update| delete | 80 select | insert | update| delete | 81 select | insert | update| delete | 82 select | insert | update| delete | 83 select | insert | update| delete | 84 select | insert | update| delete | 85 select | insert | update| delete | 86 select | insert | update| delete | 87 select | insert | update| delete | 88 select | insert | update| delete | 89 select | insert | update| delete | 90 select | insert | update| delete | 91 select | insert | update| delete | 92 select | insert | update| delete | 93 select | insert | update| delete | 94 select | insert | update| delete | 95 select | insert | update| delete | 96 select | insert | update| delete | 97 select | insert | update| delete | 98 select | insert | update| delete | 99 select | insert | update| delete | 100 select | insert | update| delete | 101 select | insert | update| delete | 102 select | insert | update| delete | 103 select | insert | update| delete | 104 select | insert | update| delete | 105 select | insert | update| delete | 106 select | insert | update| delete | 107 select | insert | update| delete | 108 select | insert | update| delete | 109 select | insert | update| delete | 110 select | insert | update| delete | 111 select | insert | update| delete | 112 select | insert | update| delete | 113 select | insert | update| delete | 114 select | insert | update| delete | 115 select | insert | update| delete | 116 select | insert | update| delete | 117 select | insert | update| delete | 118 select | insert | update| delete | 119 select | insert | update| delete | 120 select | insert | update| delete | 121 select | insert | update| delete | 122 select | insert | update| delete | 123 select | insert | update| delete | 124 change_group_commit | change_interval; 125 126 127select: 128 SELECT select_item FROM join where order_by limit; 129 130select_item: 131 * | X . _field ; 132 133join: 134 _table AS X | 135 _table AS X LEFT JOIN _table AS Y ON ( X . _field = Y . _field ) ; 136 137where: 138 | 139 WHERE X . _field < value | 140 WHERE X . _field > value | 141 WHERE X . _field = value ; 142 143where_delete: 144 | 145 WHERE _field < value | 146 WHERE _field > value | 147 WHERE _field = value ; 148 149order_by: 150 | ORDER BY X . _field ; 151 152limit: 153 | LIMIT _digit ; 154 155insert: 156 INSERT INTO _table ( _field , _field ) VALUES ( value , value ) ; 157 158update: 159 UPDATE _table AS X SET _field = value where order_by limit ; 160 161delete: 162 DELETE FROM _table where_delete LIMIT _digit ; 163 164value: 165 ' _letter ' | _digit | _date | _datetime | _time | _english ; 166 167change_group_commit: 168 SET GLOBAL MARIA_GROUP_COMMIT=none_soft_hard; 169 170none_soft_hard: 171 NONE | SOFT | HARD; 172 173change_interval: 174 set_interval | set_interval | set_interval | set_interval | 175 drop_interval; 176 177set_interval: 178 SET GLOBAL MARIA_GROUP_COMMIT_INTERVAL=_tinyint_unsigned; 179 180drop_interval: 181 SET GLOBAL MARIA_GROUP_COMMIT_INTERVAL=0; 182