mp4(H264容器)的詳細文件格式分析

十六進制碼流分析:

????? ftyp Box
????? 00 00 00 1C:? size ,28,表示此BOX有28個字節,表示長度的四個字節也計算在內。以下同
????? 66 74 79 70:? type,表示BOX TYPE,此處為ftyp
????? 6D 70 34 32:? 可能是兼容的格式信息,/mp42
????? 00 00 00 00:? 可能是插入的空字節,/也可能是version ,flags
????? 6D 70 34 32:? 可能是兼容的格式信息,mp42/?? major-brand
????? 6D 70 34 31:? 可能是兼容的格式信息,mp41/ minor-version
????? 69 73 6F 6D:? isom, ftyp中的最后一個標識,compatible-brands[];? // to end of the? box

????? The brand ‘mp41’ is defined as identifying version 1 of this specification
????? (ISO/IEC 14496-1:2001), and the brand ‘mp42’ identifies this version of
????? the specification;? at least one of these brands shall appear in the
????? compatible-brands list in the file-type box, in all files conforming to
????? this specification.

????? moov Box
????? 00 03 B0 59:? size of moov.241753個字節
????? 6D 6F 6F 76:? moov

????? mvhd Box
????? 00 00 00 6C:? size,mvhd Box的大小為108個字節
????? 6D 76 68 64:? mvhd
????? 00 00 00 00:? version,flags
????? BE EE 87 C5:? creation-time創建文件的時間,是距離1904年1月1日0點的秒數
????? BE EE 87 C5:? modifiation-time修改文件的時間,
????? 00 01 5F 90:? timescale時標,時間刻度的單位,為1/90 000秒
????? 01 A8 61 B8:? duration持續時間
????? 00 01 00 00:? rate播放描述的等級
????? 01 00:??? volume播放時的音量
????? 00 00:??? 保留的16bits的0
????? 00 00 00 00:? 保留的32bits的0
????? 00 00 00 00:?? 保留的32bits的0
????? 00 01 00 00?? 00 00 00 00?? 00 00 00 00?? 00 00 00 00
????? 00 01 00 00?? 00 00 00 00?? 00 00 00 00?? 00 00 00 00
????? 40 00 00 00??? :? matrix給視頻提供的轉換矩陣
????? 00 00 00 00?? 00 00 00 00?? 00 00 00 00
????? 00 00 00 00? 00 00 00 00?? 00 00 00 00:? 6個32bits的pre-defined 的0
????? 00 01 00 CA:? next-track-ID下一個軌跡ID

????? iods Box
????? 00 00 00 21:? size of iods,33個字節
????? 69 6F 64 73:? iods, Initial Object Descriptor
????? 00 00 00 00:? version,flags
????? 10 13 00 4F:? 可能是OD, Object Descriptor
????? FF FF 0F FE:
????? FF 0E 04 00:
????? 00 00 01 0E:
????? 04 00 00 00:
????? 02

????? udta Box
????? 00 00 06 8F:? size of udta ,1679
????? 75 64 74 61:? udta,


????? uuid Box
????? 00 00 04 A9:? size of uuid,1193
????? 75 75 69 64:? uuid
????? F7 8C AA 0C 36 BE 4C E9 88 D2 03 C2 56 DA BE B2? :? 由于boxtype =
????? uuid而定義的16個字節的usertype

????? EES-3-0-410
????? VE
????? AE
????? AudioEncoder-2-1-11
????? V bitRate=2000000bps
????? V keyFrame Period In Ms=10000
????? V number of Pass=2
????? V progressive Interlaced=0
????? V rateControlMode=cbr
????? V smoothVsSharp=0
????? V sourceNature=natural
????? V useBFrame =false.此處表明本碼流沒有使用B幀
????? V videoEncoderType=mpeg4
????? V advVideo EncoderType=mpeg4
????? V allowBitRateUnderflow=false
????? V change Rgb Yuv Conversion=false
????? V setCustomBitmapSize=false
????? V useCustomPixedAspectRatio=false
????? V useExpertFeaturesASP=false
????? V useMotionFiltering=false
????? V useVideoPacket=false
????? V vbvSizeInMs=1000
????? V burnLogo=false
????? V changeframerate=false
????? V useColorAdjustment=false
????? V useCropFilter=false
????? V useScaleFilter=false
????? V useSpatialFilter=false
????? V useTimecodes=false

????? A audioEncoderType=aac
????? A bitRate=64000bps
????? A useAutomaticBandwidth=true
????? A useMS=true
????? A balanceLeftRight=0
????? A volumeInDB=0
????? starttime=0
????? stoptime=9223372036854775807,
????? MTUSize=1448
????? exportType=mp4
????? hinted=true
????? progressiveDownload=true
????? allowDebugInformationInStream=true
????? avoidQuickTime6Warnings=false
????? forceETV15compatibility=false
????? forcePlayerCompatibility=false
????? multiThreadedOptimization=0
????? openAVIWith=DirectShow
????? previewOnOff=1
????? previewlayout=0
????? showEncodingStatistics=true
????? .......................


????? hnti Box
????? 00 00 01 DE:size of hnti,478
????? 68 6E 74 69:hnti

????? rtp Box
????? 00 00 01 D6:size of rtp,470
????? 72 74 70 20:rtp
????? 73 64 70 20:sdp
????? a=mpeg4-iod:”data:application/mpeg4-iod;
????? base64

????? ................................

????? trak Box
????? 00 00 01 A4:? size of trak,420
????? 74 72 61 6B:? trak

????? tkhd Box
????? 00 00 00 5C:? size of tkhd,92
????? 74 6B 68 64:? tkhd, track head box
????? 00 00 00 01:? 00,version;? 00 00 01,track enable flags
????? BE EE 87 C5:? creation-time創建文件的時間
????? BE EE 87 C5:? modifiation-time修改文件的時間,兩個時間應該相同
????? 00 00 00 01:? track-ID
????? 00 00 00 00:? 保留的32bits的0
????? 01 A8 5E 16:? duration持續的時間
????? 00 00 00 00?? 00 00 00 00:? 保留的2個32bits的0
????? 00 00:layer 0
????? 00 00:pre-defined 0
????? 00 00:volume,as non audio,if audio ,0x0100
????? 00 00:reserved 0
????? 00 01 00 00?? 00 00 00 00
????? 00 00 00 00??? 00 00 00 00??? 00 01 00 00??? 00 00 00 00
????? 00 00 00 00??? 00 00 00 00??? 40 00 00 00??? :matrix
????? 00 00 00 00:width,if track_is_visual 0x01400000 else 0
????? 00 00 00 00:height,if track_is_visual 0x00F00000 else 0


????? mdia Box
????? 00 00 01 28:? size of mdia,296
????? 6D 64 69 61:? mdia


