MySQL :: MySQL Forums

Announcements	Last Post
• Announcing January 2026 Releases featuring MySQL Server 9.6.0 Innovation, 8.4.8 LTS and 8.0.45	01/23/2026 11:56AM

New Topic

Pages:

1 2 3 4 5

...

21 »

Subject

Views

Written By

Posted

Sticky: MySQL 8.0: Still using MyISAM ? It is time to switch to InnoDB ! (1 Posts)

1,047

Edwin Desouza

03/07/2023 09:34AM

Sticky: Migrate MyISAM tables from MySQL 5.7 to 8.0 (1 Posts)

1,371

Edwin Desouza

08/02/2021 10:20AM

Sticky: Meltdown Fix: 40% performance regression for MyISAM; recommend switch to InnoDB (1 Posts)

2,241

Edwin Desouza

02/13/2018 10:18AM

Sticky: MySQL: InnoDB -vs- MyISAM (1 Posts)

6,662

Edwin Desouza

02/18/2016 11:24PM

Sticky: MySQL 5.6: InnoDB Read-only Performance (1 Posts)

7,390

Edwin Desouza

07/02/2012 10:58AM

using the myisam engine and am having trouble with swap memory usage even though there is available system memory

338

Seung Hong

06/05/2025 01:28AM

Index key prefix behaviour in MyISAM

1,172

Hassan Bahrami

08/22/2024 03:51AM

Re: Index key prefix behaviour in MyISAM

337

Edwin Desouza

08/22/2024 09:11AM

Re: Index key prefix behaviour in MyISAM

387

Hassan Bahrami

08/22/2024 09:27AM

Delete slow as not using index

1,088

EDGEFREE DU

02/16/2023 11:30PM

Default storage engine

1,230

K B

07/18/2022 06:26AM

Re: Default storage engine

796

Peter Brawley

07/18/2022 10:14AM

Re: Default storage engine

717

K B

07/18/2022 11:45PM

Re: Default storage engine

692

Peter Brawley

07/19/2022 12:30AM

Re: Default storage engine

681

K B

07/19/2022 01:47AM

Re: Default storage engine

729

Peter Brawley

07/19/2022 03:18PM

Changing ft_min_word_len without rebuilding old indexes - will that work as described below?

1,170

Arkadiusz Miskiewicz

04/12/2022 12:19AM

DATA DIRECTORY and INDEX DIRECTORY

1,448

Евгений Б

12/19/2020 05:11PM

Re: DATA DIRECTORY and INDEX DIRECTORY

848

Peter Brawley

12/19/2020 05:53PM

Re: DATA DIRECTORY and INDEX DIRECTORY

784

Евгений Б

12/20/2020 06:55AM

MySQL v8 - MYISAM Pack Information

1,607

Frank Peacock

09/01/2020 08:04AM

Re: MySQL v8 - MYISAM Pack Information

993

Frank Peacock

09/02/2020 02:30AM

Re: MySQL v8 - MYISAM Pack Information

894

Frank Peacock

09/03/2020 02:49AM

MySQL 8 Windows Deletion Performance Improvement?

1,909

Randy Smith

01/14/2020 03:24PM

Re: MySQL 8 Windows Deletion Performance Improvement?

959

Peter Brawley

01/14/2020 03:37PM

Re: MySQL 8 Windows Deletion Performance Improvement?

948

Randy Smith

01/14/2020 03:44PM

Re: MySQL 8 Windows Deletion Performance Improvement?

1,158

Randy Smith

01/14/2020 03:58PM

Re: MySQL 8 Windows Deletion Performance Improvement?

993

Peter Brawley

01/14/2020 11:30PM

Re: MySQL 8 Windows Deletion Performance Improvement?

1,064

Randy Smith

01/15/2020 07:13AM

Re: MySQL 8 Windows Deletion Performance Improvement?

945

Peter Brawley

01/15/2020 11:33AM

Re: MySQL 8 Windows Deletion Performance Improvement?

974

Randy Smith

01/15/2020 11:44AM

Re: MySQL 8 Windows Deletion Performance Improvement?

959

Randy Smith

01/15/2020 07:17AM

Deletion Woes

2,041

Randy Smith

01/15/2020 11:18AM

MyISAM - Incorrect information in file *.frm

