MySQL :: MySQL Forums :: Performance

Announcements	Last Post
• MySQL Connector/C 6.1.11 GA has been released	07/24/2017 10:19AM
• MySQL Router 2.1.4 GA has been released	07/24/2017 09:15AM
• MySQL Connector/ODBC 5.3.9 has been released	07/24/2017 08:59AM
• MySQL Connector/J 5.1.43 has been released	07/21/2017 02:07PM
• MySQL Cluster 7.5.7 has been released	07/19/2017 04:43AM

New Topic

Pages:

« 1 2 3 4 5

...

73 »

Subject

Views

Written By

Posted

Exceedingly slow create table performance

1,281

Ronald Van Iwaarden

03/06/2015 10:51AM

Re: Exceedingly slow create table performance

526

Rick James

03/07/2015 11:03AM

Re: Exceedingly slow create table performance

510

Ronald Van Iwaarden

03/09/2015 10:10AM

Left join optimization- query is very slow

1,740

Devrishi Shandilya

03/05/2015 05:23AM

Re: Left join optimization- query is very slow

664

Øystein Grøvlen

03/05/2015 09:12AM

Re: Left join optimization- query is very slow

944

Rick James

03/06/2015 06:48PM

Re: Left join optimization- query is very slow

585

Devrishi Shandilya

03/08/2015 11:32PM

COUNT with GROUP BY, JOIN and SUBQUERY very slow

1,475

Anderson Scouto da Silva Dan

02/28/2015 03:15AM

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

637

Øystein Grøvlen

03/02/2015 02:05AM

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

478

Øystein Grøvlen

03/02/2015 02:13AM

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

714

Anderson Scouto da Silva Dan

03/02/2015 02:28PM

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

470

Øystein Grøvlen

03/03/2015 01:27AM

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

543

Rick James

03/02/2015 06:13PM

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

456

Anderson Scouto da Silva Dan

03/02/2015 07:14PM

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

494

Anderson Scouto da Silva Dan

03/02/2015 07:20PM

Slow performance when using LIMIT 1000

1,022

Christian Esborg

02/25/2015 07:43AM

Re: Slow performance when using LIMIT 1000

455

Øystein Grøvlen

02/26/2015 04:13AM

Re: Slow performance when using LIMIT 1000

551

Rick James

02/27/2015 01:09AM

Analyse-Optimize and tablecache

1,089

Samuel Mutel

02/16/2015 03:49AM

Re: Analyse-Optimize and tablecache

482

Rick James

02/18/2015 03:54PM

Temp tables on Disk issue

889

Devrishi Shandilya

02/15/2015 11:17PM

Re: Temp tables on Disk issue

391

Rick James

02/16/2015 12:19AM

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

1,295

Pól Ua Laoínecháin

02/04/2015 08:21PM

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

535

Øystein Grøvlen

02/05/2015 01:51AM

Mysql performance between installation

1,130

Patrick MORAND

01/16/2015 07:32AM

Re: Mysql performance between installation

471

Rick James

01/17/2015 11:50AM

Re: Mysql performance between installation

522

Patrick MORAND

01/19/2015 08:26AM

Re: Mysql performance between installation

597

Rick James

01/20/2015 04:57PM

Re: Mysql performance between installation

490

Patrick MORAND

01/21/2015 02:30AM

RAM consideration/ IO usage

985

Jawahar muthukrishnan

01/13/2015 12:39PM

Re: RAM consideration/ IO usage

613

Rick James

01/14/2015 01:47PM

Re: RAM consideration/ IO usage

514

Jawahar muthukrishnan

01/15/2015 03:07PM

Re: RAM consideration/ IO usage

802

Rick James

01/16/2015 02:14PM

Unusually high cpu usage

1,756

Fabrizio Bartolomucci

01/11/2015 02:55PM

Re: Unusually high cpu usage

704

Rick James

01/12/2015 09:49PM

Re: Unusually high cpu usage

611

Fabrizio Bartolomucci

01/13/2015 09:32AM

Re: Unusually high cpu usage

858

Fabrizio Bartolomucci

01/13/2015 11:47AM

Re: Unusually high cpu usage

652

Rick James

01/13/2015 04:21PM

How To Use More Resources

1,186

Luis Cavazos

01/07/2015 11:12AM

Re: How To Use More Resources

487

Rick James

01/07/2015 07:14PM

Re: How To Use More Resources

613

Luis Cavazos

