<transcript><audio_301>effectively the right ahead buffer pool is typically pretty small it might just have a small number of pages so you need at least two but it might have a few hundred and everything's going to get flushed from top to bottom and that'll become more clear when we talk about the</transcript><transcript><audio_302>recovery protocol in the next class okay so it's a sequential file little bit different than the other files but it has a buffer pool so that when log records are created they get created in the buffer pool so transaction T1 started has a begin now T1 is getting</transcript><transcript><audio_303>written so that transaction is recording your old value was one new value is eight uh sorry old value is eight new value is one and so that's why that record has t a one and eight because eight was the old value so now in the log record I'm keeping track of my old</transcript><transcript><audio_304>and new value okay and you can as we just talked about you can optimize that stuff if you're in mbcc uh and now B got written again I've got old and new value when I write when the transaction is ready to commit even</transcript><transcript><audio_305>though that log buffer pool page is not full for that right ahead blog file I will flush that half full page to disk before I can declare commit when that page comes back with a okay the page was written the</transcript> effectively the right ahead buffer pool is typically pretty small it might just have a small number of pages so you need at least two but it might have a few hundred and everything's going to get flushed from top to bottom and that'll become more clear when we talk about the recovery protocol in the next class okay so it's a sequential file little bit different than the other files but it has a buffer pool so that when log records are created they get created in the buffer pool so transaction T1 started has a begin now T1 is getting written so that transaction is recording your old value was one new value is eight uh sorry old value is eight new value is one and so that's why that record has t a one and eight because eight was the old value so now in the log record I'm keeping track of my old and new value okay and you can as we just talked about you can optimize that stuff if you're in mbcc uh and now B got written again I've got old and new value when I write when the transaction is ready to commit even though that log buffer pool page is not full for that right ahead blog file I will flush that half full page to disk before I can declare commit when that page comes back with a okay the page was written the
{"source": "grass-yt-cc-by.-mY8ALcJVTk|shard_1_1|create_multimodal_data.extract_yt_and_generate_transcripts.62|shard_1|create_multimodal_data.generate_captions.62|shard_1|create_multimodal_data.generate_captions.62", "params": {"id": "-mY8ALcJVTk", "channel_id": "UCHnBsf2rH-K7pn09rb3qvkA", "duration": 5000, "view_count": 4483, "age_limit": 0, "like_count": 50, "channel_follower_count": 71100, "license": "Creative Commons Attribution license (reuse allowed)", "uploader_id": "@CMUDatabaseGroup", "yt_tar_file": "/leonardo_work/EUHPC_E03_068/audio/fixed_download/grass-yt-cc-by//shard_1/-mY8ALcJVTk.tar.gz"}}