Questions about innodb
Read more about innodb
python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Does MySQL rollback transaction on conflict
I am using Mysql with Innodb 5.7 with REPEATBLE READ isolation level.
I know that with MVCC, readers dont block writers and vice versa.
I want to understand how InnoDB behaves when there are 2 concurr...
Saurav Prakash
Votes: 0
Answers: 3
MySQL DELETE from two tables does not delete all records
innodb_version: 10.3.34
version: 10.3.34-MariaDB-0ubuntu0.20.04.1
Simple query:
DELETE `anode`, `adevice`
FROM `adevice`
JOIN `adevice_node`
ON `adevice_node`.`device` = `adevice`.`id`
JOIN `anode...
Avorthoren
Votes: 0
Answers: 0
Deadlocks happened when massive inserting executed simultaneously in mysql 5.0
I am using mysql 5.0 and I met some mysql deadlock problems when there were lots of inserts from different session at the same time (We estimated there would be a maximum about 900 insert statements e...
Xavier-Lam
Votes: 0
Answers: 0
Splitting database table for performance?
I have one MySQL innodb table storing data for my web service that is heavily used. I am wondering if splitting it into two tables(with identical schema) and having my web service balance load between...
Jessica
Votes: 0
Answers: 1