Questions tagged [storage-engine]
The storage-engine tag has no usage guidance.
22
questions
64
votes
4
answers
141k
views
Which is faster, InnoDB or MyISAM?
How can MyISAM be "faster" than InnoDB if
MyISAM needs to do disk reads for the data?
InnoDB uses the buffer pool for indexes and data, and MyISAM just for the index?
- 2,009
10
votes
3
answers
3k
views
I am using the MEMORY storage engine but MySQL still writes to my disk...Why?
I am using the MEMORY Engine for all tables associated with a particular MYSQL query because speed of access is paramount to my project.
For some reason, I have noticed that a large amount of disk ...
- 293
2
votes
2
answers
2k
views
Which first: upgrade mysql version or convert storage engine?
I inherited a production mysql server at 5.0. It uses MyISAM exclusively. It is not a high volume database but it does have some large datasets.
I am planning on:
upgrading to 5.5
converting ...
6
votes
1
answer
4k
views
Which mysql storage engine to choose?
I'm confused about which mysql engine should I choose (lets talk about the most used : MyISAM and InnoDB).
The theories say:
Both work with BTree indexes, but MyISAM can work with FULLTEXT index ...
- 2,009
25
votes
3
answers
19k
views
Is it common practice to mix InnoDB and MyISAM tables on same server?
I've got a single database of about 4.5GB running on a server with 8GB RAM. The vast majority of the tables are MyIsam (about 4.3GB), but I'm soon going to be converting some of them to InnoDB. (It's ...
- 23.5k
3
votes
1
answer
2k
views
MySQL query 'going away' on executing INSERT ON DUPLICATE UPDATE statement with a 12524 character blob
I have a mysql insert on update query like so
insert into table (col1, col2, col3) values (1,2,'huge blob with 12524 chars') on duplicate key update col3 = 'huge blob with 12524 chars';
col1, col2 ...
2
votes
2
answers
1k
views
Any problem will all InnoDB and one MyISAM table?
I have a MySQL 5.5 DB with all InnoDB tables. For some reason, one of the developers decided to create a MyISAM table. It is a log table for user sessions. I don't see why we should mix in a MyISAM ...
- 21
15
votes
3
answers
3k
views
Speeding up conversion of MyISAM to InnoDB
I've got a mysql 5.1 server with a database of approximately 450 tables, taking up 4GB . The vast majority of these tables (all but 2) are MyIsam. This has been fine for the most part (don't need ...
- 23.5k
13
votes
1
answer
2k
views
Slot Array and Total Page Size
I continue to read in many forums and on many blogs that a page is comprised as shown below:
Page Size: 16 x 512B = 8192B
Page Header: = 96B
Maximum In_Row Row: = 8060B
This leaves (...
- 1,437
8
votes
1
answer
1k
views
Is it Possible to Recover Data from a BLACKHOLE table? [closed]
I had created table with engine BLACKHOLE basically the BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. Retrievals always return an empty ...
- 1,197
1
vote
1
answer
998
views
Can I use symlink or data directory for ARCHIVE MySQL tables?
All mention of either using a symlink or data/index separate data directories state that MyISAM is the only supported (https://dev.mysql.com/doc/refman/5.5/en/symbolic-links.html). However, I found ...
- 367
0
votes
2
answers
665
views
Unable to Convert table Engine from MyISAM to NDBCLUSTER
I followed @RolandoMySQLDBA 's tips in this thread: mysql, changing tables from myisam to ndb But I didn't succeed on the last step.
I have a similar problem, here's my original table:
CREATE TABLE ...
- 103
38
votes
7
answers
54k
views
What are reasons **NOT** to use the MEMORY storage engine in MySQL?
I recently discovered that MySQL has a "memory" engine that I wasn't aware of (most of my database work is for hobby projects so I learn what I need as I go). It seems like this option should give me ...
- 799
7
votes
3
answers
771
views
What is the stride of a GAM interval
For interest, I was reading about the internal structures of a Microsoft SQL Server file. It's fairly obvious how IAM pages are connected. However, it is not clear to me where later GAM pages are to ...
- 25k
5
votes
2
answers
4k
views
How is it possible for mysql storage engine to be NULL?
I'm just reading a book and in one of the examples I get notices:
That the engine in the information_schema.table is null, how is that possible?
Can I create tables without any engine??, is there any ...
- 2,009
4
votes
2
answers
815
views
Should I move to InnoDB during a planned migration?
I'm shortly migrating a Debian Lenny webserver to another host and Debian Squeeze. The standard MySQL installation even on Squeeze is 5.1 and therefore would default to MyISAM - I'm inclined to stick ...
- 40.1k
3
votes
1
answer
4k
views
How to export mysql databases with different ENGINE?
I'm setting up MySQL Cluster. As it uses ENGINE=NDBCLUSTER, how could I export my databases from MySQL Server specifying the ENGINE?
Is there a way to do this?
All my tables are MYISAM
- 313
2
votes
1
answer
1k
views
TokuDB database size unknown in phpmyadmin
In mysql server, I installed the TokuDB storage engine. I converted database engine InnoDB to TokuDB, but my table sizes show unknown in phpmyadmin.
- 151
2
votes
1
answer
981
views
Issues converting MyISAM table to InnoDB (auto column issue)
I'm having issues trying to convert a table from MyISAM to InnoDB in MySQL 5.6.
The following is the table dump:
--
-- Table structure for table `companies`
--
DROP TABLE IF EXISTS `companies`;
/*!...
1
vote
1
answer
698
views
What storage engine should I use for this MySQL table?
I have a table where I store all the urls from my website, and I update them from time to time when a visitor enters.
The primary key is the url itself varchar(255).
I have set it to use InnoDB but ...
0
votes
2
answers
478
views
Disabling Aria INSERT log in MariaDB [closed]
When I bulk INSERT into an Aria table, it creates a copy of the INSERT in a series of log files (aria_log.%). It can lead to full disk and crash of MySQL.
As I understand, Aria keeps a redo log for ...
- 4,541
0
votes
1
answer
2k
views
MariaDB not starting in windows 10 after crash
MariaDB 10.7 service suddenly stopped in Windows 10 after a crash and the service is not starting. The pop up shows 'windows cannot start mariadb service). The windows event viewer gives the following ...
- 121