Questions tagged [storage-engine]
The storage-engine tag has no summary.
92 questions
3 votes
1 answer
188 views
Is there a direct way to know if a merry-go-round scan happened?
In the docs it says we can share index scans (Advanced Scanning). Now here they used wait stats and statistics and i did not find an extended events session that could directly identify it. The ...
- 167
0 votes
1 answer
69 views
what is the difference between data warehouse engine, data warehouse, olap engine, olap database, data storage engine vs data storage?
I need to clarify the keyword "engine" and what functionality stands behind it. I assume engine is a smaller component of a bigger thing - database. Like a 'car engine' is inside a car. So ...
- 483
7 votes
3 answers
852 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 ...
- 25.3k
3 votes
1 answer
366 views
WiredTiger Page Size
I'm unable to find out if there is a pagesize in a WiredTiger MongoDB storage engine. I mean some analog of the innodb_page_size for MySQL.
- 183
0 votes
1 answer
132 views
Primary File Organization in DBMS - Files of ordered records (sorted files)
"Fundamental of Database Systems", 3rd ed. by Elmasri and Navathe, page 136 says: "We can physically order the records of a file on disk based on the values of one of their fields [...]&...
- 33
1 vote
1 answer
301 views
How to add sphinx engine to mysql 5.7?
On my Ubuntu 18.04 machine using mysql 5.7 I have installed sphinxsearch 2.2 and now I'd like to add SphinxSE as an engine so that I can connect to it without language-specific medium. The docs on ...
- 165
-1 votes
1 answer
184 views
MariaDB CONNECT engine to read external mongodb collections
I want to access MongoDB collections through MariaDB 10.4.17. Both are installed on my local machine running Windows 10. Software listening port MongoDB 27017 MariaDB 15501 I installed the MariaDB ...
- 69
0 votes
2 answers
152 views
What MariaDB storage engine should i use?
I have a database with size about 170GB with rows between 20.000 - 700.000.000 rows (depending on the table). Currently i'm using MyISAM storage engine. In my case, querying (READ) speed is very ...
