MySQL :: MySQL Forums :: InnoDB

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Pages:

« 1 2 3 4 5

...

105 »

Subject

Views

Written By

Posted

KEY_BLOCK_SIZE=12 in innodb

773

06/03/2020 04:32AM

Re: KEY_BLOCK_SIZE=12 in innodb

264

Peter Brawley

06/03/2020 08:48AM

MySQL Performance : XFS -vs- EXT4

3,148

Edwin Desouza

05/13/2020 02:38PM

MySQL Performance : XFS -vs- EXT4 Story

627

Edwin Desouza

05/13/2020 02:37PM

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

672

Nico Schoemaker

11/13/2019 03:43AM

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

267

Graham Clifford

04/23/2020 08:39AM

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

231

Peter Brawley

04/23/2020 10:45AM

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

238

Graham Clifford

05/12/2020 01:21PM

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

460

Ram Freedman

05/12/2020 07:28AM

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

219

Peter Brawley

05/12/2020 12:19PM

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

671

04/30/2020 05:54AM

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

296

Peter Brawley

04/30/2020 12:12PM

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

270

05/01/2020 02:44AM

Upgrade From MySQL 5.7 to 8.20

494

04/29/2020 08:02AM

Re: Upgrade From MySQL 5.7 to 8.20

279

Peter Brawley

04/29/2020 09:28AM

LIKE not working as expected

584

04/18/2020 08:37PM

Re: LIKE not working as expected

303

Peter Brawley

04/18/2020 09:14PM

Re: LIKE not working as expected

272

04/19/2020 12:27AM

Re: LIKE not working as expected

259

Peter Brawley

04/19/2020 10:38AM

Re: LIKE not working as expected

286

04/23/2020 07:13PM

Re: LIKE not working as expected

242

Peter Brawley

04/27/2020 08:13AM

Re: LIKE not working as expected

249

04/27/2020 11:02AM

Re: LIKE not working as expected

253

04/27/2020 12:00PM

update queries running slow after colation change

489

Doug Barger

04/24/2020 10:26AM

Re: update queries running slow after colation change

222

Peter Brawley

04/24/2020 03:38PM

Re: update queries running slow after colation change

214

Doug Barger

04/24/2020 03:45PM

Re: update queries running slow after colation change

241

Peter Brawley

04/25/2020 07:51AM

Re: update queries running slow after colation change

216

Doug Barger

04/26/2020 03:54PM

Re: update queries running slow after colation change

297

Peter Brawley

04/26/2020 07:07PM

Re: update queries running slow after colation change

224

Doug Barger

04/26/2020 07:18PM

Understanding InnoDB rw-lock stats

561

Edwin Desouza

04/14/2020 09:14AM

Issue with `ibtmp1` file preventing start up

891

C D

04/01/2020 09:28PM

Re: Issue with `ibtmp1` file preventing start up

322

Peter Brawley

04/02/2020 08:37AM

Re: Issue with `ibtmp1` file preventing start up

319

C D

04/02/2020 11:47AM

Re: Issue with `ibtmp1` file preventing start up

302

Peter Brawley

04/02/2020 03:03PM

Re: Issue with `ibtmp1` file preventing start up

289

C D

04/02/2020 03:36PM

Re: Issue with `ibtmp1` file preventing start up

318

Peter Brawley

04/02/2020 03:44PM

innodb_buffer_pool_size MySQL Windows question

1,106

John Miluzzo

10/31/2019 03:55PM

Re: innodb_buffer_pool_size MySQL Windows question

409

Peter Brawley

10/31/2019 04:45PM

Re: innodb_buffer_pool_size MySQL Windows question

416

John Miluzzo

10/31/2019 06:48PM

Re: innodb_buffer_pool_size MySQL Windows question

343

John Miluzzo

10/31/2019 08:24PM

Re: innodb_buffer_pool_size MySQL Windows question

299

R Farris

