MySQL :: MySQL Forums :: Performance

Announcements	Last Post
• MySQL Enterprise Monitor 3.4.3 has been released	09/22/2017 02:51PM
• MySQL Enterprise Monitor 3.3.5 has been released	09/22/2017 01:27PM
• MySQL Enterprise Monitor 3.2.9 has been released	09/22/2017 01:05PM
• MySQL Community Server 8.0.3-rc has been released (part 2/2)	09/21/2017 09:10AM
• MySQL Community Server 8.0.3-rc has been released (part 1/2)	09/21/2017 09:08AM

New Topic

Pages:

« 1 2 3 4 5

...

73 »

Subject

Views

Written By

Posted

Fast way to have an inparameter match all values? (COALESCE slow)

1,017

Ola Arwidsson

03/26/2015 06:40AM

Re: Fast way to have an inparameter match all values? (COALESCE slow)

490

Peter Brawley

03/26/2015 10:45AM

Re: Fast way to have an inparameter match all values? (COALESCE slow)

438

Ola Arwidsson

03/30/2015 01:22AM

Re: Fast way to have an inparameter match all values? (COALESCE slow)

522

Ola Arwidsson

03/30/2015 03:27AM

Re: Fast way to have an inparameter match all values? (COALESCE slow)

422

Peter Brawley

03/30/2015 11:16AM

system table space vs file per table space

842

jongse park

03/27/2015 12:35AM

Re: system table space vs file per table space

421

Rick James

03/28/2015 03:36PM

Slow COUNT + GROUP BY

1,159

Refael Dakar

03/20/2015 07:00AM

Re: Slow COUNT + GROUP BY

487

Jeremy Smyth

03/20/2015 07:55AM

Re: Slow COUNT + GROUP BY

470

Refael Dakar

03/20/2015 08:00AM

Re: Slow COUNT + GROUP BY

433

Rick James

03/22/2015 04:11PM

Re: Slow COUNT + GROUP BY

419

Refael Dakar

03/23/2015 12:46AM

Re: Slow COUNT + GROUP BY

528

Øystein Grøvlen

03/23/2015 02:45AM

Re: Slow COUNT + GROUP BY

603

Matan K

03/23/2015 04:30AM

Re: Slow COUNT + GROUP BY

555

Øystein Grøvlen

03/23/2015 06:04AM

Re: Slow COUNT + GROUP BY

422

Matan K

03/23/2015 08:13AM

Re: Slow COUNT + GROUP BY

461

Øystein Grøvlen

03/24/2015 02:02AM

Re: Slow COUNT + GROUP BY

427

Matan K

03/24/2015 02:51AM

Re: Slow COUNT + GROUP BY

483

Øystein Grøvlen

03/24/2015 03:37AM

Query Optimization Needed

1,013

Devrishi Shandilya

02/11/2015 01:31AM

Re: Query Optimization Needed

461

Peter Brawley

02/11/2015 12:42PM

Re: Query Optimization Needed

536

Devrishi Shandilya

02/12/2015 03:51AM

Re: Query Optimization Needed

511

Peter Brawley

02/12/2015 01:24PM

Re: Query Optimization Needed

508

Devrishi Shandilya

02/13/2015 06:53AM

Re: Query Optimization Needed

438

Peter Brawley

02/13/2015 07:36AM

Re: Query Optimization Needed

450

Rick James

02/14/2015 01:04AM

Re: Query Optimization Needed

465

Devrishi Shandilya

02/15/2015 11:07PM

Re: Query Optimization Needed

491

Rick James

02/16/2015 12:15AM

Re: Query Optimization Needed

406

Peter Brawley

03/13/2015 11:15AM

Exceedingly slow create table performance

1,327

Ronald Van Iwaarden

03/06/2015 10:51AM

Re: Exceedingly slow create table performance

547

Rick James

03/07/2015 11:03AM

Re: Exceedingly slow create table performance

530

Ronald Van Iwaarden

03/09/2015 10:10AM

Left join optimization- query is very slow

1,842

Devrishi Shandilya

03/05/2015 05:23AM

Re: Left join optimization- query is very slow

693

Øystein Grøvlen

03/05/2015 09:12AM

Re: Left join optimization- query is very slow

967

Rick James

03/06/2015 06:48PM

Re: Left join optimization- query is very slow

602

Devrishi Shandilya

03/08/2015 11:32PM

COUNT with GROUP BY, JOIN and SUBQUERY very slow

1,498

Anderson Scouto da Silva Dan

02/28/2015 03:15AM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

