Archive

Posts Tagged ‘mysql’

AWS RDS Aurora max_connections limit

February 15th, 2018 No comments

For our office products, we are using Amazon Cloud. For the database, we prefer to use Amazon RDS (Aurora). Recently one of our sites was showing lots of error message in sentry.io. The error log shows it was because of MySQL denied to connect for too many open connections. This is when we checked the RDS max_connection limit and found its related to the size of your RDS instance. So we tested the max_connection limit for different size instances. And here is the result:

t2.small:

aurora max connection limit small 45

t2.medium:

aurora max connection limit medium 90

r3.large:

aurora max connection limit large 1000

r3.xlarge:

aurora max connection limit xlarge 2000

r3.2xlarge:

aurora max connection limit 2xlarge 3000

r3.4xlarge:

aurora max connection limit 4xlarge 4000

r3.8xlarge:

aurora max connection limit 8xlarge 5000

Database table repair

August 12th, 2007 4 comments

Few minutes ago, one of our mysql database table (it’s really a big table) was crashed.
So to repair this i login that server and excute

repair table tablename

But the repair process failed, and i got this output.

test.t1 | repair | error | 13 when fixing table |
| test.t1 | repair | status | Operation failed |

Then i start searching on google. After passing some time i found the reason. Mysql can’t repair that table as there is a trigger on this table. So i tried to drop the trigger

drop trigger triggername

no luck, mysql can’t drop the trigger, as the table was crashed 🙁

Now i studied more and more. At last i got the solution 🙂

REPAIR TABLE tablename USE_FRM

Now the table repair complete successfully. Thanks to Allah as i got the solution in time:)

Categories: mysql Tags: , ,
59 queries in 0.111 seconds