about Undo Tablespace used High ?

博客提及Undo表空间使用过高的情况,但未给出具体解决办法等更多信息,仅给出原文地址。Undo表空间使用过高可能影响数据库性能。
2025-10-24T06:14:45.483589Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2025-10-24T06:14:45.487190Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.43-log) starting as process 2792 ... 2025-10-24T06:14:45.499521Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2025-10-24T06:14:45.500924Z 0 [Note] InnoDB: Uses event mutexes 2025-10-24T06:14:45.501775Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2025-10-24T06:14:45.503093Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2025-10-24T06:14:45.509869Z 0 [Note] InnoDB: Number of pools: 1 2025-10-24T06:14:45.510876Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2025-10-24T06:14:45.516358Z 0 [Note] InnoDB: Initializing buffer pool, total size = 4G, instances = 8, chunk size = 128M 2025-10-24T06:14:45.739511Z 0 [Note] InnoDB: Completed initialization of buffer pool 2025-10-24T06:14:45.866688Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2025-10-24T06:14:45.917325Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1818072334033 2025-10-24T06:14:45.919665Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 1818072343203 2025-10-24T06:14:46.501026Z 0 [Note] InnoDB: Database was not shutdown normally! 2025-10-24T06:14:46.502853Z 0 [Note] InnoDB: Starting crash recovery. 2025-10-24T06:14:53.325953Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2025-10-24T06:14:53.328050Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2025-10-24T06:14:53.331419Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2025-10-24T06:14:53.341449Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2025-10-24T06:14:53.377635Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2025-10-24T06:14:53.379973Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2025-10-24T06:14:53.382232Z 0 [Note] InnoDB: Waiting for purge to start 2025-10-24T06:14:53.434201Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7651ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) 2025-10-24T06:14:53.434424Z 0 [Note] InnoDB: 5.7.43 started; log sequence number 1818072343203 2025-10-24T06:14:53.440369Z 0 [ERROR] InnoDB: Page [page id: space=26, page number=3] log sequence number 1818075015616 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.440496Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\MySql\data\ib_buffer_pool 2025-10-24T06:14:53.444882Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.454213Z 0 [ERROR] InnoDB: Page [page id: space=26, page number=2] log sequence number 1818075015133 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.457121Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.459265Z 0 [ERROR] InnoDB: Page [page id: space=26, page number=13] log sequence number 1818075023156 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.459333Z 0 [Note] Plugin 'FEDERATED' is disabled. 2025-10-24T06:14:53.461391Z 0 [ERROR] InnoDB: Page [page id: space=26, page number=4] log sequence number 1818074852082 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.464302Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.468966Z 0 [ERROR] InnoDB: Page [page id: space=26, page number=8883] log sequence number 1818075644951 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.469327Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.478059Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.481293Z 0 [ERROR] InnoDB: Page [page id: space=26, page number=5] log sequence number 1818074822726 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.488992Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.493841Z 0 [ERROR] InnoDB: Page [page id: space=26, page number=8] log sequence number 1818073611600 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.496594Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.499300Z 0 [ERROR] InnoDB: Page [page id: space=488, page number=3] log sequence number 1818075769646 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.500195Z 0 [ERROR] InnoDB: Page [page id: space=26, page number=22] log sequence number 1818074006086 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.503793Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.505862Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.513791Z 0 [ERROR] InnoDB: Page [page id: space=26, page number=23] log sequence number 1818074993296 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.515785Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.524243Z 0 [ERROR] InnoDB: Page [page id: space=488, page number=527] log sequence number 1818080514186 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.528019Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.537996Z 0 [ERROR] InnoDB: Page [page id: space=540, page number=7] log sequence number 1818081166468 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.541042Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.543656Z 0 [ERROR] InnoDB: Page [page id: space=26, page number=31] log sequence number 1818075024348 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.548712Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.554624Z 0 [ERROR] InnoDB: Page [page id: space=540, page number=4] log sequence number 1818081150547 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.558427Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.565031Z 0 [ERROR] InnoDB: Page [page id: space=539, page number=4] log sequence number 1818080173025 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.567157Z 0 [ERROR] InnoDB: Page [page id: space=26, page number=31683] log sequence number 1818075654250 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.567489Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.571042Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.598497Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2025-10-24T06:14:53.601463Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2025-10-24T06:14:53.603981Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher. 2025-10-24T06:14:53.605450Z 0 [ERROR] InnoDB: Page [page id: space=743, page number=0] log sequence number 1818074641633 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.606048Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher. 2025-10-24T06:14:53.609638Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. InnoDB: Dump of the tablespace extent descriptor: len 40; hex 0000000000000000ffffffff0000ffffffff000000000002aaffffffffffffffffffffffffffffff; asc ;2025-10-24T06:14:53.618233Z 0 [ERROR] InnoDB: InnoDB is trying to free page [page id: space=743, page number=8] though it is already marked as free in the tablespace! The tablespace free space info is corrupt. You may need to dump your tables and recreate the whole database! 2025-10-24T06:14:53.622034Z 0 [ERROR] [FATAL] InnoDB: Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.624235Z 0 [Warning] CA certificate ca.pem is self signed. 2025-10-24 14:14:53 0x354c InnoDB: Assertion failure in thread 13644 in file ut0ut.cc line 921 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 2025-10-24T06:14:53.625645Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2025-10-24T06:14:53.628676Z 0 [Note] Server hostname (bind-address): '*'; port: 3308 2025-10-24T06:14:53.629979Z 0 [Note] IPv6 is available. 2025-10-24T06:14:53.630668Z 0 [Note] - '::' resolves to '::'; 2025-10-24T06:14:53.632389Z 0 [Note] Server socket created on IP: '::'. 2025-10-24T06:14:53.747077Z 0 [ERROR] InnoDB: Page [page id: space=26, page number=16384] log sequence number 1818075741603 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:53.751073Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:53.924848Z 0 [Note] Failed to start slave threads for channel '' 2025-10-24T06:14:54.002381Z 0 [Note] Event Scheduler: Loaded 0 events 2025-10-24T06:14:54.003266Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections. Version: '5.7.43-log' socket: '' port: 3308 MySQL Community Server (GPL) 2025-10-24T06:14:54.063857Z 0 [ERROR] InnoDB: Page [page id: space=28, page number=0] log sequence number 1818073721575 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:54.067646Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:54.073181Z 0 [ERROR] InnoDB: Page [page id: space=28, page number=4] log sequence number 1818073721575 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:54.076879Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:54.081031Z 0 [ERROR] InnoDB: Page [page id: space=28, page number=5] log sequence number 1818073639109 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:54.083439Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:54.087366Z 0 [ERROR] InnoDB: Page [page id: space=488, page number=0] log sequence number 1818074963526 is in the future! Current system log sequence number 1818072347793. 2025-10-24T06:14:54.089008Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery. 2025-10-24T06:14:54.840960Z 0 [Note] InnoDB: Buffer pool(s) load completed at 251024 14:14:54
10-25
【电动汽车充电站有序充电调度的分散式优化】基于蒙特卡诺和拉格朗日的电动汽车优化调度(分时电价调度)(Matlab代码实现)内容概要:本文介绍了基于蒙特卡洛和拉格朗日方法的电动汽车充电站有序充电调度优化方案,重点在于采用分散式优化策略应对分时电价机制下的充电需求管理。通过构建数学模型,结合不确定性因素如用户充电行为和电网负荷波动,利用蒙特卡洛模拟生成大量场景,并运用拉格朗日松弛法对复杂问题进行分解求解,从而实现全局最优或近似最优的充电调度计划。该方法有效降低了电网峰值负荷压力,提升了充电站运营效率与经济效益,同时兼顾用户充电便利性。 适合人群:具备一定电力系统、优化算法和Matlab编程基础的高校研究生、科研人员及从事智能电网、电动汽车相关领域的工程技术人员。 使用场景及目标:①应用于电动汽车充电站的日常运营管理,优化充电负荷分布;②服务于城市智能交通系统规划,提升电网与交通系统的协同水平;③作为学术研究案例,用于验证分散式优化算法在复杂能源系统中的有效性。 阅读建议:建议读者结合Matlab代码实现部分,深入理解蒙特卡洛模拟与拉格朗日松弛法的具体实施步骤,重点关注场景生成、约束处理与迭代收敛过程,以便在实际项目中灵活应用与改进。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值