[MCOL-1765] Performance tuning Created: 2018-10-03 Updated: 2022-11-05 Resolved: 2022-11-05 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | DMLProc, ExeMgr |
| Affects Version/s: | None |
| Fix Version/s: | Icebox |
| Type: | Task | Priority: | Major |
| Reporter: | Abhinav santi | Assignee: | Unassigned |
| Resolution: | Won't Do | Votes: | 0 |
| Labels: | None | ||
| Environment: |
PRD |
||
| Description |
|
Hello, Some of our tables have huge rows of data (>6 Billion rows) any DML/DDL involving these tables take a huge amount of time or time out sometimes. Do you suggest any performance tuning settings to handle this kind of loads? Thanks |
| Comments |
| Comment by Roman [ 2019-03-15 ] |
|
Greetings Abhinav. You should first measure how much time does it take to run the SELECT query with the same conditions as UPDATE/DELETE. If it takes a lot then you could profile the query it using calsettrace/calgettrace functions. If not there could be a lot of wasted space in your tables b/c CS doesn't reclaim DELETE-ed records' space. |
| 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. |