Parameter Modifications

Last updated: 2020-07-01 17:53:41

    How do I modify the configuration parameters of a TencentDB for MySQL instance?

    • In the TencentDB for MySQL Console
      In the TencentDB for MySQL Console, click the instance name to enter the management page, and select Database Management > Parameter Settings. Common var\_names include:

      Variable Description
      character_set_server Default character set of the server
      connect_timeout Connection timeout period
      long_query_time A query that takes longer than this time is a slow query
      max_allowed_packet Maximum packet length
      max_connections Maximum number of connections
      sql_mode Current SQL mode of the server
      table_open_cache Number of tables opened by all threads. Increasing this value will increase the number of file descriptors that mysqld is requested to open
      wait_timeout Non-interactive connection timeout period.
    • In the phpMyAdmin Console
      Log in to the TencentDB for MySQL instance through phpMyAdmin and click Variables on the top menu. Click Edit next to the variable to be modified in the variable list, modify it, and click Save.

    You can view more configuration parameters in Database Management > Parameter Settings in the console.

    How do I set Chinese queries in TencentDB for MySQL?

    No Chinese characters are supported in TencentDB for MySQL for the time being.

    How do I enable the scheduler function in TencentDB for MySQL?

    In the TencentDB for MySQL Console, click the instance name to enter the management page, select Database Management > Parameter Settings, and set the event_scheduler parameter to "ON".

    How do I increase the connection timeout period in TencentDB for MySQL?

    In the TencentDB for MySQL Console, click the instance name to enter the management page, select Database Management > Parameter Settings, and modify the wait_timeout parameter.

    How do I modify the group_concat_max_len parameter in TencentDB for MySQL?

    In the TencentDB for MySQL Console, click the instance name to enter the management page, select Database Management > Parameter Settings, and modify the group_concat_max_len parameter.

    How do I locate the SQL statement for full table scan in TencentDB for MySQL?

    The statement for full table scan is not recorded by default. To do so, set the log_queries_not_using_indexes parameter to "ON" on the Parameter Settings page in the TencentDB for MySQL Console. Note: do not keep it on for too long.

    How do I change the default character set in TencentDB?

    The default character set in TencentDB for MySQL is the same as that in MySQL: LATIN1 (i.e., ISO-8859-1). You can change the server-side character set of a database. Currently, four character sets are supported: LATIN1, GBK, UTF8, and UTF8MB4.

    Even though TencentDB supports changing the default character set, you are recommended to explicitly specify the table encoding format when creating it and specify the connection encoding during connection establishment. In this way, your application will be more portable. For more information on the default MySQL character set and how to change it, please see Use Limits. You can change the character set in the TencentDB Console.

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help