All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
1answer
28 views

Mysql row-based binary logging behaving different in some versions of mysql (rows grouping)

Mysql row-based binary logging seems to have a different behaviour when grouping rows changes in some versions of mysql. Let's assume the following statement update three rows: UPDATE table_name ...
1
vote
1answer
50 views

Amazon RDS MySQL Troubleshooting High Sessions

I just migrated my forums application to AWS. I'm in the middle of tweaking things for performance and I noticed that the number of sessions for my RDS instance (t3.large) is consistently exceeding 2....
4
votes
6answers
640 views

MySQL join has drastically worse performance after upgrading from 5.6 to 5.7

I have a fairly straightforward query that has become very slow after upgrading from MySQL 5.6.35 to MySQL 5.7.12 (running on AWS RDS). SELECT DISTINCT Name,d.id,deviceType,issuedBy, description,...
0
votes
0answers
15 views

Does it require to change date values of tables while changing the database timezone

Currently, I am using the rds with timezone UTC. While changing the timezone from UTC to EST, How could i convert the values of date field of all tables of database in EST?
0
votes
1answer
71 views

Why are my InnoDB tables larger than calculated?

I have a DB where some of the tables are much larger than I think that they should be. For 23 of 39 tables the following query overestimates their size, as it is designed to. But for 16 tables my ...
1
vote
1answer
534 views

What is the optimal setting for innodb_buffer_pool_instances for a mid level AWS RDS server with 6gb buffer pool?

We have a MySQL 5.7 AWS RDS instance running on a db.m4.large instance. The basic resources for that instance type are: 7.5gb RAM 2 VCPU RDS defaults to a calculation that allocates 75% of RAM to ...
1
vote
2answers
2k views

enabling BINARY LOG on AWS RDS MySQL

Context I am trying to enable BINARY LOGs on a MySQL RDS instance. Issue I used CALL mysql.rds_set_configuration('binlog retention hours', 24) without encountering an error. And using CALL mysql....
0
votes
2answers
359 views

MySQL query optimization not using index

I'm running into an issue with my MySQL database and I would like to know if any of you could please shed some light. Background: I currently have entire schema configured with InnoDB. This database ...
2
votes
2answers
123 views

How should I model a database structure to retain calculation results?

I am trying to improve the performance of the queries related to one table that I consider "weird", which could be created by the next script: CREATE TABLE `CalcTable` ( `id` int(11) NOT NULL ...
4
votes
2answers
3k views

MySQL commits taking time

We are facing an issue, where at certain times there are number of commits that takes a more than a second. The time interval for this is not fixed. Our application sends thousands of commits but at ...
1
vote
2answers
1k views

PURGE BINARY LOGS taking time

We are observing high latency for some queries, digging further we found that every 5 minutes the queries take long time by examining the slow query logs. We observed that PURGE BINARY LOGS TO '...
0
votes
1answer
39 views

I have an instance of RDS of MySQL 5.7.10

I do not understand why memory bar seems to exceed to the red zone with 24.5 MB while RDS server should be with 1Gib
4
votes
1answer
1k views

“Cannot resolve table name” error when applying MySQL dump to RDS

I'm setting up replication of an external MySQL instance to RDS. Both the external MySQL instance and RDS run MySQL 5.7.10. I've followed the procedure, but when dumping the database with mysqldump ...