MySQL :: MySQL Forums :: InnoDB

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

Announcements	Last Post
• Announcing April 2026 Releases featuring MySQL Server 9.7.0, 8.4.9 and 8.0.46	04/27/2026 03:22AM

New Topic

Pages:

« 1 2 3 4 5

...

107 »

Subject

Views

Written By

Posted

Internals about how innodb shrink database file with OPTIMIZE TABLE ?

1,060

Lewis Chan

01/12/2022 12:54AM

What is FTS_*_DELETED.ibd

1,248

Vanderwyk Siahaan

12/11/2021 08:35PM

Re: What is FTS_*_DELETED.ibd

2,043

Peter Brawley

12/12/2021 11:47AM

Re: What is FTS_*_DELETED.ibd

937

Vanderwyk Siahaan

01/11/2022 12:37AM

Store icons and small images in table

1,669

Arthur Chan

01/07/2022 12:18PM

Re: Store icons and small images in table

603

Peter Brawley

01/07/2022 01:22PM

InnoDB Information_Schema.columns database lock

883

Haad Fida

12/29/2021 06:57AM

Re: InnoDB Information_Schema.columns database lock

435

Peter Brawley

12/29/2021 10:07AM

Assertion failure

3,599

ludovic lugo

12/20/2021 04:40AM

Re: Assertion failure

1,049

Peter Brawley

12/20/2021 11:12AM

Re: Assertion failure

960

ludovic lugo

12/21/2021 01:20AM

Re: Assertion failure

904

ludovic lugo

12/21/2021 02:12AM

mysql stopped suddenly / can't recover

3,697

Robert Tee

12/16/2021 07:18AM

Re: mysql stopped suddenly / can't recover

982

Robert Tee

12/16/2021 08:39AM

Re: mysql stopped suddenly / can't recover

1,086

Peter Brawley

12/16/2021 09:58AM

Re: mysql stopped suddenly / can't recover

882

Robert Tee

12/16/2021 10:10AM

Re: mysql stopped suddenly / can't recover

831

Robert Tee

12/16/2021 12:40PM

Re: mysql stopped suddenly / can't recover

940

Robert Tee

12/16/2021 01:35PM

Re: mysql stopped suddenly / can't recover

924

Peter Brawley

12/16/2021 01:49PM

What is InnoDB Reading and Writing when It's Idle?

1,298

Authorized User

12/14/2021 09:04PM

Re: What is InnoDB Reading and Writing when It's Idle?

662

Authorized User

12/15/2021 05:57AM

Re: What is InnoDB Reading and Writing when It's Idle?

590

Peter Brawley

12/15/2021 10:45AM

Re: What is InnoDB Reading and Writing when It's Idle?

582

Authorized User

12/15/2021 11:12AM

Re: What is InnoDB Reading and Writing when It's Idle?

524

Peter Brawley

12/15/2021 11:29AM

Re: What is InnoDB Reading and Writing when It's Idle?

639

Authorized User

12/15/2021 11:50AM

Re: What is InnoDB Reading and Writing when It's Idle?

610

Peter Brawley

12/15/2021 12:20PM

Re: What is InnoDB Reading and Writing when It's Idle?

659

Authorized User

12/15/2021 11:16AM

Re: What is InnoDB Reading and Writing when It's Idle?

575

Sunny Bains

12/15/2021 02:19PM

Re: What is InnoDB Reading and Writing when It's Idle?

457

Authorized User

12/15/2021 02:35PM

Re: What is InnoDB Reading and Writing when It's Idle?

588

Sunny Bains

12/15/2021 02:51PM

A question about innodb_adaptive_hash_index and INSERT BUFFER AND ADAPTIVE HASH INDEX in error log

1,273

paul paul

11/07/2021 08:44PM

Re: A question about innodb_adaptive_hash_index and INSERT BUFFER AND ADAPTIVE HASH INDEX in error log

585

Peter Brawley

11/07/2021 09:19PM

Re: A question about innodb_adaptive_hash_index and INSERT BUFFER AND ADAPTIVE HASH INDEX in error log

529

paul paul

11/08/2021 08:38AM

Re: A question about innodb_adaptive_hash_index and INSERT BUFFER AND ADAPTIVE HASH INDEX in error log

485

Peter Brawley

11/08/2021 10:42AM

ERROR 1114 (HY000): The table /var/folder/... is full

2,970

Vinay Reddy

10/24/2021 08:49PM

Re: ERROR 1114 (HY000): The table /var/folder/... is full

989

Peter Brawley

10/24/2021 10:52PM

Re: ERROR 1114 (HY000): The table /var/folder/... is full

887

Vinay Reddy

10/25/2021 11:56AM

Primary index lock on duplicate key error

