What is a storage engine.How to prevent the use of a particular storag

1.	What is a storage engine.How to prevent the use of a particular storage engine?
Answer» A DATABASE engine (or storage engine) is the underlying software component that a database management system (DBMS) uses to create, read, UPDATE and delete (CRUD) data from a database. The disabled_storage_engines configuration OPTION defines which storage engines cannot be used to create tables or tablespaces. By default, disabled_storage_engines is empty (no engines disabled), but it can be SET to a comma-separated list of one or more engines.

What is a storage engine.How to prevent the use of a particular storage engine?

Answer»

A DATABASE engine (or storage engine) is the underlying software component that a database management system (DBMS) uses to create, read, UPDATE and delete (CRUD) data from a database.

The disabled_storage_engines configuration OPTION defines which storage engines cannot be used to create tables or tablespaces. By default, disabled_storage_engines is empty (no engines disabled), but it can be SET to a comma-separated list of one or more engines.

Discussion

No Comment Found

Related InterviewSolutions

What are Roles in MySQL and briefly explain any three
What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?
What are MySQL aliases
Creating a table with query
How to change the data type of requireDate field in query
What is a routine and how is it created
What is datatype set
What is character set in MySQL. What is the default character set in MySQL
What is a storage engine.How to prevent the use of a particular storage engine?
What is PDO and the reasons to prefer it over MySQLi

What is a storage engine.How to prevent the use of a particular storage engine?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment