Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [in-memory-database]

The tag has no usage guidance.

1
vote
1answer
76 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
29 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 ...
0
votes
1answer
105 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 ...
0
votes
1answer
526 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
56 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 =...
1
vote
1answer
515 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
69 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
278 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
419 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
84 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
81 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
75 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
955 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
1answer
2k 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
105 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
161 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 ...
0
votes
1answer
195 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 ...
3
votes
2answers
1k 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
1k 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
725 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
167 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
203 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
481 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
544 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 ...
2
votes
1answer
1k 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
260 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
43 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 ...
2
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
62 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
3k 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
71 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 ...
4
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
807 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
921 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 ...
12
votes
3answers
21k 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
378 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 ...