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 Connector/J 5.1.49 GA has been released	04/29/2020 08:57AM
• MySQL Cluster 7.3.29 has been released	04/29/2020 01:52AM

New Topic

Pages:

1 2 3 4 5

...

103 »

Subject

Views

Written By

Posted

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

60

Edwin Desouza

04/30/2020 02:57PM

Sticky: InnoDB : Tablespace Space Management (1 Posts)

291

Edwin Desouza

11/08/2019 11:11AM

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

375

Edwin Desouza

07/23/2019 08:41AM

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

782

Edwin Desouza

06/18/2018 09:11AM

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

852

Edwin Desouza

05/09/2018 10:55AM

Sticky: MySQL HA: InnoDB clusters (1 Posts)

1,847

Edwin Desouza

09/20/2016 09:29AM

Sticky: MySQL 8.0: InnoDB (1 Posts)

2,019

Edwin Desouza

09/14/2016 09:49AM

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

3,598

Edwin Desouza

04/09/2015 11:51AM

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

5,942

Edwin Desouza

09/21/2013 06:00PM

Sticky: InnoDB: Blogs, Presentations (1 Posts)

7,098

Edwin Desouza

01/16/2013 03:50PM

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

7,373

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,025

Edwin DeSouza

11/07/2012 07:37PM

Sticky: MySQL 5.6: Online DDL (1 Posts)

8,018

Edwin Desouza

04/11/2012 09:57AM

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

8,550

Edwin Desouza

04/11/2012 09:56AM

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

9,492

Edwin DeSouza

07/28/2011 08:52PM

MySQL Performance : XFS -vs- EXT4

45

Edwin Desouza

05/13/2020 02:38PM

MySQL Performance : XFS -vs- EXT4 Story

32

Edwin Desouza

05/13/2020 02:37PM

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

249

Nico Schoemaker

11/13/2019 03:43AM

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

29

Graham Clifford

04/23/2020 08:39AM

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

31

Peter Brawley

04/23/2020 10:45AM

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

19

Graham Clifford

05/12/2020 01:21PM

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

49

Ram Freedman

05/12/2020 07:28AM

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

15

Peter Brawley

05/12/2020 12:19PM

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

72

04/30/2020 05:54AM

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

23

Peter Brawley

04/30/2020 12:12PM

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

19

05/01/2020 02:44AM

Upgrade From MySQL 5.7 to 8.20

75

04/29/2020 08:02AM

Re: Upgrade From MySQL 5.7 to 8.20

30

Peter Brawley

04/29/2020 09:28AM

LIKE not working as expected

114

04/18/2020 08:37PM

Re: LIKE not working as expected

37

Peter Brawley

04/18/2020 09:14PM

Re: LIKE not working as expected

33

04/19/2020 12:27AM

Re: LIKE not working as expected

43

Peter Brawley

04/19/2020 10:38AM

Re: LIKE not working as expected

31

04/23/2020 07:13PM

Re: LIKE not working as expected

25

Peter Brawley

04/27/2020 08:13AM

Re: LIKE not working as expected

24

04/27/2020 11:02AM

Re: LIKE not working as expected

16

04/27/2020 12:00PM

update queries running slow after colation change

81

Doug Barger

04/24/2020 10:26AM

Re: update queries running slow after colation change

25

Peter Brawley

04/24/2020 03:38PM

Re: update queries running slow after colation change

24

Doug Barger

04/24/2020 03:45PM

Re: update queries running slow after colation change

26

Peter Brawley

04/25/2020 07:51AM

Re: update queries running slow after colation change

22

Doug Barger

04/26/2020 03:54PM

Re: update queries running slow after colation change

29

Peter Brawley

04/26/2020 07:07PM

Re: update queries running slow after colation change

25

Doug Barger

04/26/2020 07:18PM

Understanding InnoDB rw-lock stats

111

Edwin Desouza

04/14/2020 09:14AM

Issue with `ibtmp1` file preventing start up

144

C D

04/01/2020 09:28PM

Re: Issue with `ibtmp1` file preventing start up

36

Peter Brawley

04/02/2020 08:37AM

Re: Issue with `ibtmp1` file preventing start up

35

C D

04/02/2020 11:47AM

Re: Issue with `ibtmp1` file preventing start up

35

Peter Brawley

04/02/2020 03:03PM

Re: Issue with `ibtmp1` file preventing start up

28

C D

04/02/2020 03:36PM

Re: Issue with `ibtmp1` file preventing start up

42

Peter Brawley

04/02/2020 03:44PM

innodb_buffer_pool_size MySQL Windows question

