问题描述 RDS MySQL一键上传binlog，日志空间没有变化，实例一直处于锁定状态 解决方案 1、实例锁定后，允许删除数据，如果有可以清理的数据，可以直接truncate\drop掉，会快速释放出空间。2、如果不能清理数据，建议考虑扩容磁盘。3、如果...
Note:The table file size is not displayed in mysql.slow_log log files.If the disk space usage of the instance greatly differs from the query script,you can run the following SQL statement and then check the disk space ...
Overview If you use the read/write splitting function of apsaradb RDS for MySQL,and a query statement is routed to the primary instance,the QPS of the primary instance is higher than that of the read-only instances,see to ...
Problem description RDS MySQL 8.0"/tmp/sql1a324_1 f4 a_8b' is full"error occurs.Solution Alibaba Cloud reminds you that:Before you perform operations that may cause risks,such as modifying instance configurations or data,...
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 ...
Issue After you connect to the MySQL database through the client,the database returns the following message.Too many connections Cause The possible causes are listed as follows:The database performance does not meet ...
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 ...
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 ...
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 ...
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 ...
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 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:...
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...
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 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 ...
Description When you connect to an ApsaraDB RDS for MySQL instance or an ApsaraDB RDS for MariaDB instance,the system displays one of the following error messages:ERROR 2005(HY000):Unknown MySQL server host 'xxxxxxx'(110 ...
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 ...
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....
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 ...
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 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 ...
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 ...
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 ...
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 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 ...
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 ...
GROUP BY,ORDER BY,DISTINCT,UNION,update on multiple tables,subqueries,and table joins.This also applies if you call the group_concat and count(distinct)functions.MySQL creates temporary tables for the MEMORY storage engine...
GROUP BY,ORDER BY,DISTINCT,UNION,update on multiple tables,subqueries,and table joins.This also applies if you call the group_concat and count(distinct)functions.MySQL creates temporary tables for the MEMORY storage engine...
Description When you connect to an ApsaraDB RDS for MySQL instance or an ApsaraDB RDS for MariaDB instance,one of the following error messages is displayed:ERROR 2003(HY000):Can't connect to MySQL server on 'XXX'(10038,...
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 ...
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 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 When I use my ApsaraDB RDS for MySQL instance or ApsaraDB RDS for MariaDB instance,the CPU utilization is excessively high and even reaches 100%.Causes When an application submits query or modification ...
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 ...
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...