Open Source Tutorials - Open Source Training
Open source training & tutorials from experienced, passionate people
chrome icon firefox icon ie icon opera icon safari icon Sings in these Browsers
A- A A+

By A Web Design

Welcome, Guest
Username Password: Remember me

Static and Dynamic MyISAM
(1 viewing) (1) Guest
All your queries regarding
MySQL Installation,
Learning MySQL DBA,
and tonnes more... will be solved in this forum
  • Page:
  • 1
TOPIC:

Static and Dynamic MyISAM

Static and Dynamic MyISAM 1 year, 10 months ago #50

  • kate
  • OFFLINE
  • Senior Boarder
  • Posts: 47
  • Karma: 0
Hi,

What is the difference between MyISAM Static and MyISAM Dynamic?

Re:Static and Dynamic MyISAM 1 year, 10 months ago #58

  • manav
  • OFFLINE
  • Senior Boarder
  • Posts: 51
  • Karma: 0
In MyISAM static all the fields have fixed width. The Dynamic MyISAM table would include fields such as TEXT, BLOB, etc. to accommodate the data types with various lengths. MyISAM Static would be easier to restore in case of corruption, since even though you might lose some data, you know exactly where to look for the beginning of the next record.
  • Page:
  • 1
Time to create page: 1.21 seconds
OSV Newsletter


Receive HTML?

NOTE: To prevent subscription to the OSV newsletter, uncheck the checkbox above.
Guest Blog for OSV
Free Ebook Download