[MCOL-1468] CDC adapter: mxs_adapter doesn't measure transaction insert time as expected Created: 2018-06-13 Updated: 2023-10-26 Resolved: 2018-08-07 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | None |
| Affects Version/s: | 1.1.5 |
| Fix Version/s: | 1.1.6 |
| Type: | Bug | Priority: | Major |
| Reporter: | Elena Kotsinova (Inactive) | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
CDC adapter calculates time between two transactions and displays this time as time for inserting of data from one transaction. It is expected to measure the time for insert operation only. Prerequisites: Steps to reproduce:
2. Insert 1 row in it
3. Run CDC streaming adapter
4. The cdc adapter displays message
5. Create the required table in ColumnStore
8. Wait for a couple of minutes and insert one more record through the MariaDB Server
The measured time is displayed as:
9. Wait more - for example around 1 hour and insert one more row
The measured time is displayed as:
Expected: |
| Comments |
| Comment by markus makela [ 2018-06-14 ] |
|
The output is the value returned by mcsapi::ColumnStoreSummary::getExecutionTime(). LinuxJedi does this value count the total bulk insert operation time? If so, either the wording of the output should be changed or another mechanism to track execution times needs to be added. |
| Comment by Andrew Hutchings (Inactive) [ 2018-06-14 ] |
|
markus makela the API's timer starts when the bulk insert object is created and stops at the end of commit or rollback. |
| Comment by markus makela [ 2018-08-07 ] |
|
Updated the wording in 42909280c7b29c4de416b81c26b93bd82c7749e2 to correctly describe that the time is not for transaction insertion but the span over which the data was loaded. |