| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 12:59:12 GMT
content-type: text/html; charset=utf-8
cf-ray: 963b5a86dea55917-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=fe61d8f9-9be8-4db4-8369-79f520e23406; expires=Thu, 23 Jul 2026 12:59:11 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-frame-options: SAMEORIGIN
x-request-guid: 5c509164-298b-4ee4-93a2-5c05a92bacdd
x-worker-origin-response-time: 499000000
x-dns-prefetch-control: off
set-cookie: prov=fe61d8f9-9be8-4db4-8369-79f520e23406; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=kQ.riZdwe1li.nB2DrliDFNxiCfWYhJgVqvItVpOI9Q-1753275552-1.0.1.1-Rkam7ArXCw0nZjr0V5L1h6XVtUQK_L.Jj9.G22PNbUOVVC.JzfONnxmccFSsHILe5Xj9bgAX_yWtU_f2ec29K3Lsyg1wbxO6pM996a61eJk; path=/; expires=Wed, 23-Jul-25 13:29:12 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=3Xb8e7I3Tr15rTMu_jjwPzW7KVhzrubQ.qFFV07RfPw-1753275552330-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'innodb' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 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
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [innodb]
InnoDB : MySQL's ACID-compliant Storage Engine
2,238 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-1
votes
1
answer
135
views
MySQL 8.0.41 - 83 % Waiting for row lock on AO_319474_QUEUE
Environment
We run three Jira Service Management DC clusters that all share the same topology:
MySQL 8.0.36 on Ubuntu 22.04 – 32 vCPU, 100 GB RAM, buffer-pool now 80 GB (only ~33 GB in use), NVMe ...
0
votes
2
answers
55
views
Mysql Innodb Row/Page Size Limits
I have a purely theoretical question that would help me understand how exactly data is stored in the database.
Database settings:
MySQL 8.0.15, Innodb;
Innodb_file_per_table - ON (default);
...
1
vote
0
answers
71
views
How to decrypt a mariadb database or change the encryption key?
I successfully encrypted my MariaDB database using file_key_management and following this guide. Now I'd like to change the encryption key and suppose I need to decrypt the database first, before I ...
0
votes
0
answers
41
views
mysql 8.0.33 queries suddenly hangs in `waiting for handler commit` state
I have a large production MySQL 8.0.33 primary node with two replication nodes.
Today, our database suddenly hung. SHOW FULL PROCESSLIST showed many connections in the Waiting for handler commit state,...
3
votes
1
answer
186
views
How to recreate corrupt innodb tables with innodb_file_per_table?
MySQL refuses to start up and I was only able to start in read-only mode using innodb_force_recovery = 6. Every answer I've found on this topic suggests making a backup, deleting ibdata and ...
2
votes
1
answer
96
views
Why does replacing EXISTS with (SELECT EXISTS) significantly speed up performance, in spite EXPLAIN returning the same explanation for both?
MySQL (libmysql - mysqlnd 5.0.12-dev - 20150407. I tried to get it updated a few times but I get push back).
When I run this:
SELECT (SELECT EXISTS(select 1 from cadran_item where id_parcelle = ...
2
votes
1
answer
106
views
Why does innodb next-key locks lock more range than the condition?
Assume the following table:
DROP TABLE IF EXISTS person;
CREATE TABLE person (
id int unsigned auto_increment primary key,
name varchar(255) not null,
age tinyint unsigned,
key (age)...
0
votes
4
answers
127
views
Performant way to perform update over 300M records in MYSQL
Context
I have an entity called 'Interaction'.
interaction | CREATE TABLE `interaction` (
`id` varchar(36) NOT NULL,
`entity_id` varchar(36) DEFAULT NULL,
`request_date` datetime DEFAULT NULL,
...
0
votes
2
answers
90
views
Slow select on empty table after delete
I've been running into this issue on a production instance and so tried a small scale local re-create and managed to do it.
I have a simple test table
CREATE TABLE `test` (
`id` int unsigned NOT ...
0
votes
1
answer
89
views
Mysql huge table vs small ram allocation
We have a percona mysql database where one of the table which is touching almost 26.8Gb in size. The server is just 4Gb but its specifically only hosting mysql. Now when I am trying to run a simple ...
3
votes
1
answer
171
views
Innodb - Can you safely ignore the warning "Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size"
We get this warning in our online shop
report.WARNING: Memory size allocated for the temporary table is more
than 20% of innodb_buffer_pool_size. Please update
innodb_buffer_pool_size or decrease ...
0
votes
2
answers
73
views
innodb fetch time, not query execution time
A very basic query but from a huge table
SELECT profile_id FROM clients WHERE is_vip = 0
execution has a duration of 0.716s and data fetch time of 15.072s
Obviously my question is if I can speed this ...
0
votes
0
answers
27
views
mysql innodb - copying db manually and register it
I'm creating a test setup such that at the start of each test, I will create an isolated db based on the original DB (40 tables, 14mb size total).
When using mysqldump+mysql or mydumper+myloader, the ...
0
votes
1
answer
150
views
Loading an SQL dump is slow
note: I initially asked this question on stackoverflow, but was told superuser would be a better place for it. I was then made aware of the existence of dba.stackexchange, which seems like the right ...
0
votes
0
answers
74
views
mysql 100% disk i/o with no query
I have a mysql instance running on my windows dev box that is using 100% disk i/o with no active query.
SHOW FULL PROCESSLIST;
SHOW ENGINE INNODB MUTEX;
If I refresh the mutex list the count in the ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
mysql × 1999
performance × 248
mariadb × 235
myisam × 209
index × 148
mysql-5.5 × 148
mysql-5.7 × 115
mysql-5.6 × 114
locking × 86
optimization × 80
deadlock × 70
mysqldump × 68
query-performance × 67
mysql-8.0 × 63
backup × 62
replication × 58
database-design × 55
memory × 55
recovery × 52
buffer-pool × 45
transaction × 45
foreign-key × 44
percona × 41
amazon-rds × 40
linux × 38
more related tags
Hot Network Questions
- Do the constructible lines and circles (not merely their intersections) cover the plane?
- SOSL/SOQL isn't returning User records
- A soviet sci-fi novel (novelette?) with frogs?
- Write two very different programs with the same characters
- When is XLOOKUP() faster than VLOOKUP()?
- How to expand an algebraic function like √R(x) into a continued fraction in Mathematica?
- bootstrapping for variance estimation takes too long
- How would a DiVicenzo machine prepare the maximally mixed state with a small number of ancilla qubits?
- Is there a way to retrieve my inventory from the void in Minecraft Java Edition?
- Ubuntu gives the message "You are in emergency mode."
- Differential amplifier layout: closer to MCU or Load?
- Praesul meorum tattoo
- A word that describes some people
- Story about a room on Mars that contains God
- Can you identify this shell case from Flanders?
- "Tumas t'hom" from merely walking on a non-jewish grave?
- grep behaviour is different when run using bash -c '...'
- What fiction genres do literary agents recognize?
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- What *IS* switch bounce REALLY? According to evidence. (Not *how* to debounce.)
- Is there a formal threshold for when a variable is considered 'random' in statistics? What is it?
- What's the point of all-wheel drive (AWD) in RoadCraft, if vehicles consume no fuel?
- Why does my door knob bolt catch in the retracted position?
- Manga/manhwa where protagonist is the only one summoned to a different other world