ืคึผืจืึธื”ืึธืกื˜ืขืจ > ื‘ืœืึธื’ > ืื™ื ื˜ืขืจื ืขื˜ ื ื™ื™ึทืขืก > ืžืขืœื“ื•ื ื’ ืคื•ืŸ ื“ื™ ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ DBMS TiDB 4.0

ืžืขืœื“ื•ื ื’ ืคื•ืŸ ื“ื™ ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ DBMS TiDB 4.0

ื‘ื ื™ืžืฆื ืžืขืœื“ื•ื ื’ ืคื•ืŸ ืึท ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ DBMS TiDB 4.0, ื“ืขื•ื•ืขืœืึธืคึผืขื“ ืื•ื ื˜ืขืจ ื“ืขืจ ื”ืฉืคึผืขื” ืคื•ืŸ Google ื˜ืขืงื ืึทืœืึทื“ื–ืฉื™ื– Spanner ะธ F1. TiDB ื’ืขื”ืขืจื˜ ืฆื• ื“ืขืจ ืงืึทื˜ืขื’ืึธืจื™ืข ืคื•ืŸ โ€‹โ€‹ื›ื™ื™ื‘ืจื™ื“ HTAP (Hybrid Transactional / Analytical Processing) ืกื™ืกื˜ืขืžืขืŸ, ื•ื•ืึธืก ืื™ื– ื‘ื™ื›ื•ืœืช ืฆื• ืฆื•ืฉื˜ืขืœืŸ ืคืึทืงื˜ื™ืฉ-ืฆื™ื™ื˜ ื˜ืจืึทื ื–ืึทืงืฉืึทื ื– (OLTP) ืื•ืŸ ืคึผืจืึทืกืขืกื™ื ื’ ืึทื ืึทืœื™ืกื™ืก. ื“ื™ ืคึผืจื•ื™ืขืงื˜ ืื™ื– ื’ืขืฉืจื™ื‘ืŸ ืื™ืŸ Go and ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ ื“ื•ืจืš ืœื™ื™ืกืึทื ืกื˜ ืื•ื ื˜ืขืจ ืึทืคึผืึทื˜ืฉื™ 2.0.

