MySQL Forums
Forum List  »  General

Re: coufused about ibtmp1
Posted by: victor victor
Date: September 03, 2025 01:41AM

i have a test in mysql 8.4.
when i create temporary table, the modified time of #innodb_temp/temp_10.ibt changes, and when i update/delete/insert data , both the modified time of #innodb_temp/temp_10.ibt and ibtmp1 change.
so , ibtmp1 is just undo tbs for user define temp table.

Options: ReplyQuote


Subject
Written By
Posted
August 13, 2025 11:23PM
Re: coufused about ibtmp1
September 03, 2025 01:41AM
November 13, 2025 04:37AM
November 14, 2025 12:34AM
November 20, 2025 02:22PM


This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.