《MySQL自传》

2022-09-07 00:00:00 有个 分身 感觉 我也 分身术


  • Jimmy YangOracle InnoDB Architect.

  • MySQL ACE DirectorMySQL.

  • OceanBase.





MySQL1995523958

Monty


Monty6V3.23Oracle




251V5.information_schemaXAbug


2813V5.1OracleOracle


IOE11.11



2221211.113VitessCobarTDDLDDSMyCAT




MyISAM


InnoDBInnoDBMyISAM21InnoDBInnoDB


21318V5.6InnoDB2performance_schemaDBAAWSFacebook









OracleRAC


SHOW


SHOWSHOWDBA


show slave status; # 查看分身(备库)状态show processlist; #查看当前连接信息,可以看到当前谁在访问我,还可以看到当前运行的慢SQL了show databases;  #查看数据库列表 show tables; #查看表列表show create table t1; #查看表定义 show grants for user1; #查看用户有哪些权限show engine innodb status#查看innodb运行细节,什么死锁、内存信息都在这里了


西






#MySQL使用limit的分页语法,查看从第90条开始的10条数据select * from user order by name limit 90,10





#Oracle使用rownum分页语法 select *  from(    select rownum as rn,           a.*      from user a     order by name     where rownum<100    ) where rn>90


SQL






/


MySQL AB28SUN1亿SUNSUNSPARCCPUIntelSolarisUNIXJava29Oracle74亿SUNSUN


OracleInnoDBInnoDB25OracleBerkeryDBOracle


MontyOracleMariaDBSUNMariaDBMariaDB



OracleOracleMariaDBMariaDBPK1


仿Statement28V5.1Row 2152V5.7JSONXMLJSON2InnoDB使


OracleV5.8V8218V5.7V8.MyISAMV8InnoDBInnoDBCTESQLHash Join




31OceanBaseTiDBTDSQLSequoiaDBShardingSphereVitessHotDBAWSAuroraPolarDBGaussDBHTAP


ClickHouse仿DorisHeatWave


NoSQLMongoDBRedisNebula GraphTDengine1OracleAWS亿


OracleOracleInnoDBV9


PostgreSQL7openGauss

使MySQLMySQL



相关文章