03-深度解析 AliSQL 8.0 特性和改进（23页）.pdf

1、冷香阿里云智能高级技术专家深度解析 AliSQLAliSQL 8.08.0 特性和改进赵建伟高级技术专家云智能-OLTP产品部-AliSQL 内核小组Agenda Performance Insight&DiagnosePerformance Insight&Diagnose New FeatureNew Feature Stability ImprovementStability ImprovementAgenda Performance Insight&DiagnosePerformance Insight&Diagnose New FeatureNew Feature Stability

2、 ImprovementStability ImprovementPerformance InsightDBADBA和开发视角和开发视角TransactioTransaction nBinlogBinlogSizeSizeLock CountLock CountElapsed Elapsed TimeTimeObjectObjectRead WriteRead WriteIndex Index UsageUsageStatementStatementCPU/Elapsed CPU/Elapsed TimeTimeMDL/Trans MDL/Trans LockLockIO StatsIO St

3、atsConcurrencyConcurrency研发视角Performance SchemaPerformance Insight Object StatisticsObject StatisticsTable statistics 是业务系统 scale 的数据支撑Index statistics 是业务系统优化 index 的数据支撑Performance Insight Statement StatisticsStatement StatisticsCPU ELAPSED_TIME CPU_TIMELOCK SERVER_LOCK_TIME TRANSACTION_LOCK_TIMEC

4、oncurrency MUTEX_SPINS MUTEX_WAITS RWLOCK_SPIN_WAITS RWLOCK_SPIN_ROUNDSIO DATA_READS DATA_WRITES LOGICAL_READS PHYSICAL_READS PHYSICAL_ASYNC_READSPerformance Insight Statement StatisticsStatement StatisticsCPU IntensiveMDL BlockTrans BlockPerformance Insight Statement StatisticsStatement StatisticsI

5、O IntensiveConcurrencyPerformance Diagnose 云产品深度依赖，可诊断性至关重云产品深度依赖，可诊断性至关重要要Slot:10000Interval:2SDurable:5HInnoDB IO 表现Agenda Performance Insight&DiagnosePerformance Insight&Diagnose New FeatureNew Feature Stability ImprovementStability ImprovementSequence EngineSequence Syntax:Sequence Syntax:CREATE

6、 CREATE SEQUENCE IF NOT EXISTS SEQUENCE IF NOT EXISTS schema.seqschema.seqSTART WITH START WITH MINVALUE MINVALUE MAXVALUE MAXVALUE INCREMENT BY INCREMENT BY CACHE CACHE|NOCACHE|NOCACHECYCLE|NOCYCLECYCLE|NOCYCLE;SELECT NEXTVAL(SELECT NEXTVAL(seqseq););SELECT CURRVAL(SELECT CURRVAL(seqseq););InnoDBHa