MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
1PLs Company - #1Payday.Loans Agency - Loans online and near me $100-$2500 (Same Day)
Powered by MySQL
 
Home / Table Types or Storage Engines / Question No: 206

How to change the default storage engine of MySQL?

Answer No: 206

The default storage engine can be changed at server startup or at runtime:

  • The default storage engine can be specified at server startup with the --default-storage-engine option.
  • For a running server, an administrator who has the SUPER privilege can change the default storage engine globally for all clients by setting the global storage_engine system variable:
    SET GLOBAL storage_engine = engine_name;

    Setting the storage engine this way affects any client that connects after the statement executes. Clients that are connected at the time of statement execution are unaffected.

  • Any client can change its own default storage engine by issuing either of these statements:
    SET SESSION storage_engine = engine_name;
    SET storage_engine = engine_name;

Related MySQL FAQs to the Above FAQ

How-to-get-storage-engines-available-on-MySQL-server How to get storage engines available on MySQL server?

What-is-default-table-type-of-MySQL What is default table type of MySQL?

How-to-convert-a-table-from-one-type-to-another-in-MySQL How to convert a table from one type to another in MySQL?

What-is-the-fastest-storage-engine-in-MySQL What is the fastest storage engine in MySQL?

What-are-transaction-safe-tables-and-not-transaction-safe-tables-in-MySQL What are transaction-safe tables and not transaction-safe tables in MySQL?

About FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us | Recommend this Site to Your Friend | Contact Us

Useful Links: Wikipedia.org | Oracle.com | w3schools.com | www.php.net | Github.com

© 2023  www.mysqlfaqs.net
All rights reserved.