Oracle and/or its affiliates. 5 MySQL On Premise MySQL Database Service Database High Availability Backup Security Patch & Upgrade Provision & Configure OS OS Security Patch & Upgrade OS Installation Server Hardware Purchase & Maintenance Storage Storage Purchase & Maintenance Data Center Rack & Space Power, HVAC, Networking Automated Manual
Oracle and/or its affiliates. 19 "The world's two most popular databases are the Oracle Autonomous Database and Oracle MySQL," said Oracle Chairman and CTO, Larry Ellison. "The Oracle Database once again delivered solid revenue growth in FY21. And while our Oracle Database business as measured by revenue currently dwarfs our MySQL database business—that is about to change because the latest version of Oracle MySQL has been upgraded to include a revolutionary new ultra-high-performance parallel processing query engine called HeatWave. Independent analysts have tested and confirmed that Oracle MySQL with HeatWave runs 10 to 100 times faster than Amazon's version of MySQL called Aurora. This technological breakthrough is causing several of Amazon's customers to start moving their Aurora workloads to Oracle MySQL. And industry analysts are telling us they are seeing a 10x increase in Oracle Cloud Infrastructure customer inquiries. Both the Oracle Autonomous Database and Oracle MySQL with HeatWave technology have captured the technology high-ground in the cloud database business—and that bodes well for the future of the Oracle Cloud." https://investor.oracle.com/investor-news/news-details/2021/Oracle-Announces-Fiscal-2021-Fourth-Quarter-and-Fiscal-Full-Year-Financial-Results/default.aspx
24 k S h1 (key) . . . 1 p . . . . . . R h1 (key) 1 p k . . . ① Partition ① Partition ② Build ③ Probe h2 (k) join kernel このデータが通常はCPUの下位のキャッシュに 収まるサイズに調整されている 例:JOIN処理
affiliates. 35 0 4,000 8,000 12,000 256GB 0 50,000 100,000 150,000 1TB 0 150,000 300,000 450,000 4TB Seconds 3 hrs 43 hrs 5 days 5 min 151x 高速 843x 高速 1392x 高速 Total Query Run Time With Aurora, 7 out of 22 queries did not complete within 10 hours 1 min 3 min *Benchmark queries are derived from TPC-H benchmark, but results are not comparable to published TPC-H benchmark results since they do not comply with TPC-H specification
64 Auto Parallel Loading Auto Data Placement Auto Encoding Auto Scheduling Auto Change Propagation Auto Query Time Estimation Auto Query Plan Improvement Auto Error Recovery Auto Provisioning MySQL Autopilot Data-driven Query-driven ML automation
www.mysql.com/jp MySQL ライブWebセミナー www.mysql.com/jp/news-and-events/web-seminars/ MySQL Twitter @mysql_jp MySQL YouTubeチャンネル https://www.youtube.com/c/mysql/