04/01/2020 08:19AM

Re: innodb_buffer_pool_size MySQL Windows question

271

Peter Brawley

04/01/2020 08:36AM

Orphaned idb file

525

Daniel Olivieri Parmera

03/12/2020 01:16PM

Re: Orphaned idb file

277

Peter Brawley

03/12/2020 04:14PM

Early row lookup

622

Zhou Zhou

03/02/2020 03:49AM

mysql 5.7 crashes on corrupt ibdata1 file

706

Matthijs Tempels

02/26/2020 08:25AM

Re: mysql 5.7 crashes on corrupt ibdata1 file

378

Peter Brawley

02/26/2020 12:09PM

Redundant InnoDB lock

675

Sergei Muraviev

02/10/2020 06:04AM

Re: Redundant InnoDB lock

430

Jakub Lopuszanski

02/17/2020 06:06AM

Re: Redundant InnoDB lock

304

Edwin Desouza

02/17/2020 10:59AM

Re: Redundant InnoDB lock

336

Sergei Muraviev

02/18/2020 06:42PM

Problems joining big tables

554

Claudio Battaglino

02/16/2020 04:08PM

Re: Problems joining big tables

287

Peter Brawley

02/16/2020 08:47PM

Re: Problems joining big tables

280

Claudio Battaglino

02/18/2020 10:40AM

MySQL 8.0: InnoDB -- New Redo Log

444

Edwin Desouza

02/14/2020 11:18PM

Help on Query with DATE BETWEEN not performant

1,179

Kristijan Marin

02/02/2020 06:51PM

Re: Help on Query with DATE BETWEEN not performant

438

Kristijan Marin

02/02/2020 07:13PM

Re: Help on Query with DATE BETWEEN not performant

441

Peter Brawley

02/02/2020 10:30PM

Re: Help on Query with DATE BETWEEN not performant

409

Kristijan Marin

02/03/2020 04:16AM

Re: Help on Query with DATE BETWEEN not performant

441

Kristijan Marin

02/03/2020 08:12AM

Re: Help on Query with DATE BETWEEN not performant

418

Peter Brawley

02/03/2020 10:45AM

Re: Help on Query with DATE BETWEEN not performant

429

Kristijan Marin

02/03/2020 11:20AM

Re: Help on Query with DATE BETWEEN not performant

395

Peter Brawley

02/03/2020 12:02PM

Re: Help on Query with DATE BETWEEN not performant

434

Kristijan Marin

02/03/2020 12:26PM

Re: Help on Query with DATE BETWEEN not performant

415

Peter Brawley

02/03/2020 04:19PM

Re: Help on Query with DATE BETWEEN not performant

417

Kristijan Marin

02/03/2020 06:21PM

Re: Help on Query with DATE BETWEEN not performant

438

Peter Brawley

02/03/2020 08:38PM

Re: Help on Query with DATE BETWEEN not performant

421

Kristijan Marin

02/04/2020 01:03PM

Re: Help on Query with DATE BETWEEN not performant

430

Peter Brawley

02/04/2020 01:42PM

Re: Help on Query with DATE BETWEEN not performant

457

Kristijan Marin

02/04/2020 02:48PM

Re: Help on Query with DATE BETWEEN not performant

413

Peter Brawley

02/04/2020 05:26PM

Re: Help on Query with DATE BETWEEN not performant

442

Peter Brawley

02/04/2020 05:27PM

Re: Help on Query with DATE BETWEEN not performant

389

Kristijan Marin

02/06/2020 04:21PM

Re: Help on Query with DATE BETWEEN not performant

416

Kristijan Marin

02/06/2020 04:31PM

Re: Help on Query with DATE BETWEEN not performant

447

Peter Brawley

02/06/2020 10:57PM

Re: Help on Query with DATE BETWEEN not performant

395

Kristijan Marin

02/09/2020 08:46AM

Re: Help on Query with DATE BETWEEN not performant

