[MCOL-1870] Add waiting and processing lines for statements in debuglog Created: 2018-11-09  Updated: 2022-11-05  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.0.0, 1.2, 1.5.3, 5.5.2, 5.6.2, 6.1.1
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: Richard Stracke Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
Labels: logging


 Description   

Usually columnstore logs the start and end timepoint of a SQL statement.

Oct 26 12:44:44  D 21 CAL0001: Start SQL statement: 
Oct 26 12:48:12  D 21 CAL0001: End SQL statement

The time between Start and End is not the processing time.
There are also waiting time for ressources.
You're tempted to find the error in the SQL statement himself,
but it could also memory issues, waiting for free requests
(MaxOutstandingRequests is reached), free memory,
wait for a table lock etc.

So it would helpful to add information for.

Which ressource is shortage ?
When the sql processing starts 

Oct 26 12:44:44  D 21 CAL0001: Start SQL statement: 
Oct 26 12:44:44  D 21 CAL0001: Wait for free xxxxxx
 
Oct 26 12:48:10  D 21 CAL0001: SQL Processing started
 
Oct 26 12:48:12  D 21 CAL0001: End SQL statement



 Comments   
Comment by Richard Stracke [ 2021-08-31 ]

A small workaround is possible with

calgetsqlcount();

MariaDB [(none)]> select now(), calgetsqlcount();
 
+---------------------+---------------------------------------------------+
 
| now()               | calgetsqlcount()                                  |
 
+---------------------+---------------------------------------------------+
 
| 2021-08-31 11:05:48 | Running SQL statements 4, Waiting SQL statments 0 |
 
+---------------------+---------------------------------------------------+
 
1 row in set (0.001 sec)

Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

Item is out of date. Closing due to inactivity. If you feel this was done in error please open a new ticket.

Generated at Thu Feb 08 02:32:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.