01/07/2015 09:14PM

Re: How To Use More Resources

700

Rick James

01/07/2015 11:21PM

Re: How To Use More Resources

435

Rick James

01/07/2015 11:42PM

Re: How To Use More Resources

439

Luis Cavazos

01/08/2015 05:48PM

Re: How To Use More Resources

522

Rick James

01/09/2015 02:39PM

How to use performance_schema.tables

979

jongse park

01/07/2015 02:05AM

Re: How to use performance_schema.tables

461

Øystein Grøvlen

01/07/2015 03:41AM

Re: How to use performance_schema.tables

540

Rick James

01/07/2015 05:02PM

lockfree approach to creating a single unique row without unique index

1,132

Andrew Nuss

01/03/2015 03:43PM

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

423

Rick James

01/05/2015 12:17AM

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

441

Rick James

01/05/2015 11:04AM

COUNT_STAR, SUM_TIMER_WAIT

1,128

jongse park

12/26/2014 02:08AM

Re: COUNT_STAR, SUM_TIMER_WAIT

606

Øystein Grøvlen

01/05/2015 04:27AM

what does table_open_cache_overflow=0 means?

1,247

jongse park

12/29/2014 07:42PM

Re: what does table_open_cache_overflow=0 means?

1,228

Rick James

12/31/2014 04:59PM

innodb_buffer_pool_read_requests global status wraparound

1,331

Wilson Hauck

11/18/2014 10:18AM

Re: innodb_buffer_pool_read_requests global status wraparound

583

Rick James

11/18/2014 10:40PM

Re: innodb_buffer_pool_read_requests global status wraparound

516

Wilson Hauck

11/19/2014 07:31AM

Re: innodb_buffer_pool_read_requests global status wraparound

493

Wilson Hauck

11/19/2014 10:19AM

Re: innodb_buffer_pool_read_requests global status wraparound

501

Rick James

12/22/2014 01:37AM

Re: innodb_buffer_pool_read_requests global status wraparound

508

Wilson Hauck

11/19/2014 03:00PM

Re: innodb_buffer_pool_read_requests global status wraparound

456

Wilson Hauck

12/20/2014 12:15PM

25.000+ rows - MySQL SELECT consecutive numbers performance issue

1,222

Daniel Negoita

12/12/2014 08:55AM

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

804

Daniel Negoita

12/12/2014 09:18AM

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

523

Peter Brawley

12/12/2014 12:18PM

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

796

Rick James

12/14/2014 01:42PM

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

700

Peter Brawley

12/14/2014 04:19PM

innodb_checksum_algorithm stic_crc32 is slow response

1,309

Ankur Kaushik

12/08/2014 04:29AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

613

Ankur Kaushik

12/08/2014 04:32AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

551

Øystein Grøvlen

12/08/2014 05:45AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

536

Rick James

12/08/2014 10:52AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

489

Ankur Kaushik

12/09/2014 06:44AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

591

Rick James

12/09/2014 03:34PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

544

Ankur Kaushik

12/13/2014 08:47PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

563

Ankur Kaushik

12/13/2014 08:49PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

510

Rick James

12/14/2014 11:51AM

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

1,664

Daniel Chiaramello

12/04/2014 05:05AM

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

883

Rick James

12/06/2014 02:40PM

Write Operations very slow in InnoDB engine when compared to MyIsam

1,094

MURALI NARAYANASWAMY

11/28/2014 07:07AM

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

465

Rick James

11/28/2014 06:59PM

Cardinality Problem

1,015

Katja Kahl

11/26/2014 06:53AM

Re: Cardinality Problem

460

Peter Brawley

11/26/2014 12:03PM

Re: Cardinality Problem

501

Katja Kahl

11/27/2014 03:08AM

Re: Cardinality Problem

412

Rick James

11/28/2014 06:56PM

Reduce the Query Execution Time Between MYSQL & VC++

1,325

saraswathi srinath

11/12/2014 05:01AM

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

529

Rick James

11/13/2014 06:50PM

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

541

saraswathi srinath

11/13/2014 10:29PM

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

538

Rick James

11/14/2014 07:55PM

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

629

saraswathi srinath

11/14/2014 10:33PM

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

566

Rick James

11/15/2014 08:43PM

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

564

saraswathi srinath

11/16/2014 10:19PM

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

537

saraswathi srinath

11/16/2014 10:37PM

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

450

Rick James