????? mdhd Box
????? 00 00 00 20:? size of mdhd ,32
????? 6D 64 68 64:? mdhd
????? 00 00 00 00:? version
????? BE EE 87 C5:? creation-time
????? BE EE 87 C5:? modification-time
????? 00 00 03 E8:? timescale
????? 00 04 B7 17:? duration
????? 0? :pad
????? 10101 01110 00100:? 3個5bits的language
????? 00 00 :pre-defined 0

?

????? hdlr Box
????? 00 00 00 21:size of hdlr,33
????? 68 64 6C 72:? hdlr
????? 00 00 00 00:? version
????? 00 00 00 00:? pre-defined 0
????? 6F 64 73 6D:? odsm,handler-type. ObjectDescriptorStream
????? 00 00 00 00?? 00 00 00 00?? 00 00 00 00 :? 3個reserved
????? 00? :string? name

????? minf? Box
????? 00 00 00 DF:? size of minf,223
????? 6D 69 6E 66:? minf

????? nmhd Box
????? 00 00 00 0C:? size of nmhd,12
????? 6E 6D 68 64:? nmhd
????? 00 00 00 00:? version

????? dinf Box
????? 00 00 00 24:? size of dinf,36
????? 64 69 6E 66:? dinf

????? dref Box
????? 00 00 00 1C:? size of dref,28
????? 64 72 65 66:? dref
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count

????? url Box
????? 00 00 00 0C: size of url ,12
????? 75 72 6C 20:? url
????? 00 00 00 01:? location

????? stbl Box
????? 00 00 00 A7:? size of stbl,167
????? 73 74 62 6C:? stbl

????? stsd Box
????? 00 00 00 43:? size of stsd,67
????? 73 74 73 64:? stsd
????? 00 00 00 00:? version,flags
????? 00 00 00 01:? entry-count

????? mp4s Box
????? 00 00 00 33:? size of mp4s, 51
????? 6D 70 34 73:? mp4s
????? 00 00 00 00:? version
????? 00 00 00 01:? ES

????? esds Box
????? 00 00 00 23:? size of esds,35
????? 65 73 64 73:? esds
????? 00 00 00 00:? version
????? 03 15 00 00:
????? 00 04 0D 01:
????? 05 00 00 C8:
????? 00 00 00 00:
????? 00 00 00 00:
????? 06 01 02:

????? stts Box
????? 00 00 00 18:?? size of stts,24
????? 73 74 74 73:? stts
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count
????? 00 00 00 01:? sample-count
????? 00 04 B7 17:? sample-delta

????? stsc Box
????? 00 00 00 1C:? size of stsc ,28
????? 73 74 73 63:? stsc
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count
????? 00 00 00 01:? first-chunk
????? 00 00 00 01:? samples-per-chunk
????? 00 00 00 01:? sample-description-index

????? stsz Box
????? 00 00 00 14:? size of stsz,20
????? 73 74 73 7A:? stsz
????? 00 00 00 00:? version
????? 00 00 00 12:? sample-size
????? 00 00 00 01:? sample-count

????? stco Box
????? 00 00 00 14:? size of stco,20
????? 73 74 63 6F:? stco
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count
????? 00 03 B0 7D:? chunk-offset

????? tref Box
????? 00 00 00 18:? size of tref,24
????? 74 72 65 66:? tref

????? mpod Box
????? 00 00 00 10:? size of mpod,16
????? 6D 70 6F 64:? mpod
????? 00 00 00 C9:
????? 00 00 00 65:

????? trak Box
????? 00 00 01? 91: size of trak,401
????? 74 72 61 6B:? trak

????? tkhd Box
????? 00 00 00 5C:? size of tkhd,92
????? 74 6B 68 64:? tkhd
????? 00 00 00 01:? 00,version;? 00 00 01,track enable flags
????? BE EE 87 C5:? creation-time創建文件的時間
????? BE EE 87 C5:? modifiation-time修改文件的時間,兩個時間應該相同
????? 00 00 00 02:? track-ID
????? 00 00 00 00:? 保留的32bits的0
????? 01 A8 5E 16:? duration持續的時間
????? 00 00 00 00?? 00 00 00 00:? 保留的2個32bits的0
????? 00 00:layer 0
????? 00 00:pre-defined 0
????? 00 00:volume,as non audio,if audio ,0x0100
????? 00 00:reserved 0
????? 00 01 00 00?? 00 00 00 00
????? 00 00 00 00??? 00 00 00 00??? 00 01 00 00??? 00 00 00 00
????? 00 00 00 00??? 00 00 00 00??? 40 00 00 00??? :matrix
????? 00 00 00 00:width,if track_is_visual 0x01400000 else 0
????? 00 00 00 00:height,if track_is_visual 0x00F00000 else 0

????? mdia Box
????? 00 00 01 2D:size of mdia,301
????? 6D 64 69 61:mdia

????? mdhd Box
????? 00 00 00 20:? 32
????? 6D 64 68 64:mdhd
????? 00 00 00 00 :version,flags
????? BE EE 87 C5: creation-time創建文件的時間
????? BE EE 87C5: modifiation-time修改文件的時間,兩個時間應該相同
????? 00 00 03 E8: timescale時標
????? 00 04 B7 17: duration持續的時間
????? 55 C4:pad, 3個5bits的language
????? 00 00: pre-defined 0

????? hdlr Box
????? 00 00 00 21:size of hdlr ,33
????? 68 64 6C 72:? hdlr
????? 00 00 00 00:? version
????? 00 00 00 00:? pre-defined 0
????? 73 64 73 6D:? sdsm,handler-type, SceneDescriptionStream
????? 00 00 00 00?? 00 00 00 00?? 00 00 00 00 :? 3個reserved
????? 00? :string? name

????? minf? Box
????? 00 00 00 E4:? size of minf,228
????? 6D 69 6E 66:? minf

????? nmhd Box
????? 00 00 00 0C:? size of nmhd,12
????? 6E 6D 68 64:? nmhd
????? 00 00 00 00:? version

????? dinf Box
????? 00 00 00 24:? size of dinf,36
????? 64 69 6E 66:? dinf

????? dref Box
????? 00 00 00 1C:? size of dref,28
????? 64 72 65 66:? dref
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count

????? url Box
????? 00 00 00 0C: size of url ,12
????? 75 72 6C 20:? url
????? 00 00 00 01:? location

????? stbl Box
????? 00 00 00 AC:? size of stbl,172
????? 73 74 62 6C:? stbl

????? stsd Box
????? 00 00 00 48:? size of stsd,72
????? 73 74 73 64:? stsd
????? 00 00 00 00:? version,flags
????? 00 00 00 01:? entry-count

????? mp4s Box
????? 00 00 00 38:? size of mp4s, 56
????? 6D 70 34 73:? mp4s
????? 00 00 00 00:? version
????? 00 00 00 01:? ES

