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
• MySQL Cluster 7.3.30 has been released	07/14/2020 12:50PM

New Topic

Pages:

1 2 3 4 5

...

104 »

Subject

Views

Written By

Posted

Sticky: MySQL 8.0.20 Performance : The New InnoDB Double Write Buffer in Action (1 Posts)

145

Edwin Desouza

04/30/2020 02:57PM

Sticky: InnoDB : Tablespace Space Management (1 Posts)

352

Edwin Desouza

11/08/2019 11:11AM

Sticky: MySQL 8.0: A Breakthrough in Usability – Automatic Node Provisioning (1 Posts)

456

Edwin Desouza

07/23/2019 08:41AM

Sticky: MySQL 8.0: InnoDB New Lock free, scalable WAL design (1 Posts)

850

Edwin Desouza

06/18/2018 09:11AM

Sticky: MySQL 8.0: Instant ADD COLUMN for InnoDB (1 Posts)

913

Edwin Desouza

05/09/2018 10:55AM

Sticky: MySQL HA: InnoDB clusters (1 Posts)

1,905

Edwin Desouza

09/20/2016 09:29AM

Sticky: MySQL 8.0: InnoDB (1 Posts)

2,091

Edwin Desouza

09/14/2016 09:49AM

Sticky: MySQL 5.7: Effective Functional Indexes in InnoDB (1 Posts)

3,662

Edwin Desouza

04/09/2015 11:51AM

Sticky: MySQL 5.7 DMR: InnoDB Improvements (1 Posts)

6,006

Edwin Desouza

09/21/2013 06:00PM

Sticky: InnoDB: Blogs, Presentations (1 Posts)

7,166

Edwin Desouza

01/16/2013 03:50PM

Sticky: JemeryCole: Deep Dive into InnoDB Internals (1 Posts)

7,476

Edwin Desouza

01/08/2013 03:51PM

Sticky: InnoDB Transportable Tablespaces - Recovering Data from Stranded .ibd Files is a Thing of the Past (1 Posts)

7,094

Edwin DeSouza

11/07/2012 07:37PM

Sticky: MySQL 5.6: Online DDL (1 Posts)

8,151

Edwin Desouza

04/11/2012 09:57AM

Sticky: MySQL 5.6: InnoDB Performance Improvements (1 Posts)

8,613

Edwin Desouza

04/11/2012 09:56AM

Sticky: MySQL Performance Schema: A Big Bag of Epic Awesomeness (1 Posts)

9,544

Edwin DeSouza

07/28/2011 08:52PM

Error message on OS freebsd

82

Aaron Durrani

08/08/2020 07:17PM

Re: Error message on OS freebsd

8

Aaron Durrani

08/08/2020 07:22PM

Re: Error message on OS freebsd

11

Aaron Durrani

08/08/2020 07:25PM

Re: Error message on OS freebsd

8

Peter Brawley

08/08/2020 09:53PM

Re: Error message on OS freebsd

11

Aaron Durrani

08/08/2020 10:05PM

Re: Error message on OS freebsd

11

Peter Brawley

08/08/2020 10:25PM

Re: Error message on OS freebsd

9

Aaron Durrani

08/09/2020 11:19AM

Re: Error message on OS freebsd

11

Peter Brawley

08/09/2020 12:41PM

Re: Error message on OS freebsd

8

Aaron Durrani

08/09/2020 06:40PM

Re: Error message on OS freebsd

9

Peter Brawley

08/09/2020 08:36PM

Re: Error message on OS freebsd

3

Aaron Durrani

08/12/2020 08:48PM

MySQL 8.0.20+: insert speed drop

50

08/12/2020 02:18AM

Re: MySQL 8.0.20+: insert speed drop

7

Peter Brawley

08/12/2020 07:54AM

Re: MySQL 8.0.20+: insert speed drop

7

Edwin Desouza

08/12/2020 11:05AM

Re: MySQL 8.0.20+: insert speed drop

8

Peter Brawley

08/12/2020 11:35AM

MySQL 8.0.21: Improvements to InnoDB Undo Truncation

41

Edwin Desouza

08/06/2020 08:51AM

MySQL 8.0.21: New Consistency for Datafile Locations

36

Edwin Desouza

08/06/2020 08:51AM

MySQL: Foreign Key Constraints and Locking

40

Edwin Desouza

08/04/2020 10:13AM

MySQL: Using SKIP LOCK For Queue Processing

41

Edwin Desouza

08/03/2020 09:58AM

MySQL Foreign Keys and Foreign Key Constraints

52

Edwin Desouza

08/03/2020 09:57AM

MySQL: Locks and Deadlocks

44

Edwin Desouza

08/03/2020 09:56AM

MySQL Deadlocks with INSERT

44

Edwin Desouza

