MySQL 的新功能：地端和云端.pdf

1、Whats new in MySQLOn-premise and cloud Nipun AgarwalSenior Vice President,MySQL&HeatWaveFirst LTS Release!First LTS release April 30 8.4.0 LTSInnovation releases to start with 9.0.09.7.0 targeted LTS release-in 2 years2Copyright 2024,Oracle and/or its affiliatesFocus areas Better performanceLower co

2、stDeveloper productivity SecurityHigher availability Thread Pool ImprovementsHighly Scalable Thread-Handling Model0 01,0001,0002,0002,0003,0003,0004,0004,0005,0005,0006,0006,0007,0007,0008,0008,0009,0009,00012481632641282565121,0242,0484,0966,0008,000Transactions per SecondTransactions per SecondUse

3、rs Users Sysbench OLTP Read/Write,pareto access pattern,100GB data sizeSysbench OLTP Read/Write,pareto access pattern,100GB data sizeMySQL Enterprise Edition with Thread PoolMySQL Community Server without Thread Pool9x Better Scalablity:Sysbench OLTP Read/Write4Copyright 2024,Oracle and/or its affil

4、iatesEliminating double buffer writesAtomics*Experiments show:With ATOMIC I/O,amount of data written is similar to dblwr=OFF(half)on disk With ATOMIC I/O,time to flush is similar to dblwr=OFFCoreConfigInnoDB_DoubleWriteBuffer_pool_pages_dirtyTimeBo_sum16BP 128 GB-table=10-tablesize=40MOFF5356K00:02:

5、2283.7 GBON5356K00:34:44172.5 GBATOMIC_IO5356K00:02:2283.7 GB8BP 128 GB-table=10-tablesize=20MOFF2679K00:01:1541.9 GBON2679K00:21:5186.3 GBATOMIC_IO2679K00:01:1741.9 GB4BP 128 GB-table=5-tablesize=10MOFF1339K00:00:4920.9 GBON1339K00:11:0643.2 GBATOMIC_IO1339K00:00:4920.9 GB5Copyright 2024,Oracle and

6、/or its affiliatesEliminating double buffer writesATOMIC I/O performance at par with dblwr=OFFWrite intensive workload 6Copyright 2024,Oracle and/or its affiliatesBulk ingest support in MySQL HeatWave Parallel sort&merge and parallel build of index sub-trees Sequential writes of sorted data into dis