All Questions

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

Maintaining a production big table

I have a very large table: Table1 in a production environment which I need to alter a column in. What's the best preferred way to do so without down time? Option 1: CREATE TABLE Table1_new LIKE ...
0
votes
0answers
48 views

Which MySQL settings are the closest equivalent to RDS' “Queue depth”?

I'm trying to find out which MySQL status variables can be used to get as close as possible to the RDS value of "Queue depth". On a test system, I reckon that %pending% variables may be at least a ...
0
votes
1answer
80 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
692 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
511 views

MySQL tuning: INNODB_BUFFER_POOL_SIZE not found?

My replicator MySQL db, hosted by Amazon-RDS-Aurora is performing poorly. The DB is quite powerful so performance shouldn't be an issue. When I executed SHOW VARIABLES; I could not find ...
0
votes
1answer
73 views

Simple Query intermittently returning 0 results

I'm having a strange problem and need help troubleshooting. if I run this query on my gallery table: SELECT * FROM `gallery` WHERE awarded = 1 ORDER BY awarded_date DESC LIMIT 29 OFFSET ...
3
votes
3answers
4k views

What can cause a rapid drop in RDS MySQL Database free storage space?

How could my MySQL database on Amazon RDS have recently gone from 10.5 GB free to "storage-full" status within about 1.5 hours? It's a 15GB MySQL 5.6.27 database running on a db.t2.micro instance. ...
3
votes
2answers
725 views

AWS RDS Really Odd Error… #1041 OUT OF MEMORY, Buffers OK and Memory OK

I have an AWS RDS (MySQL 5.6.35) db.m3.medium that has given me a random error when attempting to modify a table's structure in the past two weeks: #1041 - Out of memory; check if mysqld or some ...
1
vote
2answers
617 views

AWS RDS Post Optimisation after a huge delete

I'm using AWS RDS MySQL. All the tables are in InnoDB and enable innoDB_file_per_table. One of my logging tables is growing too fast. I'd like to remove older than 1-week data. Even 1 week of data ...
1
vote
3answers
141 views

How can I copy a subset of columns from one InnoDB table to another, without locking?

I have a MySQL instance running on Amazon's RDS. This means that I cannot change any of the binlog settings. I have a table source, created like this, which contains around 2 billion rows: CREATE ...
1
vote
1answer
1k views

Randomly slow inserts with InnoDB

TL;DR : How can I improve insertion time in my table so that every inserts take under 100ms to perform? This table is used by a webservice which receives transactions one by one so I can't group ...
1
vote
0answers
48 views

Can MyISAM tables affect the backup recovery of innodb tables on Amazon RDS?

I have an Amazon RDS instance containing several databases. All the tables are innnodb except from one, that is MyISAM and currently cannot be converted to innodb. I know that the recovery of MyISAM ...
0
votes
1answer
688 views

Preventing MySQL index corruption

I'm having a recurring issue with a MySQL database where one index in particular has been getting corrupted. Originally I saw a corruption event about every 2-3 weeks and this week I've seen it happen ...
0
votes
1answer
2k views

Why Write IOPS,Write throughput,Queue depth decreased on AWS/RDS after changing innodb_flush_log_at_trx_commit and sync_binlog?

I changed values for my Mysql parameters 1. innodb_flush_log_at_trx_commit=2(before it was 1) 2. sync_binlog=0(before it was 1) This has changed some of my parameters on AW RDS drastically ,here ...
1
vote
2answers
175 views

Why database size is smaller in RDS

I am trying to move my database from MySQL to RDS MySQL. I do a simple mysqldump to transfer. I use this query: SELECT TABLE_NAME, table_rows, data_length, index_length, round(((data_length + ...
1
vote
1answer
837 views

RDS innodb_flush_log_at_trx_commit problem

I use Amazon RDS as mysql db backend for highload project and try to optimize insert performance for innodb tables. According to information from different sources - good candidate to speed up inserts ...
4
votes
2answers
849 views

Is it safe to delete the innodb schema on a new Amazon RDS instance?

As per the title, I'm struggling to find out if it's safe to delete the innodb schema that's created on a fresh Amazon RDS instance. mysql> SHOW DATABASES; +--------------------+ | Database ...
5
votes
1answer
8k views

MySQL RDS Instance eating up memory and swapping

I have an issue with memory on a RDS instance which is of db.m2.4xlarge class. Below are the specifications of the RDS instance Instance Class: db.m2.4xlarge ( 68.4 GB of RAM ) Engine: ...
4
votes
1answer
10k views

Aborted connection (Got an error reading communication packets) MySQL on Amazon RDS

I'm getting the following warning in MySQL: Aborted connection (Got an error reading communication packets) I'm using Amazon RDS for MySQL hosting. Both MyISAM and InnoDB storage engines are used (...
3
votes
3answers
12k views

How to decide whether to enable MySQL query cache using InnoDB

How should the decision to enable / disable the MySQL query cache be made, on a server that uses just InnoDB tables. Say for example, if the cache is enabled, then how should the output of: SHOW ...
5
votes
1answer
757 views

RDS MYSQL instance rebooted and won't load INNODB table

So my production db in RDS apparently either crashed or was rebooted during a version update, and upon being restarted mysql couldn't load one of the innodb tables: as evidenced by the following error ...
1
vote
1answer
3k views

I have delete database from mysql but storage is not freed

I have deleted multiple databases (schema) from mysql on amazon RDS but the storage is not freed, is there anything else I should do to free up the storage? I have a mysql database that the total ...
5
votes
1answer
2k views

AWS RDS showing large growth in Write Ops/sec, despite low # DB connections?

I have a Multi-AZ AWS RDS instance running MYSQL 5.5 I've noticed that my write ops/sec are growing fairly rapidly, despite low (and sometimes zero) DB connections - see charts for Avg write ops/sec ...
1
vote
1answer
1k views

What happens when the index size of my Mysql instance exceeds the innodb_buffer_pool_size?

I am using Amazon's RDS db.m1.small. innodb_buffer_pool_size is set to 1125.00 MB. Current index size is 1110.00 MB and growing slowly but steadily. I do not need more hard drive space. I want ...
0
votes
1answer
3k views

Large INSERTs performance optimization

I have 15 Amazon AWS EC2 t1.micro instances which simultaneously populate Amazon RDS MySQL d2.m2.xlarge database with data using large INSERTs (40000 rows in query). The queries are sent continuously....
2
votes
1answer
4k views

MySQL 5.5 Runs Out of Memory, Drops All Connections When Creating Many Databases

I'm running into a problem when I create a large number of databases consecutively on an Amazon RDS db.m1.large instance. The MySQL Engine Version is 5.5.23. At some point, the RDS instance drops all ...
9
votes
1answer
16k views

Amazon RDS MySQL 5.5 Innodb Lock wait timeout exceeded

Ever since we've moved to Amazon RDS, we've had some pretty crazy performance issues, and today we started having locking issues. Because of that, I figured it was just a timeout issue, and went to ...
5
votes
3answers
7k views

Cannot write to mysql database while select query in process

Running Mysql 5.1.57 on InnoDB, and have a database locking issue. I have two separate sessions connected to a single database MySQL. On the first session, I run a long SELECT query (technically a ...
2
votes
1answer
1k views

innodb_flush settings on Amazon RDS

Setting innodb_flush_log_at_trx_commit = 2 improves my application performance considerably on my local development environment. The response time and number of requests per second on a 40 concurrent ...