Questions tagged [in-memory-database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
189 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
0answers
11 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-...
0
votes
1answer
1k 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 ...
0
votes
0answers
11 views

Script to alert me that a droplet resize is necessary for PostgreSQL DB to fit into memory?

I am trying to answer the question, "How big is my PostgreSQL DB relative to memory on my Ubuntu server?" The goal of asking this question is to be able to alert me to when the size of my database is ...
0
votes
2answers
524 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 ...
1
vote
1answer
130 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
30 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
1answer
63 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 =...
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. ...
1
vote
1answer
714 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
76 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
337 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
552 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
91 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
87 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
88 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
1k 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
1answer
262 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
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 ...
2
votes
1answer
137 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
186 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
785 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
1answer
210 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
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
0answers
176 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
215 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 ...
12
votes
3answers
22k 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
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 ...
2
votes
1answer
562 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 ...
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
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
72 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
822 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
944 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 ...
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 ...