Parameter Modifications

Last updated: 2020-09-04 11:34:04

    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 and enter the management page. Select Database Management > Parameter Settings. Common var\_name includes:

      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. Modify and click Save.

    To view more configuration parameters, click the instance name and go to Database Management > Parameter Settings in the TencentDB for MySQL Console.

    How do I set Chinese queries in TencentDB for MySQL?

    Chinese characters are currently not supported in TencentDB for MySQL.

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

    In the TencentDB for MySQL Console, click the instance name and 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 and 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 and enter the management page. Select Database Management > Parameter Settings and modify the group_concat_max_len parameter.

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

    Full-table scan statements are not recorded by default. To locate them, set the log_queries_not_using_indexes parameter to "ON" in Parameter Settings in the TencentDB for MySQL Console. We recommend that you only enable this parameter for a short period of time.

    How do I change the default character set in TencentDB?

    TencentDB for MySQL supports LATIN1, GBK, UTF8 (default), and UTF8MB4 character sets.

    Although TencentDB supports changing the default character set, we recommend that you explicitly specify the table encoding when creating a table and specify the connection encoding when establishing a connection for more portable application experience. For more information on MySQL default character set and how to modify it, please see Use Limits. You can also modify the character set in the MySQL Console.

    Was this page helpful?

    Was this page helpful?

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