????? esds Box
????? 00 00 00 28:? size of esds,40
????? 65 73 64 73:? esds
????? 00 00 00 00:? version
????? 03 1A 00 00:
????? 00 04 12 02:
????? 0D 00 00 20:
????? 00 00 00 00:
????? 00 00 00 00:
????? 05 03 00 00:
????? 40 06 01 02:

????? stts Box
????? 00 00 00 18:?? size of stts,24
????? 73 74 74 73:? stts
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count
????? 00 00 00 01:? sample-count
????? 00 04 B7 17:? sample-delta

????? stsc Box
????? 00 00 00 1C:? size of stsc ,28
????? 73 74 73 63:? stsc
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count
????? 00 00 00 01:? first-chunk
????? 00 00 00 01:? samples-per-chunk
????? 00 00 00 01:? sample-description-index

????? stsz Box
????? 00 00 00 14:? size of stsz,20
????? 73 74 73 7A:? stsz
????? 00 00 00 00:? version
????? 00 00 00 18:? sample-size
????? 00 00 00 01:? sample-count

????? stco Box
????? 00 00 00 14:? size of stco,20
????? 73 74 63 6F:? stco
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count
????? 00 03 B0 8F:? chunk-offset


????? trak Box
????? 00 01 71 55:size of trak,
????? 74 72 61 6B:trak

????? tkhd Box
????? 00 00 00 5C:? size of tkhd,92
????? 74 6B 68 64:? tkhd, track head box
????? 00 00 00 01:? 00,version;? 00 00 01,track enable flags
????? BE EE 87 C5:? creation-time創建文件的時間
????? BE EE 87 C5:? modifiation-time修改文件的時間,兩個時間應該相同
????? 00 00 00 C9:? track-ID
????? 00 00 00 00:? 保留的32bits的0
????? 01 A8 61 B8:? duration持續的時間
????? 00 00 00 00?? 00 00 00 00:? 保留的2個32bits的0
????? 00 00:layer 0
????? 00 00:pre-defined 0
????? 00 00:volume,as non audio,if audio ,0x0100
????? 00 00:reserved 0
????? 00 01 00 00?? 00 00 00 00
????? 00 00 00 00??? 00 00 00 00??? 00 01 00 00??? 00 00 00 00
????? 00 00 00 00??? 00 00 00 00??? 40 00 00 00??? :matrix
????? 02 D0 00 00:width,if track_is_visual 0x01400000 else 0
????? 01 E0 00 00:height,if track_is_visual 0x00F00000 else 0

????? mdia Box
????? 00 01 70 CD:? size of mdia
????? 6D 64 69 61:? mdia


????? mdhd Box
????? 00 00 00 20:? size of mdhd ,32
????? 6D 64 68 64:? mdhd
????? 00 00 00 00:? version
????? BE EE 87 C5:? creation-time
????? BE EE 87 C5:? modification-time
????? 00 01 5F 90:? timescale
????? 01 A8 61 B8:? duration
????? 0? :pad
????? 10101 01110 00100:? 3個5bits的language
????? 00 00 :pre-defined 0

????? hdlr Box
????? 00 00 00 21:size of hdlr,33
????? 68 64 6C 72:? hdlr
????? 00 00 00 00:? version
????? 00 00 00 00:? pre-defined 0
????? 76 69 64 65:? vide,handler-type,表示此trak為視頻
????? 00 00 00 00?? 00 00 00 00?? 00 00 00 00 :? 3個reserved
????? 00? :string? name


????? minf? Box
????? 00 01 70 84:? size of minf,94340
????? 6D 69 6E 66:? minf

????? vmhd Box
????? 00 00 00 14:? size of nmhd
????? 76 6D 68 64:? nmhd
????? 00 00 00 01:? version,flags
????? 00 00 00 00:
????? 00 00 00 00:

?


????? dinf Box
????? 00 00 00 24:? size of dinf,36
????? 64 69 6E 66:? dinf

????? dref Box
????? 00 00 00 1C:? size of dref,28
????? 64 72 65 66:? dref
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count

????? url Box
????? 00 00 00 0C: size of url ,12
????? 75 72 6C 20:? url
????? 00 00 00 01:? location

????? stbl Box
????? 00 01 70 44:? size of stbl
????? 73 74 62 6C:? stbl

????? stsd Box
????? 00 00 00 AC:? size of stsd,72
????? 73 74 73 64:? stsd
????? 00 00 00 00:? version,flags
????? 00 00 00 01:? entry-count

????? mp4v Box
????? 00 00 00 9C:? size of mp4v
????? 6D 70 34 76:? mp4v
????? 00 00 00 00:? version
????? 00 00 00 01:? ES
????? 00 00 00 00 00 00 :
????? 00 00 00 00 00 00 00 00 00 00 02 D0 01 E0 00 48
????? 00 00 00 48 00 00 00 00 00 00 00 01 00 00 00 00
????? 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
????? 00 00 00 00 00 00 00 00 00 00 00 00 00 18 FF FF

????? esds Box
????? 00 00 00 46:? size of esds
????? 65 73 64 73:? esds
????? 00 00 00 00:? version
????? 03 38 00 00:
????? 00 04 30 20:
????? 11 03 D0 90:
????? 00 1E 84 80:
????? 00 1E 84 80:
????? 05 21 00 00:
????? 01 B0 00 00:
????? 00 01 B5 0E:
????? A0 20 20 2F:
????? 00 00 01 00:
????? 00 00 01 20:
????? 00 C7 88 BA:
????? 98 51 68 43:
????? C1 46 3F 06:
????? 01 02 :

????? stts Box
????? 00 00 E7 90:?? size of stts
????? 73 74 74 73:? stts
????? 00 00 00 00:? version
????? 00 00 1C F0:? entry-count
????? 00 00 00 01:? sample-count
????? 00 00 0B BB:? sample-delta
????? 00 00 00 01
????? 00 00 11 97
????? 00 00 00 01
????? 00 00 0B BB
????? 00 00 00 01
????? 00 00 11 9A
????? ...........

????? stsc Box
????? 00 00 0E 8C:? size of stsc ,
????? 73 74 73 63:? stsc
????? 00 00 00 00:? version
????? 00 00 01 35:? entry-count

????? 00 00 00 01:? first-chunk
????? 00 00 00 15:? samples-per-chunk
????? 00 00 00 01:? sample-description-index

????? 00 00 00 02
????? 00 00 00 18
????? 00 00 00 01

????? 00 00 00 03
????? 00 00 00 18
????? 00 00 00 01

????? 00 00 00 04
????? 00 00 00 18
????? 00 00 00 01
????? .............