08/03/2020 09:56AM

MySQL from a Developers Perspective

50

Edwin Desouza

07/30/2020 10:54PM

MySQL still add gap lock on unique index when delete

76

Jacky Jacky

07/20/2020 02:56AM

MySQL 8.0: Keep an eye on your auto_increment values

50

Edwin Desouza

07/16/2020 08:17AM

Innodb showing high usage 99.7

75

Leonard Maria Arul

07/07/2020 03:05PM

Re: Innodb showing high usage 99.7

37

Peter Brawley

07/07/2020 06:27PM

Ubuntu apt update fails

82

Ashley Drees

06/17/2020 05:15AM

Ashley, please don't duplicate posts

40

Peter Brawley

06/17/2020 10:02AM

KEY_BLOCK_SIZE=12 in innodb

77

06/03/2020 04:32AM

Re: KEY_BLOCK_SIZE=12 in innodb

36

Peter Brawley

06/03/2020 08:48AM

MySQL Performance : XFS -vs- EXT4

166

Edwin Desouza

05/13/2020 02:38PM

MySQL Performance : XFS -vs- EXT4 Story

81

Edwin Desouza

05/13/2020 02:37PM

Fall back to error 1216/1217 without a lot of ddl user rights

324

Nico Schoemaker

11/13/2019 03:43AM

Re: Fall back to error 1216/1217 without a lot of ddl user rights

55

Graham Clifford

04/23/2020 08:39AM

Re: Fall back to error 1216/1217 without a lot of ddl user rights

56

Peter Brawley

04/23/2020 10:45AM

Re: Fall back to error 1216/1217 without a lot of ddl user rights

48

Graham Clifford

05/12/2020 01:21PM

can I set on DB to Barracuda without effecting the whole shared hosting server?

107

Ram Freedman

05/12/2020 07:28AM

Re: can I set on DB to Barracuda without effecting the whole shared hosting server?

42

Peter Brawley

05/12/2020 12:19PM

Upgrading MySQL 5.7 to 8.x on Windows Datadir path ignored

125

04/30/2020 05:54AM

Re: Upgrading MySQL 5.7 to 8.x on Windows Datadir path ignored

48

Peter Brawley

04/30/2020 12:12PM

Re: Upgrading MySQL 5.7 to 8.x on Windows Datadir path ignored

49

05/01/2020 02:44AM

Upgrade From MySQL 5.7 to 8.20

136

04/29/2020 08:02AM

Re: Upgrade From MySQL 5.7 to 8.20

61

Peter Brawley

04/29/2020 09:28AM

LIKE not working as expected

195

04/18/2020 08:37PM

Re: LIKE not working as expected

96

Peter Brawley

04/18/2020 09:14PM

Re: LIKE not working as expected

69

04/19/2020 12:27AM

Re: LIKE not working as expected

71

Peter Brawley

04/19/2020 10:38AM

Re: LIKE not working as expected

60

04/23/2020 07:13PM

Re: LIKE not working as expected

58

Peter Brawley

04/27/2020 08:13AM

Re: LIKE not working as expected

60

04/27/2020 11:02AM

Re: LIKE not working as expected

50

04/27/2020 12:00PM

update queries running slow after colation change

138

Doug Barger

04/24/2020 10:26AM

Re: update queries running slow after colation change

55

Peter Brawley

04/24/2020 03:38PM

Re: update queries running slow after colation change

54

Doug Barger

04/24/2020 03:45PM

Re: update queries running slow after colation change

52

Peter Brawley

04/25/2020 07:51AM

Re: update queries running slow after colation change

49

Doug Barger

04/26/2020 03:54PM

Re: update queries running slow after colation change

57

Peter Brawley

04/26/2020 07:07PM

Re: update queries running slow after colation change

56

Doug Barger

04/26/2020 07:18PM

Understanding InnoDB rw-lock stats

188

Edwin Desouza

04/14/2020 09:14AM

Issue with `ibtmp1` file preventing start up

200

C D

04/01/2020 09:28PM

Re: Issue with `ibtmp1` file preventing start up

67

Peter Brawley

04/02/2020 08:37AM

Re: Issue with `ibtmp1` file preventing start up

67

C D

04/02/2020 11:47AM

Re: Issue with `ibtmp1` file preventing start up

62

Peter Brawley

04/02/2020 03:03PM

Re: Issue with `ibtmp1` file preventing start up

60

C D

04/02/2020 03:36PM

Re: Issue with `ibtmp1` file preventing start up

76

Peter Brawley

04/02/2020 03:44PM

innodb_buffer_pool_size MySQL Windows question

491

John Miluzzo

10/31/2019 03:55PM

Re: innodb_buffer_pool_size MySQL Windows question

167

Peter Brawley

10/31/2019 04:45PM

