Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
Where MyISAM table will be stored and also give their formats of storage?
Home
Sql
Where MyISAM table will be stored and also give their formats of storage?
0
votes
asked
Jan 14
in
Sql
by
AdilsonLima
Where MyISAM table will be stored and also give their formats of storage?
mysql-interview-qeustions-answers
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jan 14
by
AdilsonLima
Each MyISAM table is stored on disk in three formats:
The ‘.frm’ file stores the table definition
The data file has a ‘.MYD’ (MYData) extension
The index file has a ‘.MYI’ (MYIndex) extension
Related questions
0
votes
Q: What is the difference between the LIKE and REGEXP operators?
asked
Jan 14
in
Sql
by
AdilsonLima
mysql-interview-qeustions-answers
0
votes
Q: Is Mysql query is case sensitive?
asked
Jan 14
in
Sql
by
AdilsonLima
mysql-interview-qeustions-answers
0
votes
Q: How can we convert between Unix & MySQL timestamps?
asked
Jan 14
in
Sql
by
AdilsonLima
mysql-interview-qeustions-answers
0
votes
Q: If you create a table but don't create a database then where will the table be stored?
asked
Oct 25, 2020
in
Hive
by
rahuljain1
#hive-database-create
0
votes
Q: What is the difference between MyISAM Static and MyISAM Dynamic?
asked
Jan 13
in
Sql
by
DavidAnderson
sql-interview-questions-answers
0
votes
Q: Your company is planning to use the Simple Storage Service to host objects that users will access. You need to store the photos based on the date and you also need the folder structure to be concise. There is a speculation that there would be roughly 6000 GET requests per second.
asked
Apr 29
in
AWS
by
DavidAnderson
aws-certified-cloud-practitioner-exam
0
votes
Q: Where the Mapper's intermediate data will be stored?
asked
Jun 21, 2023
in
Hadoop
by
sharadyadav1986
mapperdata
+2
votes
Q: Where does default configurations will be stored?
asked
Jul 2, 2021
in
Apache Storm
by
rajeshsharma
configuration
storm-default-configuration
0
votes
Q: Describe the role of entity group transactions in Azure Table Storage and give an example of a use case?
asked
Nov 17, 2023
in
Azure
by
GeorgeBell
azure-interview-questions-answers
+1
vote
Q: Where is table data stored in Apache Hive by default?
asked
Jun 7, 2020
in
Hive
by
SakshiSharma
#hive-data-store
#apache-hive-data
...