• Mysql 存储引擎简介

    ##1.  查看存储引擎:

    show engines;

     

    show engines \G;
    1. *************************** 1. row ***************************
    2.       Engine: InnoDB
    3.      Support: DEFAULT
    4.      Comment: Supports transactions, row-level locking, and foreign keys
    5. Transactions: YES
    6.           XA: YES
    7.   Savepoints: YES
    8. *************************** 2. row ***************************
    9.       Engine: MRG_MYISAM
    10.      Support: YES
    11.      Comment: Collection of identical MyISAM tables
    12. Transactions: NO
    13.           XA: NO
    14.   Savepoints: NO
    15. *************************** 3. row ***************************
    16.       Engine: MEMORY
    17.      Support: YES
    18.      Comment: Hash based, stored in memory, useful for temporary tables
    19. Transactions: NO
    20.           XA: NO
    21.   Savepoints: NO
    22. *************************** 4. row ***************************
    23.       Engine: BLACKHOLE
    24.      Support: YES
    25.      Comment: /dev/null storage engine (anything you write to it disappears)
    26. Transactions: NO
    27.           XA: NO
    28.   Savepoints: NO
    29. *************************** 5. row ***************************
    30.       Engine: MyISAM
    31.      Support: YES
    32.      Comment: MyISAM storage engine
    33. Transactions: NO
    34.           XA: NO
    35.   Savepoints: NO
    36. *************************** 6. row ***************************
    37.       Engine: CSV
    38.      Support: YES
    39.      Comment: CSV storage engine
    40. Transactions: NO
    41.           XA: NO
    42.   Savepoints: NO
    43. *************************** 7. row ***************************
    44.       Engine: ARCHIVE
    45.      Support: YES
    46.      Comment: Archive storage engine
    47. Transactions: NO
    48.           XA: NO
    49.   Savepoints: NO
    50. *************************** 8. row ***************************
    51.       Engine: PERFORMANCE_SCHEMA
    52.      Support: YES
    53.      Comment: Performance Schema
    54. Transactions: NO
    55.           XA: NO
    56.   Savepoints: NO
    57. *************************** 9. row ***************************
    58.       Engine: FEDERATED
    59.      Support: NO
    60.      Comment: Federated MySQL storage engine
    61. Transactions: NULL
    62.           XA: NULL
    63.   Savepoints: NULL
    64. 9 rows in set (0.00 sec)

  • 相关阅读:
    TorchDynamo初探②：Torch.FX调研和实践
    神舟通用数据库
    Greenplum数据库外部表——url_curl创建销毁
    能耗分项计量监测系统在某大型公建中的应用
    【pac文件】win10自动配置代理
    Dubbo2.7源码详解
    python数字
    K8S安装过程三：HAProxy负载均衡服务安装
    Linux——简单指令汇总
    16.使用 Dockerfile 定制镜像
  • 原文地址：https://blog.csdn.net/sinat_36572927/article/details/126131381