MySQL :: MySQL Forums

Announcements	Last Post
• Announcing October 2025 Releases featuring MySQL Server 9.5.0 Innovation, 8.4.7 LTS and 8.0.44	10/25/2025 05:45AM

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)

895

Edwin Desouza

03/07/2023 09:34AM

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

1,188

Edwin Desouza

08/02/2021 10:20AM

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

2,120

Edwin Desouza

02/13/2018 10:18AM

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

6,501

Edwin Desouza

02/18/2016 11:24PM

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

7,262

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

165

Seung Hong

06/05/2025 01:28AM

Index key prefix behaviour in MyISAM

1,032

Hassan Bahrami

08/22/2024 03:51AM

Re: Index key prefix behaviour in MyISAM

231

Edwin Desouza

08/22/2024 09:11AM

Re: Index key prefix behaviour in MyISAM

298

Hassan Bahrami

08/22/2024 09:27AM

Delete slow as not using index

916

EDGEFREE DU

02/16/2023 11:30PM

Default storage engine

1,043

K B

07/18/2022 06:26AM

Re: Default storage engine

623

Peter Brawley

07/18/2022 10:14AM

Re: Default storage engine

598

K B

07/18/2022 11:45PM

Re: Default storage engine

510

Peter Brawley

07/19/2022 12:30AM

Re: Default storage engine

555

K B

07/19/2022 01:47AM

Re: Default storage engine

574

Peter Brawley

07/19/2022 03:18PM

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

971

Arkadiusz Miskiewicz

04/12/2022 12:19AM

DATA DIRECTORY and INDEX DIRECTORY

1,318

Евгений Б

12/19/2020 05:11PM

Re: DATA DIRECTORY and INDEX DIRECTORY

733

Peter Brawley

12/19/2020 05:53PM

Re: DATA DIRECTORY and INDEX DIRECTORY

699

Евгений Б

12/20/2020 06:55AM

MySQL v8 - MYISAM Pack Information

1,402

Frank Peacock

09/01/2020 08:04AM

Re: MySQL v8 - MYISAM Pack Information

858

Frank Peacock

09/02/2020 02:30AM

Re: MySQL v8 - MYISAM Pack Information

764

Frank Peacock

09/03/2020 02:49AM

MySQL 8 Windows Deletion Performance Improvement?

1,710

Randy Smith

01/14/2020 03:24PM

Re: MySQL 8 Windows Deletion Performance Improvement?

814

Peter Brawley

01/14/2020 03:37PM

Re: MySQL 8 Windows Deletion Performance Improvement?

856

Randy Smith

01/14/2020 03:44PM

Re: MySQL 8 Windows Deletion Performance Improvement?

973

Randy Smith

01/14/2020 03:58PM

Re: MySQL 8 Windows Deletion Performance Improvement?

805

Peter Brawley

01/14/2020 11:30PM

Re: MySQL 8 Windows Deletion Performance Improvement?

901

Randy Smith

01/15/2020 07:13AM

Re: MySQL 8 Windows Deletion Performance Improvement?

839

Peter Brawley

01/15/2020 11:33AM

Re: MySQL 8 Windows Deletion Performance Improvement?

877

Randy Smith

01/15/2020 11:44AM

Re: MySQL 8 Windows Deletion Performance Improvement?

858

Randy Smith

01/15/2020 07:17AM

Deletion Woes

1,864

Randy Smith

01/15/2020 11:18AM

MyISAM - Incorrect information in file *.frm

2,642

Boraiah Manjunatha

07/01/2019 02:06PM

Re: MyISAM - Incorrect information in file *.frm

1,161

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

1,909

Greg Mundt

02/19/2019 09:35AM

Re: Performance by Selections

1,132

Peter Brawley

02/19/2019 12:02PM

Re: Performance by Selections

1,107

Greg Mundt

02/21/2019 06:58AM

Re: Performance by Selections

956

Peter Brawley

02/21/2019 01:13PM

Re: Performance by Selections

1,037

Greg Mundt

02/28/2019 03:56PM

Re: Performance by Selections

1,012

Peter Brawley

02/28/2019 05:10PM

Re: Performance by Selections

1,003

Greg Mundt

03/04/2019 10:14AM

Re: Performance by Selections

1,015

Peter Brawley

03/04/2019 11:08AM

Re: Performance by Selections

1,045

Greg Mundt

03/22/2019 06:09AM

Re: Performance by Selections

976

Peter Brawley

03/22/2019 09:29AM

Database Utilities

1,677

Scott Krise

03/15/2019 10:58AM

Re: Database Utilities

943

Peter Brawley

03/15/2019 11:44AM

Re: Database Utilities

1,049

Scott Krise

