People who code: we want your input. Take the Survey

Questions tagged [in-memory-database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
61 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
1answer
44 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
1answer
28 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
1answer
39 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
1answer
93 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 ...
0
votes
1answer
60 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 ...
2
votes
0answers
52 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 ...
8
votes
1answer
348 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
1answer
29 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
2answers
175 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 ...
1
vote
0answers
46 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
1answer
913 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
0answers
37 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 ...
2
votes
1answer
1k 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
1answer
5k 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 ...
1
vote
1answer
254 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
1answer
2k 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
1answer
132 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
2answers
525 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
1answer
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
2answers
149 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
2answers
273 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
0answers
152 views

SQL InMemory Natively Compiled SP - unsupported constructs

We're looking at converting several normal T-SQL Stored Procedures into Natively Compiled SPs for performance. The SPs use a ton of #tmp tables - select into, delete from, update from, and several ...
0
votes
3answers
2k 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 ...
5
votes
3answers
4k 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. ...
2
votes
1answer
570 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
1answer
382 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
1answer
269 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
2answers
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. ...
0
votes
1answer
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 ...
1
vote
1answer
1k 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 ...
0
votes
0answers
194 views

In-memory file group and log are growing huge and fast

We have a DB in stress environment: SQL Server 2014 (SP1-CU3) + Always ON The whole db is around 850GB, but in some point something happens and in memory FG is growing to 250GB and a log to 450GB (...
1
vote
0answers
255 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 ...
0
votes
2answers
795 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 ...
2
votes
1answer
598 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
1answer
2k 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 ...
4
votes
1answer
286 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
1answer
44 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 ...
3
votes
1answer
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 ...
1
vote
1answer
66 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
2answers
4k 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
1answer
82 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 ...
5
votes
1answer
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
1answer
922 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
0answers
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 ...
13
votes
3answers
27k 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,...
1
vote
3answers
385 views

in-memory SQL database system [closed]

In an application, I am using mysql's TEMPORARY TABLE. Since this application does not need permanent tables, I wonder if I can find an alternative RDMS designed for memory tables. I hope to find an ...
8
votes
4answers
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 ...