Amazon RDS MySQL/Aurora查询有时会永远挂起。任何关于度量和方法的2美分我们可以对它进行分类并防止它发生?

Just some contexts: In our old data pipeline system, we are running MySQL 5.6. or Aurora on Amazon rds. Bad thing about our old data pipeline is running a lot of heavy computations on the database servers because we are handcuffed by what was designed: treating transactional databases as data warehouse and our backend API directly “fishing” the databases heavily in our old system. We are currently patching this old data pipeline, while re-design the new data warehouse in SnowFlake.Just some contexts: In our old data pipeline sy