Cluster Performance

Lock Wait Detection
During SQL Execution, a Table Deadlock Occurs and An Error Stating LOCK_WAIT_TIMEOUT Is Reported
Error "abort transaction due to concurrent update" Is Reported During SQL Execution
Solution to High Disk Usage and Cluster Read-Only
SQL Execution Is Slow with Low Performance and Sometimes Does Not End After a Long Period of Time
Data Skew Causes Slow SQL Statement Execution and Operations Fail on Large Tables
Table Size Does not Change After VACUUM FULL Is Executed on the Table
VACUUM Is Executed After Table Data Deletion, But the Space Is Not Released
Error "lock wait timeout" Is Reported When VACUUM FULL Is Executed
Slow VACUUM FULL Execution
Table Bloating Causes Slow SQL Query and Failed Data Loading on the GUI
Memory Overflow Occurs in a Cluster
Statements with User-defined Functions Cannot Be Pushed Down
Column-Store Tables Cannot Be Updated or Table Bloat Occurs
Table Bloat Occurs After Data Is Inserted into a Column-Store Table for Multiple Times
Writing Data to DWS Is Slow and Client Data Is Stacked
Low Query Efficiency
Poor Query Performance Due to the Lack of Statistics
Execution of SQL Statements Is Slow Due to Nested Loops in Execution Plans
SQL Query Is Slow Because Partitions Are Not Pruned
Optimizer Uses Nested Loop Due to the Small Estimated Number of Rows and the Performance Deteriorates
SQL Statements Contain the in Constant and No Result Is Returned After SQL Statement Execution
Performance of Single-Table Point Query Is Poor
CCN Queuing Under Dynamic Load Management
Performance Deterioration Due to Data Bloat
Slow Performance Caused by Too Many Small CUs in Column Storage
Reducing I/O Usage
Tuning Systems with High CPU Usage
Reducing Memory Usage
"ERROR: Session used memory xxx Kbytes is beyond the limitation (xxx Kbytes)" Is Displayed During Service Execution

Previous topic: A User Cannot Be Deleted Due to Its Dependencies

Next topic: Lock Wait Detection

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot