Skip to main content
Database Administrators

Questions tagged [storage-engine]

Ask Question

The tag has no summary.

92 questions
Newest Active Bountied Unanswered
3 votes
1 answer
189 views

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 ...
Suleyman Essa's user avatar
  • 167
1 vote
2 answers
359 views

I need to store a big amount of data (about 2.5 billion of new data rows per month), but also I need a very fast way to retrieve the latest value per group on specific time point. The data looking ...
the_it_guy's user avatar
  • 11
0 votes
1 answer
70 views

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 ...
ERJAN's user avatar
  • 483
5 votes
1 answer
851 views

SQL Server tracks page allocation in various internal bitmaps. Among these are the Global Allocation Map (GAM) and Page Free Space (PFS) pages. We know that GAM pages occur at set intervals of 511232 ...
Michael Green's user avatar
  • 25.3k
7 votes
3 answers
854 views

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 ...
Michael Green's user avatar
  • 25.3k
0 votes
1 answer
2k views

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 ...
sariDon's user avatar
  • 121
3 votes
1 answer
367 views

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.
Pavel Sapezhko's user avatar
  • 183
1 vote
1 answer
162 views

I have a MariaDb database which consists of 2 tables and which is around 10Gb of the size. One is dependendant on the other via a foreign key. How can I change the engine type of that particular db ...
Kum's user avatar
  • 57
0 votes
1 answer
132 views

"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 [...]&...
keezar's user avatar
  • 33
0 votes
2 answers
576 views

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 ...
Googlebot's user avatar
  • 4,551
1 vote
1 answer
303 views

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 ...
Karlom's user avatar
  • 165
3 votes
2 answers
2k views

I was going through Database storage engines and found out about LSM trees. I had also read about Kafka architecture and know that Kafka internally is a commit log. I want to know if Kafka internally ...
Ayman Patel's user avatar
  • 153
-1 votes
1 answer
185 views

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 ...
DB guy's user avatar
  • 69
1 vote
0 answers
56 views

I want to decentralize my databases and upload it to Sia Skynet to give the users the ability to search on front-end. It is important to be able to deal with large amounts of data, but the RAM-based ...
DaWe's user avatar
  • 119
0 votes
2 answers
155 views

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 ...
ilos-vigil's user avatar
  • 1

15 30 50 per page
1
2 3 4 5
…
7