418

Peter Brawley

02/09/2020 11:48AM

Re: Help on Query with DATE BETWEEN not performant

402

Edwin Desouza

02/09/2020 05:04PM

Re: Help on Query with DATE BETWEEN not performant

396

Kristijan Marin

02/04/2020 04:12PM

When was table or DB statistics gathered

734

sreekanth pm

01/23/2020 08:14AM

show engine innodb status not showing most recent deadlock

813

Stephen McCants

01/03/2020 11:36AM

Re: show engine innodb status not showing most recent deadlock

337

Stephen McCants

01/13/2020 02:11PM

Re: show engine innodb status not showing most recent deadlock

407

Peter Brawley

01/13/2020 07:51PM

Re: show engine innodb status not showing most recent deadlock

369

Stephen McCants

01/14/2020 09:58AM

Re: show engine innodb status not showing most recent deadlock

326

Peter Brawley

01/14/2020 10:47AM

How to recover a table with a corrupted partition?

832

harry sheng

01/07/2020 11:57AM

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

339

Peter Brawley

01/07/2020 01:51PM

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

346

harry sheng

01/07/2020 03:13PM

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

351

harry sheng

01/07/2020 03:42PM

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

348

Peter Brawley

01/07/2020 07:44PM

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

360

harry sheng

01/09/2020 08:23AM

[mysql] Error: MySQL shutdown unexpectedly.

2,324

Akifcan Kara

12/11/2019 04:22AM

Re: [mysql] Error: MySQL shutdown unexpectedly.

812

Peter Brawley

12/11/2019 12:03PM

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

756

Cesar Murilo Cesar

11/29/2019 10:07AM

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

280

Peter Brawley

12/11/2019 11:58AM

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

2,764

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

2,521

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

1,011

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

1,577

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

1,020

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

1,285

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

1,922

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

1,080

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

826

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

693

Peter Brawley

11/06/2019 10:15AM

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

1,037

Rahul n

11/25/2019 11:31PM

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

329

Peter Brawley

11/26/2019 11:47AM

MySQL 8.0: InnoDB Deep Dive

686

Edwin Desouza

11/19/2019 10:31PM

MySQL Clone

481

Edwin Desouza

11/17/2019 10:48PM

MySQL Clone Plugin Speed Test

458

Edwin Desouza

11/13/2019 06:52PM

Information on Analyze and Optimize

761

sreekanth pm

10/14/2019 04:46AM

Re: Information on Analyze and Optimize

304

sreekanth pm

10/15/2019 11:01PM

Re: Information on Analyze and Optimize

349

Peter Brawley

10/18/2019 09:23AM

Re: Information on Analyze and Optimize

323

sreekanth pm

10/20/2019 11:09PM

Re: Information on Analyze and Optimize

301

Peter Brawley

10/21/2019 11:08AM

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

2,046

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

10/16/2019 12:51AM

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

1,204

Peter Brawley

10/18/2019 09:44AM

Repeatable Read update sees new value from another session

560

Bill Okara

10/17/2019 04:23PM

Mysql crash on startup

789

Stefano Passiatore

10/14/2019 01:48AM

Re: Mysql crash on startup

340

Peter Brawley

10/15/2019 10:48AM

cached lock_sys hash value in block descriptor

510

Chen Fu

10/13/2019 11:05AM

The total number of locks exceeds the lock table sizeSource

2,976

10/07/2019 02:16AM

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

693

Peter Brawley

10/07/2019 11:16AM

Database recovery

493

kaling rajan

10/04/2019 02:27AM

Re: Database recovery

257

Peter Brawley

10/04/2019 08:31AM

Exact table count for all tables in a schema.

1,174

sreekanth pm

09/13/2019 01:53AM

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

349

Peter Brawley

09/13/2019 09:43AM

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

349

sreekanth pm

09/16/2019 11:15PM

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

333

Peter Brawley

