Problem description When you use DMS to export data to an apsaradb RDS for MySQL instance,the following error message is displayed.The MySQL server has been disconnected due to the long execution time.In this case,adjust ...
Overview This topic describes how to view the locks of MySQL databases.Procedure Alibaba Cloud reminds you that:Before you perform operations that may cause risks,such as modifying instance configurations or data,we ...
Overview This topic describes how to export slow MySQL log data to a local disk.Detail Alibaba Cloud reminds you that:Before you perform operations that may cause risks,such as modifying instance configurations or data,we ...
Check whether there are too many sessions.If there are too many idle sessions,evaluate whether the setting of the number of idle sessions is reasonable.For more information about how to check the Session value,see MySQL ...
Problem description When you create a table in an apsaradb RDS for MySQL instance,the following error occurs.ERROR 1118(42000):Row size too large.The maximum row size for the used table type,not counting BLOBs,is 65535....
Overview When apsaradb for MySQL is used,a Waiting for an event from Coordinator thread is detected in the session.Detail Alibaba Cloud reminds you that:Before you perform operations that may cause risks,such as modifying ...
Overview MySQL performs schema changes(such as adding fields,modifying field attributes,adding indexes,and modifying indexes)when a large amount of data is processed.The risk of locking tables must be considered because ...
Problem description When you execute the create table XXX select XXX SQL statement in apsaradb for MySQL to create a table and copy the old table data,the following error occurs.1786-Statement violates GTID consistency:...
问题描述 MySQL读取binlog文件报错：File is not a binary log file 解决方案 在RDS控制台 备份恢复 日志备份（如截图），下载要读取的binlog到本地，在本地解析 问题原因 mysqlbinlog命令去解析的文件必须是show binary logs 里面可获取到...
3）主实例的大事务 在只读实例出现大事务导致延迟时，登录数据库，执行以下SQL语句，确认Seconds_Behind_Master不断变化，而Exec_Master_Log_Pos却保持不变，说明只读实例的SQL线程在执行一个大事务或者DDL操作。然后通过 show processlist...
Description A replication delay exists between the apsaradb RDS for MySQL moderator instance and its read-only instance.Causes Cause 1:you have executed DDL statements that involve large amounts of data.DDL statements that...
such as CPU,I/O,IPC,and SWAP,during the execution of an SQL statement.Usage of Profiling The following content shows the basic usage of Profiling in MySQL.For more information,see MySQL official documentation.Step 1:enable...
问题描述 RDS MySQL一键上传binlog，日志空间没有变化，实例一直处于锁定状态 解决方案 1、实例锁定后，允许删除数据，如果有可以清理的数据，可以直接truncate\drop掉，会快速释放出空间。2、如果不能清理数据，建议考虑扩容磁盘。3、如果...
Overview This topic describes how to read/write splitting to apsaradb RDS for MySQL instances.Detail The MySQL instance read/write splitting involves the following knowledge points.Transactions and stored procedure are ...
问题描述 MySQL8.0 使用asText函数报错，ERROR 1305（42000)：FUNCTION db_name.asText does not exist 解决方案 asText()在MySQL8.0已经弃用，使用 ST_AsText()函数替代，如 select ST_asText(字段名)from 表名;适用范围：MySQL 8.0
we recommend that you check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.If you modify the configuration and data of an instance(including but not limited to ECS and RDS),...
Problem description The number of connections to an ApsaraDB RDS for MySQL instance reaches the upper limit,and clients cannot connect to the RDS instance.Causes A large number of idle connections exist.A large number of ...
Problem description The storage capacity of your ApsaraDB RDS for MySQL instance is exhausted by temporary files.As a result,the RDS instance enters the Locked state.Causes A large number of temporary files are written to ...
see Change the specifications of an ApsaraDB RDS for MySQL instance.If you cannot expand the storage capacity of your RDS instance,resolve the issue based on the major engine version of your RDS instance:If your RDS ...
Problem description After I execute the select*from performance_schema.threads statement on my RDS instance,an empty result is returned.Causes By default,performance_schema is set to OFF for your RDS instance.If the value ...
This topic describes the causes and solutions for the latency during data replication between a primary ApsaraDB RDS for MySQL instance and its read-only RDS instances.Problem description Read-only RDS instances use the ...
Problem description The IOPS usage of an ApsaraDB RDS for MySQL instance is high.Causes A large amount of physical I/O is generated because the memory capacity of the RDS instance cannot meet the requirements of data ...
If an ApsaraDB RDS for MySQL instance is automatically locked when the storage capacity is exhausted by system files,especially the undo file,you can follow the instructions in this topic to unlock the RDS instance and ...
If an ApsaraDB RDS for MySQL instance is automatically locked when the storage capacity is exhausted by system files,especially the undo file,you can follow the instructions in this topic to unlock the RDS instance and ...
your RDS instance is automatically locked to prevent data loss.In this case,you cannot write data to your RDS instance.Solutions Prerequisites If your RDS instance runs MySQL 5.5,MySQL 5.6,MySQL 5.7,or MySQL 8.0,you must ...
your RDS instance is automatically locked to prevent data loss.In this case,you cannot write data to your RDS instance.Solutions Prerequisites If your RDS instance runs MySQL 5.5,MySQL 5.6,MySQL 5.7,or MySQL 8.0,you must ...
If you do not delete the data files on your ApsaraDB RDS for MySQL instance for a long period of time,the storage capacity of the RDS instance may be exhausted.As a result,your RDS instance is automatically locked to ...
Problem description When I replicate data from a primary ApsaraDB RDS for MySQL instance to its secondary or read-only RDS instance,the replication is interrupted and the following error message is displayed:[ERROR][MY-...
If you do not delete the data files on your ApsaraDB RDS for MySQL instance for a long period of time,the storage capacity of the RDS instance may be exhausted.As a result,your RDS instance is automatically locked to ...
Problem description When I replicate data from a primary ApsaraDB RDS for MySQL instance to its secondary or read-only RDS instance,the replication is interrupted and the following error message is displayed:[ERROR][MY-...
767 bytes/4 bytes per character≈191 characters.If you create an index on a field of the varchar(255)or char(255)type,the index creation fails.For more information,see the MySQL documentation at the official MySQL website....
问题描述 Quick BI中接入亚马逊云平台的MySQL数据库报“数据源连通性异常，请检查参数是否正确，错误信息:XXX:ECS only support IP address”。问题原因 创建"自建数据源"时MySQL有安全问题，Quick BI产品做了特殊校验。因此接入MySQL时，...
If the storage capacity of your ApsaraDB RDS for MySQL instance is exhausted due to issues such as slow SQL queries and a large amount of inserted data,the system automatically locks the RDS instance to prevent data loss....
When the disk space of an ApsaraDB RDS for MySQL instance is exhausted because of issues such as slow SQL statements or excessive data insertion,the system automatically locks the instance to prevent data loss.The instance...
Problem description The following error is reported in ApsaraDB RDS for MySQL:ERROR 1205(HY000):Lock wait timeout exceeded;try restarting transaction The query result of the information_schema.innodb_trx table shows that a...
Problem description I fail to perform a full physical backup on my ApsaraDB RDS instance that runs MySQL 8.0.31.MySQL 8.0.31 is equivalent to version 20230630 of AliSQL.Causes INSTANT ADD/DROP COLUMNS is introduced in ...
Problem description I fail to perform a full physical backup on my ApsaraDB RDS instance that runs MySQL 8.0.31.MySQL 8.0.31 is equivalent to version 20230630 of AliSQL.Causes INSTANT ADD/DROP COLUMNS is introduced in ...
Solution 2:Use the privileged account and the MySQL command line to change the value of host of a database account to%and then authorize or delete the account in the ApsaraDB RDS console.UPDATE mysql.user SET host='%' ...
Problem description When a session waits for a row exclusive lock that is held by another session,a row lock wait occurs.If the row lock wait times out,the following error is reported:ERROR 1205(HY000):Lock wait timeout ...
This topic describes the causes and solutions for the latency during data replication between a primary ApsaraDB RDS for MySQL instance and its read-only RDS instances.Problem description Read-only RDS instances use the ...