My team and I are attempting to upgrade our multi-tenancy AWS RDS/MySQL instance from MySQL 5.7 to 8. After trying the upgrade, we received a report showing a large number of errors for the customers, and lineitems tables. Example Errors…
Is it possible to get aws rds version? I know for Aws rds Aurora version select aurora_version(); aurora_version ---------------- 16.3.0 (1 row) select version(); version ------------------------------------------------------------------------------------------------------------- PostgreSQL 16.3 on aarch64-unknown-linux-gnu, compiled by aarch64-unknown-linux-gnu-gcc (GCC) 9.5.0, 64-bit (1 row) SHOW server_version…
We are find a specific query running very very slow if the LIMIT value is larger than the number of returned rows. We are running MySQL on RDS - 8.0.mysql_aurora.3.02.0 and have no other performance issues. Example 1 - query…
IMMUTABLE indicates that the function cannot modify the database and always returns the same result when given the same argument values; that is, it does not do database lookups or otherwise use information not directly present in its argument list.…
setup: aws rds mysql aurora Our DB has a writer and a reader instances. If we use the reader instance(which has a separate CPU) will large read requests have any affect on the Database that the Writer instance is connecting…
I expected the function call "expensive" to be called only once, but it appears to be called for every row in "children". Can the CTE/query be tweaked to only call the function once and have that value returned for every…
Database aggregation is usually much faster than returning all the data to the application and calculating there. But for this partitioned table, a simple one-column AVG() query runs in 15 seconds, while returning all the rows to the application runs…
I'm currently using AWS Aurora Mysql(ServerlessV2). Engine version: Aurora MySQL 3.04.0 (compatible with MySQL 8.0.28) I have table like below: CREATE TABLE "Test" ( "key1" varchar(37) NOT NULL, "key2" varchar(50) NOT NULL, "key3" varchar(20) NOT NULL, "createdDate" timestamp(3) NOT NULL,…
I have an postgres table in the below structure I want to write a query which will Delete all the records from the table which are older than 90 days and is in COMPLETE status. if any row has a…
We are using AWS Aurora MySQL(8.0.mysql_aurora.3.04.0) InnoDB engine with large instance(16GB RAM). One particular “SELECT” query running against one large table (250GB - not partitioned) in the "reader" instance which does some calculations including min,max,window functions, group by, etc. This…