03/15/2019 01:08PM

Re: Database Utilities

936

Peter Brawley

03/15/2019 01:45PM

Record locking

1,926

Scott Krise

01/30/2019 10:09AM

Re: Record locking

975

Peter Brawley

01/30/2019 11:13AM

Re: Record locking

1,006

Scott Krise

01/30/2019 12:18PM

Re: Record locking

996

Peter Brawley

01/30/2019 02:44PM

MyISAM Column / Record Delimiter

1,893

Alan Halls

12/12/2018 05:25PM

Optimize Table not fixing Blocks/Record

1,694

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

1,865

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

Peter Brawley

11/23/2018 11:50AM

Error : Too many columns

3,655

Ian Konda

09/19/2018 07:41AM

Re: Error : Too many columns

1,468

Peter Brawley

09/19/2018 09:14AM

Re: Error : Too many columns

1,239

Ian Konda

09/19/2018 09:48AM

Re: Error : Too many columns

1,504

Peter Brawley

09/19/2018 12:45PM

Cannot open MyISAM backup files with MySQL 8

2,368

ferit akgul

07/18/2018 02:20PM

Re: Cannot open MyISAM backup files with MySQL 8

1,213

Peter Brawley

07/19/2018 10:55AM

Re: Cannot open MyISAM backup files with MySQL 8

1,244

ferit akgul

07/19/2018 11:37AM

Re: Cannot open MyISAM backup files with MySQL 8

1,154

Peter Brawley

07/20/2018 08:55PM

ONLINE DDL - Incorrect Key

1,988

G K

07/09/2018 01:14PM

MyISAM multi queries slow performance

1,782

Kaihao Wang

06/04/2018 05:43PM

Re: MyISAM multi queries slow performance

1,024

Peter Brawley

06/04/2018 09:58PM

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

2,340

Michael Uray

01/22/2018 06:20AM

Optimum settings for Small DB running on 2G Ram

2,107

Hans Brost

10/09/2017 12:20PM

Additional Key Caches

1,753

alan langridge

09/22/2017 10:53AM

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

2,136

Eric Robinson

05/04/2017 05:46PM

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

1,411

Benoit St-Jean

05/04/2017 06:04PM

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

1,425

Eric Robinson

05/04/2017 08:44PM

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

1,459

Benoit St-Jean

05/04/2017 09:46PM

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

1,318

Eric Robinson

05/05/2017 11:23AM

Massive MyISAM query

2,161

Dave S

05/01/2017 05:59PM

Re: Massive MyISAM query

1,306

Peter Brawley

05/01/2017 06:16PM

Re: Massive MyISAM query

1,130

Dave S

05/01/2017 07:52PM

Re: Massive MyISAM query

1,188

Peter Brawley

05/01/2017 09:05PM

How Switching To InnoDB Helped Us Bust Through MyISAM Walls

1,928

Edwin Desouza

02/22/2017 12:05AM

Location search in mysql joining 4 tables

3,972

Soubhik Chatterjee

01/21/2017 07:27AM

Re: Location search in mysql joining 4 tables

1,317

Peter Brawley

01/21/2017 04:25PM

Still disable InnoDB in MySQL 5.7

5,122

Jean-Baptiste SILVY

11/22/2016 12:46AM

Re: Still disable InnoDB in MySQL 5.7

1,960

Peter Brawley

11/22/2016 02:18PM

Re: Still disable InnoDB in MySQL 5.7

1,811

Jean-Baptiste SILVY

11/24/2016 10:21PM

Re: Still disable InnoDB in MySQL 5.7

1,691

Rick James

11/25/2016 08:02PM

MySQL 5.6 Upgrade - Hung On Creating sort index

4,395

Andrew Klug

10/10/2016 09:52AM

Re: MySQL 5.6 Upgrade - Hung On Creating sort index

2,520

Peter Brawley

10/10/2016 12:45PM

Re: MySQL 5.6 Upgrade - Hung On Creating sort index

2,491

Rick James

10/16/2016 04:56PM

Composite index

2,953

Julian Assange

08/26/2016 05:44PM

Re: Composite index

1,474

Rick James

08/27/2016 01:55PM

Re: Composite index

1,552

Julian Assange

08/28/2016 06:18AM

Re: Composite index

1,770

Rick James

08/29/2016 11:34PM

Re: Composite index

1,559

Julian Assange

08/30/2016 03:16AM

Re: Composite index

1,443

Rick James

08/31/2016 04:48PM

Too many key parts specified; max 16 parts allowed.

6,199

Abhishek Sahu

07/27/2016 05:40AM

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

3,868

Rick James

07/29/2016 05:10PM

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

3,037

Abhishek Sahu

