:original_name: gaussdb_03_0152.html

.. _gaussdb_03_0152:

Enabling or Disabling SQL Explorer
==================================

Enabling SQL Explorer will allow GaussDB(for MySQL) to store all SQL statement logs for analysis.

By default, SQL Explorer is disabled for GaussDB(for MySQL). This section describes how to enable and disable SQL Explorer.

Enabling SQL Explorer
---------------------

#. Log in to the console.

#. Click |image1| in the upper left corner and select a region and a project.

#. Under **Database**, click **GaussDB**. In the navigation pane on the left, click **GaussDB(for MySQL)**.

#. On the **Instances** page, click the instance name to go to the **Basic Information** page.

#. In the navigation pane on the left, choose **Advanced O&M**.

#. In the **SQL Explorer** tab, set |image2| to |image3|. In the displayed dialog box, select **I have read the agreement and agree to having my data stored**, and click **OK**.


   .. figure:: /_static/images/en-us_image_0000001446730040.png
      :alt: **Figure 1** Enabling SQL Explorer

      **Figure 1** Enabling SQL Explorer

   .. note::

      SQL data is stored for 1 day by default and will be automatically deleted after that time expires.

Disabling SQL Explorer
----------------------

#. Log in to the console.
#. Click |image4| in the upper left corner and select a region and a project.
#. Under **Database**, click **GaussDB**. In the navigation pane on the left, click **GaussDB(for MySQL)**.
#. On the **Instances** page, click the instance name to go to the **Basic Information** page.
#. In the navigation pane on the left, choose **Advanced O&M**. Click **SQL Explorer** and set |image5| to |image6|.

.. |image1| image:: /_static/images/en-us_image_0000001400391461.png
.. |image2| image:: /_static/images/en-us_image_0000001496610421.png
.. |image3| image:: /_static/images/en-us_image_0000001497009921.png
.. |image4| image:: /_static/images/en-us_image_0000001400391461.png
.. |image5| image:: /_static/images/en-us_image_0000001496889725.png
.. |image6| image:: /_static/images/en-us_image_0000001497009925.png
