[MCOL-570] The default value for max_allowed_packet in my.cnf is too small (1M) Created: 2017-02-15 Updated: 2022-11-05 Resolved: 2022-11-05 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MariaDB Server |
| Affects Version/s: | 1.0.7 |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Minor |
| Reporter: | Daniel Lee (Inactive) | Assignee: | Unassigned |
| Resolution: | Won't Do | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Build tested: 1.0.7-1 By default, the max_allowed_packet is setup 1M, which allows up to about 7384 rows of lineitem to be included in the value. This affects both ColumnStore and InnoDB tables. Since we target for data warehousing, We should increase the default value to 4M or higher. After increasing the value to 4M, I was able to insert 4x the number of rows. I created an Autopilot test (autopilot.systemTest.largeInsert) for this test. |
| Comments |
| Comment by Todd Stoffel (Inactive) [ 2022-11-05 ] |
|
This item is being closed because it was well passed the expiration date with no activity. If you suspect this was done in error please create a new ticket. |