› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
virus94
V2EX  ›  MySQL

MySQL 手册中的 dive into 该怎么理解?

  •  
  •   virus94 · Jan 7, 2019 · 4952 views
    This topic created in 2858 days ago, the information mentioned may be changed or developed.

    在看 mysql5.7 的手册,看到 Optimization 章节时,发现这一段

     • Otherwise, any index on col_name is nonunique and the optimizer can estimate the row count for each
    range using dives into the index or index statistics.
    
    With index dives, the optimizer makes a dive at each end of a range and uses the number of rows in the
    range as the estimate. For example, the expression col_name IN (10, 20, 30) has three equality
    ranges and the optimizer makes two dives per range to generate a row estimate. Each pair of dives yields
    an estimate of the number of rows that have the given value.
    
      Index dives provide accurate row estimates, but as the number of comparison values in the expression
    increases, the optimizer takes longer to generate a row estimate. Use of index statistics is less accurate
    than index dives but permits faster row estimation for large value lists.
    

    查了一下有道词典,dive 翻译为潜水,俯冲,知乎上有个 DBA 翻译了这个章节,也翻译成潜水,总感觉不对.

    请教各位,这里面的 dive 和 dive into 该如何理解?

    3 replies  •  2019-03-24 16:54:06 +08:00
    mywaiting
    mywaiting
    Jan 7, 2019❤️1
    1
    dive into 理解为“深入”?
    fkdog
    fkdog
    Jan 7, 2019
    2
    不止 dive into,还有 dig into,
    isrfr
    isrfr
    Mar 24, 2019 via Android
    3
    植入?
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   4941 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 35ms · UTC 08:46 · PVG 16:46 · LAX 00:46 · JFK 03:46
    ♥ Do have faith in what you're doing.