Questions tagged [in-memory-database]
The in-memory-database tag has no usage guidance.
52
questions
0
votes
0
answers
44
views
Capturing in-memory OLTP transaction aborted errors in SQL Server
In one of my SQL Server 2016 Enterprise instances, sp_blitzfirst is reporting hundreds of aborted transactions per second in one of my in-memory OLTP databases.
I've set up error logging with try/...
- 69
4
votes
2
answers
633
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) ...
- 43
0
votes
1
answer
231
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 ...
- 368
2
votes
0
answers
152
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 ...
- 121
1
vote
0
answers
165
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 ...
- 29
0
votes
1
answer
473
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,...
- 75
6
votes
3
answers
10k
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 (...
- 695
0
votes
1
answer
496
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 ...
- 111
1
vote
1
answer
209
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
78
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
217
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
1
answer
196
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 ...
- 101
2
votes
0
answers
255
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 ...
- 121
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.
...
- 103
2
votes
1
answer
47
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
1k
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 ...
- 38.6k
1
vote
0
answers
99
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-...
- 149
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 ...
- 4,066
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 ...
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 ...
- 151
6
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 ...
- 10.9k
1
vote
1
answer
794
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?
user158823
0
votes
1
answer
457
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
683
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 ...
- 121
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 ...
- 167
2
votes
2
answers
343
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?
- 23
1
vote
2
answers
450
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 ...
- 136
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 ...
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.
...
- 349
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 ...
- 135
0
votes
1
answer
721
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 ...
- 135
1
vote
1
answer
300
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. ...
- 131
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 ...
- 103
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,931
1
vote
0
answers
317
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 ...
- 381
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 ...
- 289
2
votes
1
answer
621
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 ...
- 121
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 ...
- 742
4
votes
1
answer
312
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 ...
- 163
0
votes
1
answer
47
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 ...
- 103
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 ...
1
vote
1
answer
74
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 "...
- 255
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 ...
- 163
1
vote
1
answer
123
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 ...
- 410
7
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 ...
- 173
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,945
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 ...
- 609
14
votes
3
answers
32k
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,...
- 877