MySQL :: MySQL Forums

Announcements	Last Post
• MySQL Connector/ODBC 5.3.14 has been released	10/30/2019 04:51PM
• MySQL Connector/C++ 1.1.13 has been released	10/25/2019 05:05AM

New Topic

Pages:

1 2 3 4 5

...

21 »

Subject

Views

Written By

Posted

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

493

Edwin Desouza

02/13/2018 10:18AM

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

4,294

Edwin Desouza

02/18/2016 11:24PM

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

6,011

Edwin Desouza

07/02/2012 10:58AM

MyISAM - Incorrect information in file *.frm

136

Boraiah Manjunatha

07/01/2019 02:06PM

Re: MyISAM - Incorrect information in file *.frm

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

244

Greg Mundt

02/19/2019 09:35AM

Re: Performance by Selections

133

Peter Brawley

02/19/2019 12:02PM

Re: Performance by Selections

139

Greg Mundt

02/21/2019 06:58AM

Re: Performance by Selections

103

Peter Brawley

02/21/2019 01:13PM

Re: Performance by Selections

105

Greg Mundt

02/28/2019 03:56PM

Re: Performance by Selections

111

Peter Brawley

02/28/2019 05:10PM

Re: Performance by Selections

Greg Mundt

03/04/2019 10:14AM

Re: Performance by Selections

Peter Brawley

03/04/2019 11:08AM

Re: Performance by Selections

Greg Mundt

03/22/2019 06:09AM

Re: Performance by Selections

Peter Brawley

03/22/2019 09:29AM

Database Utilities

162

Scott Krise

03/15/2019 10:58AM

Re: Database Utilities

109

Peter Brawley

03/15/2019 11:44AM

Re: Database Utilities

102

Scott Krise

03/15/2019 01:08PM

Re: Database Utilities

Peter Brawley

03/15/2019 01:45PM

Record locking

258

Scott Krise

01/30/2019 10:09AM

Re: Record locking

136

Peter Brawley

01/30/2019 11:13AM

Re: Record locking

127

Scott Krise

01/30/2019 12:18PM

Re: Record locking

129

Peter Brawley

01/30/2019 02:44PM

MyISAM Column / Record Delimiter

272

Alan Halls

12/12/2018 05:25PM

Optimize Table not fixing Blocks/Record

238

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

284

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

185

Peter Brawley

11/23/2018 11:50AM

Error : Too many columns

329

Ian Konda

09/19/2018 07:41AM

Re: Error : Too many columns

243

Peter Brawley

09/19/2018 09:14AM

Re: Error : Too many columns

194

Ian Konda

09/19/2018 09:48AM

Re: Error : Too many columns

223

Peter Brawley

09/19/2018 12:45PM

Cannot open MyISAM backup files with MySQL 8

454

ferit akgul

07/18/2018 02:20PM

Re: Cannot open MyISAM backup files with MySQL 8

251

Peter Brawley

07/19/2018 10:55AM

Re: Cannot open MyISAM backup files with MySQL 8

234

ferit akgul

07/19/2018 11:37AM

Re: Cannot open MyISAM backup files with MySQL 8

230

Peter Brawley

07/20/2018 08:55PM

ONLINE DDL - Incorrect Key

368

G K

07/09/2018 01:14PM

MyISAM multi queries slow performance

385

Kaihao Wang

06/04/2018 05:43PM

Re: MyISAM multi queries slow performance

229

Peter Brawley

06/04/2018 09:58PM

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

511

Michael Uray

01/22/2018 06:20AM

Optimum settings for Small DB running on 2G Ram

455

Hans Brost

10/09/2017 12:20PM

Additional Key Caches

461

alan langridge

09/22/2017 10:53AM

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

642

Eric Robinson

05/04/2017 05:46PM

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

485

Benoit St-Jean

05/04/2017 06:04PM

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

447

Eric Robinson

05/04/2017 08:44PM

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

497

Benoit St-Jean

05/04/2017 09:46PM

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

445

Eric Robinson

05/05/2017 11:23AM

Massive MyISAM query

568

Dave S

05/01/2017 05:59PM

Re: Massive MyISAM query

414

Peter Brawley

05/01/2017 06:16PM

Re: Massive MyISAM query

325

Dave S

05/01/2017 07:52PM

Re: Massive MyISAM query

342

Peter Brawley

05/01/2017 09:05PM

How Switching To InnoDB Helped Us Bust Through MyISAM Walls

594

Edwin Desouza

02/22/2017 12:05AM

Location search in mysql joining 4 tables

1,575

Soubhik Chatterjee

01/21/2017 07:27AM

Re: Location search in mysql joining 4 tables

439

Peter Brawley

01/21/2017 04:25PM

Still disable InnoDB in MySQL 5.7

2,788

Jean-Baptiste SILVY

11/22/2016 12:46AM

Re: Still disable InnoDB in MySQL 5.7

911

Peter Brawley

11/22/2016 02:18PM

Re: Still disable InnoDB in MySQL 5.7

821

Jean-Baptiste SILVY

11/24/2016 10:21PM

Re: Still disable InnoDB in MySQL 5.7

791

Rick James

11/25/2016 08:02PM

MySQL 5.6 Upgrade - Hung On Creating sort index

2,107

Andrew Klug

10/10/2016 09:52AM

Re: MySQL 5.6 Upgrade - Hung On Creating sort index

1,294

Peter Brawley

10/10/2016 12:45PM

Re: MySQL 5.6 Upgrade - Hung On Creating sort index

