MSSQL网站制作之X$表
但我们知道,若使用statement,并没有上述需要的数据。试想binlog中记录了一句updatetsetf1=3whereid=3。怎么恢复呢?ernelLayer-PhaseCommit
lobalransactionntry
X$K2GTE-Current2PCtx
X$K2GTE2-Current2PCtx
acheLayer
ufferManagement
Bufferash
X$BH-HashTable
BufferLRUStatistics
X$KCBCBH-urrentuffers(buckets)-lru_statistics
X$KCBRBH-ecentuffers(buckets)-lru_extended
Buffers
X$KCBWAIT-Waitsbyblockclass
X$KCBFWAIT-WaitsbyFile
orkingSets-7.3orhigher
X$KCBWDS-Setescriptors
ontrolFileManagement
ontrolileList-7.0.16orhigher
X$KCCCF-ControlFileNames&status
atabasenformation
X$KCCDI-DatabaseInformation
Datailes
X$KCCFE-Filentries(fromcontrolfile)
X$KCCFN-ileames
ogFiles
X$KCCLE-LogFilentries
X$KCCLH-Logistory(archiveentries)
ThreadInformation
X$KCCRT-edohreadInformation
ileManagement
X$KCFIO-FileStatistics
ockManagerComponent(LCK)
ashandBucketTables-7.0.15to7.1.1,and7.2.0orhigher
X$KCLFH-FileashTable
X$KCLFI-FileBucketTable
X$LE-Locklements
X$LE_STAT-LockConversionistics
X$KCLFX-LockElementreeliststatistics-7.3orhigher
X$KCLLS-PerLCKfreeliststatistics-7.3orhigher
X$KCLQN-ame(hash)tablestatistics-7.3orhigher
edoComponent
ediarecovery-kcra.h-7.3orhigher
X$KCRMF-ilecontext
X$KCRMT-hreadcontext
X$KCRMX-RecoveryContet
ileread
X$KCRFX-FileReadContet-7.3orhigher
RecoeryComponent
ileeaders
X$KCVFH-Allfileheaders
X$KCVFHMRR-Fileswithediaecoveryequired
X$KCVFHONL-ineFileheaders
ompatibilityManagement-7.1.1orhigher
X$KCKCE-ompatibilitySegmentntries
X$KCKTY-Compatibilitypes
X$KCKFM-Compatibilityorats(indexintoX$KCKCE)
ataLayer
SequenceumberComponent
X$KDNCE-Sequenceachentries-7.2orlower
equenceEnqueues-commonareaforenqueueobjects
X$KDNSSC-acheEnqueueObjects-7.2orlower
X$KDNSSF-lushEnqueueObjects-7.2orlower
X$KDNST-Cacheatistics-7.2orlower
IndeBlockComponent
X$KDXHS-Indexitogram
X$KDXST-Indexatistics
enericLayer
eapManager
X$KGHLU-State(summary)ofRheap(s)-definedinksmh.h
nstantiationManager
ursorache
X$KGICC-Sessionstatistics-definedinkqlf.h
X$KGICS-Systemwidestatistics-definedinkqlf.h
ibraryCacheManager(definedandmappedfromkqlf)
BindVariables
X$KKSBV-LibraryObjectindariables
ObjectCache
X$KGLOB-Alljects
X$KGLTABLE-Filterfors
X$KGLBODY-Filterfor(packages)
X$KGLTRIGGER-Filterfors
X$KGLINDEX-Filterfores
X$KGLCLUSTER-Filterfors
X$KGLCURSOR-Filterfors
CacheDependency
X$KGLDP-Objecteendencytable
X$KGLRD-eadonlyependencytable-7.3orhigher
ObjectLocks
X$KGLLK-Objectocs
ObjectNames
X$KGLNA-Objectmes(sqltext)
X$KGLNA1-Objectmes(sqltext)withnewlines-7.2.0orhigher
ObjectPins
X$KGLPN-Objectis
CacheStatistics
X$KGLST-Librarycacheatistics
TranslationTable
X$KGLTR-Addressanslation
AccessTable
X$KGLXS-ObjectAccessTable
AuthorizationTable-7.1.5orhigher
X$KGLAU-ObjectAuthorizationtable
LatchCleanup-7.0.15orhigher
X$KGLLC-atchleanupforCache/PinLatches
ompileLayer
haredObjects
X$KKSAI-Cursorllocationnformation-7.3.2orhigher
oader
ibrary
X$KLLCNT-orolStatistics
X$KLLTAB-leStatistics
ulti-ThreadedLayer
ircuitcomponent
X$KMCQS-Currentueuetate
X$KMCVC-irtualircuitstate
onitorServer/dispatcher
ispatcher
X$KMMDI-ispatchernfo(status)
X$KMMDP-ispatcherConfig(rotocolinfo)
erver
X$KMMSI-ervernfo(status)
X$KMMSG-ainfo(globalstatistics)
X$KMMRD-equesttimingistributions
slVersionandOptionLayer
Kernelersions
X$VERSION-Libraryversions
Kernelptions-7.1.3orhigher
X$OPTION-ServerOptions
ueryLayer
ictionaryCacheManagement
X$KQDPG-arowcachecursorstatistics
ixedTables/viewsManagement
X$KQFCO-Tablelumndefinitions
X$KQFDT-erivedables
X$KQFSZ-KernelDatastructuretypeies
X$KQFTA-Fixedbles
X$KQFVI-Fixedews
X$KQFVT-iewextdefinition-7.2.0orhigher
owCacheManagement
X$KQRST-Cacheatistics
X$KQRPD-arentCacheefinition-7.1.5orhigher
X$KQRSD-ubordinateCacheefinition-7.1.5orhigher
erviceLayer
ackgroundManagement
etachedProcess
X$KSBDD-DetachedProcessefinition(info)
X$KSBDP-DetachedrocessDescriptor(name)
X$MESSAGES-BackgroundMessagetable
nstanceanagement-7.3orhigher
X$KSIMAT-Instancetributes
X$KSIMAV-ttributealuesforallinstances
X$KSIMSI-erialandnstancenumbers
ockManagement
ventWaits
X$KSLED-Eventescriptors
X$KSLEI-nstancewidestatisticssincestartup
X$KSLES-Currentessionstatistics
atches
X$KSLLD-Latchescriptor(name)
X$KSLLT-Latchstatistics[+Childlatches@7.3orhigher]
X$KSLLW-Latchcontext(here)descriptors-7.3orhigher
X$KSLPO-Latchststatistics-7.3orhigher
X$KSLWSC-NoaitandleepountstatsbyContext-7.3orhigher
emoryManagement
ontextareas
X$KSMCX-Etendedstatisticsonusage-7.3.1orlower
HeapAreas
X$KSMSP-SGAHea
X$KSMPP-GAHea-7.3.2andabove
X$KSMUP-GAHea-7.3.2andabove
X$KSMHP-Anyea-7.3.2andabove
X$KSMSPR-haredooleservedList-7.1.5orhigher
eastrecentlyusedsharedpoolchunks
X$KSMLRU-LRflushesfromthesharedpool
GAObjects
X$KSMSD-SizeefinitionforFixed/Variablesummary
X$KSMSS-Statistics(lengths)ofSGAobjects
SGAory
X$KSMMEM-mapoftheentireSGA-7.2.0orhigher
X$KSMFSV-AddressesofixedGAariables-7.2.1orhigher
arameterComponent
X$KSPPI-arameternfo(Names)
X$KSPPCV-urrentSessionalues-7.3.2orabove
X$KSPPSV-ystemalues-7.3.2orabove
EnueueManagement
X$KSQDN-Globalatabaseame
X$KSQEQ-nueueObject
X$KSQRS-Enqueueeource
X$KSQST-Enqueuetatisticsbyype
serManagement
ost
X$KSUCF-Costunction(resourcelimit)
icence
X$KSULL-Licenceimits
anguageManager
X$NLS_PARAMETERS-NLSparameters
X$KSULV-NLSalidValues-7.1.2orhigher
atistics
X$KSUMYSTA-atisics(currentsession)
rocessInfo
X$KSUPL-Process(resource)imits
X$KSUPRLAT-chHolder
X$KSUPR-Processobject
esource
X$KSURU-Resourcesage
tatistics
X$KSUSD-escriptors(statisticnames)&nb两个到底是哪一个给出了MySQL这个名字至今依然是个迷,包括开发者在内也不知道。 一个是把SQL语句写到客户端,可以使用DataSet进行加工; 另一个是把SQL语句写到服务器端,就是所谓的SP(存储过程); SP4是一个累积性的ServicePack,包含自以前的ServicePack发布以来所有的修补程序(包括MS03-031安全公告)。 对于微软系列的东西除了一遍遍尝试还真没有太好的办法 groupby子句可以将查询结果分组,并返回行的汇总信息Oracle按照groupby子句中指定的表达式的值分组查询结果。 对递归类的树遍历很有帮助。个人感觉这个真是太棒了!阅读清晰,非常有时代感。 Mirror可以算是SQLServer的Dataguard了。但是能不能被大伙用起来就不知道了。 大侠们有推荐的书籍和学习方法写下吧。 记得在最开始使用2k的时候就要用到这个功能,可惜2k没有,现在有了作解决方案的朋友会很高兴吧。
页:
[1]