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, 1427🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...