1,254

Rick James

10/16/2016 04:56PM

Composite index

1,331

Julian Assange

08/26/2016 05:44PM

Re: Composite index

617

Rick James

08/27/2016 01:55PM

Re: Composite index

627

Julian Assange

08/28/2016 06:18AM

Re: Composite index

823

Rick James

08/29/2016 11:34PM

Re: Composite index

684

Julian Assange

08/30/2016 03:16AM

Re: Composite index

610

Rick James

08/31/2016 04:48PM

Too many key parts specified; max 16 parts allowed.

2,428

Abhishek Sahu

07/27/2016 05:40AM

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

2,137

Rick James

07/29/2016 05:10PM

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

1,371

Abhishek Sahu

07/31/2016 04:35AM

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

1,147

Rick James

08/01/2016 10:33AM

slow query / table lock

1,453

Thomas Manninger

06/06/2016 01:55AM

Re: slow query / table lock

704

Thomas Manninger

06/06/2016 02:06AM

Re: slow query / table lock

860

Rick James

06/13/2016 01:55AM

Re: slow query / table lock

646

Rick James

06/13/2016 01:57AM

Backup MySQL MyISAM databases by copying the physical files

1,591

Timothy Mifsud

04/01/2016 08:58AM

Re: Backup MySQL MyISAM databases by copying the physical files

798

Rick James

04/04/2016 12:07PM

Change from InnoDB to MyISAM storage engine

1,331

Michael John

03/29/2016 04:01AM

Re: Change from InnoDB to MyISAM storage engine

758

Peter Brawley

03/29/2016 09:20AM

Re: Change from InnoDB to MyISAM storage engine

750

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

1,468

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

01/29/2016 09:13AM

Re: Fulltext in MyISAM does not work with cyrillic

783

Rick James

01/30/2016 10:20AM

Re: Fulltext in MyISAM does not work with cyrillic

802

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

02/01/2016 02:04AM

Re: Fulltext in MyISAM does not work with cyrillic

700

Rick James

02/02/2016 09:33PM

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

1,519

Richard Jones

01/26/2016 05:45AM

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

757

Rick James

01/27/2016 09:50PM

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

793

Richard Jones

01/28/2016 06:11AM

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

823

Richard Jones

01/28/2016 06:22AM

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

731

Rick James

01/29/2016 06:39PM

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

893

Richard Jones

01/30/2016 03:17PM

information_schema refresh

2,413

Thol Chidambaram

12/22/2015 05:28PM

Re: information_schema refresh

1,077

Rick James

12/23/2015 09:50PM

Re: information_schema refresh

1,060

Peter Brawley

01/29/2016 04:29PM

Cannot display index entries

1,394

Pavlos Ponos

11/07/2015 11:04AM

Re: Cannot display index entries

761

Peter Brawley

11/07/2015 01:46PM

Re: Cannot display index entries

798

Pavlos Ponos

11/07/2015 01:47PM

Re: Cannot display index entries

843

Rick James

11/30/2015 08:15PM

This topic has been moved.: error 2003

theo tek

09/26/2015 11:17PM

Export geants database

1,730

loriot alban

08/25/2015 03:41AM

Confusing "Waiting for table level lock"

3,447

William Oberman

06/27/2015 03:02PM

Re: Confusing "Waiting for table level lock"

1,268

Rick James

07/02/2015 09:40PM

Tables keep crashing and corrupting

2,264

Sebastião Burnay

04/28/2015 10:05AM

Re: Tables keep crashing and corrupting

1,208

Rick James

04/29/2015 06:41PM

Re: Tables keep crashing and corrupting

1,136

Sebastião Burnay

04/30/2015 03:12AM

Re: Tables keep crashing and corrupting

982

Rick James

05/01/2015 07:42PM

Too many key parts specified; max 16 parts allowed

5,160

Ahmad Shahzad

04/02/2015 05:47AM

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

2,595

Peter Brawley

04/02/2015 11:06AM

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

2,015

Rick James

04/04/2015 08:37PM

Table keeps crashing. Why?

2,183

Johannes Ernst

03/24/2015 05:14PM

Re: Table keeps crashing. Why?

1,154

Rick James

03/27/2015 12:22AM

poor create table performance

1,969

Ronald Van Iwaarden

03/04/2015 02:29PM

Slow performance when using LIMIT 1000

2,146

Christian Esborg

02/26/2015 04:32AM

Please don't duplicate-post

1,117

Peter Brawley

02/26/2015 05:03PM

Option to avoid table rebuild on CREATE INDEX?

2,141

David Lambert

02/03/2015 05:39PM

Re: Option to avoid table rebuild on CREATE INDEX?

1,219

Rick James

02/04/2015 07:25PM

Dumping enormous MYISAM table with BLOB based on WHERE clause

2,101

Ifechukwukwu Okobi

01/29/2015 12:40AM

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

1,195

Jonathan Stephens

01/29/2015 06:27AM

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

1,128

Ifechukwukwu Okobi

01/29/2015 10:34AM

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

1,200

Rick James

01/29/2015 04:53PM

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

1,221

Rick James

01/29/2015 04:59PM

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

1,272

Ifechukwukwu Okobi

01/30/2015 05:49AM

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

1,254

Rick James

01/30/2015 12:01PM

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

1,096

Ifechukwukwu Okobi

01/30/2015 05:46AM

Memory Problem with 1 DB. Other DB ok

2,470

Gabriel Dunn

01/22/2015 11:15PM