????? stsz Box
????? 00 00 73 D8? size of stsz,20
????? 73 74 73 7A:? stsz
????? 00 00 00 00:? version
????? 00 00 00 00:? sample-size
????? 00 00 1C F1:? sample-count
????? 00 00 86
????? 24(從此開始,為當前chunk中每幀視頻數據的字節大小,此大小與offset相對應,用offset找到偏移的絕對地址(指向mdat
????? box中)后,從000001B6的第一個字節開始,加上對應的視頻字節數,就是本幀的大小。一個視頻chunk中首先是連續的視頻幀,然后也包含其他數據,暫不清楚視頻數據后面的數據類型)
????? 00 00 08 F9
????? 00 00 3B 04
????? 00 00 1D F2
????? 00 00 49 00
????? 00 00 60 A6
????? 00 00 2E 30
????? 00 00 33 F9
????? 00 00 22 19
????? 00 00 15 DB
????? 00 00 17 47
????? 00 00 1D 16
????? 00 00 3A 4A
????? 00 00 1C 1B
????? 00 00 2C EA
????? 00 00 37 28
????? 00 00 3D 70
????? 00 00 36 0B
????? 00 00 16 D0
????? 00 00 39 0F
????? 00 00 22 79
????? 第一個chunk中所有的視頻幀大小結束
????? 下面為當前chunk中視頻數據后面暫不清楚為什么數據類型的開始
????? 00 00 15 DB
????? 00 00 17 47
????? ................

?

????? stco Box
????? 00 00 04 E4:? size of stco,20
????? 73 74 63 6F:? stco
????? 00 00 00 00:? version
????? 00 00 01 35:? entry-count
????? 00 03 B0 A7:? chunk-offset(幀數據偏移的絕對地址(指向mdat
????? box中),此處為視頻數據,一個chunk約包含1S的數據,但不固定)
????? 00 07 F1 5D
????? 00 0B 58 D7
????? 00 0E 58 9D
????? 00 11 A5 3E
????? 00 15 11 0B
????? 00 18 15 4E

?

????? stss Box
????? 00 00 00 B8:size
????? 73 74 73 73:stss
????? 00 00 00 00:version,flags
????? 00 00 00 2A:entry_count
????? 00 00 00 01
????? 00 00 00 12
????? 00 00 00 38
????? 00 00 01 63
????? 00 00 02 8E
????? 00 00 03 B9
????? 00 00 04 E4
????? 00 00 05 83
????? 00 00 06 AE
????? 00 00 07 26
????? 00 00 07 47
????? 00 00 07 68
????? 00 00 08 67
????? 00 00 08 73


????? ...............

????? udta Box
????? 00 00 00 24:
????? 75 64 74 61:

????? uuid Box
????? 00 00 00 1C:? size of uuid
????? 75 75 69 64:? uuid
????? F7 8C AA 0C 36 BE 4C E9 87 D2 03 C2 56 DA BE B2? :? 由于boxtype =
????? uuid而定義的16個字節的usertype
????? 與前面不同
????? 00 01 19 9A

????? trak Box
????? 00 01 72 D5
????? 74 72 61 6B

????? tkhd Box
????? 00 00 00 5C:? size of tkhd,92
????? 74 6B 68 64:? tkhd, track head box
????? 00 00 00 00:? 00,version;? 00 00 00,track enable flags
????? BE EE 87 C5:? creation-time創建文件的時間
????? BE EE 87 C5:? modifiation-time修改文件的時間,兩個時間應該相同
????? 00 01 00 C9:? track-ID
????? 00 00 00 00:? 保留的32bits的0
????? 01 A8 61 B8:? duration持續的時間
????? 00 00 00 00?? 00 00 00 00:? 保留的2個32bits的0
????? 00 00:layer 0
????? 00 00:pre-defined 0
????? 00 00:volume,as non audio,if audio ,0x0100
????? 00 00:reserved 0
????? 00 01 00 00?? 00 00 00 00
????? 00 00 00 00??? 00 00 00 00??? 00 01 00 00??? 00 00 00 00
????? 00 00 00 00??? 00 00 00 00??? 40 00 00 00??? :matrix
????? 00 00 00 00:width,if track_is_visual 0x01400000 else 0
????? 00 00 00 00:height,if track_is_visual 0x00F00000 else 0

????? mdia Box
????? 00 01 70 5D:? size of mdia
????? 6D 64 69 61:? mdia


????? mdhd Box
????? 00 00 00 20:? size of mdhd ,32
????? 6D 64 68 64:? mdhd
????? 00 00 00 00:? version
????? BE EE 87 C5:? creation-time
????? BE EE 87 C5:? modification-time
????? 00 01 5F 90:? timescale
????? 01 A8 61 B8:? duration
????? 0? :pad
????? 10101 01110 00100:? 3個5bits的language
????? 00 00 :pre-defined 0


????? hdlr Box
????? 00 00 00 21:size of hdlr,33
????? 68 64 6C 72:? hdlr
????? 00 00 00 00:? version
????? 00 00 00 00:? pre-defined 0
????? 68 69 6E 74:? hint,handler-type
????? 00 00 00 00?? 00 00 00 00?? 00 00 00 00 :? 3個reserved
????? 00? :string? name

????? minf? Box
????? 00 01 70 14:? size of minf
????? 6D 69 6E 66:? minf

????? hmhd Box
????? 00 00 00 1C
????? 68 6D 68 64
????? 00 00 00 00
????? 05 A8 05 3B
????? 00 1E 84 80
????? 00 18 70 4E
????? 00 1E 84 80


????? dinf Box
????? 00 00 00 24:? size of dinf,36
????? 64 69 6E 66:? dinf

????? dref Box
????? 00 00 00 1C:? size of dref,28
????? 64 72 65 66:? dref
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count

????? url Box
????? 00 00 00 0C: size of url ,12
????? 75 72 6C 20:? url
????? 00 00 00 01:? location

????? stbl Box
????? 00 01 6F CC:? size of stbl,
????? 73 74 62 6C:? stbl

????? stsd Box
????? 00 00 00 34:? size of stsd,
????? 73 74 73 64:? stsd
????? 00 00 00 00:? version,flags
????? 00 00 00 01:? entry-count


????? rtp
????? 00 00 00 24
????? 72 74 70 20:rtp
????? 00 00 00 00
????? 00 00 00 01
????? 00 01 00 01
????? 00 00 05 A8


????? tims
????? 00 00 00 0C
????? 74 69 6D 73
????? 00 01 5F 90

????? stts
????? 00 00 E7 90
????? 73 74 74 73
????? 00 00 00 00:? version
????? 00 00 1C F0:? entry-count
????? 00 00 00 01:? sample-count
????? 00 00 0B BB:? sample-delta
????? 00 00 00 01
????? 00 00 11 97
????? 00 00 00 01
????? 00 00 0B BB
????? 00 00 00 01
????? 00 00 11 9A
????? ..................

????? stsc
????? 00 00 0E 8C
????? 73 74 73 63
????? 00 00 00 00:? version
????? 00 00 01 35:? entry-count

????? 00 00 00 01:? first-chunk
????? 00 00 00 18:? samples-per-chunk
????? 00 00 00 01:? sample-description-index

????? 00 00 00 02
????? 00 00 00 18
????? 00 00 00 01

????? 00 00 00 03
????? 00 00 00 18
????? 00 00 00 01

????? ..............

?


????? stsz Box
????? 00 00 73 D8:? size of stsz,20
????? 73 74 73 7A:? stsz
????? 00 00 00 00:? version
????? 00 00 00 00:? sample-size
????? 00 00 1C F1:? sample-count

????? ..................

????? stco
????? 00 00 04 E4
????? 73 74 63 6F
????? 00 00 00 00:? version
????? 00 00 01 35:? entry-count
????? 00 07 B1 24:chunk_offset
????? 00 0B 20 81


????? ..............

????? stss
????? 00 00 00 B8
????? 73 74 73 73
????? .............

????? tref
????? 00 00 00 14
????? 74 72 65 66

????? hint
????? 00 00 00 0C
????? 68 69 6E 74
????? 00 00 00 C9

????? udta
????? 00 00 02 00
????? 75 64 74 61

????? hinf
????? 00 00 00 E2
????? 68 69 6E 66

????? trpy
????? 00 00 00 10
????? 74 72 70 79
????? 00 00 00 00
????? 03 B8 8E 51

????? nump
????? 00 00 00 10
????? 6E 75 6D 70
????? 00 00 00 00
????? 00 00 B6 0A

????? tpyl
????? 00 00 00 10
????? 74 70 79 6C
????? 00 00 00 00
????? 03 B0 05 D9

????? totl
????? 00 00 00 0C
????? 74 6F 74 6C
????? 03 B8 8E 51

????? npck
????? 00 00 00 0C
????? 6E 70 63 6B
????? 00 00 B6 0A

????? tpay
????? 00 00 00 0C
????? 74 70 61 79
????? 03 B0 05 D9

????? dmed
????? 00 00 00 10
????? 64 6D 65 64
????? 00 00 00 00
????? 03 B0 05 B8

????? dimm
????? 00 00 00 10
????? 64 69 6D 6D
????? 00 00 00 00
????? 00 00 00 21

????? drep
????? 00 00 00 10
????? 64 72 65 70
????? 00 00 00 00
????? 00 00 00 00

????? tmin
????? 00 00 00 0C
????? 74 6D 69 6E
????? FF FF FC 18

????? tmax
????? 00 00 00 0C
????? 74 6D 61 78
????? 00 00 00 00

????? pmax
????? 00 00 00 0C
????? 70 6D 61 78
????? 00 00 05 A8

????? dmax
????? 00 00 00 0C
????? 64 6D 61 78
????? 00 00 00 32

????? payt
????? 00 00 00 26
????? 70 61 79 74
????? 00 00 00 60 19
????? a=rtpmap:96 MP4V-ES/90000
????? hnti
????? sdp m=video 0 RTP/AVP 96
????? b=AS:2048
????? a=rtpmap:96 MP4V-ES/90000
????? a=fmtp:96 profile-level-id=254;config=
????? a=cliprect:0,0,480,720
????? a=mpeg4-esid:201
????? a=x-envivio-verid:0001199A
????? a=control:trackID=65737

????? trak
????? 00 00 AB 60
????? 74 72 61 6B

????? tkhd Box
????? 00 00 00 5C:? size of tkhd,92
????? 74 6B 68 64:? tkhd
????? 00 00 00 01:? 00,version;? 00 00 01,track enable flags
????? BE EE 87 C5:? creation-time創建文件的時間
????? BE EE 87 C5:? modifiation-time修改文件的時間,兩個時間應該相同
????? 00 00 00 65:? track-ID
????? 00 00 00 00:? 保留的32bits的0
????? 01 A8 07 40:? duration持續的時間
????? 00 00 00 00?? 00 00 00 00:? 保留的2個32bits的0
????? 00 00:layer 0
????? 00 00:pre-defined 0
????? 00 00:volume,as non audio,if audio ,0x0100
????? 00 00:reserved 0
????? 00 01 00 00?? 00 00 00 00
????? 00 00 00 00??? 00 00 00 00??? 00 01 00 00??? 00 00 00 00
????? 00 00 00 00??? 00 00 00 00??? 40 00 00 00??? :matrix
????? 00 00 00 00:width,if track_is_visual 0x01400000 else 0
????? 00 00 00 00:height,if track_is_visual 0x00F00000 else 0

????? mdia Box
????? 00 00 AA D8:size of mdia,301
????? 6D 64 69 61:mdia

????? mdhd Box
????? 00 00 00 20:? 32
????? 6D 64 68 64:mdhd
????? 00 00 00 00 :version,flags
????? BE EE 87 C5: creation-time創建文件的時間
????? BE EE 87C5: modifiation-time修改文件的時間,兩個時間應該相同
????? 00 00 7D 00: timescale時標
????? 00 96 C4 00: duration持續的時間
????? 55 C4:pad, 3個5bits的language
????? 00 00: pre-defined 0

????? hdlr Box
????? 00 00 00 21:size of hdlr ,33
????? 68 64 6C 72:? hdlr
????? 00 00 00 00:? version
????? 00 00 00 00:? pre-defined 0
????? 73 6F 75 6E:? soun,handler-type,表示此trak為音頻
????? 00 00 00 00?? 00 00 00 00?? 00 00 00 00 :? 3個reserved
????? 00? :string? name

?

????? minf Box
????? 00 00 AA 8F:size of minf
????? 6D 69 6E 66:minf

????? smhd Box
????? 00 00 00 10:size of smhd
????? 73 6D 68 64:smhd
????? 00 00 00 00:version
????? 00 00 :balance,
????? balance is a fixed-point 8.8 number that places mono audio tracks in a
????? stereo space; 0 is center (the normal value); full left is -1.0 and full
????? right is 1.0.
????? 00 00:reserved

????? dinf Box
????? 00 00 00 24:size of dinf
????? 64 69 6E 66:dinf

????? dref Box
????? 00 00 00 1C:? size of dref,28
????? 64 72 65 66:? dref
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count


????? url Box
????? 00 00 00 0C: size of url ,12
????? 75 72 6C 20:? url
????? 00 00 00 01:? location


????? stbl Box
????? 00 00 AA 53:? size of stbl
????? 73 74 62 6C:? stbl

????? stsd Box
????? 00 00 00 5B:? size of stsd
????? 73 74 73 64:? stsd
????? 00 00 00 00:? version,flags
????? 00 00 00 01:? entry-count


????? mp4a Box
????? 00 00 00 4B:
????? 6D 70 34 61:mp4a
????? 00 00 00 00:version
????? 00 00 00 01:ES
????? 00 00 00 00
????? 00 00 00 00
????? 00 02 00 10
????? 00 00 00 00
????? 7D 00 00 00

????? esds box
????? 00 00 00 27
????? 65 73 64 73
????? 00 00 00 00:? version
????? 03 19 00 00:
????? 00 04 11 40:
????? 15 00 06 00:
????? 00 00 FA 00:
????? 00 00 FA 00:
????? 05 02 12 90:
????? 06 01 02 :

????? stts
????? 00 00 00 18
????? 73 74 74 73:stts
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count
????? 00 00 25 B1:? sample-count
????? 00 00 04 00:? sample-delta

????? stsc Box
????? 00 00 0E 38:? size of stsc?
????? 73 74 73 63:? stsc
????? 00 00 00 00:? version
????? 00 00 01 2E:? entry-count
????? 00 00 00 01:? first-chunk
????? 00 00 00 20:? samples-per-chunk
????? 00 00 00 01:? sample-description-index
????? 00 00 00 02
????? 00 00 00 20
????? 00 00 00 01
????? 00 00 00 03
????? 00 00 00 20
????? 00 00 00 01
????? 00 00 00 04
????? 00 00 00 20
????? 00 00 00 01

????? ..........................

????? stsz box
????? 00 00 96 D8:? size of stsz,
????? 73 74 73 7A:? stsz
????? 00 00 00 00:? version
????? 00 00 00 00:? sample-size
????? 00 00 25 B1:? sample-count

????? .................................

????? stco
????? 00 00 04 C8
????? 73 74 63 6F:stco
????? 00 00 00 00:? version
????? 00 00 01 2E:? entry-count
????? 00 07 C9 54:? chunk-offset
????? 00 0B 32 0D
????? 00 0E 32 9B
????? ............................

????? udta box
????? 00 00 00 24
????? 75 64 74 61

????? uuid
????? 00 00 00 1C
????? 75 75 69 64
????? F7 8C AA 0C 36 BE 4C E9 87 D2 03 C2 56 DA BE
????? B2? :? 由于boxtype = uuid而定義的16個字節的usertype
????? 00 01 19 9A


????? trak
????? 00 00 16 76
????? 74 72 61 6B:? trak

????? tkhd Box
????? 00 00 00 5C:? size of tkhd,92
????? 74 6B 68 64:? tkhd, track head box
????? 00 00 00 00:? 00,version;? 00 00 00,track enable flags
????? BE EE 87 C5:? creation-time創建文件的時間
????? BE EE 87 C5:? modifiation-time修改文件的時間,兩個時間應該相同
????? 00 01 00 65:? track-ID
????? 00 00 00 00:? 保留的32bits的0
????? 01 A8 07 40:? duration持續的時間
????? 00 00 00 00?? 00 00 00 00:? 保留的2個32bits的0
????? 00 00:layer 0
????? 00 00:pre-defined 0
????? 00 00:volume,as non audio,if audio ,0x0100
????? 00 00:reserved 0
????? 00 01 00 00?? 00 00 00 00
????? 00 00 00 00??? 00 00 00 00??? 00 01 00 00??? 00 00 00 00
????? 00 00 00 00??? 00 00 00 00??? 40 00 00 00??? :matrix
????? 00 00 00 00:width,if track_is_visual 0x01400000 else 0
????? 00 00 00 00:height,if track_is_visual 0x00F00000 else 0

????? mdia box
????? 00 00 13 F9
????? 6D 64 69 61

????? mdhd box
????? 00 00 00 20
????? 6D 64 68 64:mdhd
????? 00 00 00 00
????? BE EE 87 C5
????? BE EE 87 C5
????? 00 00 7D 00:timescale
????? 00 96 C4 00:duration
????? 55 C4=
????? 0? :pad
????? 10101 01110 00100:? 3個5bits的language
????? 00 00 :pre-defined 0


????? hdlr box
????? 00 00 00 21:size of hdlr,33
????? 68 64 6C 72:? hdlr
????? 00 00 00 00:? version
????? 00 00 00 00:? pre-defined 0
????? 68 69 6E 74:? hint,handler-type
????? 00 00 00 00?? 00 00 00 00?? 00 00 00 00 :? 3個reserved
????? 00? :string? name

?


????? minf? Box
????? 00 00 13 B0:? size of minf
????? 6D 69 6E 66:? minf

????? hmhd box
????? 00 00 00 1C
????? 68 6D 68 64
????? 00 00 00 00
????? 05 A8 :maxPDU
????? 01 0C :avgPDU
????? 00 00 FA 00: maxbitrate
????? 00 00 FA 00: avgbitrate
????? 00 00 FA 00:此處應該為保留的0,有誤?

????? dinf Box
????? 00 00 00 24:? size of dinf,36
????? 64 69 6E 66:? dinf

????? dref Box
????? 00 00 00 1C:? size of dref,28
????? 64 72 65 66:? dref
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count

????? url Box
????? 00 00 00 0C: size of url ,12
????? 75 72 6C 20:? url
????? 00 00 00 01:? location


????? stbl box
????? 00 00 13 68
????? 73 74 62 6C:? stbl

????? stsd Box
????? 00 00 00 34:? size of stsd,67
????? 73 74 73 64:? stsd
????? 00 00 00 00:? version,flags
????? 00 00 00 01:? entry-count

????? rtp box
????? 00 00 00 24
????? 72 74 70 20:rtp
????? 00 00 00 00
????? 00 00
????? 00 01: hinttrackversion
????? 00 01: highestcompatibleversion
????? 00 01 00 00 : maxpacketsize
????? 05 A8: additionaldata[]

?

????? tims box
????? 00 00 00 0C
????? 74 69 6D 73
????? 00 00 7D 00: timescale

?


????? stts box
????? 00 00 00 18
????? 73 74 74 73
????? 00 00 00 00:? version
????? 00 00 00 01:? entry-count
????? 00 00 25 B1:? sample-count
????? 00 00 04 00:? sample-delta

????? stsc Box
????? 00 00 0E 38:? size of stsc
????? 73 74 73 63:? stsc
????? 00 00 00 00:? version
????? 00 00 01 2E:? entry-count
????? 00 00 00 01:? first-chunk
????? 00 00 00 20:? samples-per-chunk
????? 00 00 00 01:? sample-description-index

????? 00 00 00 02:? first-chunk
????? 00 00 00 20:? samples-per-chunk
????? 00 00 00 01:? sample-description-index

????? 00 00 00 03:? first-chunk
????? 00 00 00 20:? samples-per-chunk
????? 00 00 00 01:? sample-description-index

