mysql_storageengine
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| mysql_storageengine [2016/02/05 14:47] – luke7858 | mysql_storageengine [2024/05/23 07:26] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 3: | Line 3: | ||
| \\ | \\ | ||
| mysql < 5.5 the default engine is MyISAM | mysql < 5.5 the default engine is MyISAM | ||
| + | \\ | ||
| + | \\ | ||
| Before we convert tables we can first view the table engine with: | Before we convert tables we can first view the table engine with: | ||
| + | \\ | ||
| + | **Note**: Change ' | ||
| <sxh bash> | <sxh bash> | ||
| + | SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = ' | ||
| </ | </ | ||
| Now we have viewed the table engine we can go ahead and convert the tables. | Now we have viewed the table engine we can go ahead and convert the tables. | ||
mysql_storageengine.1454683630.txt.gz · Last modified: 2024/05/23 07:26 (external edit)