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 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:


aurora max connection limit small 45


aurora max connection limit medium 90


aurora max connection limit large 1000


aurora max connection limit xlarge 2000


aurora max connection limit 2xlarge 3000


aurora max connection limit 4xlarge 4000


aurora max connection limit 8xlarge 5000

Views :205

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 🙂


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

Views :240292
Categories: mysql Tags: , ,
46 queries in 0.144 seconds