ืคึฟืขื™ึดืงื™ื™ื˜ืŸ ืคื•ืŸ TiDB:

  • SQL ืฉื˜ื™ืฆืŸ ืื•ืŸ ื˜ื ื™ื™ึท ืคื•ืŸ ืึท ืงืœื™ืขื ื˜ ืฆื•ื‘ื™ื ื“ ืงืึทืžืคึผืึทื˜ืึทื‘ืึทืœ ืžื™ื˜ ื“ื™ MySQL ืคึผืจืึธื˜ืึธืงืึธืœ, ื•ื•ืึธืก ืกื™ืžืคึผืœืึทืคื™ื™ื– ื“ื™ ืึทื“ืึทืคึผื˜ื™ื™ืฉืึทืŸ ืคื•ืŸ ื™ื’ื–ื™ืกื˜ื™ื ื’ ืึทืคึผืœืึทืงื™ื™ืฉืึทื ื– ื’ืขืฉืจื™ื‘ืŸ ืคึฟืึทืจ MySQL ืฆื• TiDB, ืื•ืŸ ืื•ื™ืš ืึทืœืึทื•ื– ื“ื™ ื ื•ืฆืŸ ืคื•ืŸ ืคึผืจืึธืกื˜ ืงืœื™ืขื ื˜ ืœื™ื™ื‘ืจืขืจื™ื–. ืื™ืŸ ืึทื“ื™ืฉืึทืŸ ืฆื• ื“ื™ MySQL ืคึผืจืึธื˜ืึธืงืึธืœ, ืื™ืจ ืงืขื ืขืŸ ื ื•ืฆืŸ ืึท JSON-ื‘ืื–ื™ืจื˜ ืึทืคึผื™ ืื•ืŸ ืึท ืงืึทื ืขืงื˜ืขืจ ืคึฟืึทืจ ืกืคึผืึทืจืง ืฆื• ืึทืงืกืขืก ื“ื™ DBMS.
  • SQL ืคึฟืขื™ึดืงื™ื™ื˜ืŸ ืฉื˜ื™ืฆืŸ ื™ื ื“ืขืงืกื™ื–, ื’ืขืžื™ื™ื ื–ืึทื ืคืึทื ื’ืงืฉืึทื ื–, GROUP BY, ORDER BY, DISTINCT ืื•ื™ืกื“ืจื•ืงืŸ, ืžืขืจื“ื–ืฉื™ื– (ืœื™ื ืงืก ืคืึทืจื‘ื™ื ื“ืŸ / ืจืขื›ื˜ ืคืึทืจื‘ื™ื ื“ืŸ / ืงืจื™ื™ึทื– ืคืึทืจื‘ื™ื ื“ืŸ), ืงื•ืงืŸ, ืคึฟืขื ืฆื˜ืขืจ ืคืึทื ื’ืงืฉืึทื ื– ืื•ืŸ ืกืึทื‘ืงื•ื•ืขืจื™ื–. ื“ื™ ืฆื•ื’ืขืฉื˜ืขืœื˜ ืงื™ื™ืคึผืึทื‘ื™ืœืึทื˜ื™ื– ื–ืขื ืขืŸ ื’ืขื ื•ื’ ืฆื• ืึธืจื’ืึทื ื™ื–ื™ืจืŸ ืึทืจื‘ืขื˜ ืžื™ื˜ TiDB ืคึฟืึทืจ ืึทื–ืึท ื•ื•ืขื‘ ืึทืคึผืœืึทืงื™ื™ืฉืึทื ื– ื•ื•ื™ PhpMyAdmin, ื’ืึธื’ืก ืื•ืŸ ื•ื•ืึธืจื“ืคึผืจืขืกืก;
  • ื”ืึธืจื™ื–ืึธื ื˜ืึทืœ ืกืงืึทืœืึทื‘ื™ืœื™ื˜ื™ ืื•ืŸ ืฉื•ืœื“ ื˜ืึธืœืขืจืึทื ืฅ: ืกื˜ืึธืจื™ื“ื–ืฉ ื’ืจื™ื™ืก ืื•ืŸ ืคึผืจืึทืกืขืกื™ื ื’ ืžืึทื›ื˜ ืงืขื ืขืŸ ื–ื™ื™ืŸ ื’ืขื•ื•ืืงืกืŸ ื“ื•ืจืš ืคืฉื•ื˜ ืงืึทื ืขืงื˜ื™ื ื’ ื ื™ื™ึท ื ืึธื•ื“ื–. ื“ืึทื˜ืŸ ื–ืขื ืขืŸ ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ ืึทืจื™ื‘ืขืจ ื ืึธื•ื“ื– ืžื™ื˜ ื™ื‘ืขืจื™ืงื™ื™ึทื˜, ืึทืœืึทื•ื™ื ื’ ืึธืคึผืขืจืึทืฆื™ืข ืฆื• ืคืึธืจื–ืขืฆืŸ ืื•ื™ื‘ ื™ื—ื™ื“ ื ืึธื•ื“ื– ืคืึทืจืœืึธื–ืŸ. ืคื™ื™ืœื™ืขืจื– ื–ืขื ืขืŸ ื›ืึทื ื“ืึทืœื“ ืื•ื™ื˜ืึธืžืึทื˜ื™ืฉ.
  • ื“ืขืจ ืกื™ืกื˜ืขื ื’ืขืจืึทื ื˜ื™ื– ืงืึธื ืกื™ืกื˜ืขื ืกื™ ืื•ืŸ ืคึฟืึทืจ ื“ื™ ืงืœื™ืขื ื˜ ื•ื•ื™ื™ื›ื•ื•ืืจื’ ืขืก ืงื•ืงื˜ ื•ื•ื™ ืื™ื™ืŸ ื’ืจื•ื™ืก DBMS, ื˜ืจืึธืฅ ื“ืขืจ ืคืึทืงื˜ ืึทื– ืื™ืŸ ืคืึทืงื˜, ื“ืึทื˜ืŸ ืคื•ืŸ ืคื™ืœืข ื ืึธื•ื“ื– ื–ืขื ืขืŸ ื’ืขืฆื•ื™ื’ืŸ ืฆื• ืคืึทืจืขื ื“ื™ืงืŸ ื“ื™ ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ.
  • ืฆื• ืคื™ื–ื™ืงืœื™ ืงืจืึธื ื“ืึทื˜ืŸ ืื•ื™ืฃ ื ืึธื•ื“ื–, ืคืึทืจืฉื™ื“ืขื ืข ื‘ืึทืงืขื ื“ื– ืงืขื ืขืŸ ื–ื™ื™ืŸ ื’ืขื•ื•ื™ื™ื ื˜, ืœืžืฉืœ, ื”ื™ื’ืข ืกื˜ืึธืจื™ื“ื–ืฉ ืขื ื“ื–ืฉืึทื ื– GoLevelDB ืื•ืŸ BoltDB ืึธื“ืขืจ ืื•ื ื“ื–ืขืจ ืื™ื™ื’ืขื ืข ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ ืกื˜ืึธืจื™ื“ื–ืฉ ืขื ื“ื–ืฉืึทื ื– TiKV ืื•ืŸ ื˜ื™ืคืœืึทืฉ. TiKV ืกื˜ืึธืจื– ื“ืึทื˜ืŸ ืื™ืŸ ืกื˜ืจื™ื ื’ืก ืื™ืŸ ืฉืœื™ืกืœ / ื•ื•ืขืจื˜ ืคึฟืึธืจืžืึทื˜ ืื•ืŸ ืื™ื– ืžืขืจ ืึธืคึผื˜ื™ืžืึทืœ ืคึฟืึทืจ ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ ืคึผืจืึทืกืขืกื™ื ื’ ื˜ืึทืกืงืก (OLTP). TiFlash ืกื˜ืึธืจื– ื“ืึทื˜ืŸ ืื™ืŸ ืึท ืงืึธืœื•ืžื ืขืจ ืฉื˜ื™ื™ื’ืขืจ ืื•ืŸ ืึทืœืึทื•ื– ืื™ืจ ืฆื• ื“ืขืจื’ืจื™ื™ื›ืŸ ื”ืขื›ืขืจ ืคืึธืจืฉื˜ืขืœื•ื ื’ ื•ื•ืขืŸ ืกืึทืœื•ื•ื™ื ื’ ืึทื ืึทืœื™ืกื™ืก ืคึผืจืึธื‘ืœืขืžืก (OLAP).
  • ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื™ื™ืกื™ื ื’ืงืจืึทื ืึทืกืœื™ ื˜ื•ื™ืฉืŸ ื“ื™ ืกื˜ืึธืจื™ื“ื–ืฉ ืกื˜ืฉืขืžืึท, ืึทืœืึทื•ื™ื ื’ ืื™ืจ ืฆื• ืœื™ื™ื’ืŸ ืฉืคืืœื˜ืŸ ืื•ืŸ ื™ื ื“ืขืงืกื™ื– ืื•ื™ืฃ ื“ื™ ืคืœื™ืขืŸ ืึธืŸ ืกื˜ืึธืคึผืคึผื™ื ื’ ื“ื™ ืคึผืจืึทืกืขืกื™ื ื’ ืคื•ืŸ ืึธื ื’ืึธื™ื ื’ ืึทืคึผืขืจื™ื™ืฉืึทื ื–.