????? 00 00 00 04:? first-chunk
????? 00 00 00 20:? samples-per-chunk
????? 00 00 00 01:? sample-description-index


????? .............................

????? stsz Box
????? 00 00 00 14:? size of stsz,20
????? 73 74 73 7A:? stsz
????? 00 00 00 00:? version
????? 00 00 00 30:? sample-size
????? 00 00 25 B1:? sample-count

????? stco Box
????? 00 00 04 C8:? size of stco
????? 73 74 63 6F:? stco
????? 00 00 00 00:? version
????? 00 00 01 2E:? entry-count
????? 00 07 EB 5D:? chunk-offset
????? 00 0B 52 D7
????? ...........................

????? tref Box
????? 00 00 00 14:? size of tref,
????? 74 72 65 66:? tref

????? hint box
????? 00 00 00 0C
????? 68 69 6E 74
????? 00 00 00 65:track-IDS

????? udta box
????? 00 00 02 05
????? 75 64 74 61

????? hinf box
????? 00 00 00 EA
????? 68 69 6E 66

????? trpy Box
????? 00 00 00 10:size of trpy,16
????? 74 72 70 79:trpy
????? 00 00 00 00 00 28 0E DE: uint(64)? bytessent;?? // total bytes sent,
????? including 12-byte RTP headers


????? nump Box
????? 00 00 00 10:size of nump,16
????? 6E 75 6D 70:nump
????? 00 00 00 00 00 00 25 B1: uint(64)? packetssent

????? tpyl Box
????? 00 00 00 10:size of tpyl,16
????? 74 70 79 6C:tpyl
????? 00 00 00 00 00 26 4A 92: uint(64)? bytessent;? // total bytes sent, not
????? including RTP headers


????? totl Box
????? 00 00 00 0C:size of totl,12
????? 74 6F 74 6C:totl
????? 00 28 0E DE: bytessent; }? // total bytes sent, including 12-byte RTP
????? headers

????? npck Box
????? 00 00 00 0C:size of npck,12
????? 6E 70 63 6B:npck
????? 00 00 25 B1: packetssent; }? // total packets sent

????? tpay Box
????? 00 00 00 0C:size of tpay,12
????? 74 70 61 79:tpay
????? 00 26 4A 92: bytessent; }? // total bytes sent, not including RTP headers?? dmed Box
????? 00 00 00 10:16
????? 64 6D 65 64:dmed
????? 00 00 00 00 00 25 B3 CE: bytessent; }? // total bytes sent from media??? tracks

????? dimm Box
????? 00 00 00 10:16
????? 64 69 6D 6D:dimm
????? 00 00 00 00 00 00 96 C4: bytessent; }? // total bytes sent immediate mode

?

????? drep Box
????? 00 00 00 10:16
????? 64 72 65 70:drep
????? 00 00 00 00 00 00 00 00: bytessent; }? // total bytes in repeated packets


????? tmin Box
????? 00 00 00 0C:12
????? 74 6D 69 6E: tmin
????? FF FF FF 40: time;???? // smallest relative transmission time, milliseconds


????? tmax Box
????? 00 00 00 0C:12
????? 74 6D 61 78:tmax
????? 00 00 00 00: time; }??? // largest relative transmission time,milliseconds


????? pmax Box
????? 00 00 00 0C:12
????? 70 6D 61 78:pamx
????? 00 00 01 45: bytes; }????? // largest packet sent, including RTP header


????? dmax Box
????? 00 00 00 0C:12
????? 64 6D 61 78:dmax
????? 00 00 00 20: time; }????? // longest packet duration, milliseconds

????? payt Box
????? 00 00 00 2E:
????? 70 61 79 74:payt
????? 00 00 00 61: payloadID
????? 21 : count,
????? a=rtpmap:97 mpeg4-generic/32000/2


????? hnti Box
????? 00 00 01 13:
????? 68 6E 74 69:hnti

????? sdp Box
????? 00 00 01 0B:
????? 73 64 70 20:sdp
????? sdptext[]:
????? m=audio 0 RTP/AVP 97
????? b=AS:75
????? a=rtpmap:97 mpeg4-generic/32000/2
????? a=fmtp:97 profile-level-id =15
????? config=1290
????? streamtype=5
????? mode=AAC-hbr
????? SizeLength=13
????? IndexLength=3
????? IndexDeltaLength=3
????? a=mpeg4-esid:101
????? a=x-envivio=verid:0001199A
????? a=control:trackID=65637

????? mdat box
????? 03 F1 27 F4
????? 6D 64 61 74:mdat


本文來自互聯網用戶投稿,該文觀點僅代表作者本人,不代表本站立場。本站僅提供信息存儲空間服務,不擁有所有權,不承擔相關法律責任。
如若轉載,請注明出處:http://www.pswp.cn/news/454938.shtml
繁體地址,請注明出處:http://hk.pswp.cn/news/454938.shtml
英文地址,請注明出處:http://en.pswp.cn/news/454938.shtml

如若內容造成侵權/違法違規/事實不符,請聯系多彩編程網進行投訴反饋email:809451989@qq.com,一經查實,立即刪除!

相關文章

hdu 5925 搜索

題意&#xff1a;一個圖&#xff0c;n個障礙&#xff0c;求聯通塊 思路&#xff1a; 圖很大&#xff0c;障礙物很少。把聯通的障礙物塊摳出來&#xff0c;然后暴力。 代碼&#xff1a; #include<bits/stdc.h> using namespace std; #define MEM(a,b) memset(a,b,sizeof(a…

分析數據庫CitusDB:提供彈性計算能力

本文講的是分析數據庫CitusDB&#xff1a;提供彈性計算能力,企業數據庫市場很龐大&#xff0c;在這個領域既有Oracle這樣行家&#xff0c;也有IBM(DB2)和微軟(SQL Server)這樣的跨界巨頭。它們都與中小企業常用到的開源數據庫MySQL一樣&#xff0c;都屬于傳統關系型數據庫。似乎…

mysql不能創建innodb類型表_MYSQL have_innodb DISABLED無法創建innodb類型的表

今天在一臺MYSQL服務器上發現&#xff0c;明明用了engineinnodb創建的表&#xff0c;結果創建出來卻成了myisam的表。再看show variables like %innodb%;have_innodb 成了DISABLED。經過一番試驗&#xff0c;發現是我關閉數據庫后&#xff0c;直接刪除ibdata1文件造成的。刪除該…

[bzoj1059]矩陣游戲

雖然是一道水難題&#xff0c;但是我這種蒟蒻還是要講一講的。 Description 小Q是一個非常聰明的孩子&#xff0c;除了國際象棋&#xff0c;他還很喜歡玩一個電腦益智游戲——矩陣游戲。矩陣游戲在一個N*N黑白方陣進行&#xff08;如同國際象棋一般&#xff0c;只是顏色是隨意的…