11/17/2014 08:06PM

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

475

saraswathi srinath

11/19/2014 11:09PM

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

483

Rick James

11/20/2014 07:59PM

Which server hardware would you pick?

1,094

Robert Gunther

11/14/2014 08:24PM

Re: Which server hardware would you pick?

541

Rick James

11/15/2014 08:46PM

Re: Which server hardware would you pick?

487

Robert Gunther

11/16/2014 06:25PM

Re: Which server hardware would you pick?

497

Rick James

11/17/2014 03:42PM

Re: Which server hardware would you pick?

532

Robert Gunther

11/18/2014 09:08AM

Re: Which server hardware would you pick?

479

Rick James

11/19/2014 05:02PM

MySQL query execution time differs between executions

1,846

Ofer Bechar

11/16/2014 09:49AM

Re: MySQL query execution time differs between executions

653

Peter Brawley

11/16/2014 12:19PM

Re: MySQL query execution time differs between executions

597

Rick James

11/16/2014 03:24PM

Re: MySQL query execution time differs between executions

630

Ofer Bechar

11/17/2014 02:57AM

Re: MySQL query execution time differs between executions

685

Rick James

11/17/2014 04:09PM

Re: MySQL query execution time differs between executions

600

Ofer Bechar

11/17/2014 02:30AM

Why INSERT performance has not increase in sub-table?

1,434

Yao Yao

11/03/2014 03:02AM

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

490

Dexter Yao

11/03/2014 09:07AM

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

446

Rick James

11/03/2014 09:31AM

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

434

Dexter Yao

11/03/2014 11:56AM

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

576

Rick James

11/03/2014 01:12PM

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

450

Dexter Yao

11/03/2014 09:43PM

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

516

Rick James

11/04/2014 08:57AM

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

435

Dexter Yao

11/05/2014 04:39AM

Performance of insert on duplicate key update

4,535

Ravi Malghan

10/23/2014 02:03PM

Re: Performance of insert on duplicate key update

2,235

Rick James

10/24/2014 10:39AM

Re: Performance of insert on duplicate key update

1,582

Ravi Malghan

10/24/2014 11:54AM

Re: Performance of insert on duplicate key update

1,333

Rick James

10/25/2014 12:51PM

Re: Performance of insert on duplicate key update

1,140

Ravi Malghan

10/27/2014 07:44AM

Re: Performance of insert on duplicate key update

1,106

Rick James

10/28/2014 11:33AM

Re: Performance of insert on duplicate key update

864

Ravi Malghan

11/04/2014 06:40AM

msyql 5.0.22 and multi-core server support

1,371

Christine Ross

10/31/2014 10:30AM

Re: msyql 5.0.22 and multi-core server support

668

Peter Brawley

10/31/2014 11:14AM

Re: msyql 5.0.22 and multi-core server support

600

Christine Ross

10/31/2014 01:38PM

Re: msyql 5.0.22 and multi-core server support

832

Rick James

11/02/2014 09:33AM

GROUP causing Using Temporary Using Filesort

11,222

RT Lee

07/31/2014 02:35PM

Re: GROUP causing Using Temporary Using Filesort

3,784

Peter Brawley

07/31/2014 03:24PM

Re: GROUP causing Using Temporary Using Filesort

3,131

RT Lee

07/31/2014 05:45PM

Re: GROUP causing Using Temporary Using Filesort

2,747

Rick James

08/01/2014 04:45PM

Re: GROUP causing Using Temporary Using Filesort

2,004

RT Lee

08/01/2014 08:26PM

Re: GROUP causing Using Temporary Using Filesort

1,708

Rick James

08/01/2014 11:45PM

Re: GROUP causing Using Temporary Using Filesort

1,614

RT Lee

08/02/2014 08:23AM

Re: GROUP causing Using Temporary Using Filesort

1,699

Rick James

08/02/2014 12:44PM

Re: GROUP causing Using Temporary Using Filesort

1,106

Leonardo Duque

10/30/2014 12:57PM

Leonardo, please do not hijack threads

855

Peter Brawley

10/31/2014 11:15AM

Eliminate filesort in update query

1,536

Matzz -

09/23/2014 02:48AM

Re: Eliminate filesort in update query

582

Rick James

09/23/2014 09:59PM

Re: Eliminate filesort in update query

544

Matzz -

09/24/2014 01:25AM

Re: Eliminate filesort in update query

625

Rick James

