Collections:
Data Removed in MEMORY Tables in MySQL
What Happens to MEMORY Tables When MySQL Server Is Stopped in MySQL?
✍: FYIcenter.com
If you have data rows stored in a table with the MEMORY storage engine, and the MySQL server has been shut down by the DBA, all data rows will be removed. But the table structure will remain in the server.
The tutorial exercise below shows you a good example of using MEMORY tables:
>cd \mysql\bin\mysql -u dev -piyf fyi mysql> INSERT INTO fyi_memory (id) VALUES (-1); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO fyi_memory (id, count) VALUES (-2, 987); Query OK, 1 row affected (0.01 sec) mysql> SELECT * FROM fyi_memory; +----+-------+-------+ | id | title | count | +----+-------+-------+ | -1 | NULL | NULL | | -2 | NULL | 987 | +----+-------+-------+ 2 rows in set (0.00 sec) mysql> quit; >\mysql\bin\mysqladmin -u root -pretneciyf shutdown >\mysql\bin\mysqld-max >\mysql\bin\mysql -u dev -piyf fyi mysql> SELECT * FROM fyi_memory; Empty set (0.00 sec)
⇒ Show Storage Engines Supported in MySQL in MySQL
⇐ Tables Using MEMORY Storage Engine in MySQL
2017-08-08, 1420🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...