09/17/2019 10:07AM

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

316

sreekanth pm

09/19/2019 12:24AM

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

390

Peter Brawley

09/19/2019 09:38AM

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

382

sreekanth pm

09/20/2019 04:04AM

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

329

Peter Brawley

09/20/2019 09:50AM

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

312

sreekanth pm

09/20/2019 10:03AM

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

367

Peter Brawley

09/20/2019 12:45PM

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

352

sreekanth pm

09/22/2019 11:51PM

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

293

Peter Brawley

09/23/2019 10:21AM

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

371

sreekanth pm

09/24/2019 10:45PM

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

337

Peter Brawley

09/25/2019 11:01AM

create_time value is incorrect from information_schema.tables

1,030

D BA

08/28/2019 02:19AM

Re: create_time value is incorrect from information_schema.tables

450

Frederic Descamps

08/28/2019 05:56PM

Re: create_time value is incorrect from information_schema.tables

413

D BA

08/28/2019 11:32PM

unable to shrink IBDATA1 file

986

P N Narender Babu

08/21/2019 12:32AM

Re: unable to shrink IBDATA1 file

387

james wang

08/21/2019 02:12AM

Re: unable to shrink IBDATA1 file

409

P N Narender Babu

08/21/2019 03:34AM

Re: unable to shrink IBDATA1 file

358

Peter Brawley

08/21/2019 10:26AM

Re: unable to shrink IBDATA1 file

359

P N Narender Babu

08/22/2019 03:47AM

On the auto-extending innodb_system data file

5,486

Maurice Volaski

08/05/2019 08:46PM

Re: On the auto-extending innodb_system data file

1,717

Peter Brawley

08/06/2019 10:56AM

Re: On the auto-extending innodb_system data file

1,154

Maurice Volaski

08/08/2019 07:39PM

Re: On the auto-extending innodb_system data file

1,244

Maurice Volaski

08/08/2019 09:58PM

Re: On the auto-extending innodb_system data file

1,084

Peter Brawley

08/09/2019 09:50AM

Re: On the auto-extending innodb_system data file

1,081

Maurice Volaski

08/10/2019 01:33AM

Re: On the auto-extending innodb_system data file

1,013

Peter Brawley

08/10/2019 11:52AM

Re: On the auto-extending innodb_system data file

1,047

Maurice Volaski

08/19/2019 02:43PM

How to update two tables but limit one row?

866

nobody nobody

02/09/2019 05:36PM

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

402

nobody nobody

02/09/2019 05:38PM

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

415

Peter Brawley

02/09/2019 08:28PM

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

298

08/14/2019 06:12AM

Free up space after dropping indexes

701

Alexandru Badulescu

08/06/2019 02:53AM

Table Data gets Deleted automatically Urgent

781

samuel muendo

07/29/2019 11:14PM

Re: Table Data gets Deleted automatically Urgent

355

Peter Brawley

07/30/2019 09:19AM

Insert to InnoDB table stops after about 40,000 rows

1,888

07/16/2019 10:43AM

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

405

Peter Brawley

07/16/2019 10:57AM

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

320

07/16/2019 03:01PM

How to show hideen column values about MVCC?

2,032

PC N

07/08/2019 10:06PM

InnoDB field type size vs file size descrepency?

873

Eman G

07/05/2019 12:58PM

Re: InnoDB field type size vs file size descrepency?

357

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

949

mike hill

05/27/2019 10:05PM

Re: risk for innodb_flush_method=nosync

455

Peter Brawley

05/27/2019 11:12PM

Re: risk for innodb_flush_method=nosync

472

mike hill

05/28/2019 09:27PM

Re: risk for innodb_flush_method=nosync

398

Peter Brawley

05/29/2019 10:11AM

Re: risk for innodb_flush_method=nosync

859

Mike Hill

05/31/2019 01:13AM

Re: risk for innodb_flush_method=nosync

549

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

...

105 »

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.