Question : I have a mysql insert on update query like so insert into table (col1, col2, col3) values (1,2,’huge […]
Tag: storage-engine
Which MySQL table to use for read-only, bulk-loaded tables?
Question : So I have a workload on 2 key tables in my application with the following characteristics: READ-ONLY DATA […]
Understanding IAM Pages: extent intervals
Question : I’m reading Itzik’s book “Querying Microsoft SQL Server 2012” as well as reading/watching different educational material on the […]
SQL SERVER Database IO performance impact of splitting database tables into FileGroups and multiple Files per filegroup
Question : SAN LUN ambiguity wrt performance MSDN says to split read/write operations into a drive, sequential writes to another […]
What are the pros and cons of using the Sphinx Storage Engine?
Question : What are the pros/cons of using the Sphinx Storage Engine in MySQL (doc) over the normal api? Answer […]
Fastest engine for Mass Updates (only updates done on table)
Question : I have a table of 2 columns and 60 million rows. I want to update the table by […]
Best MySQL storage engine for read heavy table with two indexes
Question : I have a pretty big MySQL table (70G) with about 15 columns and 1.5M rows. There is one […]
How do I create fractal index using tokudb engine?
Question : I install MariaDb and configured it to use TokuDb Engine. I need to use Fractal-Index Built-in on TokuDb […]
MongoDB MMAPv1 vs WiredTiger storage engines
Question : In mongoDB3 appeared a new storage engine: WiredTiger. Yet, MMAPv1 is still the default choice in Mongo. One […]
What storage engine should I use for this MySQL table?
Question : I have a table where I store all the urls from my website, and I update them from […]