明輝手游網中心：是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺！

mysql學習之數據引擎的示例代碼分享

發(fā)表時間：2023-09-04 來源：明輝站整理相關軟件相關文章人氣：

[摘要]插件式存儲引擎是MySQL數據庫最重要的特征之一，用戶可以根據應用的需要尋找如何存儲和索引數據、是否使用事務等。MySQL默認支持多種存儲引擎，以適用于不同領域的數據庫應用需求，用戶可以通過選擇選擇不同的存儲引擎提供應用的效率，提供靈活的存儲查看當前數據庫支持的引擎show engines+---...
插件式存儲引擎是MySQL數據庫最重要的特征之一，用戶可以根據應用的需要尋找如何存儲和索引數據、是否使用事務等。MySQL默認支持多種存儲引擎，以適用于不同領域的數據庫應用需求，用戶可以通過選擇選擇不同的存儲引擎提供應用的效率，提供靈活的存儲

查看當前數據庫支持的引擎

show engines
+--------------------+---------+------------------------------+--------------+------+------------+
  Engine         Support   Comment          Transactions   XA    Savepoints  
+--------------------+---------+---------------------+--------------+------+------------+
  InnoDB         DEFAULT   Supports transactions, row-level locking, and foreign keys     YES       YES   YES     
  MRG_MYISAM       YES     Collection of identical MyISAM tables               NO        NO    NO      
  MEMORY         YES     Hash based, stored in memory, useful for temporary tables     NO        NO    NO      
  BLACKHOLE       YES     /dev/null storage engine (anything you write to it disappears)   NO        NO    NO      
  MyISAM         YES     MyISAM storage engine                       NO        NO    NO      
  CSV          YES     CSV storage engine                         NO        NO    NO      
  ARCHIVE        YES     Archive storage engine                       NO        NO    NO      
  PERFORMANCE_SCHEMA   YES     Performance Schema                         NO        NO    NO      
  FEDERATED       NO     Federated MySQL storage engine                   NULL       NULL   NULL     
+--------------------+---------+--------------+--------------+------+------------+
9 rows in set (0.00 sec)

或者

show engines \G
mysql> show engines \G
*************************** 1. row ***************************
   Engine: InnoDB
   Support: DEFAULT
   Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
     XA: YES
 Savepoints: YES
*************************** 2. row ***************************
   Engine: MRG_MYISAM
   Support: YES
   Comment: Collection of identical MyISAM tables
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 3. row ***************************
   Engine: MEMORY
   Support: YES
   Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 4. row ***************************
   Engine: BLACKHOLE
   Support: YES
   Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 5. row ***************************
   Engine: MyISAM
   Support: YES
   Comment: MyISAM storage engine
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 6. row ***************************
   Engine: CSV
   Support: YES
   Comment: CSV storage engine
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 7. row ***************************
   Engine: ARCHIVE
   Support: YES
   Comment: Archive storage engine
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 8. row ***************************
   Engine: PERFORMANCE_SCHEMA
   Support: YES
   Comment: Performance Schema
Transactions: NO
     XA: NO
 Savepoints: NO
*************************** 9. row ***************************
   Engine: FEDERATED
   Support: NO
   Comment: Federated MySQL storage engine
Transactions: NULL
     XA: NULL
 Savepoints: NULL
9 rows in set (0.00 sec)

Engine 引擎的名稱
Support 是否支付YES表示支持，NO表示不支持
Comment 評價或者備注 Defalut表示，默認支持的引擎
Transactions 是否支持事務，YES表示支持，NO表示不支持
XA 所有支持的分布式是否符合XA規(guī)范，YES表示支持，NO表示不支持
Savepoints 是否支持事務處理中的保存點，YES表示支持，NO表示不支持

或者

show variables like ‘have%'

mysql> show variables like 'have%';
+------------------------+----------+
  Variable_name       Value   
+------------------------+----------+
  have_compress       YES    
  have_crypt         NO     
  have_dynamic_loading    YES    
  have_geometry       YES    
  have_openssl        DISABLED  
  have_profiling       YES    
  have_query_cache      YES    
  have_rtree_keys      YES    
  have_ssl          DISABLED  
  have_statement_timeout   YES    
  have_symlink        YES    
+------------------------+----------+
11 rows in set, 1 warning (0.00 sec)

Variable_name 引擎名稱
value 是否支持YES支持，NO不支持,DISABLED表示支持但未啟用

查看默認引擎

show variables like ‘%storage_engine%'

mysql> show variables like '%storage_engine%';
+----------------------------------+--------+
  Variable_name            Value  
+----------------------------------+--------+
  default_storage_engine        InnoDB  
  default_tmp_storage_engine      InnoDB  
  disabled_storage_engines           
  internal_tmp_disk_storage_engine   InnoDB  
+----------------------------------+--------+
4 rows in set, 1 warning (0.00 sec)

InnoDB 為默認引擎

修改默認引擎

my.ini文件

[mysqld]
# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking
# enable-named-pipe
# shared-memory
# shared-memory-base-name=MYSQL
# The Pipe the MySQL Server will use
# socket=MYSQL
# The TCP/IP Port the MySQL Server will listen on 默認端口號
port=3306
# Path to installation directory. All paths are usually resolved relative to this. 服務器的默認安裝目錄
# basedir="C:/Program Files/MySQL/MySQL Server 5.7/"
# Path to the database root  數據庫數據文件的目錄
datadir=C:/ProgramData/MySQL/MySQL Server 5.7\Data
# The default character set that will be used when a new schema or table is
# created and no character set is defined 修改服務器默認字符
character-set-server=utf8
# The default storage engine that will be used when create new tables when
# 這里修改默認引擎
default-storage-engine=INNODB

修改后重啟Mysql服務

以上就是mysql學習之數據引擎的示例代碼分享的詳細內容，更多請關注php中文網其它相關文章！


學習教程快速掌握從入門到精通的SQL知識。