The storage-engine tag has no wiki summary.
9
votes
2answers
2k 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 ...
9
votes
1answer
320 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 ...
8
votes
3answers
19k 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?
8
votes
3answers
830 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 ...
7
votes
2answers
2k 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 ...
7
votes
3answers
739 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 ...
5
votes
1answer
154 views
What are the pros and cons of using the Sphinx Storage Engine?
What are the pros/cons of using the Sphinx Storage Engine in MySQL (doc) over the normal api?
4
votes
2answers
457 views
What storage engines work with Oracle?
http://en.wikipedia.org/wiki/Database_engine
mentions about database engines aka storage engines. What all storage engines can be used with the Oracle database?
4
votes
3answers
2k views
Is MariaDB a suitable drop in replacement for MySQL on a standard LAMP stack?
I've been wondering lately what (if any) are the improvements available in MariaDB over 'conventional' MySQL?
I understand that where platform interoperability and/or backwards compatibility may be ...
4
votes
1answer
130 views
Which MySQL storage engine is the most similar to ARCHIVE when that is not available?
I have a table that contains a log of events that is written to often and read very infrequently by comparison. I would love to use the ARCHIVE engine, because it is basically designed for exactly ...
4
votes
1answer
99 views
Why does my heap not fill its pages completely while an identical clustered index can fill to m_freeCnt = 0?
-- Example 1: With Clustered Index
CREATE TABLE tbl5
(
i VARCHAR(900) NOT NULL
) ;
GO
CREATE CLUSTERED INDEX CIX_tbl5
ON tbl5 (i ASC) ;
GO
INSERT INTO tbl5
( i )
VALUES
...
3
votes
2answers
537 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 ...
3
votes
1answer
319 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 ...
3
votes
3answers
3k views
How to Add Federated engine after installing Mysql
I have Mysql 5.5.18
and upon show engines:
show engines;
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine ...
3
votes
1answer
87 views
Which MySQL table to use for read-only, bulk-loaded tables?
So I have a workload on 2 key tables in my application with the following characteristics:
READ-ONLY DATA
The data is bulk-loaded in a fully consistent manner from a single process on a schedule, ...
2
votes
2answers
313 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 ...
2
votes
1answer
88 views
Is the Memory engine adequate for a read intensive/lookup table?
I have an InnoDB table with just two columns, a VARCHAR(20) and a DATETIME, and around 4M rows. This table serves as a blacklist for other tables, and is truncated and recreated from a csv file from ...
2
votes
1answer
681 views
Any disadvantages to enabling federated storage engine?
We've encountered a couple use cases where having federated tables prove useful, despite their limitations and caveats.
As best I can tell this must be enabled with a federated declaration in the ...
2
votes
1answer
287 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 ...
1
vote
1answer
72 views
Does SQL Server check disk space before allocating a new page?
I have a bet with my old boss. I bet her that SQL Server, when allocating a new extent, always allocates from the buffer pool and never checks to see whether there is some place on disk where the ...
1
vote
1answer
113 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 ...
1
vote
2answers
42 views
Which MySQL engine should i use where most operations are read operations
I want to develop an application for which i will need a database to store data. I am using MySQL as backend. My question is Which MySQL engine should i use?
Well, i have mentioned some important ...
1
vote
1answer
76 views
Issue with Storage Engine
Just got the below error in one of the slave. I just Googled it and changed the variable myisam_data_pointer_size from 4 to 6.
Somehow, my ALTER TABLE was successful.
Can you please let me know ...
1
vote
1answer
2k views
Do you still use MyISAM or prefer Aria storage engine?
If Aria storage engine (previously called Maria) is the "new" MyISAM, which supports transaction and automatic crash recovery:
Why still use MyISAM ?
Should changing storage engine from MyISAM to ...
1
vote
2answers
310 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 ...
1
vote
1answer
183 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 ...
1
vote
1answer
65 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
1answer
51 views
Is there a query to set a table's engine to innodb if it's not already?
I can set a (MyISAM) table's engine to InnoDB using the query:
alter table tablename engine=InnoDB
which takes some time to complete for large tables. It appears though that if I run the same query ...
1
vote
1answer
99 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 ...
0
votes
2answers
98 views
Best MySQL storage engine for read heavy table with two indexes
I have a pretty big MySQL table (70G) with about 15 columns and 1.5M rows.
There is one index on the autoincrement id and one on a foreign key (integer). Apart from that there are several VARCHAR and ...