Re: innodb_buffer_pool_size MySQL Windows question

174

John Miluzzo

10/31/2019 06:48PM

Re: innodb_buffer_pool_size MySQL Windows question

148

John Miluzzo

10/31/2019 08:24PM

Re: innodb_buffer_pool_size MySQL Windows question

60

R Farris

04/01/2020 08:19AM

Re: innodb_buffer_pool_size MySQL Windows question

60

Peter Brawley

04/01/2020 08:36AM

Orphaned idb file

179

Daniel Olivieri Parmera

03/12/2020 01:16PM

Re: Orphaned idb file

81

Peter Brawley

03/12/2020 04:14PM

Early row lookup

164

Zhou Zhou

03/02/2020 03:49AM

mysql 5.7 crashes on corrupt ibdata1 file

179

Matthijs Tempels

02/26/2020 08:25AM

Re: mysql 5.7 crashes on corrupt ibdata1 file

100

Peter Brawley

02/26/2020 12:09PM

Redundant InnoDB lock

299

Sergei Muraviev

02/10/2020 06:04AM

Re: Redundant InnoDB lock

138

Jakub Lopuszanski

02/17/2020 06:06AM

Re: Redundant InnoDB lock

106

Edwin Desouza

02/17/2020 10:59AM

Re: Redundant InnoDB lock

98

Sergei Muraviev

02/18/2020 06:42PM

Problems joining big tables

221

Claudio Battaglino

02/16/2020 04:08PM

Re: Problems joining big tables

98

Peter Brawley

02/16/2020 08:47PM

Re: Problems joining big tables

91

Claudio Battaglino

02/18/2020 10:40AM

MySQL 8.0: InnoDB -- New Redo Log

174

Edwin Desouza

02/14/2020 11:18PM

Help on Query with DATE BETWEEN not performant

821

Kristijan Marin

02/02/2020 06:51PM

Re: Help on Query with DATE BETWEEN not performant

210

Kristijan Marin

02/02/2020 07:13PM

Re: Help on Query with DATE BETWEEN not performant

217

Peter Brawley

02/02/2020 10:30PM

Re: Help on Query with DATE BETWEEN not performant

214

Kristijan Marin

02/03/2020 04:16AM

Re: Help on Query with DATE BETWEEN not performant

219

Kristijan Marin

02/03/2020 08:12AM

Re: Help on Query with DATE BETWEEN not performant

216

Peter Brawley

02/03/2020 10:45AM

Re: Help on Query with DATE BETWEEN not performant

217

Kristijan Marin

02/03/2020 11:20AM

Re: Help on Query with DATE BETWEEN not performant

201

Peter Brawley

02/03/2020 12:02PM

Re: Help on Query with DATE BETWEEN not performant

204

Kristijan Marin

02/03/2020 12:26PM

Re: Help on Query with DATE BETWEEN not performant

204

Peter Brawley

02/03/2020 04:19PM

Re: Help on Query with DATE BETWEEN not performant

198

Kristijan Marin

02/03/2020 06:21PM

Re: Help on Query with DATE BETWEEN not performant

205

Peter Brawley

02/03/2020 08:38PM

Re: Help on Query with DATE BETWEEN not performant

214

Kristijan Marin

02/04/2020 01:03PM

Re: Help on Query with DATE BETWEEN not performant

217

Peter Brawley

02/04/2020 01:42PM

Re: Help on Query with DATE BETWEEN not performant

207

Kristijan Marin

02/04/2020 02:48PM

Re: Help on Query with DATE BETWEEN not performant

204

Peter Brawley

02/04/2020 05:26PM

Re: Help on Query with DATE BETWEEN not performant

209

Peter Brawley

02/04/2020 05:27PM

Re: Help on Query with DATE BETWEEN not performant

204

Kristijan Marin

02/06/2020 04:21PM

Re: Help on Query with DATE BETWEEN not performant

207

Kristijan Marin

02/06/2020 04:31PM

Re: Help on Query with DATE BETWEEN not performant

200

Peter Brawley

02/06/2020 10:57PM

Re: Help on Query with DATE BETWEEN not performant

207

Kristijan Marin

02/09/2020 08:46AM

Re: Help on Query with DATE BETWEEN not performant

208

Peter Brawley

02/09/2020 11:48AM

Re: Help on Query with DATE BETWEEN not performant

205

Edwin Desouza

02/09/2020 05:04PM

Re: Help on Query with DATE BETWEEN not performant

204

Kristijan Marin

02/04/2020 04:12PM

When was table or DB statistics gathered

433

sreekanth pm

01/23/2020 08:14AM

show engine innodb status not showing most recent deadlock

399

Stephen McCants

01/03/2020 11:36AM

Re: show engine innodb status not showing most recent deadlock

134

Stephen McCants

