Statements (102)
| Predicate | Object |
|---|---|
| gptkbp:instance_of |
gptkb:cloud_storage
|
| gptkbp:allows |
table compression
|
| gptkbp:can_be_configured_for |
my.cnf file
|
| gptkbp:can_be_used_with |
gptkb:PHP
|
| gptkbp:developed_by |
gptkb:My_SQL_AB
|
| gptkbp:has |
three table types
data files with . MYD extension index files with . MYI extension limited crash recovery capabilities |
| gptkbp:has_limitations |
maximum row size
non-transactional applications table size limits |
| gptkbp:has_relationship_with |
False
|
| https://www.w3.org/2000/01/rdf-schema#label |
My ISAM
|
| gptkbp:introduced_in |
gptkb:My_SQL_3.23
|
| gptkbp:is |
widely used in legacy systems
a default storage engine in My SQL 5.1 and earlier a fast storage engine for read operations a file-based storage engine a legacy storage engine a non-transactional storage engine a part of My SQL's architecture a part of My SQL's history a popular choice for simple applications a simple storage engine a storage engine that can be easily backed up a storage engine that can lead to table corruption a storage engine that is easy to use a storage engine that is often replaced by Inno DB a storage engine that lacks row-level locking a storage engine that supports large tables a storage engine with limitations a widely recognized storage engine deprecated in newer My SQL versions faster for read operations than Inno DB not ACID compliant not designed for high write loads not recommended for data integrity not recommended for new applications not suitable for complex transactions not suitable for high availability systems not suitable for large-scale applications suitable for small to medium-sized applications a storage engine that is not suitable for mission-critical applications |
| gptkbp:is_ac |
gptkb:cloud_storage
|
| gptkbp:is_accessible_by |
My SQL command line
|
| gptkbp:is_compatible_with |
gptkb:My_SQL_5.7
Linux and Windows My SQL versions prior to 5.5 |
| gptkbp:is_effective_against |
Inno DB for write operations
|
| gptkbp:is_less_flexible_than |
Inno DB for schema changes
|
| gptkbp:is_not_acandidate_for |
data warehousing
|
| gptkbp:is_not_transactional |
gptkb:true
|
| gptkbp:is_optimized_for |
read-heavy operations
read-heavy workloads read operations over write operations REPAIR TABLE command |
| gptkbp:is_part_of |
gptkb:My_SQL
open-source software ecosystem LAMP stack My SQL database management system |
| gptkbp:is_recommended_by |
developers for simplicity
|
| gptkbp:is_recommended_for |
read operations
read-heavy applications |
| gptkbp:is_supported_by |
gptkb:php_My_Admin
My SQL community |
| gptkbp:is_used_for |
logging purposes
|
| gptkbp:is_used_in |
content management systems
data analysis tools web applications e-commerce platforms reporting tools |
| gptkbp:is_vulnerable_to |
table corruption
|
| gptkbp:provides |
fast read operations
|
| gptkbp:reliability |
gptkb:Inno_DB
|
| gptkbp:replaced_by |
gptkb:Inno_DB
gptkb:My_SQL_8.0 |
| gptkbp:requires |
manual backup
manual backup procedures |
| gptkbp:security |
gptkb:Inno_DB
|
| gptkbp:speed |
Inno DB for read operations
|
| gptkbp:storage |
. MYD files
up to 256 TB of data |
| gptkbp:stores_index_in |
. MYI files
|
| gptkbp:suitable_for |
real-time applications
mission-critical applications high-availability systems small to medium-sized applications high-volume transaction processing high-concurrency environments high-concurrency write operations |
| gptkbp:supported |
transactions
|
| gptkbp:supports |
foreign key constraints
multiple key types dynamic row format full-text indexing multiple key indexes |
| gptkbp:type_of |
False
|
| gptkbp:uses |
table-level locking
|
| gptkbp:uses_table_level_locking |
gptkb:True
|
| gptkbp:bfsParent |
gptkb:My_SQL
|
| gptkbp:bfsLayer |
4
|