H264 RTP頭分析

h264 RTP頭解析流程 結合NALDecoder.c分析 協議分析 &#xff1a;每一個RTP數據報都由頭部&#xff08;Header&#xff09;和負載&#xff08;Payload&#xff09;兩個部分組成&#xff0c;其中頭部前 12 個字節的含義是固定的&#xff0c;而負載則可以是音頻或者視頻數據。 一…

golang mysql 插入_Mysql學習(一)添加一個新的用戶并用golang操作Mysql

Mysql添加一個新的用戶并賦予權限添加一個自己的用戶到mysql首先我們需要先用root用戶登錄mysql&#xff0c;但是剛安裝完沒有密碼&#xff0c;我們先跳過密碼ailumiyanaailumiyana:~/Git_Project/Go_Test$ sudo mysqld_safe --skip-grant-tables2019-01-07T01:35:51.559420Z m…

云計算構建基石之Hyper-V:虛擬機管理

本文講的是云計算構建基石之Hyper-V:虛擬機管理,作為云計算的重要基石&#xff0c;虛擬化技術的好壞起著關鍵作用。Hyper-V作為微軟重要的虛擬化解決技術&#xff0c;在微軟云計算構建解決方案中&#xff0c;更是關鍵至關鍵&#xff0c;基礎之基礎。在本系列文章中&#xff0c;…

Delphi語言最好的JSON代碼庫 mORMot學習筆記1

mORMot沒有控件安裝&#xff0c;直接添加到lib路徑,工程中直接添加syncommons&#xff0c;syndb等到uses里 --------------------------------------------------------- 在進行網絡編程中需要JSON對象的構建與解析&#xff0c;這個Delphi XE自帶&#xff1a;{$IF CompilerVers…

3GP文件格式分析

1. 概述現在很多智能手機都支持多媒體功能&#xff0c;特別是音頻和視頻播放功能&#xff0c;而3GP文件格式是手機端普遍支持的視頻文件格式。目前很多手機都支持h263視頻編碼格式的視頻文件播放&#xff0c;還有些手機支持h264。音頻文件格式普遍支持amr&#xff0c;有些手…

mysql group concat_MySQL 的 GROUP_CONCAT 函數詳解

GROUP_CONCAT(expr) 函數會從 expr 中連接所有非 NULL 的字符串。如果沒有非 NULL 的字符串&#xff0c;那么它就會返回 NULL。語法如下&#xff1a;GROUP_CONCAT 語法規則它在遞歸查詢中用的比較多&#xff0c;但要使用好它并不容易。所以讓我們一起來看看吧&#xff1a;假設有…

ORACLE數據庫 常用命令和Sql常用語句

ORACLE 賬號相關 如何獲取表及權限 1.COPY表空間backup scottexp登錄管理員賬號system2.創建用戶 create user han identified(認證) by mima default tablespace users&#xff08;默認的表空間&#xff09; quota&#xff08;配額&#xff09;10M on users;創建賬號分配權限g…

光榮之路測試開發面試linux考題之四:性能命令

Hi,大家好我是tom,I am back.今天要給大家講講linux系統一些性能相關命令。 1.fdisk 磁盤管理 是一個強大的危險命令&#xff0c;所有涉及磁盤的操作都由該命令完成&#xff0c;包括&#xff1a;新增磁盤、增刪改磁盤分區等。 1.fdisk -l 查看磁盤分區情況 Disk /dev/sda: 27.8…

一起學并發編程 - 優雅關閉

Java中原來在Thread中提供了stop()方法來終止線程&#xff0c;但這個方法是不安全的&#xff0c;所以一般不建議使用。文本將介紹兩種可以優雅的終止線程的方式...<!-- more --> 第一種 在JAVA《Java多線程模式》中有一種叫Two-Phase Termination&#xff08;兩步終止&am…

mac安裝完mysql后關機特別慢_mysql-Mac終端下遇到的問題總結

為了方便啟動mysql服務&#xff0c;修改/etc/.bash_profile文件&#xff0c;如下alias mysql"/usr/local/mysql/bin/mysql"alias mysqladmin"/usr/local/mysql/bin/mysqladmin"或者alias mysqlstart"sudo /usr/local/mysql/support-files/mysql.serve…

sending data mysql slow Mysql查詢非常慢的可能原因

1.用explain看看mysql的執行情況,可以得知,task_id掃描了近20萬條數據,而且這個task_id不是索引 2.為這個task_id所在的表,將此字段添加索引后,查詢就變得很快了 轉載于:https://www.cnblogs.com/Skrillex/p/7365590.html

mybatis 添加語句返回對象_mybatis的insert語句插入數據時的返回值的實現

mybatis的insert語句插入數據時的返回值的實現,語句,返回值,那條,都是,站長站mybatis的insert語句插入數據時的返回值的實現易采站長站&#xff0c;站長之家為您整理了mybatis的insert語句插入數據時的返回值的實現的相關內容。mybatis的sql語句一般是配置在配置文件中&#xf…

打包上架

昨天寫的打包上架&#xff0c;分組到了文章&#xff0c;發現不便查看貼鏈接到這里&#xff1a; http://www.cnblogs.com/ITCoderW/articles/7597969.html 最近一個版本的審核的過程 當我們上傳到APP Store一個新的版本后 登錄ITunes Connect就可以看到相應的版本的審核的狀態 粗…

inet_pton函數和inet_ntop函數的用法及簡單實現

http://blog.csdn.net/eagle51/article/details/53157643?utm_sourceitdadao&utm_mediumreferral 這兩個函數是隨IPv6出現的新函數&#xff0c;對于IPv4地址和IPv6地址都適用。函數名中的p和n非別代表表達&#xff08;presentation&#xff09;和數值&#xff08;numeric&…

mysql 5.7 延遲同步_MySQL5.6升級5.7時出現主從延遲問題排查過程

最近在做zabbix的數據庫MySQL5.6升級5.7時&#xff0c;出現主從延遲問題&#xff0c;這個問題困擾了很久沒有解決&#xff0c;昨天終于解決了&#xff0c;整理了一下整個排查過程&#xff0c;分享給大家。環境說明&#xff1a;mysql主庫為5.6的版本&#xff0c;有四個從庫&…

架構設計--僅是軟件開發之第二大影響力?!

SDWest2006&#xff08;譯注1&#xff09;對我來說是個有趣的大會。我除了星期三之外&#xff08;當時我正飛往費城參加一個客戶會議 因此錯過了Jolt頒獎部分&#xff09;每天都在演講。我也參加了一些談話和會議&#xff1b;其中最引人關注的是Mike Cohn的計劃與估算的談話。…