acid Questions
10
Solved
What is the relationship between ACID and database transaction?
Does ACID give database transaction or is it the same thing?
Could someone enlighten this topic.
Conflux asked 18/9, 2010 at 3:35
12
In my production error logs I occasionally see:
SQLSTATE[HY000]: General error: 1205
Lock wait timeout exceeded; try
restarting transaction
I know which query is trying to access the databas...
Whitener asked 14/5, 2011 at 7:7
32
Is there any NoSQL data store that is ACID compliant?
4
I came across a situation where I started doubting whether the two-phase commit protocol really guarantees the ACID properties, especially the 'A' part of it.
Let's look at a theoretical distribute...
Antagonistic asked 9/1, 2011 at 14:39
4
Solved
EDIT This questions is no longer valid as the issue was something else. Please see my explanation below in my answer.
I'm not sure of the etiquette so i'l leave this question in its' current state...
Camelback asked 25/4, 2013 at 13:21
4
Solved
From the docs of atomic()
atomic blocks can be nested
This sound like a great feature, but in my use case I want the opposite: I want the transaction to be durable as soon as the block decorat...
Litigant asked 27/9, 2016 at 8:17
3
Solved
What is the exact difference between the two locking read clauses:
SELECT ... FOR UPDATE
and
SELECT ... LOCK IN SHARE MODE
And why would you need to use one over the other?
Endicott asked 28/9, 2015 at 16:26
2
If I read and write a single file using normal IO APIs, writes are guaranteed to be atomic on a per-block basis. That is, if my write only modifies a single block, the operating system guarantees t...
9
Solved
Clarified Question:
When the OS sends the command to write a sector to disk is it atomic? i.e. Write of new data succeeds fully or old data is left intact should the power fail immediately followin...
1
Solved
In my understanding, mysql binlog can fully function as InnoDB's redo log.
So, after the binlog is enabled, why does InnoDB have to write a redo log at the same time instead of just switching to ...
Silverplate asked 18/9, 2019 at 0:25
2
There are NoSQL ACID (distributed) databases, despite CAP theorem. How this is possible? What's the relation between CAP theorem and (possible/not possible of) being ACID?
Is impossible for a di...
Palmetto asked 27/5, 2013 at 19:23
2
MongoDB now support multi-document ACID Transactions.
With this update, is it safe to say that MongoDB can now be used for financial applications involving financial transactions such as pay...
Androecium asked 6/10, 2018 at 4:36
1
Solved
Wiki says；
Repeatable read:
In this isolation level, a lock-based
concurrency control DBMS implementation keeps read and write locks
(acquired on selected data) until the end of the transact...
Syzygy asked 24/1, 2018 at 8:12
1
Solved
I'm pretty new at implementing microservice architecture and this question is breaking my mind
How a microservice architecture address transactional mechanism between different end-points calls.
...
Colonic asked 27/8, 2018 at 0:47
1
I have an external table mapped in Hive (v2.3.2 on EMR-5.11.0) that I need to update with new data around once a week. The merge consists of a conditional upsert statement.
The table's location is...
1
Solved
I am developing an application where I am using MongoDB as database with Nodejs + Express in application layer, I have two collections, namely
users
transactions
Here i have to update wallet o...
Arango asked 8/7, 2018 at 0:57
10
Solved
I am not a database expert and have no formal computer science background, so bear with me. I want to know the kinds of real world negative things that can happen if you use an old MongoDB version ...
5
Solved
Sorry for the ignorant question, but what kind of applications wouldn't require an ACID compliant database server? I have a SQL Server background where ACID has always "been there", and now researc...
Pt asked 25/4, 2011 at 18:15
1
I do pagination of large result sets with Cassanda 2.2 using the java client and PagingState like described here: https://datastax.github.io/java-driver/2.2.0-rc2/features/paging/
That works prett...
Jeopardize asked 5/10, 2015 at 17:39
1
My Hive version is 0.13. I have two tables, table_1 and table_2
table_1 contains:
customer_id | items | price | updated_date
------------+-------+-------+-------------
10 | watch | 1000 | 2017062...
4
Solved
I noticed the following occurrence in both Oracle and PostgreSQL.
Considering we have the following database schema:
create table post (
id int8 not null,
title varchar(255),
version int4 no...
Hampstead asked 19/9, 2016 at 7:9
2
Solved
I'm having trouble finding some examples that do three of the following things:
1) Allow raw sql transactions in golang.
2) Use prepared statements.
3) Rollback on query failures.
I would like ...
Guinna asked 16/10, 2016 at 23:24
3
Solved
What is difference between Atomicity and consistency ? it looks to me as both are saying same thing in different word.
Atomicity
All tasks of a transaction are performed or none of them are. There ...
5
Solved
I am newbie to database and SQL Server.
So when i have search things about database on internet i have found that The Database said to be good if it obey or follow the ACID (Atomicity, Consistency...
Ion asked 9/7, 2011 at 9:0
1
Solved
I need an implementation of an Atomic Counter on cloud to produce a serial integer from concurrent connections. The business behind is a tracking server.
Requirements by priority:
(MUST) Dur...
Bcd asked 23/10, 2016 at 1:42
1 Next >
© 2022 - 2024 — McMap. All rights reserved.