396

John Miluzzo

10/31/2019 03:55PM

Re: innodb_buffer_pool_size MySQL Windows question

130

Peter Brawley

10/31/2019 04:45PM

Re: innodb_buffer_pool_size MySQL Windows question

144

John Miluzzo

10/31/2019 06:48PM

Re: innodb_buffer_pool_size MySQL Windows question

114

John Miluzzo

10/31/2019 08:24PM

Re: innodb_buffer_pool_size MySQL Windows question

35

R Farris

04/01/2020 08:19AM

Re: innodb_buffer_pool_size MySQL Windows question

32

Peter Brawley

04/01/2020 08:36AM

Orphaned idb file

126

Daniel Olivieri Parmera

03/12/2020 01:16PM

Re: Orphaned idb file

53

Peter Brawley

03/12/2020 04:14PM

Early row lookup

114

Zhou Zhou

03/02/2020 03:49AM

mysql 5.7 crashes on corrupt ibdata1 file

132

Matthijs Tempels

02/26/2020 08:25AM

Re: mysql 5.7 crashes on corrupt ibdata1 file

62

Peter Brawley

02/26/2020 12:09PM

Redundant InnoDB lock

228

Sergei Muraviev

02/10/2020 06:04AM

Re: Redundant InnoDB lock

98

Jakub Lopuszanski

02/17/2020 06:06AM

Re: Redundant InnoDB lock

71

Edwin Desouza

02/17/2020 10:59AM

Re: Redundant InnoDB lock

64

Sergei Muraviev

02/18/2020 06:42PM

Problems joining big tables

159

Claudio Battaglino

02/16/2020 04:08PM

Re: Problems joining big tables

64

Peter Brawley

02/16/2020 08:47PM

Re: Problems joining big tables

59

Claudio Battaglino

02/18/2020 10:40AM

MySQL 8.0: InnoDB -- New Redo Log

126

Edwin Desouza

02/14/2020 11:18PM

Help on Query with DATE BETWEEN not performant

666

Kristijan Marin

02/02/2020 06:51PM

Re: Help on Query with DATE BETWEEN not performant

183

Kristijan Marin

02/02/2020 07:13PM

Re: Help on Query with DATE BETWEEN not performant

191

Peter Brawley

02/02/2020 10:30PM

Re: Help on Query with DATE BETWEEN not performant

180

Kristijan Marin

02/03/2020 04:16AM

Re: Help on Query with DATE BETWEEN not performant

186

Kristijan Marin

02/03/2020 08:12AM

Re: Help on Query with DATE BETWEEN not performant

191

Peter Brawley

02/03/2020 10:45AM

Re: Help on Query with DATE BETWEEN not performant

185

Kristijan Marin

02/03/2020 11:20AM

Re: Help on Query with DATE BETWEEN not performant

177

Peter Brawley

02/03/2020 12:02PM

Re: Help on Query with DATE BETWEEN not performant

179

Kristijan Marin

02/03/2020 12:26PM

Re: Help on Query with DATE BETWEEN not performant

178

Peter Brawley

02/03/2020 04:19PM

Re: Help on Query with DATE BETWEEN not performant

173

Kristijan Marin

02/03/2020 06:21PM

Re: Help on Query with DATE BETWEEN not performant

178

Peter Brawley

02/03/2020 08:38PM

Re: Help on Query with DATE BETWEEN not performant

180

Kristijan Marin

02/04/2020 01:03PM

Re: Help on Query with DATE BETWEEN not performant

185

Peter Brawley

02/04/2020 01:42PM

Re: Help on Query with DATE BETWEEN not performant

181

Kristijan Marin

02/04/2020 02:48PM

Re: Help on Query with DATE BETWEEN not performant

179

Peter Brawley

02/04/2020 05:26PM

Re: Help on Query with DATE BETWEEN not performant

179

Peter Brawley

02/04/2020 05:27PM

Re: Help on Query with DATE BETWEEN not performant

179

Kristijan Marin

02/06/2020 04:21PM

Re: Help on Query with DATE BETWEEN not performant

179

Kristijan Marin

02/06/2020 04:31PM

Re: Help on Query with DATE BETWEEN not performant

175

Peter Brawley

02/06/2020 10:57PM

Re: Help on Query with DATE BETWEEN not performant

184

Kristijan Marin

02/09/2020 08:46AM

Re: Help on Query with DATE BETWEEN not performant

180

Peter Brawley

02/09/2020 11:48AM

Re: Help on Query with DATE BETWEEN not performant

182

Edwin Desouza

02/09/2020 05:04PM