1,422

RONALDS BREIKSS

09/29/2021 06:02AM

Re: Primary index lock on duplicate key error

550

Peter Brawley

10/22/2021 03:07PM

MySQL 8.0 – locking details

1,143

Edwin Desouza

10/22/2021 11:11AM

Very slow performance when inserting, updating, deleting and changing schema

4,989

01/27/2021 01:27PM

Re: Very slow performance when inserting, updating, deleting and changing schema

1,484

Peter Brawley

01/27/2021 04:15PM

Re: Very slow performance when inserting, updating, deleting and changing schema

1,250

Alejandro Alvarez

05/21/2021 12:15PM

Re: Very slow performance when inserting, updating, deleting and changing schema

1,089

05/27/2021 07:24PM

Re: Very slow performance when inserting, updating, deleting and changing schema

937

Peter Brawley

05/27/2021 07:57PM

Re: Very slow performance when inserting, updating, deleting and changing schema

1,037

05/27/2021 08:12PM

Re: Very slow performance when inserting, updating, deleting and changing schema

1,087

Peter Brawley

05/28/2021 11:10AM

Re: Very slow performance when inserting, updating, deleting and changing schema

2,770

Alejandro Alvarez

05/21/2021 12:11PM

Re: Very slow performance when inserting, updating, deleting and changing schema

1,261

Peter Brawley

05/22/2021 09:43AM

Re: Very slow performance when inserting, updating, deleting and changing schema

1,132

JOHAN CORSINI

09/27/2021 11:57PM

Re: Very slow performance when inserting, updating, deleting and changing schema

1,104

09/28/2021 07:24AM

Full Table Scans When LIMIT / OFFSET Are Used

2,984

09/22/2021 08:50AM

Re: Full Table Scans When LIMIT / OFFSET Are Used

801

Peter Brawley

09/22/2021 10:38AM

Re: Full Table Scans When LIMIT / OFFSET Are Used

769

09/22/2021 03:16PM

Re: Full Table Scans When LIMIT / OFFSET Are Used

684

Peter Brawley

09/22/2021 03:27PM

Re: Full Table Scans When LIMIT / OFFSET Are Used

872

09/22/2021 05:34PM

Re: Full Table Scans When LIMIT / OFFSET Are Used

672

Peter Brawley

09/22/2021 08:09PM

InnoDB does not start:Database page corruption

1,056

Burkhard Neukirch

09/20/2021 02:24AM

Re: InnoDB does not start:Database page corruption

536

Peter Brawley

09/20/2021 10:16AM

Redo buffer flushing in MySQL

967

Josh Visser

09/18/2021 06:20AM

Ease My Pain: InnoDB in a Memory-Constrained Environment

1,252

Authorized User

09/09/2021 12:54PM

Re: Ease My Pain: InnoDB in a Memory-Constrained Environment

641

Peter Brawley

09/09/2021 01:57PM

Re: Ease My Pain: InnoDB in a Memory-Constrained Environment

550

Authorized User

09/09/2021 02:15PM

Re: Ease My Pain: InnoDB in a Memory-Constrained Environment

522

Peter Brawley

09/09/2021 03:39PM

Re: Ease My Pain: InnoDB in a Memory-Constrained Environment

582

Authorized User

09/09/2021 04:58PM

Re: Ease My Pain: InnoDB in a Memory-Constrained Environment

625

Peter Brawley

09/09/2021 06:43PM

Re: Ease My Pain: InnoDB in a Memory-Constrained Environment

610

Authorized User

09/13/2021 08:10AM

Re: Ease My Pain: InnoDB in a Memory-Constrained Environment

478

Opera Extensions

09/13/2021 09:51AM

MySQL dump & load InnoDB Buffer Pool

876

Edwin Desouza

09/10/2021 03:13PM

Run ANALYZE TABLE — Do Not Rely on InnoDB's Automatic Recalculation of Statistics

966

Edwin Desouza

09/08/2021 09:52AM

How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

1,860

Y M

09/03/2021 08:54AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

538

Peter Brawley

09/03/2021 09:35AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

532

Y M

09/03/2021 10:07AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

635

Y M

09/03/2021 10:19AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

568

Peter Brawley

09/03/2021 11:44AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

728

Y M

09/03/2021 10:15PM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

637

Y M

09/04/2021 05:08AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

525

Peter Brawley

09/04/2021 11:50AM

Re: How does Innodb cleverly avoid read-write conflicts when implementing mvcc?

1,273

Y M

09/04/2021 08:32PM

MVCC - The atomicity problem of consistent reads

1,157

Y M

09/02/2021 11:09AM

Re: MVCC - The atomicity problem of consistent reads

534

Peter Brawley