644

Øystein Grøvlen

03/02/2015 02:05AM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

482

Øystein Grøvlen

03/02/2015 02:13AM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

733

Anderson Scouto da Silva Dan

03/02/2015 02:28PM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

475

Øystein Grøvlen

03/03/2015 01:27AM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

546

Rick James

03/02/2015 06:13PM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

461

Anderson Scouto da Silva Dan

03/02/2015 07:14PM

Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow

499

Anderson Scouto da Silva Dan

03/02/2015 07:20PM

Slow performance when using LIMIT 1000

1,039

Christian Esborg

02/25/2015 07:43AM

Re: Slow performance when using LIMIT 1000

459

Øystein Grøvlen

02/26/2015 04:13AM

Re: Slow performance when using LIMIT 1000

558

Rick James

02/27/2015 01:09AM

Analyse-Optimize and tablecache

1,100

Samuel Mutel

02/16/2015 03:49AM

Re: Analyse-Optimize and tablecache

484

Rick James

02/18/2015 03:54PM

Temp tables on Disk issue

899

Devrishi Shandilya

02/15/2015 11:17PM

Re: Temp tables on Disk issue

396

Rick James

02/16/2015 12:19AM

5.6 -> 5.7 - huge jump in memory usage, CentOS 7.

1,310

Pól Ua Laoínecháin

02/04/2015 08:21PM

Re: 5.6 -> 5.7 - huge jump in memory usage, CentOS 7.

539

Øystein Grøvlen

02/05/2015 01:51AM

Mysql performance between installation

1,157

Patrick MORAND

01/16/2015 07:32AM

Re: Mysql performance between installation

475

Rick James

01/17/2015 11:50AM

Re: Mysql performance between installation

527

Patrick MORAND

01/19/2015 08:26AM

Re: Mysql performance between installation

602

Rick James

01/20/2015 04:57PM

Re: Mysql performance between installation

497

Patrick MORAND

01/21/2015 02:30AM

RAM consideration/ IO usage

1,003

Jawahar muthukrishnan

01/13/2015 12:39PM

Re: RAM consideration/ IO usage

622

Rick James

01/14/2015 01:47PM

Re: RAM consideration/ IO usage

522

Jawahar muthukrishnan

01/15/2015 03:07PM

Re: RAM consideration/ IO usage

814

Rick James

01/16/2015 02:14PM

Unusually high cpu usage

1,809

Fabrizio Bartolomucci

01/11/2015 02:55PM

Re: Unusually high cpu usage

715

Rick James

01/12/2015 09:49PM

Re: Unusually high cpu usage

625

Fabrizio Bartolomucci

01/13/2015 09:32AM

Re: Unusually high cpu usage

881

Fabrizio Bartolomucci

01/13/2015 11:47AM

Re: Unusually high cpu usage

668

Rick James

01/13/2015 04:21PM

How To Use More Resources

1,200

Luis Cavazos

01/07/2015 11:12AM

Re: How To Use More Resources

494

Rick James

01/07/2015 07:14PM

Re: How To Use More Resources

620

Luis Cavazos

01/07/2015 09:14PM

Re: How To Use More Resources

707

Rick James

01/07/2015 11:21PM

Re: How To Use More Resources

440

Rick James

01/07/2015 11:42PM

Re: How To Use More Resources

442

Luis Cavazos

01/08/2015 05:48PM

Re: How To Use More Resources

525

Rick James

01/09/2015 02:39PM

How to use performance_schema.tables

1,004

jongse park

01/07/2015 02:05AM

Re: How to use performance_schema.tables

471

Øystein Grøvlen

01/07/2015 03:41AM

Re: How to use performance_schema.tables

549

Rick James

01/07/2015 05:02PM

lockfree approach to creating a single unique row without unique index

1,146

Andrew Nuss

01/03/2015 03:43PM

Re: lockfree approach to creating a single unique row without unique index

430

Rick James

01/05/2015 12:17AM

Re: lockfree approach to creating a single unique row without unique index

444

Rick James

01/05/2015 11:04AM

COUNT_STAR, SUM_TIMER_WAIT

1,154

jongse park

12/26/2014 02:08AM

Re: COUNT_STAR, SUM_TIMER_WAIT

618

Øystein Grøvlen

01/05/2015 04:27AM

what does table_open_cache_overflow=0 means?

1,427

jongse park

12/29/2014 07:42PM

Re: what does table_open_cache_overflow=0 means?

1,272

Rick James

12/31/2014 04:59PM

innodb_buffer_pool_read_requests global status wraparound

1,358

Wilson Hauck

11/18/2014 10:18AM

Re: innodb_buffer_pool_read_requests global status wraparound

591

Rick James

11/18/2014 10:40PM

Re: innodb_buffer_pool_read_requests global status wraparound

520

Wilson Hauck

11/19/2014 07:31AM

Re: innodb_buffer_pool_read_requests global status wraparound

496

Wilson Hauck

11/19/2014 10:19AM

Re: innodb_buffer_pool_read_requests global status wraparound

513

Rick James

12/22/2014 01:37AM

Re: innodb_buffer_pool_read_requests global status wraparound

513

Wilson Hauck

11/19/2014 03:00PM

Re: innodb_buffer_pool_read_requests global status wraparound

462

Wilson Hauck

12/20/2014 12:15PM

25.000+ rows - MySQL SELECT consecutive numbers performance issue

1,250

Daniel Negoita

12/12/2014 08:55AM

Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue

821

Daniel Negoita

12/12/2014 09:18AM

Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue

536

Peter Brawley

12/12/2014 12:18PM

Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue

803

Rick James

12/14/2014 01:42PM

Re: 25.000+ rows - MySQL SELECT consecutive numbers performance issue

706

Peter Brawley

12/14/2014 04:19PM

innodb_checksum_algorithm stic_crc32 is slow response

1,327

Ankur Kaushik

12/08/2014 04:29AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

619

Ankur Kaushik

12/08/2014 04:32AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

561

Øystein Grøvlen

12/08/2014 05:45AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

552

Rick James

12/08/2014 10:52AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

495

Ankur Kaushik

12/09/2014 06:44AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

603

Rick James

12/09/2014 03:34PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

549

Ankur Kaushik

12/13/2014 08:47PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

570

Ankur Kaushik

12/13/2014 08:49PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

517

Rick James

12/14/2014 11:51AM

UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?

1,684

Daniel Chiaramello

12/04/2014 05:05AM

Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?

894

Rick James

12/06/2014 02:40PM

Write Operations very slow in InnoDB engine when compared to MyIsam

1,111

MURALI NARAYANASWAMY

11/28/2014 07:07AM

Re: Write Operations very slow in InnoDB engine when compared to MyIsam

469

Rick James

11/28/2014 06:59PM

Cardinality Problem

1,025

Katja Kahl

11/26/2014 06:53AM

Re: Cardinality Problem

466

Peter Brawley

11/26/2014 12:03PM

Re: Cardinality Problem

508

Katja Kahl

11/27/2014 03:08AM

Re: Cardinality Problem

420

Rick James

11/28/2014 06:56PM

Reduce the Query Execution Time Between MYSQL & VC++

1,345

saraswathi srinath

11/12/2014 05:01AM

Re: Reduce the Query Execution Time Between MYSQL & VC++

535

Rick James

11/13/2014 06:50PM

Re: Reduce the Query Execution Time Between MYSQL & VC++

553

saraswathi srinath

11/13/2014 10:29PM

Re: Reduce the Query Execution Time Between MYSQL & VC++

546

Rick James

11/14/2014 07:55PM

Re: Reduce the Query Execution Time Between MYSQL & VC++

639

saraswathi srinath

11/14/2014 10:33PM

Re: Reduce the Query Execution Time Between MYSQL & VC++

576

Rick James

11/15/2014 08:43PM

Re: Reduce the Query Execution Time Between MYSQL & VC++

574

saraswathi srinath

11/16/2014 10:19PM

Re: Reduce the Query Execution Time Between MYSQL & VC++

545

saraswathi srinath

11/16/2014 10:37PM

Re: Reduce the Query Execution Time Between MYSQL & VC++

460

Rick James

11/17/2014 08:06PM

Re: Reduce the Query Execution Time Between MYSQL & VC++

484

saraswathi srinath

11/19/2014 11:09PM

Re: Reduce the Query Execution Time Between MYSQL & VC++

488

Rick James

11/20/2014 07:59PM

Which server hardware would you pick?

1,114

Robert Gunther

11/14/2014 08:24PM

Re: Which server hardware would you pick?

552

Rick James

11/15/2014 08:46PM

Re: Which server hardware would you pick?

535

Robert Gunther

11/16/2014 06:25PM

Re: Which server hardware would you pick?

503

Rick James

11/17/2014 03:42PM

Re: Which server hardware would you pick?

540

Robert Gunther

11/18/2014 09:08AM

Re: Which server hardware would you pick?

485

Rick James

11/19/2014 05:02PM

MySQL query execution time differs between executions

1,910

Ofer Bechar

11/16/2014 09:49AM

Re: MySQL query execution time differs between executions

665

Peter Brawley

11/16/2014 12:19PM

Re: MySQL query execution time differs between executions

609

Rick James

11/16/2014 03:24PM

Re: MySQL query execution time differs between executions

644

Ofer Bechar

11/17/2014 02:57AM

Re: MySQL query execution time differs between executions

706

Rick James

11/17/2014 04:09PM

Re: MySQL query execution time differs between executions

607

Ofer Bechar

11/17/2014 02:30AM

Why INSERT performance has not increase in sub-table?

1,466

Yao Yao

11/03/2014 03:02AM

Re: Why INSERT performance has not increase in sub-table?

494

Dexter Yao

11/03/2014 09:07AM

Re: Why INSERT performance has not increase in sub-table?

457

Rick James

11/03/2014 09:31AM

Re: Why INSERT performance has not increase in sub-table?

441

Dexter Yao

11/03/2014 11:56AM

Re: Why INSERT performance has not increase in sub-table?

583

Rick James

11/03/2014 01:12PM

Re: Why INSERT performance has not increase in sub-table?

455

Dexter Yao

11/03/2014 09:43PM

Re: Why INSERT performance has not increase in sub-table?

521

Rick James

11/04/2014 08:57AM

Re: Why INSERT performance has not increase in sub-table?

443

Dexter Yao

11/05/2014 04:39AM

Performance of insert on duplicate key update

4,819

Ravi Malghan

10/23/2014 02:03PM

Re: Performance of insert on duplicate key update

2,403

Rick James

10/24/2014 10:39AM

Re: Performance of insert on duplicate key update

1,679

Ravi Malghan

10/24/2014 11:54AM

Re: Performance of insert on duplicate key update

1,412

Rick James

10/25/2014 12:51PM

Re: Performance of insert on duplicate key update

1,216

Ravi Malghan

10/27/2014 07:44AM

Re: Performance of insert on duplicate key update

1,189

Rick James

10/28/2014 11:33AM

Re: Performance of insert on duplicate key update

919

Ravi Malghan

11/04/2014 06:40AM

msyql 5.0.22 and multi-core server support

1,395

Christine Ross

10/31/2014 10:30AM

Re: msyql 5.0.22 and multi-core server support

677

Peter Brawley

10/31/2014 11:14AM

Re: msyql 5.0.22 and multi-core server support

606

Christine Ross

10/31/2014 01:38PM

Re: msyql 5.0.22 and multi-core server support

845

Rick James

11/02/2014 09:33AM

GROUP causing Using Temporary Using Filesort

11,626

RT Lee

07/31/2014 02:35PM

Re: GROUP causing Using Temporary Using Filesort

3,943

Peter Brawley

07/31/2014 03:24PM

Re: GROUP causing Using Temporary Using Filesort

3,240

RT Lee

07/31/2014 05:45PM

Re: GROUP causing Using Temporary Using Filesort

2,828

Rick James

08/01/2014 04:45PM

Re: GROUP causing Using Temporary Using Filesort

2,059

RT Lee

08/01/2014 08:26PM

Re: GROUP causing Using Temporary Using Filesort

1,748

Rick James

08/01/2014 11:45PM

Re: GROUP causing Using Temporary Using Filesort

1,651

RT Lee

08/02/2014 08:23AM

Re: GROUP causing Using Temporary Using Filesort

1,742

Rick James

08/02/2014 12:44PM

Re: GROUP causing Using Temporary Using Filesort

1,138

Leonardo Duque

10/30/2014 12:57PM

Leonardo, please do not hijack threads

870

Peter Brawley

10/31/2014 11:15AM

Eliminate filesort in update query

1,568

Matzz -

09/23/2014 02:48AM

Re: Eliminate filesort in update query

590

Rick James

09/23/2014 09:59PM

Re: Eliminate filesort in update query

554

Matzz -

09/24/2014 01:25AM

Re: Eliminate filesort in update query

631

Rick James

09/24/2014 08:40PM

Re: Eliminate filesort in update query

591

Matzz -

09/25/2014 05:48AM

Re: Eliminate filesort in update query

554

Rick James

09/26/2014 04:39PM

Re: Eliminate filesort in update query

568

Matzz -

10/01/2014 06:49AM

Re: Eliminate filesort in update query

615

Rick James

10/03/2014 10:09PM