09/24/2014 08:40PM

Re: Eliminate filesort in update query

584

Matzz -

09/25/2014 05:48AM

Re: Eliminate filesort in update query

548

Rick James

09/26/2014 04:39PM

Re: Eliminate filesort in update query

562

Matzz -

10/01/2014 06:49AM

Re: Eliminate filesort in update query

607

Rick James

10/03/2014 10:09PM

Re: Eliminate filesort in update query

627

Matzz -

10/04/2014 03:13AM

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

1,300

Jeetu Gaur

09/26/2014 06:48AM

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

574

Rick James

09/27/2014 08:16AM

Slow response time due queries

2,620

Jens Meier

09/23/2014 01:32AM

Re: Slow response time due queries

980

Rick James

09/23/2014 10:11PM

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

1,655

Caleb Pitman

09/21/2014 11:04AM

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

712

Rick James

09/22/2014 03:39PM

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

827

Caleb Pitman

09/22/2014 04:55PM

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

582

Rick James

09/23/2014 03:21PM

How to set mysql CPU affinity?

2,620

Metal Messiah

09/21/2014 01:33PM

Re: How to set mysql CPU affinity?

1,172

Rick James

09/22/2014 03:25PM

Re: How to set mysql CPU affinity?

1,178

Sophia Parsons

09/23/2014 01:30AM

Re: How to set mysql CPU affinity?

1,085

Rick James

09/23/2014 11:03AM

Query optimization to reduce execution time.

1,346

Neetu Nayak

09/22/2014 07:33AM

Re: Query optimization to reduce execution time.

581

Rick James

09/22/2014 08:46PM

Re: Query optimization to reduce execution time.

546

Neetu Nayak

09/23/2014 12:38AM

Re: Query optimization to reduce execution time.

609

Neetu Nayak

09/23/2014 01:42AM

Mass Update optimization

1,738

Susan Lin

09/14/2014 06:00PM

Re: Mass Update optimization

649

Rick James

09/15/2014 11:38AM

Re: Mass Update optimization

601

Sophia Parsons

09/23/2014 01:36AM

Optimising query with composite index, which says using where

1,166

Timothy Mifsud

09/06/2014 12:38AM

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

500

Timothy Mifsud

09/06/2014 01:53AM

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

506

Rick James

09/07/2014 10:46PM

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

487

Øystein Grøvlen

09/15/2014 06:03AM

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

496

Rick James

09/15/2014 10:03AM

Slow Performance with Multi-threaded app

1,275

Minesh Desai

09/12/2014 09:24AM

Re: Slow Performance with Multi-threaded app

586

Rick James

09/13/2014 09:47AM

InnoDB and locking, UPDATE and SELECT

1,254

Andreas Greulich

09/10/2014 01:18AM

Re: InnoDB and locking, UPDATE and SELECT

505

Rick James

09/13/2014 12:09AM

MySQL using too much CPU

1,577

31 Special

08/29/2014 05:12PM

Re: MySQL using too much CPU

664

Rick James

08/30/2014 05:27PM

Re: MySQL using too much CPU

870

31 Special

08/31/2014 10:13PM

Understanding Explain

1,214

J M

08/27/2014 07:31AM

Re: Understanding Explain

576

Peter Brawley

08/27/2014 10:35AM

Re: Understanding Explain

529

J M

08/27/2014 10:51AM

Re: Understanding Explain

573

Øystein Grøvlen

08/28/2014 03:00PM

Re: Understanding Explain

432

Rick James

08/29/2014 09:45PM

Need help to otimize my query

1,077

GAURAV JAIN

08/21/2014 07:28AM

Re: Need help to otimize my query

560

Rick James

08/24/2014 09:17PM

Slow response in MY SQL 5.5.1.8

1,084

Amila Kumara

07/16/2014 01:30AM

Re: Slow response in MY SQL 5.5.1.8

570

Rick James

07/16/2014 09:04PM

Re: Slow response in MY SQL 5.5.1.8

580

Amila Kumara

07/21/2014 05:02AM

Re: Slow response in MY SQL 5.5.1.8

612

Rick James

07/23/2014 12:19AM

Help in tuning MySQL 5.6 database

1,105

Deepak Dambe

07/17/2014 05:26AM

Re: Help in tuning MySQL 5.6 database

554

Rick James

07/18/2014 12:12PM

Query slows down over time

1,544

Sameer Shah

05/28/2014 09:35AM