Details
-
Task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
None
Description
Without mariadb quick, load data outfile performs really slow as it has to buffer the results from columnstore. To address quickly, columnstore enables mariadb quick by default on newer versions, but has the side effect of unfriendly output on simple queries, like show variables, show tables , show databases etc.
A longer term solution would have the mariadb server optimizer identify that the load data outfile is going to run against a columnstore table and to dynamically turn on mariadb quick
Customer experience:
[root@ip-172-31-35-155 rocky]# mariadb -e "show status like '%Columnstore%';" |
+---------------+-------+
|
| Variable_name | Value |
|
+---------------+-------+
|
| Columnstore_commit_hash | source |
|
| Columnstore_version | 23.10.3 | |
+---------------+-------+
|
Attachments
Issue Links
- is caused by
-
MCOL-5523 SELECT INTO OUTFILE | Performance
-
- Closed
-
select into outfile has nothing to do with mariadb --quick, it cannot possibly turn it on, and even if by some magic it would, it wouldn't have any effect on performance whatsoever.
and optimizer has nothing to do with either.