TencentDB disables the ping operation by default.
You can use Telnet to check connectivity if needed.
Please use the latest version for connection.
binlog dump
of TencentDB for MariaDB?It is a normal master/slave sync thread, which is resident.
Multi-thread download is not supported. You can use the wget --content-disposition
command for download.
The TencentDB Console supports most common database parameters and sets security thresholds for them. If a parameter to be modified does not exist or cannot be modified to a specific value, please submit a ticket for assistance.
SELECT INTO OUTFILE
or ./mysqldump
on a TencentDB for MariaDB instance to export files locally?Files cannot be written to instance server directories.
SELECT FOR UPDATE
on a TencentDB for MariaDB instance?Some SQL statements do not support read/write separation. SELECT FOR UPDATE
is a write operation and will cause an error.
You can enter the instance details page in the TencentDB for MariaDB Console and select "Performance Optimization" > "Slow Query Analysis" to specifically analyze the slow queries.
Possible reasons include:
XA_RBTIMEOUT
error on a TencentDB for MariaDB instance?It is possible that a large transaction has generated a super-large binlog. You are recommended to add an auto-increment field to the required tables.
Was this page helpful?