› 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
q1450718943
V2EX  ›  MySQL

MySQL 空间索引求解

  •  
  •   q1450718943 · Jan 20, 2024 · 2109 views
    This topic created in 996 days ago, the information mentioned may be changed or developed.

    建表语句如下

    CREATE TABLE `nearby_user` (
      `id` int NOT NULL AUTO_INCREMENT,
      `name` varchar(30) NOT NULL DEFAULT '',
      `location` geometry NOT NULL,
      PRIMARY KEY (`id`),
      SPATIAL KEY `location` (`location`)
    ) ENGINE=InnoDB AUTO_INCREMENT=60001 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
    

    查询语句

    explain SELECT name, ST_AsText(location)
    FROM nearby_user
    WHERE MBRContains(ST_GeomFromText('Polygon((30000 15000,
                     31000 15000,
                     31000 16000,
                     30000 16000,
                     30000 15000))'), location);
    

    60w 数据不走索引,possible_keys 和 key 都是 null

    MySQL 版本:8.0.35-0ubuntu0.22.04.1

    有了解 MySQL 空间索引的大佬可以解答一下吗?

    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   1331 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 29ms · UTC 23:49 · PVG 07:49 · LAX 16:49 · JFK 19:49
    ♥ Do have faith in what you're doing.