2,784

Boraiah Manjunatha

07/01/2019 02:06PM

Re: MyISAM - Incorrect information in file *.frm

1,256

Peter Brawley

07/01/2019 05:12PM

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

sanjb c

06/29/2019 12:13PM

Performance by Selections

2,047

Greg Mundt

02/19/2019 09:35AM

Re: Performance by Selections

1,254

Peter Brawley

02/19/2019 12:02PM

Re: Performance by Selections

1,293

Greg Mundt

02/21/2019 06:58AM

Re: Performance by Selections

1,135

Peter Brawley

02/21/2019 01:13PM

Re: Performance by Selections

1,207

Greg Mundt

02/28/2019 03:56PM

Re: Performance by Selections

1,136

Peter Brawley

02/28/2019 05:10PM

Re: Performance by Selections

1,117

Greg Mundt

03/04/2019 10:14AM

Re: Performance by Selections

1,156

Peter Brawley

03/04/2019 11:08AM

Re: Performance by Selections

1,162

Greg Mundt

03/22/2019 06:09AM

Re: Performance by Selections

1,097

Peter Brawley

03/22/2019 09:29AM

Database Utilities

1,837

Scott Krise

03/15/2019 10:58AM

Re: Database Utilities

1,051

Peter Brawley

03/15/2019 11:44AM

Re: Database Utilities

1,161

Scott Krise

03/15/2019 01:08PM

Re: Database Utilities

1,071

Peter Brawley

03/15/2019 01:45PM

Record locking

2,096

Scott Krise

01/30/2019 10:09AM

Re: Record locking

1,069

Peter Brawley

01/30/2019 11:13AM

Re: Record locking

1,137

Scott Krise

01/30/2019 12:18PM

Re: Record locking

1,122

Peter Brawley

01/30/2019 02:44PM

MyISAM Column / Record Delimiter

2,050

Alan Halls

12/12/2018 05:25PM

Optimize Table not fixing Blocks/Record

1,826

Jim Staff

11/30/2018 12:25PM

Mysql order by is very slow from 1,000,000 rows, we have nearly 300,000 search results

2,020

Ozden Haldun

11/23/2018 07:29AM

Re: Mysql order by is very slow from 1,000,000 rows, we have nearly 300,000 search results

1,112

Peter Brawley

11/23/2018 11:50AM

Error : Too many columns

3,856

Ian Konda

09/19/2018 07:41AM

Re: Error : Too many columns

1,610

Peter Brawley

09/19/2018 09:14AM

Re: Error : Too many columns

1,376

Ian Konda

09/19/2018 09:48AM

Re: Error : Too many columns

1,612

Peter Brawley

09/19/2018 12:45PM

Cannot open MyISAM backup files with MySQL 8

2,520

ferit akgul

07/18/2018 02:20PM

Re: Cannot open MyISAM backup files with MySQL 8

1,360

Peter Brawley

07/19/2018 10:55AM

Re: Cannot open MyISAM backup files with MySQL 8

1,395

ferit akgul

07/19/2018 11:37AM

Re: Cannot open MyISAM backup files with MySQL 8

1,258

Peter Brawley

07/20/2018 08:55PM

ONLINE DDL - Incorrect Key

2,173

G K

07/09/2018 01:14PM

MyISAM multi queries slow performance

2,037

Kaihao Wang

06/04/2018 05:43PM

Re: MyISAM multi queries slow performance

1,113

Peter Brawley

06/04/2018 09:58PM

Write Buffering / Write Cache to reduce SSD / CFast Flash wearing

2,560

Michael Uray

01/22/2018 06:20AM

Optimum settings for Small DB running on 2G Ram

2,297

Hans Brost

10/09/2017 12:20PM

Additional Key Caches

1,900

alan langridge

09/22/2017 10:53AM

We're a Big MyISAM Shop, But...

2,304

Eric Robinson

05/04/2017 05:46PM

Re: We're a Big MyISAM Shop, But...

1,569

Benoit St-Jean

05/04/2017 06:04PM

Re: We're a Big MyISAM Shop, But...

1,549

Eric Robinson

05/04/2017 08:44PM

Re: We're a Big MyISAM Shop, But...

1,603

Benoit St-Jean

05/04/2017 09:46PM