Re: Help on Query with DATE BETWEEN not performant

174

Kristijan Marin

02/04/2020 04:12PM

When was table or DB statistics gathered

364

sreekanth pm

01/23/2020 08:14AM

show engine innodb status not showing most recent deadlock

316

Stephen McCants

01/03/2020 11:36AM

Re: show engine innodb status not showing most recent deadlock

95

Stephen McCants

01/13/2020 02:11PM

Re: show engine innodb status not showing most recent deadlock

108

Peter Brawley

01/13/2020 07:51PM

Re: show engine innodb status not showing most recent deadlock

77

Stephen McCants

01/14/2020 09:58AM

Re: show engine innodb status not showing most recent deadlock

84

Peter Brawley

01/14/2020 10:47AM

MySQL shutdown unexpectedly

4,846

Thurein Htet

10/25/2019 01:11AM

Re: MySQL shutdown unexpectedly

2,084

Peter Brawley

10/25/2019 05:08AM

Re: MySQL shutdown unexpectedly

1,101

Peter Karki

01/13/2020 07:43PM

How to recover a table with a corrupted partition?

283

harry sheng

01/07/2020 11:57AM

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

94

Peter Brawley

01/07/2020 01:51PM

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

94

harry sheng

01/07/2020 03:13PM

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

87

harry sheng

01/07/2020 03:42PM

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

88

Peter Brawley

01/07/2020 07:44PM

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

75

harry sheng

01/09/2020 08:23AM

[mysql] Error: MySQL shutdown unexpectedly.

796

Akifcan Kara

12/11/2019 04:22AM

Re: [mysql] Error: MySQL shutdown unexpectedly.

310

Peter Brawley

12/11/2019 12:03PM

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

290

Cesar Murilo Cesar

11/29/2019 10:07AM

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

81

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,278

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

602

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

317

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

413

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

274

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

276

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

193

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

223

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

169

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

147

Peter Brawley

11/06/2019 10:15AM

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

389

Rahul n

11/25/2019 11:31PM

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

103

Peter Brawley

11/26/2019 11:47AM

MySQL 8.0: InnoDB Deep Dive

285

Edwin Desouza

11/19/2019 10:31PM

MySQL Clone

221

Edwin Desouza

11/17/2019 10:48PM

MySQL Clone Plugin Speed Test

207

Edwin Desouza

11/13/2019 06:52PM

Information on Analyze and Optimize

337

sreekanth pm

10/14/2019 04:46AM

Re: Information on Analyze and Optimize

128

sreekanth pm

10/15/2019 11:01PM

Re: Information on Analyze and Optimize

132

Peter Brawley

10/18/2019 09:23AM

Re: Information on Analyze and Optimize

112

sreekanth pm

10/20/2019 11:09PM

Re: Information on Analyze and Optimize

119

Peter Brawley

10/21/2019 11:08AM

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

749

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

10/16/2019 12:51AM

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

352

Peter Brawley

10/18/2019 09:44AM

Repeatable Read update sees new value from another session

251

Bill Okara

10/17/2019 04:23PM

Mysql crash on startup

328

Stefano Passiatore

10/14/2019 01:48AM

Re: Mysql crash on startup

146

Peter Brawley

10/15/2019 10:48AM

cached lock_sys hash value in block descriptor

228

Chen Fu

10/13/2019 11:05AM

The total number of locks exceeds the lock table sizeSource

507

10/07/2019 02:16AM

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

194

Peter Brawley

10/07/2019 11:16AM

Database recovery

279

kaling rajan

10/04/2019 02:27AM

Re: Database recovery

123

Peter Brawley

10/04/2019 08:31AM

Exact table count for all tables in a schema.

614

sreekanth pm

09/13/2019 01:53AM

Re: Exact table count for all tables in a schema.

154

Peter Brawley

09/13/2019 09:43AM

Re: Exact table count for all tables in a schema.

137

sreekanth pm

09/16/2019 11:15PM

Re: Exact table count for all tables in a schema.

131

Peter Brawley

09/17/2019 10:07AM

Re: Exact table count for all tables in a schema.

128

sreekanth pm

09/19/2019 12:24AM

Re: Exact table count for all tables in a schema.

130

Peter Brawley

09/19/2019 09:38AM

Re: Exact table count for all tables in a schema.

129

sreekanth pm

09/20/2019 04:04AM

Re: Exact table count for all tables in a schema.

139

Peter Brawley

09/20/2019 09:50AM

Re: Exact table count for all tables in a schema.

122

sreekanth pm

09/20/2019 10:03AM