01/13/2020 02:11PM

Re: show engine innodb status not showing most recent deadlock

153

Peter Brawley

01/13/2020 07:51PM

Re: show engine innodb status not showing most recent deadlock

106

Stephen McCants

01/14/2020 09:58AM

Re: show engine innodb status not showing most recent deadlock

127

Peter Brawley

01/14/2020 10:47AM

MySQL shutdown unexpectedly

5,889

Thurein Htet

10/25/2019 01:11AM

Re: MySQL shutdown unexpectedly

2,531

Peter Brawley

10/25/2019 05:08AM

Re: MySQL shutdown unexpectedly

1,425

Peter Karki

01/13/2020 07:43PM

How to recover a table with a corrupted partition?

359

harry sheng

01/07/2020 11:57AM

Re: How to recover a table with a corrupted partition?

125

Peter Brawley

01/07/2020 01:51PM

Re: How to recover a table with a corrupted partition?

123

harry sheng

01/07/2020 03:13PM

Re: How to recover a table with a corrupted partition?

121

harry sheng

01/07/2020 03:42PM

Re: How to recover a table with a corrupted partition?

124

Peter Brawley

01/07/2020 07:44PM

Re: How to recover a table with a corrupted partition?

102

harry sheng

01/09/2020 08:23AM

[mysql] Error: MySQL shutdown unexpectedly.

1,111

Akifcan Kara

12/11/2019 04:22AM

Re: [mysql] Error: MySQL shutdown unexpectedly.

426

Peter Brawley

12/11/2019 12:03PM

How do I retrieve items that have changed their value type?

351

Cesar Murilo Cesar

11/29/2019 10:07AM

Re: How do I retrieve items that have changed their value type?

114

Peter Brawley

12/11/2019 11:58AM

SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed

1,482

sanjb c

06/28/2019 06:53AM

Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed

747

Peter Brawley

06/28/2019 11:03AM

Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed

390

sanjb c

06/28/2019 10:22PM

Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed

486

Peter Brawley

06/29/2019 12:12PM

Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed

339

sanjb c

07/01/2019 03:01AM

Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed

339

Peter Brawley

07/01/2019 09:39AM

Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed

296

Lucas van Staden

11/27/2019 07:14AM

Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed

310

Lucas van Staden

11/27/2019 07:34AM

Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed

212

Efecan Bilge

11/05/2019 10:43PM

Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed

195

Peter Brawley

11/06/2019 10:15AM

MySQL 8 is not using INDEX when subquery has a group column

472

Rahul n

11/25/2019 11:31PM

Re: MySQL 8 is not using INDEX when subquery has a group column

137

Peter Brawley

11/26/2019 11:47AM

MySQL 8.0: InnoDB Deep Dive

340

Edwin Desouza

11/19/2019 10:31PM

MySQL Clone

264

Edwin Desouza

11/17/2019 10:48PM

MySQL Clone Plugin Speed Test

251

Edwin Desouza

11/13/2019 06:52PM

Information on Analyze and Optimize

412

sreekanth pm

10/14/2019 04:46AM

Re: Information on Analyze and Optimize

154

sreekanth pm

10/15/2019 11:01PM

Re: Information on Analyze and Optimize

160

Peter Brawley

10/18/2019 09:23AM

Re: Information on Analyze and Optimize

137

sreekanth pm

10/20/2019 11:09PM

Re: Information on Analyze and Optimize

157

Peter Brawley

10/21/2019 11:08AM

mysql 5.6 InnoDB: Error (Duplicate key) writing word node to FTS auxiliary index table.

970

Дмитрий Багас

10/16/2019 12:51AM

Re: mysql 5.6 InnoDB: Error (Duplicate key) writing word node to FTS auxiliary index table.

459

Peter Brawley

10/18/2019 09:44AM

Repeatable Read update sees new value from another session

299

Bill Okara

10/17/2019 04:23PM

Mysql crash on startup

398

Stefano Passiatore

10/14/2019 01:48AM

Re: Mysql crash on startup

187

Peter Brawley

10/15/2019 10:48AM

cached lock_sys hash value in block descriptor

280

Chen Fu

10/13/2019 11:05AM

The total number of locks exceeds the lock table sizeSource

664

10/07/2019 02:16AM

Re: The total number of locks exceeds the lock table sizeSource

252

Peter Brawley

10/07/2019 11:16AM

This topic has been moved.: can I set on DB to Barracuda without effecting the whole shared hosting server?

0

Ram Freedman

05/12/2020 10:14AM

This topic has been moved.: innodb_buffer_pool_size MySQL Windows question

0

John Miluzzo

10/31/2019 04:41PM

This topic has been moved.: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed

12

sanjb c

06/29/2019 12:13PM

Pages:

1 2 3 4 5

...

104 »

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.