09/02/2021 12:06PM

Re: MVCC - The atomicity problem of consistent reads

500

jf z

09/02/2021 07:27PM

innochecksum doesn't rewrite checksums

1,540

Christos Chatzaras

08/31/2021 12:05AM

Re: innochecksum doesn't rewrite checksums

1,407

Christos Chatzaras

08/31/2021 12:23AM

Re: innochecksum doesn't rewrite checksums

680

Peter Brawley

08/31/2021 10:02AM

Re: innochecksum doesn't rewrite checksums

663

Christos Chatzaras

08/31/2021 10:38AM

Re: innochecksum doesn't rewrite checksums

597

Peter Brawley

08/31/2021 11:38AM

Re: innochecksum doesn't rewrite checksums

672

Christos Chatzaras

09/01/2021 06:45AM

This topic has been moved.: MySQL Replication lag in slave due to Delete query - Row Based Replication

23

Vinieth S S

08/24/2021 08:49AM

Resolving errors generated when attempting to restore using a mysqldump file

2,916

Paul Schmehl

08/23/2021 04:35PM

Re: Resolving errors generated when attempting to restore using a mysqldump file

779

Peter Brawley

08/23/2021 08:15PM

Re: Resolving errors generated when attempting to restore using a mysqldump file

595

Paul Schmehl

08/23/2021 09:06PM

Can database corruption be caused by a Windows Virtual Memory Resize?

1,134

Andy Heitke

08/23/2021 07:13AM

Re: Can database corruption be caused by a Windows Virtual Memory Resize?

515

Peter Brawley

08/23/2021 11:39AM

OS Error 1217 on startup

3,865

asd asd

08/16/2021 08:54AM

Re: OS Error 1217 on startup

917

Peter Brawley

08/16/2021 12:05PM

Re: OS Error 1217 on startup

816

asd asd

08/17/2021 12:32AM

Re: OS Error 1217 on startup

895

Peter Brawley

08/17/2021 09:43AM

Re: OS Error 1217 on startup

796

asd asd

08/18/2021 03:19AM

Re: OS Error 1217 on startup

853

asd asd

08/18/2021 03:27AM

Re: OS Error 1217 on startup

797

Peter Brawley

08/18/2021 08:07AM

Error: MySQL shutdown unexpectedly.

2,763

Fajar Fidhi

08/15/2021 09:47PM

Re: Error: MySQL shutdown unexpectedly.

639

Peter Brawley

08/16/2021 11:18AM

Regarding "[Warning] InnoDB: Cannot add field"

8,795

Stephen Kwok

07/27/2021 04:24PM

Re: Regarding "[Warning] InnoDB: Cannot add field"

3,350

Peter Brawley

07/27/2021 07:51PM

Re: Regarding "[Warning] InnoDB: Cannot add field"

2,670

Stephen Kwok

07/29/2021 11:40AM

Re: Regarding "[Warning] InnoDB: Cannot add field"

1,853

Peter Brawley

07/29/2021 12:17PM

Re: Regarding "[Warning] InnoDB: Cannot add field"

2,076

Stephen Kwok

08/02/2021 01:09PM

Re: Regarding "[Warning] InnoDB: Cannot add field"

2,108

Peter Brawley

08/02/2021 03:17PM

Re: Regarding "[Warning] InnoDB: Cannot add field"

1,859

Stephen Kwok

08/02/2021 06:18PM

Re: Regarding "[Warning] InnoDB: Cannot add field"

2,024

Peter Brawley

08/02/2021 11:47PM

Re: Regarding "[Warning] InnoDB: Cannot add field"

1,784

Stephen Kwok

08/03/2021 07:34PM

mysql create table with data directory: access denied

3,525

Brian Lee

02/19/2021 10:22PM

Re: mysql create table with data directory: access denied

734

Brian Lee

02/19/2021 10:24PM

Re: mysql create table with data directory: access denied

803

Peter Brawley

02/19/2021 11:56PM

Re: mysql create table with data directory: access denied

729

Brian Lee

02/20/2021 06:33AM

Re: mysql create table with data directory: access denied

850

Brian Lee

02/21/2021 08:20PM

Re: mysql create table with data directory: access denied

724

X X

07/30/2021 08:36PM

Need help for understanding why the MySQL allow to gap lock conflicting between two transactions.

2,008

hanjae jung

07/26/2021 07:15PM

Re: Need help for understanding why the MySQL allow to gap lock conflicting between two transactions.

615

Peter Brawley

07/26/2021 08:26PM

Re: Need help for understanding why the MySQL allow to gap lock conflicting between two transactions.

885

hanjae jung

07/26/2021 08:38PM

Re: Need help for understanding why the MySQL allow to gap lock conflicting between two transactions.

