Sign inTry Free
  • Introduction
    • Deploy
      • Connect to Your Cluster
        • Create a Database
          • Integrate with SingleStoreDB
            • Load Data
              • Query Data
                • Manage Data
                  • Developer Resources
                    • User and Cluster Administration
                      • SingleStoreDB User Management
                        • Cluster Health and Performance
                          • High Availability and Disaster Recovery
                            • Maintain Your Cluster
                              • Dealing with Cluster Failures
                                • Startup Sequence and Process in a Cluster
                                • Resize Your Cluster
                                  • Upgrade or Uninstall SingleStoreDB
                                    • Transition from MySQL to SingleStoreDB
                                      • Troubleshooting
                                        • Introduction
                                        • 1. Identifying Expensive Queries
                                        • 2. Investigating Expensive Queries
                                        • 3. Are any queries waiting on something?
                                        • 4. Are key resources being overused?
                                        • 5. Are there other ongoing operational activities?
                                        • 6. Checking Node, Partition, and Overall Database Health
                                        • 7. Checking Partition Number and Data Skew
                                        • 8. Checking for System Changes and Log Hints
                                      • Use the Workload Manager and Set Resource Limits
                                        • Migrate from Ops to Tools
                                          • Cluster Management with Tools
                                            • Dedicated Admin Connections
                                            • Changing the Root Password
                                            • Recovering from Loss of Root Credentials
                                          • Reference
                                            • Security
                                              • Release Notes
                                                • Support
                                                  • Glossary
                                                  1. Self-Managed v8.0
                                                  2. /
                                                  3. ...
                                                  4. /
                                                  5. Troubleshooting

                                                  Troubleshooting

                                                  In this section

                                                  • Introduction
                                                  • 1. Identifying Expensive Queries
                                                  • 2. Investigating Expensive Queries
                                                  • 3. Are any queries waiting on something?
                                                  • 4. Are key resources being overused?
                                                  • 5. Are there other ongoing operational activities?
                                                  • 6. Checking Node, Partition, and Overall Database Health
                                                  • 7. Checking Partition Number and Data Skew
                                                  • 8. Checking for System Changes and Log Hints

                                                  Last modified: April 24, 2021

                                                  Was this article helpful?

                                                  Transitioning Your Application
                                                  Introduction

                                                  Product

                                                  • Product Overview
                                                  • Solutions
                                                  • Pricing
                                                  • Support

                                                  Community

                                                  • Forums
                                                  • Developer Hub
                                                  • Events
                                                  • Training

                                                  Company

                                                  • Contact Us
                                                  • Blog
                                                  • Careers
                                                  • SingleStore Connect

                                                  This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

                                                  • © SingleStore
                                                  • |

                                                  • Privacy Policy
                                                  • |

                                                  • Terms of Service
                                                  • |

                                                  • Legal Terms and Conditions

                                                  Was this article helpful?