How can we help you today?

How to Use the MySQL Slow Queries in the Control Panel

Created by: Sophie van Vrijberghe de Coningh

Modified on: Wed, 19 Aug, 2020 at 4:21 PM


If your database query takes too long, you run the risk of crashing your site, because this will delay other queries. The database server can also become overloaded by poorly designed queries, causing performance issues on your Hypernode. You can use the MySQL Slow Logs in the Control Panel to find out what's causing the delay.

TABLE OF CONTENTS

MySQL Slow Logs in the Control Panel

In the Control Panel you can view the slow query logs under the button MySQL Slow Queries in the sidebar on the left. MySQL queries that took longer than 2 seconds are logged here:

MySQL Slow Logs Details

You can also unfold an entry for more information by clicking the orange arrow:


This entry contains the following information:

  • start time
  • duration
  • database
  • user
  • bytes sent
  • lock time
  • source IP
  • rows evaluated
  • rows updated
  • rows returned
  • the actual query

Filtering Logs

We have 7 days worth of MySQL slow logs in the Control Panel. You can also filter the logs by date:

S
Sophie is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.