testyahoo

yahoo 相册  时间:2021-02-22  阅读:()
AlternativeConcurrencyControlMethodsR&G-Chapter17RoadmapSofar:Correctnesscriterion:serializabilityLock-basedCCtoenforceserializabilityStrict2PLDeadlocksLockinggranularitiesTreelockingprotocolsPhantomsToday:AlternativeCCmechanismsOptimisticCC(Kung-Robinson)Lockingisaconservativeapproachinwhichconflictsareprevented.
Disadvantages:Lockmanagementoverhead.
Deadlockdetection/resolution.
Lockcontentionforheavilyusedobjects.
Lockingis"pessimistic"becauseitassumesthatconflictswillhappen.
WhatifconflictsarerareWemightgetbetterperformancebynotlocking,andinsteadcheckingforconflictsatcommittime.
Kung-RobinsonModelXactshavethreephases:READ:Xactsreadfromthedatabase,butmakechangestoprivatecopiesofobjects.
VALIDATE:Checkforconflicts.
WRITE:Makelocalcopiesofchangespublic.
RVWValidationIdea:testconditionsthataresufficienttoensurethatnoconflictoccurred.
EachXactassignedanumericid.
Justuseatimestamp.
AssignedatendofREADphase.
ReadSet(Ti):SetofobjectsreadbyXactTi.
WriteSet(Ti):SetofobjectsmodifiedbyTi.
Test1ForalliandjsuchthatTiWTS(O):AllowTtoreadO.
ResetRTS(O)tomax(RTS(O),TS(T))ChangetoRTS(O)onreadsmustbewrittentodisk!
Thisandrestartsrepresentoverheads.
TimestampCC:WhenXactTwantstoWriteObjectOIfTS(T)WTS(O))untilwriterofOcommits.
SimilartowritersholdingXlocksuntilcommit,butstillnotquite2PL.
T1T2W(A)R(A)W(B)CommitUnrecoverableschedulesareallowedbyTimestampCC!
Recoverableschedule:xactscommitonlyafter(andif)allxactswhosechangestheyreadcommitAweakerconditionthanAvoidCascadingRollbackMultiversionTimestampCCIdea:Letwritersmakea"new"copywhilereadersuseanappropriate"old"copy:OO'O''MAINSEGMENT(CurrentversionsofDBobjects)VERSIONPOOL(Olderversionsthatmaybeusefulforsomeactivereaders.
)Readersarealwaysallowedtoproceed.
Butmaybeblockeduntilwritercommits.
MultiversionCC(Contd.
)Eachversionofanobjecthasitswriter'sTSasitsWTS,andtheTSoftheXactthatmostrecentlyreadthisversionasitsRTS.
Versionsarechainedbackward;wecandiscardversionsthatare"toooldtobeofinterest".
EachXactisclassifiedasReaderorWriter.
Writermaywritesomeobject;Readerneverwill.
XactdeclareswhetheritisaReaderwhenitbegins.
ReaderXactForeachobjecttoberead:FindsnewestversionwithWTSReaderXactsareneverrestarted.
However,mightblockuntilwriteroftheappropriateversioncommits.
ToldnewWTStimelineWriterXactToreadanobject,followsreaderprotocol.
Towriteanobject:FindsnewestversionVs.
t.
WTSIfRTS(V))Else,rejectwrite.
ToldnewWTSCVVRTS(V)SummaryOptimisticCCusingend-of-xact"validation"Goodif:Read-dominatedworkloadSystemhaslotsofextraresourcesMostrealsystemsuselockingSummary(Contd.
)Anotheralternative:TimestampCCDecidelogicalxactexecutionorderwhenxactsentersystemEnforcebycomparingxacttimestampswithobjecttimestampsVariant:MultiversionCCKeepout-of-dateversionsofobjects,so"old"readersdon'thavetorestart(theycanrun"inthepast")OracleusesaflavorofmultiversionCC

vdsina:俄罗斯VPS(datapro),6卢布/天,1G内存/1核(AMD EPYC 7742)/5gNVMe/10T流量

今天获得消息,vdsina上了AMD EPYC系列的VDS,性价比比较高,站长弄了一个,盲猜CPU是AMD EPYC 7B12(经过咨询,详细CPU型号是“EPYC 7742”)。vdsina,俄罗斯公司,2014年开始运作至今,在售卖多类型VPS和独立服务器,可供选择的有俄罗斯莫斯科datapro和荷兰Serverius数据中心。付款比较麻烦:信用卡、webmoney、比特币,不支持PayPal...

HostDare($33.79/年)CKVM和QKVM套餐 可选CN2 GIA线路

关于HostDare服务商在之前的文章中有介绍过几次,算是比较老牌的服务商,但是商家背景财力不是特别雄厚,算是比较小众的个人服务商。目前主流提供CKVM和QKVM套餐。前者是电信CN2 GIA,不过库存储备也不是很足,这不九月份发布新的补货库存活动,有提供九折优惠CN2 GIA,以及六五折优惠QKVM普通线路方案。这次活动截止到9月30日,不清楚商家这次库存补货多少。比如 QKVM基础的五个方案都...

HostKvm四月优惠:VPS主机全场八折,香港/美国洛杉矶机房$5.2/月起

HostKvm是一家成立于2013年的国外主机服务商,主要提供基于KVM架构的VPS主机,可选数据中心包括日本、新加坡、韩国、美国、中国香港等多个地区机房,均为国内直连或优化线路,延迟较低,适合建站或者远程办公等。本月商家针对全场VPS主机提供8折优惠码,优惠后美国洛杉矶VPS月付5.2美元起。下面列出几款不同机房VPS主机产品配置信息。套餐:美国US-Plan0CPU:1cores内存:1GB硬...

yahoo 相册为你推荐
qq讨论组qq讨论组是什么?为什么我的好友都能看见我说话?windows优化大师怎么用windows优化大师怎么用啊?iphone5解锁苹果5手机怎么屏幕解锁雅虎社区有什么网站的论坛内容丰富 资讯较新 适合年轻人的?办公协同软件最好用的协同办公软件是哪个童之磊网文大学很强吗?开机滚动条电脑开机有滚动条的画面xv播放器下载求手机可以看xv格式的视频播放器免费免费建站电脑上有真正免费的网站吗??Qzongqzong皮肤上怎样写字
com域名抢注 国外主机 kddi 美国主机论坛 http500内部服务器错误 服务器怎么绑定域名 debian源 ibrs java虚拟主机 777te 智能骨干网 福建天翼加速 ftp教程 超级服务器 跟踪路由命令 smtp虚拟服务器 西安服务器托管 湖南idc 个人免费邮箱 photobucket 更多