Re: Eliminate filesort in update query

637

Matzz -

10/04/2014 03:13AM

How to get fast Performance during Insert Large Volume of records into table

1,335

Jeetu Gaur

09/26/2014 06:48AM

Re: How to get fast Performance during Insert Large Volume of records into table

585

Rick James

09/27/2014 08:16AM

Slow response time due queries

2,673

Jens Meier

09/23/2014 01:32AM

Re: Slow response time due queries

995

Rick James

09/23/2014 10:11PM

PHP/MySQL to use all CPU/memory to increase performance

1,705

Caleb Pitman

09/21/2014 11:04AM

Re: PHP/MySQL to use all CPU/memory to increase performance

722

Rick James

09/22/2014 03:39PM

Re: PHP/MySQL to use all CPU/memory to increase performance

837

Caleb Pitman

09/22/2014 04:55PM

Re: PHP/MySQL to use all CPU/memory to increase performance

587

Rick James

09/23/2014 03:21PM

How to set mysql CPU affinity?

2,735

Metal Messiah

09/21/2014 01:33PM

Re: How to set mysql CPU affinity?

1,209

Rick James

09/22/2014 03:25PM

Re: How to set mysql CPU affinity?

1,234

Sophia Parsons

09/23/2014 01:30AM

Re: How to set mysql CPU affinity?

1,110

Rick James

09/23/2014 11:03AM

Query optimization to reduce execution time.

1,367

Neetu Nayak

09/22/2014 07:33AM

Re: Query optimization to reduce execution time.

597

Rick James

09/22/2014 08:46PM

Re: Query optimization to reduce execution time.

555

Neetu Nayak

09/23/2014 12:38AM

Re: Query optimization to reduce execution time.

615

Neetu Nayak

09/23/2014 01:42AM

Mass Update optimization

1,762

Susan Lin

09/14/2014 06:00PM

Re: Mass Update optimization

656

Rick James

09/15/2014 11:38AM

Re: Mass Update optimization

609

Sophia Parsons

09/23/2014 01:36AM

Optimising query with composite index, which says using where

1,179

Timothy Mifsud

09/06/2014 12:38AM

Re: Optimising query with composite index, which says using where

503

Timothy Mifsud

09/06/2014 01:53AM

Re: Optimising query with composite index, which says using where

511

Rick James

09/07/2014 10:46PM

Re: Optimising query with composite index, which says using where

490

Øystein Grøvlen

09/15/2014 06:03AM

Re: Optimising query with composite index, which says using where

500

Rick James

09/15/2014 10:03AM

Slow Performance with Multi-threaded app

1,305

Minesh Desai

09/12/2014 09:24AM

Re: Slow Performance with Multi-threaded app

588

Rick James

09/13/2014 09:47AM

InnoDB and locking, UPDATE and SELECT

1,278

Andreas Greulich

09/10/2014 01:18AM

Re: InnoDB and locking, UPDATE and SELECT

520

Rick James

09/13/2014 12:09AM

MySQL using too much CPU

1,601

31 Special

08/29/2014 05:12PM

Re: MySQL using too much CPU

671

Rick James

08/30/2014 05:27PM

Re: MySQL using too much CPU

876

31 Special

08/31/2014 10:13PM

Understanding Explain

1,236

J M

08/27/2014 07:31AM

Re: Understanding Explain

580

Peter Brawley

08/27/2014 10:35AM

Re: Understanding Explain

535

J M

08/27/2014 10:51AM

Re: Understanding Explain

580

Øystein Grøvlen

08/28/2014 03:00PM

Re: Understanding Explain

439

Rick James

08/29/2014 09:45PM

Need help to otimize my query

1,091

GAURAV JAIN

08/21/2014 07:28AM

Re: Need help to otimize my query

563

Rick James

08/24/2014 09:17PM

Slow response in MY SQL 5.5.1.8

1,103

Amila Kumara

07/16/2014 01:30AM

Re: Slow response in MY SQL 5.5.1.8

577

Rick James

07/16/2014 09:04PM

Re: Slow response in MY SQL 5.5.1.8

592

Amila Kumara

07/21/2014 05:02AM

Re: Slow response in MY SQL 5.5.1.8

618

Rick James

07/23/2014 12:19AM

Help in tuning MySQL 5.6 database

1,123

Deepak Dambe

07/17/2014 05:26AM

Re: Help in tuning MySQL 5.6 database

563

Rick James

07/18/2014 12:12PM

Query slows down over time

1,591

Sameer Shah

05/28/2014 09:35AM