Re: We're a Big MyISAM Shop, But...

1,456

Eric Robinson

05/05/2017 11:23AM

Massive MyISAM query

2,307

Dave S

05/01/2017 05:59PM

Re: Massive MyISAM query

1,466

Peter Brawley

05/01/2017 06:16PM

Re: Massive MyISAM query

1,230

Dave S

05/01/2017 07:52PM

Re: Massive MyISAM query

1,278

Peter Brawley

05/01/2017 09:05PM

How Switching To InnoDB Helped Us Bust Through MyISAM Walls

2,072

Edwin Desouza

02/22/2017 12:05AM

Location search in mysql joining 4 tables

4,146

Soubhik Chatterjee

01/21/2017 07:27AM

Re: Location search in mysql joining 4 tables

1,416

Peter Brawley

01/21/2017 04:25PM

Still disable InnoDB in MySQL 5.7

5,307

Jean-Baptiste SILVY

11/22/2016 12:46AM

Re: Still disable InnoDB in MySQL 5.7

2,097

Peter Brawley

11/22/2016 02:18PM

Re: Still disable InnoDB in MySQL 5.7

1,954

Jean-Baptiste SILVY

11/24/2016 10:21PM

Re: Still disable InnoDB in MySQL 5.7

1,814

Rick James

11/25/2016 08:02PM

MySQL 5.6 Upgrade - Hung On Creating sort index

4,546

Andrew Klug

10/10/2016 09:52AM

Re: MySQL 5.6 Upgrade - Hung On Creating sort index

2,635

Peter Brawley

10/10/2016 12:45PM

Re: MySQL 5.6 Upgrade - Hung On Creating sort index

2,593

Rick James

10/16/2016 04:56PM

Composite index

3,147

Julian Assange

08/26/2016 05:44PM

Re: Composite index

1,653

Rick James

08/27/2016 01:55PM

Re: Composite index

1,709

Julian Assange

08/28/2016 06:18AM

Re: Composite index

1,880

Rick James

08/29/2016 11:34PM

Re: Composite index

1,665

Julian Assange

08/30/2016 03:16AM

Re: Composite index

1,561

Rick James

08/31/2016 04:48PM

Too many key parts specified; max 16 parts allowed.

6,408

Abhishek Sahu

07/27/2016 05:40AM

Re: Too many key parts specified; max 16 parts allowed.

3,991

Rick James

07/29/2016 05:10PM

Re: Too many key parts specified; max 16 parts allowed.

3,167

Abhishek Sahu

07/31/2016 04:35AM

Re: Too many key parts specified; max 16 parts allowed.

2,489

Rick James

08/01/2016 10:33AM

slow query / table lock

19,263

Thomas Manninger

06/06/2016 01:55AM

Re: slow query / table lock

1,834

Thomas Manninger

06/06/2016 02:06AM

Re: slow query / table lock

2,215

Rick James

06/13/2016 01:55AM

Re: slow query / table lock

1,683

Rick James

06/13/2016 01:57AM

Backup MySQL MyISAM databases by copying the physical files

3,391

Timothy Mifsud

04/01/2016 08:58AM

Re: Backup MySQL MyISAM databases by copying the physical files

1,718

Rick James

04/04/2016 12:07PM

Change from InnoDB to MyISAM storage engine

2,704

Michael John

03/29/2016 04:01AM

Re: Change from InnoDB to MyISAM storage engine

1,730

Peter Brawley

03/29/2016 09:20AM

Re: Change from InnoDB to MyISAM storage engine

1,661

Michael John

03/30/2016 07:40AM

This topic has been moved.: Load Data Vertical Raw using MySQL command

Ferdie Palero

03/29/2016 09:24AM

Fulltext in MyISAM does not work with cyrillic

3,477

Андрей Третяк

01/29/2016 09:13AM

Re: Fulltext in MyISAM does not work with cyrillic

1,848

Rick James

01/30/2016 10:20AM

Re: Fulltext in MyISAM does not work with cyrillic

2,022

Андрей Третяк

02/01/2016 02:04AM

Re: Fulltext in MyISAM does not work with cyrillic

1,869

Rick James

02/02/2016 09:33PM

trying to alter table column to geometry but getting errors. please help.

3,217

Richard Jones

01/26/2016 05:45AM

