What are the standards and certifications of TencentDB for MariaDB?
TencentDB for MariaDB has earned many Chinese and international certifications on behalf of TencentDB, including but not limited to:
Software Copyright
ISO22301 Certification
ISO27001 Certification
ISO20000 Certification
ISO9001 Certification
Trusted Cloud Service Certification
Cybersecurity Classified Protection Certification
STAR Certification
Some features of TencentDB for MariaDB are designed based on the following standards:
GBT 20273-2006 Information Security Technology - Security Techniques Requirement for Database Management System
JRT 0072-2012 Testing and Evaluation Guide for Classified Protection of Information System of Financial Industry
Why does an error occur when I specify some storage engines for a TencentDB for MariaDB instance?
During the initialization of MariaDB, consistency requirements are prioritized, and certain storage engines may cause data inconsistency. As a result, you may encounter errors when creating tables with some storage engines. You can use the SHOW ENGINES command to view the storage engines supported by the current database. For more information on storage engines, please refer to Storage Engines.
Why does a newly purchased TencentDB for MariaDB instance with 2 GB memory only have about 1 GB cache capacity after initialization?
Please see "Parameter Settings" of the corresponding instance in the TencentDB for MariaDB Console. 1 GB out of the 2 GB memory will be assigned to the threads executed by SQL, such as temporary table variables in the figure below.
Why does the max_tmp_size parameter have a size of at most 60 MB in a TencentDB for MariaDB instance with 6 GB memory?
The default value for the MariaDB system is 64 MB, and it is not recommended to adjust it too high. If you need to set it to a specific value, please submit a ticket, and we will assist you.
Why does the CPU utilization reach 50% when there is no operation on the TencentDB for MariaDB instance?
Due to the TencentDB architecture design, binlogs and slow logs are analyzed and uploaded once every five minutes; therefore, there will be one minute with high CPU utilization every five minutes.
The monitoring page in the console displays the maximum value in five minutes, so the utilization seems high; however, the actual utilization is lower than the displayed value.
Why is only one IP address displayed for the TencentDB for MariaDB Standard Edition (one primary and one replica)?
The replica server does not provide an IP address. You can purchase read-only replicas if needed.
Why doesn't the available disk capacity increase after I delete content from tables in a TencentDB for MariaDB instance?
Data deletion does not release available physical capacity (similar to other databases). You can use Percona Toolkit to perform the alter table xxxx engine=innodb operation on the desired table.
The download link for a TencentDB for MariaDB instance is valid for only 15 minutes. What can I do if there is a high volume of data that cannot be fully downloaded within 15 minutes?
To ensure security of the download link, the URL is valid for only 15 minutes; however, if the download has already started, the connection will remain valid throughout the download (a copied URL will be invalid).
Why does the available cache capacity keep decreasing even to 0 or –1?
The actual available space in the Innodb_buffer is collected. As databases typically use the LRU scheduling scheme, this value will tend to be close to 0 under normal circumstances, and there is no need to worry. Please prioritize checking if the cache hit rate is too low, such as below 90%.
During large transactions, this value may be negative, indicating that the database memory usage exceeds the actual allocated value. This is because, to ensure the smooth operation of your business, we have reserved some extra memory in the physical space, allowing for occasional overuse.
Can I change the previously configured character set and the number of bytes during initialization of a TencentDB for MariaDB instance?
The character set can be modified in the parameter settings by changing the character_set_server or by specifying the character set when creating a table. To modify the innodb_page_size parameter, you need to submit a ticket (reinstall the instance).
What will happen if the number of connections to a TencentDB for MariaDB instance is too large? Or how do I avoid the problem where new business requests cannot properly connect to the database?
The default maximum number of connections for TencentDB for MariaDB (TDSQL) client is 4096. When this limit is reached, new connections will be rejected. Please check the monitoring metrics: Active Connection Count and Connection Utilization. You can analyze the situation based on the following scenarios:
If the client is a short connection application, please check whether there are unclosed connections (in this case, the number of active connections usually increases linearly to 4,096). If metrics such as number of query requests increase drastically at the same time, please check whether there is a sudden increase in the number of requests.
If the client is a persistent connection application, please check the number of connections in all connection pools to the instance. If the connection utilization in monitoring metrics is low, the number of connections to a connection pool is too large.
How can I verify that read/write separation has been performed on the replica server in a TencentDB for MariaDB instance?
You can check the number of (SELECT) queries on the replica server through the corresponding monitoring metric in the console. If read/write separation is enabled, this value will be greater than 0.
What are the differences between the aggregated data, master node data, and replica node data in MariaDB monitoring? Why are some monitoring values significantly different?
The aggregated data is the aggregation of all monitoring data of the entire instance and may be the sum of values of all primary nodes, or all primary and replica nodes.
Primary and replica node data is data of a single node; therefore, the values are certainly different.
What should I do if my TencentDB for MariaDB instance expires?
For details on MariaDB expiration reminders, see Arrears Notice.
