MySQL purge 清理undo
如果history length 比較大，在purge的時候會導致髒頁增多，purge的堆疊如下
mysqld!trx_undo_truncate_start(trx_rseg_t*, unsigned long, unsigned long, unsigned long long) (/Users/xiaoyu.bai/Downloads/mysql-5.7.29/storage/innobase/trx/trx0undo.cc:1191) mysqld!trx_purge_truncate_rseg_history(trx_rseg_t*, purge_iter_t const*) (/Users/xiaoyu.bai/Downloads/mysql-5.7.29/storage/innobase/trx/trx0purge.cc:582) mysqld!trx_purge_truncate_history(purge_iter_t*, ReadView const*) (/Users/xiaoyu.bai/Downloads/mysql-5.7.29/storage/innobase/trx/trx0purge.cc:1233) mysqld!trx_purge_truncate() (/Users/xiaoyu.bai/Downloads/mysql-5.7.29/storage/innobase/trx/trx0purge.cc:1816) mysqld!trx_purge(unsigned long, unsigned long, bool) (Unknown Source:0) mysqld!srv_do_purge(unsigned long, unsigned long*) (/Users/xiaoyu.bai/Downloads/mysql-5.7.29/storage/innobase/srv/srv0srv.cc:2636) mysqld!::srv_purge_coordinator_thread(void *) (/Users/xiaoyu.bai/Downloads/mysql-5.7.29/storage/innobase/srv/srv0srv.cc:2809) libsystem_pthread.dylib!_pthread_start (Unknown Source:0) libsystem_pthread.dylib!thread_start (Unknown Source:0)
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/25719946/viewspace-2912669/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- InnoDB purge原理--哪些undo log可purge
- MySQL中undo log介紹及清理MySql
- MySQL undoMySql
- MySQL 5.5 -- innodb_purge_threadsMySqlthread
- mysql undo管理MySql
- MySQL：Innodb purge執行緒略解MySql執行緒
- dbms_shared_pool.purge 清理某個SQL執行計劃SQL
- PURGE MASTER LOGS語法--MySql資料庫ASTMySql資料庫
- MySQL 日誌 undo | redoMySql
- mysql清理日誌MySql
- 深入理解MYSQL undo redoMySql
- mysql 查詢undo空間MySql
- Oracle Recyclebin - purgeOracle
- MySQL redo與undo日誌解析MySql
- MySQL InnoDB Undo表空間配置MySql
- MySQL 配置InnoDB清理排程MySql
- mysql清理binlog的方法MySql
- MySQL中的redo log和undo logMySql
- MySQL Undo Log和Redo Log介紹MySql
- mysql簡單的碎片清理指令碼MySql指令碼
- How to purge the Oracle Database Recycle BinOracleDatabase
- 淺析MySQL事務中的redo與undoMySql
- MySQL UNDO表空間獨立和截斷MySql
- 9i客戶端無法“直接”使用purge recyclebin命令清理10g資料庫回收站資訊客戶端資料庫
- MySQL必知必會：簡介undo log、truncate、以及undo log如何幫你回滾事物MySql
- mysql主庫清理資料，從庫保留MySql
- 還不懂mysql的undo log和mvcc？算我輸！MySqlMVC
- 【Mysql】三大日誌 redo log、bin log、undo logMySql
- innodb_undo_tablespaces導致Mysql啟動報錯MySql
- Oracle Drop表(purge)恢復(ODU)Oracle
- Oracle Purge和drop的區別Oracle
- MySQL資料清理的需求分析和改進MySql
- MySQL 5.7新特性之線上收縮undo表空間MySql
- 【MySQL】undo,redo,2PC,恢復思維導圖MySql
- php頁面呼叫purge介面清除nginxcachePHPNginx
- Nginx系列教程：ngx_cache_purge模組Nginx
- DROP TABLE ** CASCADE CONSTRAINTS PURGEAI
- Purge Old Mongo Logs without User InterventionGo