07/31/2016 04:35AM

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

2,398

Rick James

08/01/2016 10:33AM

slow query / table lock

19,094

Thomas Manninger

06/06/2016 01:55AM

Re: slow query / table lock

1,665

Thomas Manninger

06/06/2016 02:06AM

Re: slow query / table lock

2,025

Rick James

06/13/2016 01:55AM

Re: slow query / table lock

1,563

Rick James

06/13/2016 01:57AM

Backup MySQL MyISAM databases by copying the physical files

3,214

Timothy Mifsud

04/01/2016 08:58AM

Re: Backup MySQL MyISAM databases by copying the physical files

1,619

Rick James

04/04/2016 12:07PM

Change from InnoDB to MyISAM storage engine

2,566

Michael John

03/29/2016 04:01AM

Re: Change from InnoDB to MyISAM storage engine

1,614

Peter Brawley

03/29/2016 09:20AM

Re: Change from InnoDB to MyISAM storage engine

1,576

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

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

01/29/2016 09:13AM

Re: Fulltext in MyISAM does not work with cyrillic

1,722

Rick James

01/30/2016 10:20AM

Re: Fulltext in MyISAM does not work with cyrillic

1,894

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

02/01/2016 02:04AM

Re: Fulltext in MyISAM does not work with cyrillic

1,713

Rick James

02/02/2016 09:33PM

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

3,019

Richard Jones

01/26/2016 05:45AM

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

1,588

Rick James

01/27/2016 09:50PM

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

1,713

Richard Jones

01/28/2016 06:11AM

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

1,791

Richard Jones

01/28/2016 06:22AM

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

1,560

Rick James

01/29/2016 06:39PM

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

1,818

Richard Jones

01/30/2016 03:17PM

information_schema refresh

5,219

Thol Chidambaram

12/22/2015 05:28PM

Re: information_schema refresh

2,216

Rick James

12/23/2015 09:50PM

Re: information_schema refresh

2,147

Peter Brawley

01/29/2016 04:29PM

Cannot display index entries

2,606

Pavlos Ponos

11/07/2015 11:04AM

Re: Cannot display index entries

1,517

Peter Brawley

11/07/2015 01:46PM

Re: Cannot display index entries

1,584

Pavlos Ponos

11/07/2015 01:47PM

Re: Cannot display index entries

1,636

Rick James

11/30/2015 08:15PM

This topic has been moved.: error 2003

theo tek

09/26/2015 11:17PM

Export geants database

2,866

loriot alban

08/25/2015 03:41AM

Confusing "Waiting for table level lock"

5,146

William Oberman

06/27/2015 03:02PM

Re: Confusing "Waiting for table level lock"

2,206

Rick James

07/02/2015 09:40PM

Tables keep crashing and corrupting

3,664

Sebastião Burnay

04/28/2015 10:05AM

Re: Tables keep crashing and corrupting

2,089

Rick James

04/29/2015 06:41PM

Re: Tables keep crashing and corrupting

1,945

Sebastião Burnay

04/30/2015 03:12AM

Re: Tables keep crashing and corrupting

1,882

Rick James

05/01/2015 07:42PM

Too many key parts specified; max 16 parts allowed

9,588

Ahmad Shahzad

04/02/2015 05:47AM

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

5,494

Peter Brawley

04/02/2015 11:06AM

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

3,614

Rick James

04/04/2015 08:37PM

Table keeps crashing. Why?

3,832

Johannes Ernst

03/24/2015 05:14PM

Re: Table keeps crashing. Why?

2,108

Rick James

03/27/2015 12:22AM

poor create table performance

3,211

Ronald Van Iwaarden

03/04/2015 02:29PM

Slow performance when using LIMIT 1000

4,029

Christian Esborg

02/26/2015 04:32AM

Please don't duplicate-post

1,962

Peter Brawley

02/26/2015 05:03PM

Option to avoid table rebuild on CREATE INDEX?

3,623

David Lambert

02/03/2015 05:39PM

Re: Option to avoid table rebuild on CREATE INDEX?

2,198

Rick James

02/04/2015 07:25PM

Dumping enormous MYISAM table with BLOB based on WHERE clause

3,493

Ifechukwukwu Okobi

01/29/2015 12:40AM

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

2,129

Jonathan Stephens

01/29/2015 06:27AM

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

1,996

Ifechukwukwu Okobi

01/29/2015 10:34AM

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

2,136

Rick James

01/29/2015 04:53PM

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

2,151

Rick James

01/29/2015 04:59PM

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

2,161

Ifechukwukwu Okobi

01/30/2015 05:49AM

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

2,130

Rick James

01/30/2015 12:01PM

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

1,958

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.