TencentDB disables the ping operation by default.
You can use Telnet to check connectivity if needed.
Please use the latest version for connection.
binlog dumpof 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 OUTFILEor
./mysqldumpon a TencentDB for MariaDB instance to export files locally?
Files cannot be written to instance server directories.
SELECT FOR UPDATEon 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_RBTIMEOUTerror 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.