What are the effects of Mysql long transactions

This article mainly shows you "what are the effects of Mysql long affairs". The content is simple and clear. I hope it can help you solve your doubts. Let me lead you to study and learn this article "what are the effects of Mysql long affairs".

1. Long transactions mean that there will be a very old transaction view in the system. Before committing this transaction, you should keep a rollback record, which will result in a large amount of storage space.

2. Long transactions will also take up lock resources and may drag down the database.

Example

SELECT ps.id 'PROCESS ID', ps.USER, ps.HOST, esh.EVENT_ID, trx.trx_started, esh.event_name' EVENT NAME', esh.sql_text 'SQL' Ps.timeFROM performance_schema.events_statements_history esh JOIN performance_schema.threads th ON esh.thread_id = th.thread_id JOIN information_schema.PROCESSLIST ps ON ps.id = th.processlist_id LEFT JOIN information_schema.innodb_trx trx ON trx.trx_mysql_thread_id = ps.idWHERE trx.trx_id IS NOT NULL AND ps.USER! = 'SYSTEM_USER' AND ps.id = process IDORDER BY esh.EVENT_ID These are all the contents of this article entitled "what is the impact of Mysql's long-term affairs". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!