ืื™ืŸ ื“ื™ ื ื™ื™ึทืข ืžืขืœื“ื•ื ื’:

  • ื“ื•ืจืš ืคืขืœื™ืงื™ื™ึทื˜, ื“ื™ ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ ืžื™ืกื˜ ืงืึทืœืขืงื˜ืขืจ ื’ืจื™ืŸ ื’ืง ืื™ื– ืขื ื™ื™ื‘ืึทืœื“, ื•ื•ืึธืก ืงืขื ืขืŸ ื‘ืื˜ื™ื™ื˜ื™ืง ืคืึทืจื’ืจืขืกืขืจืŸ ื“ื™ ื’ื™ื›ืงื™ื™ึทื˜ ืคื•ืŸ ืžื™ืกื˜ ื–ืึทืžืœื•ื ื’ ืื™ืŸ ื’ืจื•ื™ืก ืงืœืึทืกื˜ืขืจื– ืื•ืŸ ืคึฟืึทืจื‘ืขืกืขืจืŸ ืคืขืกื˜ืงื™ื™ึทื˜;
  • ืฆื•ื’ืขื’ืขื‘ืŸ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื’ืจื•ื™ืก ื˜ืจืึทื ื–ืึทืงืฉืึทื ื–, ื“ื™ ื’ืจื™ื™ืก ืคื•ืŸ ื•ื•ืึธืก ืื™ื– ืœื™ืžื™ื˜ืขื“ ื›ึผืžืขื˜ ื“ื•ืจืš ื“ื™ ื’ืจื™ื™ืก ืคื•ืŸ ื’ืฉืžื™ื•ืช ื–ื›ึผืจื•ืŸ. ื“ื™ ื’ืจื™ื™ืก ืœื™ืžื™ื˜ ืคึฟืึทืจ ืึท ืื™ื™ืŸ ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ ืื™ื– ื’ืขื•ื•ืืงืกืŸ ืคื•ืŸ 100 ืžื‘ ืฆื• 10 ื’ื™ื’ืื‘ื™ื™ื˜;
  • ืฆื•ื’ืขื’ืขื‘ืŸ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื‘ืึทืงืงื•ืคึผ ืื•ืŸ ืจื™ืกื˜ืึธืจื™ื ื’ ืงืึทืžืึทื ื“ื– ืคึฟืึทืจ ื‘ืึทืงืึทืคึผ;
  • ืฆื•ื’ืขื’ืขื‘ืŸ ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ืฉื˜ืขืœืŸ ืœืึทืงืก ืื•ื™ืฃ ื˜ื™ืฉืŸ;
  • ืฆื•ื’ืขืœื™ื™ื’ื˜ MySQL-ืงืึทืžืคึผืึทื˜ืึทื‘ืึทืœ ืœื™ื™ืขื ืขืŸ-ืžื“ืจื’ื” ื˜ืจืึทื ืกืึทืงื˜ื™ืึธืŸ ืืคื’ืขื–ื•ื ื“ืขืจื˜ืงื™ื™ื˜ ืžืขืงืึทื ื™ื–ืึทื (ืœื™ื™ืขื ืขืŸ ืงืึทืžื™ื˜ืึทื“);
  • ืึทื“ื“ืขื“ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ LIKE ืื•ืŸ WHERE ืื•ื™ืกื“ืจื•ืงืŸ ืฆื• ื“ื™ "ADMIN SHOW DDL JOBS" ื‘ืึทืคึฟืขืœ;
  • ืฆื•ื’ืขื’ืขื‘ืŸ ื“ื™ oom-use-tmp-storage ืคึผืึทืจืึทืžืขื˜ืขืจ, ื•ื•ืึธืก ืึทืœืึทื•ื– ืื™ืจ ืฆื• ื ื•ืฆืŸ ืฆื™ื™ึทื˜ื•ื•ื™ื™ึทืœื™ืง ื˜ืขืงืขืก ืฆื• ืงืึทืฉ ื™ื ื˜ืขืจืžื™ื“ื™ื™ื˜ ืจืขื–ื•ืœื˜ืึทื˜ืŸ ื•ื•ืขืŸ ืขืก ืื™ื– ื ื™ื˜ ื’ืขื ื•ื’ื™ืง ื‘ืึทืจืึทืŸ;
  • ืฆื•ื’ืขื’ืขื‘ืŸ ื“ื™ ืจืึทื ื“ืึธื ืงื™ื•ื•ืขืจื“ ืฆื• ื‘ืึทืฉื˜ื™ืžืขืŸ ื˜ืจืึทืค ื•ื•ืึทืœื•ืขืก ืฆื• ืึทื˜ืจื™ื‘ื™ื•ืฅ;
  • ื“ื™ LOAD DATA ื‘ืึทืคึฟืขืœ ืื™ืฆื˜ ื”ืื˜ ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื ื•ืฆืŸ ื”ืขืงืกืึทื“ืขืกื™ืžืึทืœ ืื•ืŸ ื‘ื™ื™ื ืขืจื™ ืื•ื™ืกื“ืจื•ืงืŸ;
  • ืฆื•ื’ืขื’ืขื‘ืŸ 15 ืคึผืึทืจืึทืžืขื˜ืขืจืก ืฆื• ืงืึธื ื˜ืจืึธืœื™ืจืŸ ื“ื™ ื ืึทื˜ื•ืจ ืคื•ืŸ ื“ื™ ืึธืคึผื˜ื™ืžื™ื–ืขืจ;
  • ืฆื•ื’ืขืœื™ื™ื’ื˜ ืžื›ืฉื™ืจื™ื ืคึฟืึทืจ ื“ื™ืึทื’ื ืึธืกื™ื ื’ ื“ื™ ืคืึธืจืฉื˜ืขืœื•ื ื’ ืคื•ืŸ SQL ืงื•ื•ื™ืจื™ื–. ืฆื•ื’ืขื’ืขื‘ืŸ ืึท ืงืœืึธืฅ ืคื•ืŸ ืคึผืึทืžืขืœืขืš ืงื•ื•ื™ืจื™ื–, ืฆื•ื˜ืจื™ื˜ืœืขืš ื“ื•ืจืš ื“ื™ SLOW_QUERY / CLUSTER_SLOW_QUERY ืกื™ืกื˜ืขื ื˜ื™ืฉืŸ;
  • ืฆื•ื’ืขืœื™ื™ื’ื˜ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ืคืึทื ื’ืงืฉืึทื ื– ืคึฟืึทืจ ืืจื‘ืขื˜ืŸ ืžื™ื˜ ืกื™ืงื•ื•ืึทื ืกื™ื–;
  • ืฆื•ื’ืขื’ืขื‘ืŸ ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื“ื™ื ืึทืžื™ืงืึทืœืœื™ ื˜ื•ื™ืฉืŸ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืœื™ื™ืขื ืขืŸ ืคึฟื•ืŸ ืคึผื“ (ืคึผืœื™ื™ืกืžืึทื ื˜ ื“ืจื™ื™ื•ื•ืขืจ, ืงื ื•ื™ืœ ืคืึทืจื•ื•ืึทืœื˜ื•ื ื’ ืกืขืจื•ื•ืขืจ). ืฆื•ื’ืขืœื™ื™ื’ื˜ ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื ื•ืฆืŸ ื“ื™ "SET CONFIG" ืื•ื™ืกื“ืจื•ืง ืฆื• ื˜ื•ื™ืฉืŸ ื“ื™ ืกืขื˜ื˜ื™ื ื’ืก ืคื•ืŸ PD / TiKV ื ืึธื•ื“ื–.
  • ืึทื“ื“ืขื“ ืžืึทืงืก-ืกืขืจื•ื•ืขืจ-ืงืึทื ืขืงืฉืึทื ื– ื‘ืึทืฉื˜ืขื˜ื™ืงืŸ ืฆื• ื‘ืึทื’ืจืขื ืขืฆืŸ ื“ื™ ืžืึทืงืกื™ืžื•ื ื ื•ืžืขืจ ืคื•ืŸ ืกื™ื™ืžืึทืœื˜ื™ื™ื ื™ืึทืก ืงืึทื ืขืงืฉืึทื ื– ืฆื• ื“ื™ ืกืขืจื•ื•ืขืจ (ืคืขืœื™ืงื™ื™ึทื˜ 4096);
  • ื™ืžืคึผืจื•ื•ื•ื“ ืคืึธืจืฉื˜ืขืœื•ื ื’ ืื™ืŸ ืกื™ื˜ื•ืึทื˜ื™ืึธื ืก ื•ื•ื• ื“ื™ ื’ืขื‘ืขื˜ืŸ ืฉืคืืœื˜ืŸ ื–ืขื ืขืŸ ื’ืึธืจ ื‘ืื“ืขืงื˜ ื“ื•ืจืš ื™ื ื“ืขืงืกื™ื–;
  • ืฆื•ื’ืขืœื™ื™ื’ื˜ ืึธื ืคึฟืจืขื’ ืึทืคึผื˜ืึทืžืึทื–ื™ื™ืฉืึทืŸ ื‘ืื–ื™ืจื˜ ืื•ื™ืฃ ืื™ื ื“ืขืงืก ืžืขืจื“ื–ืฉื™ื ื’;
  • ื™ืžืคึผืจื•ื•ื•ื“ ืคืึธืจืฉื˜ืขืœื•ื ื’ ืคื•ืŸ ืึทืคึผืขืจื™ื™ืฉืึทื ื– ืžื™ื˜ ื•ื•ืขืจื˜ ืจื™ื™ื ื“ื–ืฉืึทื–;
  • ืจื™ื“ื•ืกื˜ ืงืคึผื• ืžืึทืกืข ื“ื•ืจืš ืงืึทื˜ืฉื™ื ื’ ื“ื™ ืจืขื–ื•ืœื˜ืึทื˜ืŸ ืคื•ืŸ ืึทืงืกืขืก ื™ื ื“ืขืงืกื™ื– ืื•ืŸ ืคื™ืœื˜ืขืจื™ื ื’ ื“ื•ืคึผืœื™ืงืึทื˜ืŸ;
  • ืฆื•ื’ืขืœื™ื™ื’ื˜ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ืึท ื ื™ื™ึท ืจื•ื“ืขืจืŸ ืกื˜ืึธืจื™ื“ื–ืฉ ืคึฟืึธืจืžืึทื˜ ื•ื•ืึธืก ืึทืœืึทื•ื– ืื™ืจ ืฆื• ืคืึทืจื’ืจืขืกืขืจืŸ ื“ื™ ืคืึธืจืฉื˜ืขืœื•ื ื’ ืคื•ืŸ ื˜ื™ืฉืŸ ืžื™ื˜ ืึท ื’ืจื•ื™ืก ื ื•ืžืขืจ ืคื•ืŸ ืฉืคืืœื˜ืŸ;
  • ื“ื™ GROUP_CONCAT ืคื•ื ืงืฆื™ืข ืื™ืฆื˜ ืฉื˜ื™ืฆื˜ ื“ื™ "ORDER BY" ืื•ื™ืกื“ืจื•ืง;
  • ืฆื•ื’ืขื’ืขื‘ืŸ ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ืขืงืกื˜ืจืึทืงื˜ ื“ืึทื˜ืŸ ืคื•ืŸ ื“ื™ ื˜ื™ืคืœืึทืฉ ืงืœืึธืฅ ื“ื•ืจืš ืกืงืœ;
  • ื“ื™ RECOVER TABLE ื‘ืึทืคึฟืขืœ ืื™ืฆื˜ ืฉื˜ื™ืฆื˜ ืจื™ืกื˜ืึธืจื™ื ื’ ื˜ืจืึทื ื’ืงื™ื™ื˜ื™ื“ ื˜ื™ืฉืŸ;
  • ืฆื•ื’ืขื’ืขื‘ืŸ DDLJobs ืกื™ืกื˜ืขื ื˜ื™ืฉ ืฆื• ืึธื ืคืจืขื’ ื“ืขื˜ืึทื™ืœืก ื•ื•ืขื’ืŸ DDL ืึทืจื‘ืขื˜ ื“ื•ืจื›ืคื™ืจื•ื ื’;
  • ืฆื•ื’ืขืœื™ื™ื’ื˜ ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื ื•ืฆืŸ ื“ื™ SHOW CONFIG ื‘ืึทืคึฟืขืœืŸ ืฆื• ื•ื•ื™ื™ึทื–ืŸ PD ืื•ืŸ TiKV ืกืขื˜ื˜ื™ื ื’ืก;
  • ืื•ื™ืกื’ืขืœืืฉืŸ ืงืึธื•ืคึผืจืึทืกืขืกืขืจ ืงืึทืฉ ื“ื•ืจืš ืคืขืœื™ืงื™ื™ึทื˜;
  • ื“ื™ ื ื•ืžืขืจ ืคื•ืŸ ืงืึธืจืึธื•ื˜ื™ื ืขืก (ื’ืึธืจืึธื•ื˜ื™ื ืขืก) ืื™ืŸ ื“ื™ ืจื™ื˜ืจื™ื•ื•ื™ื ื’ ืคืึทืกืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ืึท ื™ื‘ืขืจื’ืขื‘ืŸ ืงืขื ืขืŸ ืื™ืฆื˜ ื–ื™ื™ืŸ ืงืึทื ื˜ืจืึธื•ืœื“ ื ื™ืฆืŸ ื“ื™ ืงืึทืžื™ื˜ืขืจ-ืงืึทื ืกืขืจืึทื ืก ื‘ืึทืฉื˜ืขื˜ื™ืงืŸ;
  • ืฆื•ื’ืขื’ืขื‘ืŸ ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ืึทืจื•ื™ืกื•ื•ื™ื™ึทื–ืŸ ื˜ื™ืฉ ืฆืขื˜ื™ื™ืœื•ื ื’ ืžืงื•ืžื•ืช;
  • ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื‘ืึทื’ืจืขื ืขืฆืŸ ื“ื™ ื’ืจื™ื™ืก ืคื•ืŸ ืฆื™ื™ึทื˜ื•ื•ื™ื™ึทืœื™ืง ืกื˜ืึธืจื™ื“ื–ืฉ ืื™ื– ืฆื•ื’ืขื’ืขื‘ืŸ ืฆื• tidb-server;
  • ืฆื•ื’ืขืœื™ื™ื’ื˜ ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื“ื™ ืึทืคึผืขืจื™ื™ืฉืึทื ื– "ืึทืจื™ื™ึทื ืœื™ื™ื’ืŸ ืื™ืŸ ื˜ื‘ืœ_ื ืึทืžืข ืฆืขื˜ื™ื™ืœื•ื ื’ (ื˜ื™ื™ืœื•ื ื’_ื ืึทืžืข_ืœื™ืกื˜)" ืื•ืŸ "ืคืึทืจื‘ื™ื™ึทื˜ืŸ ืื™ืŸ ื˜ื‘ืœ_ื ืึทืžืข ืฆืขื˜ื™ื™ืœื•ื ื’ (ื˜ื™ื™ืœ_ื ืึทืžืข_ืœื™ืกื˜)";
  • ืื™ืŸ ื“ื™ ื”ืึทืฉ ื’ืขื ื™ืฆื˜ ืคึฟืึทืจ ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’, ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ืคึฟื™ืœื˜ืจื™ืจื•ื ื’ ื‘ืื–ื™ืจื˜ ืื•ื™ืฃ ื“ื™ ืึทื˜ืจื™ื‘ื™ื•ื˜ "ืื™ื– ื ืึทืœ" ืื™ื– ืฆื•ื’ืขื’ืขื‘ืŸ;
  • ืคึฟืึทืจ ืคึผืึทืจื˜ื™ืฉืึทื ื“ ื˜ื™ืฉืŸ, ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ืื™ื ื“ืขืงืก ื˜ืฉืขืง, ืงืœื™ื ืึทืคึผ ืื•ืŸ ืคืึทืจืจื™ื›ื˜ืŸ ืึทืคึผืขืจื™ื™ืฉืึทื ื– ืื™ื– ืฆื•ื’ืขื’ืขื‘ืŸ.

ืžืงื•ืจ: opennet.ru

ืœื™ื™ื’ืŸ ืึท ื‘ืึทืžืขืจืงื•ื ื’