782

Peter Brawley

07/27/2021 08:53AM

MYSQL5.7 In the case of Read-Commit,Deadlocks caused by concurrent inserts(“Multiple-Column Indexes”)

1,298

PengWei Wang

07/17/2021 11:15AM

Re: MYSQL5.7 In the case of Read-Commit,Deadlocks caused by concurrent inserts(“Multiple-Column Indexes”)

642

Peter Brawley

07/17/2021 12:02PM

creating index on READ database

1,018

Ra Nala

07/05/2021 07:58AM

Re: creating index on READ database

562

Peter Brawley

07/17/2021 11:48AM

MySQL dump & load InnoDB Buffer Pool

1,049

Edwin Desouza

06/21/2021 09:52AM

Data too long for column 'vdisuser' at row 1

1,066

Colin Millard

06/14/2021 03:44PM

Re: Data too long for column 'vdisuser' at row 1

475

Colin Millard

06/14/2021 04:38PM

How to get all configuration parameters of InnoDB?

964

derek fu

05/26/2021 09:59PM

Re: How to get all configuration parameters of InnoDB?

447

Peter Brawley

05/26/2021 10:03PM

Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ？

1,019

wenchao wenchao

05/14/2021 02:24AM

Re: Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ？

581

Peter Brawley

05/14/2021 11:42AM

Re: Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ？

540

wenchao wenchao

05/16/2021 08:58PM

Re: Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ？

461

Peter Brawley

05/17/2021 09:38AM

Re: Table Engine Innodb, but mysqldump add option --single-transaction always lock table it ？

470

wenchao wenchao

05/18/2021 12:07AM

InnoDB: Converting old atomic code to C++11

908

Edwin Desouza

04/21/2021 12:29PM

InnoDB Data Locking – Part 5 “Concurrent queues”

1,003

Edwin Desouza

04/19/2021 12:02PM

InnoDB Data Locking – Part 4 “Scheduling”

929

Edwin Desouza

04/16/2021 01:30PM

About Next-Key Locks

1,548

five small

04/14/2021 06:30AM

Re: About Next-Key Locks

542

five small

04/14/2021 06:33AM

Re: About Next-Key Locks

737

Peter Brawley

04/14/2021 01:42PM

Re: About Next-Key Locks

478

five small

04/15/2021 07:49AM

how to change innodb_autoinc_lock_mode = 0

2,280

matthew Baynham

04/09/2021 02:32AM

Re: how to change innodb_autoinc_lock_mode = 0

980

Peter Brawley

04/09/2021 10:34AM

Re: how to change innodb_autoinc_lock_mode = 0

881

matthew Baynham

04/09/2021 10:51AM

Re: how to change innodb_autoinc_lock_mode = 0

790

Peter Brawley

04/14/2021 10:45AM

why for SQLCOM_UPDATE_MULTI, it lock with lock_s

1,117

Tom ccc

03/23/2021 07:25AM

Re: why for SQLCOM_UPDATE_MULTI, it lock with lock_s

659

Tom ccc

03/24/2021 01:40AM

Deep Dive into MySQL Workload Analysis

896

Edwin Desouza

02/26/2021 10:25AM

MySQL Recovery

1,069

Edwin Desouza

02/23/2021 11:23AM

TEXT field performance issue on idle server

1,024

02/10/2021 01:10PM

Re: TEXT field performance issue on idle server

529

02/10/2021 01:12PM

This topic has been moved.: Mysql master/slave

31

Dimitri Gesquiere

02/10/2021 10:08AM

InnoDB Data Locking – Part 3 “Deadlocks”

728

Edwin Desouza

02/09/2021 10:36AM

my table not open

812

hector carlin

02/07/2021 04:34PM

Re: my table not open

508

Peter Brawley

02/07/2021 05:21PM

InnoDB Locking Explained with Stick Figures

1,228

Edwin Desouza

01/21/2021 10:30PM

A Comprehensive (and Animated) Guide to InnoDB Locking

933

Edwin Desouza

01/21/2021 10:25PM

Why Invisible Column is important for InnoDB Storage Engine

894

Edwin Desouza

01/21/2021 08:07PM

This topic has been moved.: mysql stopped suddenly / can't recover

0

Robert Tee

12/16/2021 09:58AM

This topic has been moved.: Primary index lock on duplicate key error

0

RONALDS BREIKSS

09/29/2021 10:13AM

This topic has been moved.: Need help for understanding why the MySQL allow to gap lock conflicting between two transactions.

0

hanjae jung

07/26/2021 07:50PM

This topic has been moved.: About Next-Key Locks

0

five small

04/14/2021 10:18AM

Pages:

« 1 2 3 4 5

...

107 »

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.