Re: Exact table count for all tables in a schema.

128

Peter Brawley

09/20/2019 12:45PM

Re: Exact table count for all tables in a schema.

132

sreekanth pm

09/22/2019 11:51PM

Re: Exact table count for all tables in a schema.

120

Peter Brawley

09/23/2019 10:21AM

Re: Exact table count for all tables in a schema.

135

sreekanth pm

09/24/2019 10:45PM

Re: Exact table count for all tables in a schema.

139

Peter Brawley

09/25/2019 11:01AM

create_time value is incorrect from information_schema.tables

353

D BA

08/28/2019 02:19AM

Re: create_time value is incorrect from information_schema.tables

164

Frederic Descamps

08/28/2019 05:56PM

Re: create_time value is incorrect from information_schema.tables

172

D BA

08/28/2019 11:32PM

unable to shrink IBDATA1 file

459

P N Narender Babu

08/21/2019 12:32AM

Re: unable to shrink IBDATA1 file

187

james wang

08/21/2019 02:12AM

Re: unable to shrink IBDATA1 file

170

P N Narender Babu

08/21/2019 03:34AM

Re: unable to shrink IBDATA1 file

177

Peter Brawley

08/21/2019 10:26AM

Re: unable to shrink IBDATA1 file

171

P N Narender Babu

08/22/2019 03:47AM

On the auto-extending innodb_system data file

1,729

Maurice Volaski

08/05/2019 08:46PM

Re: On the auto-extending innodb_system data file

686

Peter Brawley

08/06/2019 10:56AM

Re: On the auto-extending innodb_system data file

418

Maurice Volaski

08/08/2019 07:39PM

Re: On the auto-extending innodb_system data file

404

Maurice Volaski

08/08/2019 09:58PM

Re: On the auto-extending innodb_system data file

378

Peter Brawley

08/09/2019 09:50AM

Re: On the auto-extending innodb_system data file

385

Maurice Volaski

08/10/2019 01:33AM

Re: On the auto-extending innodb_system data file

366

Peter Brawley

08/10/2019 11:52AM

Re: On the auto-extending innodb_system data file

376

Maurice Volaski

08/19/2019 02:43PM

How to update two tables but limit one row?

562

nobody nobody

02/09/2019 05:36PM

Re: How to update two tables but limit one row?

286

nobody nobody

02/09/2019 05:38PM

Re: How to update two tables but limit one row?

260

Peter Brawley

02/09/2019 08:28PM

Re: How to update two tables but limit one row?

160

08/14/2019 06:12AM

Free up space after dropping indexes

326

Alexandru Badulescu

08/06/2019 02:53AM

Table Data gets Deleted automatically Urgent

346

samuel muendo

07/29/2019 11:14PM

Re: Table Data gets Deleted automatically Urgent

153

Peter Brawley

07/30/2019 09:19AM

Insert to InnoDB table stops after about 40,000 rows

917

07/16/2019 10:43AM

Re: Insert to InnoDB table stops after about 40,000 rows

242

Peter Brawley

07/16/2019 10:57AM

Re: Insert to InnoDB table stops after about 40,000 rows

168

07/16/2019 03:01PM

How to show hideen column values about MVCC?

1,504

PC N

07/08/2019 10:06PM

InnoDB field type size vs file size descrepency?

490

Eman G

07/05/2019 12:58PM

Re: InnoDB field type size vs file size descrepency?

176

Peter Brawley

07/05/2019 07:13PM

This topic has been moved.: Mysql 8 group replication sync problem

24

Peter Hutchison

06/19/2019 09:32AM

This topic has been moved.: How to make InnoDB cluster survive network issues - 8.0.16+

16

Dan Cvrcek

06/13/2019 10:02AM

This topic has been moved.: Using InnoDB Cluster Commands In “Batch” Mode

25

06/13/2019 10:02AM

risk for innodb_flush_method=nosync

558

mike hill

05/27/2019 10:05PM

Re: risk for innodb_flush_method=nosync

264

Peter Brawley

05/27/2019 11:12PM

Re: risk for innodb_flush_method=nosync

255

mike hill

05/28/2019 09:27PM

Re: risk for innodb_flush_method=nosync

220

Peter Brawley

05/29/2019 10:11AM

Re: risk for innodb_flush_method=nosync

288

Mike Hill

05/31/2019 01:13AM

Re: risk for innodb_flush_method=nosync

260

Peter Brawley

05/31/2019 12:08PM

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.: On the auto-extending innodb_system data file

0

Maurice Volaski

08/06/2019 10:57AM

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

...

103 »

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.