Storage Typen – MySQL
Nachfolgend werden die meistverwendeten Storagetypen beschrieben:
Storage Typ | Beschreibung/Merkmale |
MyISAM Tabellen | MyISAM (My Indexed Sequential Access Method) ist eine Storage-Engine des Datenbankverwaltungssystems MySQL. Sie baut, um einige Erweiterungen ergänzt, auf dem älteren ISAM-System auf und war bis MySQL 5.1 Standard-Storage-Engine. Seit Version 5.5 wurde sie durch InnoDB als Standard-Storage-Engine abgelöst. |
HEAP und MEMORY Tabellen | The MEMORY storage engine creates tables with contents that are stored in memory. Formerly, these were known as HEAP tables. MEMORY is the preferred term, although HEAP remains supported for backward compatibility. |
InnoDB und BDB Tabellen | InnoDB ist ein freies Speichersubsystem für das Datenbankmanagementsystem MySQL. Sein Hauptvorteil gegenüber anderen Speichersubsystemen für MySQL ist, dass Transaktionssicherheit und referenzielle Integrität über Fremdschlüssel gewährleistet werden. |
ARCHIVE Tabellen | The ARCHIVE storage engine is used for storing large amounts of data without indexes in a very small footprint. |
CSV Tabellen | A comma-separated values (CSV) (also sometimes called character-separated values) file stores tabular data (numbers and text) in plain-text form. Plain text means that the file is a sequence of characters, with no data that has to be interpreted as binary numbers. A CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields. |
(Quellen: Auf den Storage Typ klicken)
Schlagwörter: Linux, mysql, storage typen
By continuing to use the site, you agree to the use of cookies. more information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.