Enhancing Transactional Application Performance with HeatWave MySQL [THR3162].pdf

1、Enhancing Transactional Application Performance with HeatWave MySQLTHR3162 Mike FrankMySQL Product Management Director,OracleOracle CloudWorld Copyright 2024,Oracle and/or its affiliates1Enhancing Transactional Application Performance with HeatWave MySQLWhy it matters Performance ArchitecturesAutopi

2、lot ML for performance tuningObservability and MonitoringAgendaOracle CloudWorld Copyright 2024,Oracle and/or its affiliates2Oracle CloudWorld Copyright 2024,Oracle and/or its affiliates3Why High-Performance mattersHIGH-PERFORMANCE IS JUST EXPECTED IN MODERN APPLICATIONS.PeopleUsers and developers e

3、xpect instant responsiveness.BusinessApp speed boosts revenue and satisfaction.CompetitorsPerformance sets you apart from competitors.Database EfficiencyA high-performance database is the backbone of any fast and reliable app.HeatWave OLTP,OLAP,ML,Lakehouse,GenAI,Vector StoreOracle CloudWorld Copyri

4、ght 2024,Oracle and/or its affiliates4Transactions,real-time analytics across data warehouse and data lake,machine learning,GenAI in one database serviceQueriesResultsSocial,eCommerce,IoT,gaming,fintech apps Analytics/ML/GenAI toolsObject StorageDatabase exportsDatabase exportsStreaming dataData Sou

5、rcesEnterprise AppsWeb/SocialLog filesIoTMySQL databaseHeatWaveOLAPOLTPAutopilotVector storeGenAIAutoMLHeatWave MySQL for OLTPOracle CloudWorld Copyright 2024,Oracle and/or its affiliates5 Developed&operated bytheMySQL engineering Optimized for performance Default ConfigurationsareoptimizedbyShape a

6、nd Architecture Read ScaleoutTransactional applications(OLTP)InnoDB PrimaryInnoDBSecondaries and ReplicasDatabaseHeatWave MySQL is 10 x better than Aurora for OLTPOracle CloudWorld Copyright 2024,Oracle and/or its affiliates6AUTO THREAD POOLING01000200030004000500060007000141664128256512102420484096