Stack Overflow
Stack Overflow

Questions tagged [storage-engines]

A storage engine is the underlying software component used to create, read, update and delete data from a data store.

Most database management systems include their own application programming interface (API) that allows the user to interact with their underlying engine without going through the user interface of the DBMS. Many of the modern DBMS support multiple database engines within the same database. For example, MySQL supports InnoDB as well as MyISAM.

http://en.wikipedia.org/wiki/Database_engine

75 questions
94
votes
3 answers

How do I know if a mysql table is using myISAM or InnoDB Engine?

In MySQL, there is no way to specify a storage engine for a certain database, only for single tables. However, you can specify a storage engine to be used during one session with: SET storage_engine=InnoDB; So you don't have to specify it for each…
kamal
  • 9,637
  • 30
  • 101
  • 168
90
votes
4 answers

Show tables by engine in MySQL

How would I show all tables in MySQL with a given engine, e.g. InnoDB, MyISAM, FEDERATED?
Aurelia Peters
  • 2,169
  • 1
  • 20
  • 34
79
votes
14 answers

Create mysql table directly from CSV file using the CSV Storage engine?

I just learned that MySQL has a native CSV storage engine which stores data in a Comma-Separated-Value file per table. Is it possible to create a table directly from a uploaded CSV file, something like: CREATE TABLE USERS < PATH/USERS.CSV where…
Jonathan DS
  • 2,050
  • 5
  • 25
  • 48
36
votes
3 answers

How to know which storage engine is used in mongodb?

Starting from version 3.0, mongodb support pluggable storage engine. How to know which storage engine is being used in a system?
Mayank Patel
  • 8,088
  • 5
  • 55
  • 75
21
votes
1 answer

How to check if MySQL table is UTF-8 and has storageEngine InnoDB?

Googling around just finds instructions for changing from one format to another, but I can't seem to find how exactly to make sure which of these I have first. How can I: Check what character encoding a table has? Check what storage engine a table…
GeekedOut
  • 16,905
  • 37
  • 107
  • 185
21
votes
2 answers

How to choose from MMAPV1, WiredTiger or In-Memory StorageEngine for MongoDB?

In MongoDb Documentation 3.2 I saw that they support 3 Storage Engine, MMAPV1, WiredTiger, In-Memory, it is very confusing which one to choose. I have the sensation from the description that WiredTiger is better than MMAPV1, but in other sources…
Alexandru Olaru
  • 6,842
  • 6
  • 27
  • 53
20
votes
2 answers

Explicitly set MySQL table storage engine using South and Django

I'm running into an issue that South creates the DB table for a new model as INNODB when I migrate but creates the table as MYISAM when another developer runs their own migration. The problem with this is that all my other tables are MYISAM so using…
Eron Villarreal
  • 995
  • 10
  • 15
18
votes
7 answers

See what storage engine MySQL database uses via terminal

Is there a command in terminal for finding out what storage engine my MySQL database is using?
NightHawk
  • 3,633
  • 8
  • 37
  • 56
17
votes
1 answer

Pros and Cons of the MySQL Archive Storage Engine?

For a website I am developing, I am going to store user activity information (like Facebook) and HTTP requests to the server into a MySQL database. I was going to use InnoDB as the storage engine, however, I briefly read about the Archive storage…
GateKiller
  • 74,180
  • 73
  • 171
  • 204
15
votes
3 answers

MySQL: Has anyone used the TokuDB storage engine?

Has anyone used the TokuDB storage engine for MySQL? The product web site claims to have a 50x performance increase over other MySQL storage engines (e.g. Innodb, MyISAM, etc). Here are the performance claims…
Timmyboy
  • 191
  • 1
  • 6
12
votes
1 answer

Difference between a Database & a Storage Engine

I have small doubt, can anyone help me to clear it.. My doubt is that, what is the difference between a normal DB (what we see as a DB user) & a Storage Engine. While searching about it I seen a point, A database engine (or storage engine) is the…
Sinto
  • 3,915
  • 11
  • 36
  • 70
9
votes
1 answer

My own storage engine crashes because of a too small sort_buffer

I am working on my own storage engine for MySQL. So far this storage engine works reliable and correct - but only for small (~100 MB) tables... For big tables, I get a segmentation fault, when I try to execute a query with an order by, so something…
Markus Pilman
  • 3,104
  • 3
  • 22
  • 31
9
votes
2 answers

Django set Storage Engine & Default Charset

Creating my tables from my models.py. I donno how to do 2 things - I want to specify MySQL to create some of my tables as InnoDB & some as MyISAM. How do I do it? Also I want to specify my tables DEFAULT CHARSET as utf8. How do I do it? This is…
Srikar Appalaraju
  • 71,928
  • 54
  • 216
  • 264
7
votes
4 answers

Best MySQL storage engine to use for PHP session storage

I want to use MySQL to store session variables. From what I understand this means that on every page request there will be one read and one write to the table. Which MySQL storage engine is best suited for this task? MyISAM, InnoDB , MariaDB (which…
qwertymk
  • 34,200
  • 28
  • 121
  • 184
6
votes
2 answers

How do you choose storage engines for Oracle?

Ok the question is obviously wrong as it stands, but I'm wondering how can I choose storage implementations on Oracle as I would for MySQL, say I want one table to MyIsam like and another for Archiving only and one Black Hole style for test…
Robert Gould
  • 68,773
  • 61
  • 187
  • 272
1
2 3 4 5