Re: trying to alter table column to geometry but getting errors. please help.

1,698

Rick James

01/27/2016 09:50PM

Re: trying to alter table column to geometry but getting errors. please help.

1,880

Richard Jones

01/28/2016 06:11AM

Re: trying to alter table column to geometry but getting errors. please help.

1,946

Richard Jones

01/28/2016 06:22AM

Re: trying to alter table column to geometry but getting errors. please help.

1,671

Rick James

01/29/2016 06:39PM

Re: trying to alter table column to geometry but getting errors. please help.

1,934

Richard Jones

01/30/2016 03:17PM

information_schema refresh

5,434

Thol Chidambaram

12/22/2015 05:28PM

Re: information_schema refresh

2,378

Rick James

12/23/2015 09:50PM

Re: information_schema refresh

2,253

Peter Brawley

01/29/2016 04:29PM

Cannot display index entries

2,750

Pavlos Ponos

11/07/2015 11:04AM

Re: Cannot display index entries

1,670

Peter Brawley

11/07/2015 01:46PM

Re: Cannot display index entries

1,683

Pavlos Ponos

11/07/2015 01:47PM

Re: Cannot display index entries

1,762

Rick James

11/30/2015 08:15PM

This topic has been moved.: error 2003

theo tek

09/26/2015 11:17PM

Export geants database

3,019

loriot alban

08/25/2015 03:41AM

Confusing "Waiting for table level lock"

5,312

William Oberman

06/27/2015 03:02PM

Re: Confusing "Waiting for table level lock"

2,316

Rick James

07/02/2015 09:40PM

Tables keep crashing and corrupting

3,813

Sebastião Burnay

04/28/2015 10:05AM

Re: Tables keep crashing and corrupting

2,200

Rick James

04/29/2015 06:41PM

Re: Tables keep crashing and corrupting

2,093

Sebastião Burnay

04/30/2015 03:12AM

Re: Tables keep crashing and corrupting

2,085

Rick James

05/01/2015 07:42PM

Too many key parts specified; max 16 parts allowed

9,772

Ahmad Shahzad

04/02/2015 05:47AM

Re: Too many key parts specified; max 16 parts allowed

5,683

Peter Brawley

04/02/2015 11:06AM

Re: Too many key parts specified; max 16 parts allowed

3,806

Rick James

04/04/2015 08:37PM

Table keeps crashing. Why?

3,986

Johannes Ernst

03/24/2015 05:14PM

Re: Table keeps crashing. Why?

2,222

Rick James

03/27/2015 12:22AM

poor create table performance

3,367

Ronald Van Iwaarden

03/04/2015 02:29PM

Slow performance when using LIMIT 1000

4,218

Christian Esborg

02/26/2015 04:32AM

Please don't duplicate-post

2,082

Peter Brawley

02/26/2015 05:03PM

Option to avoid table rebuild on CREATE INDEX?

3,804

David Lambert

02/03/2015 05:39PM

Re: Option to avoid table rebuild on CREATE INDEX?

2,333

Rick James

02/04/2015 07:25PM

Dumping enormous MYISAM table with BLOB based on WHERE clause

3,687

Ifechukwukwu Okobi

01/29/2015 12:40AM

Re: Dumping enormous MYISAM table with BLOB based on WHERE clause

2,317

Jonathan Stephens

01/29/2015 06:27AM

Re: Dumping enormous MYISAM table with BLOB based on WHERE clause

2,102

Ifechukwukwu Okobi

01/29/2015 10:34AM

Re: Dumping enormous MYISAM table with BLOB based on WHERE clause

2,255

Rick James

01/29/2015 04:53PM

Re: Dumping enormous MYISAM table with BLOB based on WHERE clause

2,303

Rick James

01/29/2015 04:59PM

Re: Dumping enormous MYISAM table with BLOB based on WHERE clause

2,331

Ifechukwukwu Okobi

01/30/2015 05:49AM

Re: Dumping enormous MYISAM table with BLOB based on WHERE clause

2,320

Rick James

01/30/2015 12:01PM

Re: Dumping enormous MYISAM table with BLOB based on WHERE clause

2,068

Ifechukwukwu Okobi

01/30/2015 05:46AM

Pages:

1 2 3 4 5

...

21 »

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.