传统数据库DBA到开源的技能和心理切换——开源数据库专场（32页）.pdf

1、?o?o?o?o?o?o?o?o?o?o?01?DocumentDocumentKeyKey ValueValueRelationalRelationalDBaaSDBaaSNewSQLNewSQLBigBig tablestablesGraphGraphNonNon-RelationalRelationalOperationalOperationalPiccoloPiccoloNoSQLOLAPOLTPNoSQLNoSQLAnalyticAnalytic?New Future on Cloud02?u:0a=1 s7on,scn,=571s1=or53,=4r1a0=0,=571,7:=:1

2、,=571,0:=:2,scn=:3,scn,wr:=:4,scn,bas=:5,nu7,7a:5n3s=:(,=57,scn,7a:=:)w41r1=4r1a0=0 an0 scn=(s161c=75n(scn 2ro7 s7on,scn,=571 w41r1=4r1a0=0?sc5 select FROM_UNIXTIME(1558519237,%Y-%m-%d%H:%i:%S);+-+|FROM_UNIXTIME(1558519237,%Y-%m-%d%H:%i:%S)|+-+|2019-05-22 18:00:37|+-+1 row in set(0.00 sec)mysql sele

3、ct UNIX_TIMESTAMP(2019-05-22 18:00:37);+-+|UNIX_TIMESTAMP(2019-05-22 18:00:37)|+-+|1558519237|+-+1 row in set(0.02 sec)?1(1(05?738 84537825611)5*67)(1(./.(1(/#!#/0?1(1(05?738 84537825611)5*67)(1(./.(1(/#!#/0?9o;!)?1(1(05?Binlog Event Common Header?mysql SET TIMESTAMP=UNIX_TIMESTAMP(1999-01-01);Query

4、 OK,0 rows affected(0.00 sec)mysql select now(),sysdate(),sleep(3),now(),sysdate();+-+-+-+-+-+|now()|sysdate()|sleep(3)|now()|sysdate()|+-+-+-+-+-+|1999-01-01 00:00:00|2019-09-04 11:27:29|0|1999-01-01 00:00:00|2019-09-04 11:27:32|+-+-+-+-+-+1 row in set(3.00 sec)?New Future on Cloud?New Future on Cl

5、oud?New Future on Cloud03?WAIT#1:nam=direct path read ela=43 p1=1 p2=1 p3=1WAIT#1:nam=direct path read ela=4 p1=2 p2=1 p3=1WAIT#1:nam=direct path read ela=3 p1=3 p2=1 p3=1WAIT#1:nam=direct path read ela=2 p1=4 p2=1 p3=1WAIT#1:nam=direct path read ela=2 p1=201 p2=1 p3=1WAIT#1:nam=db file sequential r

6、ead ela=88 p1=1 p2=417 p3=1WAIT#1:nam=db file sequential read ela=91 p1=1 p2=377 p3=1=PARSING IN CURSOR#2 len=188 dep=1 uid=0 oct=1 lid=0 tim=1149404325230977 hv=0 ad=b700de24create table bootstrap$(line#number not null,obj#number not null,sql_textvarchar2(4000)not null)storage(initial 50K objno 56