Questions tagged [in-memory-database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
1k views

Is MySQL Cluster just for in-memory databases?

In MySQL website I see below definition for MySQL Cluster. MySQL Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. I want to use Clustering for a ...
4 votes
2 answers
450 views

In-memory OLTP databases take very long to recover during startup

we use SQL Server 2019 on Windows with in-memory oltp activated on some databases. After a server reboot/service restart, the in-memory databases take very long to be available (more than an hour) ...
0 votes
1 answer
115 views

SQL Server 2019 SE adoption of in-memory OLTP table consideration

i have an SQL Server database, that is almost a read-only db (the write procedure will happen at scheduled time, tipically twice a day). I have recently discovered about the in-memory table (i'am a ...
2 votes
0 answers
139 views

MySQL release memory allocated for a temp table

I'm using 5.6 MySQL database to insert tens of millions records between multiple tables. Before the insertion I send all my data into a temp memory table, for that reason I have increased both ...
5 votes
2 answers
7k views

In Memory Database Remove File and FileGroup

I have a SQL Server 2016 database and I configured in-memory table. I want to drop this configuration, then I drop that table. When I want to delete that file and filegroup, I got following error. ...
0 votes
1 answer
182 views

oracle XE 18c inmemory settings

I try to this in oracle XE 18c. I cant't alter inmemory_size property but can alter sga_target. Who relieve me? SQL> alter system set inmemory_size=200M; alter system set inmemory_size=200M * ERROR ...
10 votes
1 answer
1k views

Efficiently store large list structure in RocksDB so that the data can be retrieved in pages

Description: RocksDB is a key-value storage so we can simply serialise the list of objects & store the value corresponding to a key. This would be ok if the data in the list is small enough. ...
1 vote
0 answers
161 views

Bogus SQL Server (XTP) in-memory error 41842 claiming 4B rows updated [closed]

We run a large, very active set of in-memory (schema-only) tables - the main table has been split (sharded) into 5 separate databases because the table is a total size of > 50gb (Standard Edition ...
0 votes
1 answer
428 views

How to run postgres in-memory on windows and sync to FS when a temer runs out?

So Progress is slow for me (in terms of query and update times) on SSD and it is ok in my case: I use it as a mix of Graph database + Table processor + NoSQL JSON trees so lots of loops, graphs, trees,...
5 votes
2 answers
8k views

Is it possible to have a temporary, on-the-fly PostgreSQL table which only ever lives in RAM?

I know that PostgreSQL automatically uses RAM only for tables that are small enough. But I'm not just talking about the data inside the table, but about the entire table itself. Basically, I've (...
0 votes
1 answer
448 views

How to configure InnoDB/MariaDB to not fill ibdata1 with (rollback/undo?) data that is useless in an in-memory database? [closed]

I'm trying to run a tiny (~100-200 MB) database in-memory, but ibdata1 grows out of control. Situation: MariaDB is running on a resource constrained HW (Raspberry, 1GB RAM), storing non-critical ...
1 vote
1 answer
189 views

How to enable INMEMORY JOIN GROUP in Oracle 12.2

I have read official Oracle documentation on INMEMORY JOIN GROUP and run code from their tutorials. However I unable to successfully create INMEMORY JOIN GROUP. Installed database is Oracle 12.2 ...
1 vote
1 answer
71 views

where is memory going in In-Memory OLTP?

I have only memory optimized table in my database. When I am running below query, I am getting pages_mb for that DB as 710 MB. SELECT type , name , memory_node_id , pages_kb/1024 AS pages_MB ...
0 votes
1 answer
213 views

In Memory OLTP causing OOM Issue in SQL Server even though no data in In Memory OLTP Table

We have only 1 memory optimized table in each database and there are total 10 databases as such. This table is completely empty. But still we can see in DBCC MEMORYSTATUS Output that In memory OLTP is ...
3 votes
1 answer
2k views

Slow inserts in oracle 12c inmemory table

We are running some tests to check the in-memory performance on a 12c (12.1.0.2.4 EE) RAC. Servers have 56GB memory and 20core CPUs. Our plan is to have a few read-performance critical tables in ...
2 votes
0 answers
222 views

Do concurrent in-memory databases exist?

I spent days searching the internet but all the databases I found are at most in-memory but not concurrent. By concurrency I mean that they run on multiple threads and can do multiple reads ...
2 votes
1 answer
45 views

Literature about In-Memory Database Systems [closed]

I am currently writing my bachelor thesis on IMDBS and would like to ask if any of you have any recommendations for literature which summarizes the technical conception/architecture of IMDBS as ...
2 votes
2 answers
969 views

Is an in-memory table faster to read from than a table cached in memory?

Is an in-memory (aka Hekaton) table faster to read from than a non-in-memory table that's already cached in the memory of a SQL server? I ask this because I have a case where I'm considering ...
5 votes
1 answer
11k views

Keep H2 in-memory database between connections

I create and use a H2 database in-memory (no writing to storage) for demos and quick tests using this code in Java: Connection conn = DriverManager.getConnection( "jdbc:h2:mem:example_db" ) ; This ...
2 votes
1 answer
2k views

MySQL is not releasing memory after memory tables are dropped

After creating several tables of memory engine and dropping them, mysqld is not releasing all the corresponding memory. Below are the exact steps to reproduce the problem. Memory usage is observed ...
1 vote
0 answers
89 views

Are OLAP / NoSql / In-Memory database mutually exclusive concepts or can there be overlap between them?

I'm a data scientist with little knowledge of DB technology. I keep hearing 3 types of databases mentioned as key technologies for analytics and modeling solutions: NoSql databases OLAP cubes In-...
2 votes
1 answer
3k views

In memory table vs temporary table - benefits if temdb in already on ram disk

In the docs, we have example of how temporary tables can be replaced with in-memory tables and because a memory-optimized table: is stored only in memory, and has no component on disk involves no IO ...
0 votes
0 answers
50 views

SQL Server 2017 - In Memory and Native Compilation

I've been using these features experimentally, but have, to date, encountered 3 big issues. Runtime errors have put the database into a suspect state. This has happened twice. Complicated ...
1 vote
1 answer
735 views

is there a way (clean or unclean) to eliminate a filestream data file on a production SQL Server database?

Is there a way (clean or unclean) to eliminate a filestream data file on a production database? I forced a garbage collection on an empty filestream : sp_filestream_force_garbage_collection @dbname =...
3 votes
1 answer
3k views

Can Entity Framework access In Memory OLTP Tables?

Are there any restrictions with having Entity Framework access In Memory OLTP Tables? Or is this not possible?
0 votes
1 answer
425 views

how to shrink(and also reduce size on disk) a very big log file in SQL server 2016 [duplicate]

I have a datawarehouse with database log of 800 GB.now I want to shrink it or reduce the disk space occupied by Log.ldf file. I tried to shrink file in several ways - took full backup , performned ...
1 vote
2 answers
665 views

MySQL XtraDB/Galera Cluster High Availability RamDisk *SuperFast*

Ok, So this is going to be a speculative question, mostly design oriented and a rather long one. I'd grab a cuppa' covfefe, if I were you. Preface: So I have been researching into databases and ...
0 votes
1 answer
1k views

How to enable Oracle Database In-Memory feature in Oracle 11g R2 to reduce report generation time?

Problem: Each report generation takes a few hours in Oracle 11g R2 and a few tens of reports has to be generated every day. Objective: To reduce report generation time Understood: a) "reports that ...
2 votes
2 answers
316 views

Which user defined data type is memory optimized?

How can i know which one of my uddts is memory optimized? and how can i know it's definition?
1 vote
2 answers
414 views

Why would my Oracle read from disk?

[Copied from ServerFault to what seems like a better-suited forum] Our Oracle server (version 12c) is running on a RedHat-6.7 server with 128GB of RAM. The current size of the only database on it is ...
0 votes
3 answers
3k views

SQL server in memory table performace [closed]

I am using Microsft SQL Server 2016. I have an SQL table with 140000 rows. It is used only for selecting data. I am trying to increase it's selection performance by making it In-Memory table (it is ...
4 votes
1 answer
309 views

Can Oracle TimesTen (or 12c's In-Memory) benefit from GPU?

I have looked into TimesTen and In-Memory recently. They claim they use SIMD (Single instruction, multiple data) to speed up queries. We use HP DL380 G9 Servers for our DB. Since This series are ...
0 votes
1 answer
2k views

mongodb inMemory engine available in the community edition?

I'm currently working with MongoDB 3.2.10 and I recently heard of the new "inMemory" engine. After some research I found that it was available in the Enterprise Edition since version 3.2.6, but I ...
2 votes
1 answer
1k views

Are Delete operations written to AppendOnlyFile in Redis?

AppendOnlyFile in Redis logs every write operation done to the redis database. My Question is that when we delete data from the redis database, are those operations logged in the AppendOnlyFile ? And ...
0 votes
1 answer
698 views

What happens redis uses all allocated memory?

I am quite new to redis and try to learn and explore the structure and architecture of redis. Before version 2.4, there was Virtual Memory option available in redis by which one could swap the ...
1 vote
1 answer
2k views

SQLServer In-Memory database and log file size unexpected increase

I have a strange issue with a SQLServer 2014 (12.0.4439.1) database. I created some months ago a data file and table to play with In-Memory basic features and see if could improve some of our ...
1 vote
1 answer
294 views

Why Java Pool is not a required component of Oracle SGA?

Why Java Pool is not a required component of Oracle SGA? As we know SGA has many components, I mean: Java Pool Shared pool Large Pool Data Buffer cache Others... I took an exam and I saw that ...
2 votes
2 answers
2k views

In memory database error: table is full

I got hit by error "Tale is full" on my in memory database. My database is 4.5GB in size and has 300 partitions. I run MySql 5.6.17 version_compile_machine=x86_64 on 64 bit Windows 10, 16GB ram. ...
1 vote
0 answers
304 views

SQLite vs MemSQL vs other SQLAlchemy compatible in memory databses

What is the recommended in-memory database which connects to SQLAlchemy? Requirements: Connects to SQLAlchemy. Minimal memory usage when empty (it will store <50MB). Easy to work with (e.g. Kafka ...
14 votes
3 answers
31k views

ALTER DATABASE statement not allowed within multi-statement transaction

I've downloaded the AdventureWorks based In-memory sample from here, and followed all the steps described in the accompanying doc. However, when I try to run the script in SQL Server Management Studio,...
8 votes
4 answers
2k views

What advantages does in-memory OLAP have over traditional systems with significant memory?

Do in-memory OLAP engines have advantages over the traditional OLAP engines backed by enough RAM to contain the entire cube(s)? For example, if I use a MOLAP engine (SSAS) and GB / TB of RAM where ...
2 votes
1 answer
614 views

Memory Table and Disk Table

I'm running a pretty big (or maybe I should call it SELECT & INSERT-intensive) database. Now I've heard here and there that a MEMORY-based table is better for my situation (since I now run on a ...
3 votes
1 answer
3k views

Using ddl triggers with in-memory tables

I've created server scope ddl trigger to audit user activities on the server. Now if someone tries to create in-memory table the statement fails with the following error: Error SQL72014: .Net ...
0 votes
1 answer
46 views

Can not install a database, can I still learn though?

I am given access to a domain where I can put my code in and it will go public, like in this example. In order to store the data right now, I am using PHP and I write the data to a file. When the page ...
1 vote
1 answer
73 views

Provides Oracle's database in-memory?

I'm trying to find out, if Oracle's newest database release 12c comes per default as an in-memory database or does it use TimesTen for this feature? According to Wikipedia (Oracle Database) it "...
3 votes
2 answers
5k views

Calculating RAM requirements for an in-memory database [closed]

In general, how much RAM does an in-memory database require? I would assume it requires enough RAM for: Operating system and general system services, plus DBMS, plus the entire database (same amount ...
1 vote
1 answer
121 views

What is the disadvantage of maintaining both row and column table storage?

I just watched Oracle's In Memory database release. I can understand that removing a lot OLAP indexes accelerated the database a bit. But does that really mean maintaining 2 table storages doesn't ...
6 votes
1 answer
3k views

Oracle TimesTen vs Oracle database in-memory

Oracle has recently announced its latest Oracle database in-memory feature in 12c. Oracle already had an in-memory database TimesTen and now I was wondering as to what the the differences between ...
5 votes
1 answer
1k views

SQL Server 2014 In Memory OLTP - Garbage Collection on Transaction Rollback

In SQL Server 2014, In Memory OLTP, What happens, if a transaction is rolled back and newly created version of row is no more required. Is it duty of garbage collector to remove even such type of rows ...
2 votes
0 answers
1k views

In-memory database vs RAM-disk

In SQLite, are there any differences in performance/features/reliability/... between: 1) an in-memory database: rc = sqlite3_open("file::memory:", &db); 2) a database on a RAM-disk? The ...