MySQL :: MySQL Forums :: Performance

Announcements	Last Post
• MySQL Enterprise Monitor 3.3.4 has been released	06/13/2017 01:27PM
• MySQL Enterprise Monitor 3.2.8 has been released	06/13/2017 12:49PM
• MySQL Enterprise Monitor 3.4.1 has been released	06/06/2017 10:48AM
• MySQL for Excel 1.3.7 has been released	05/24/2017 11:05AM

New Topic

Pages:

« 1 2 3 4 5

...

73 »

Subject

Views

Written By

Posted

Exceedingly slow create table performance

1,245

Ronald Van Iwaarden

03/06/2015 10:51AM

Re: Exceedingly slow create table performance

506

Rick James

03/07/2015 11:03AM

Re: Exceedingly slow create table performance

472

Ronald Van Iwaarden

03/09/2015 10:10AM

Left join optimization- query is very slow

1,681

Devrishi Shandilya

03/05/2015 05:23AM

Re: Left join optimization- query is very slow

644

Øystein Grøvlen

03/05/2015 09:12AM

Re: Left join optimization- query is very slow

931

Rick James

03/06/2015 06:48PM

Re: Left join optimization- query is very slow

572

Devrishi Shandilya

03/08/2015 11:32PM

COUNT with GROUP BY, JOIN and SUBQUERY very slow

1,457

Anderson Scouto da Silva Dan

02/28/2015 03:15AM

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

627

Øystein Grøvlen

03/02/2015 02:05AM

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

470

Øystein Grøvlen

03/02/2015 02:13AM

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

705

Anderson Scouto da Silva Dan

03/02/2015 02:28PM

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

466

Øystein Grøvlen

03/03/2015 01:27AM

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

537

Rick James

03/02/2015 06:13PM

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

451

Anderson Scouto da Silva Dan

03/02/2015 07:14PM

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

488

Anderson Scouto da Silva Dan

03/02/2015 07:20PM

Slow performance when using LIMIT 1000

982

Christian Esborg

02/25/2015 07:43AM

Re: Slow performance when using LIMIT 1000

448

Øystein Grøvlen

02/26/2015 04:13AM

Re: Slow performance when using LIMIT 1000

545

Rick James

02/27/2015 01:09AM

Analyse-Optimize and tablecache

1,080

Samuel Mutel

02/16/2015 03:49AM

Re: Analyse-Optimize and tablecache

477

Rick James

02/18/2015 03:54PM

Temp tables on Disk issue

877

Devrishi Shandilya

02/15/2015 11:17PM

Re: Temp tables on Disk issue

384

Rick James

02/16/2015 12:19AM

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

1,285

Pól Ua Laoínecháin

02/04/2015 08:21PM

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

526

Øystein Grøvlen

02/05/2015 01:51AM

Mysql performance between installation

1,108

Patrick MORAND

01/16/2015 07:32AM

Re: Mysql performance between installation

464

Rick James

01/17/2015 11:50AM

Re: Mysql performance between installation

516

Patrick MORAND

01/19/2015 08:26AM

Re: Mysql performance between installation

590

Rick James

01/20/2015 04:57PM

Re: Mysql performance between installation

484

Patrick MORAND

01/21/2015 02:30AM

RAM consideration/ IO usage

967

Jawahar muthukrishnan

01/13/2015 12:39PM

Re: RAM consideration/ IO usage

605

Rick James

01/14/2015 01:47PM

Re: RAM consideration/ IO usage

509

Jawahar muthukrishnan

01/15/2015 03:07PM

Re: RAM consideration/ IO usage

795

Rick James

01/16/2015 02:14PM

Unusually high cpu usage

1,732

Fabrizio Bartolomucci

01/11/2015 02:55PM

Re: Unusually high cpu usage

690

Rick James

01/12/2015 09:49PM

Re: Unusually high cpu usage

602

Fabrizio Bartolomucci

01/13/2015 09:32AM

Re: Unusually high cpu usage

846

Fabrizio Bartolomucci

01/13/2015 11:47AM

Re: Unusually high cpu usage

645

Rick James

01/13/2015 04:21PM

How To Use More Resources

1,167

Luis Cavazos

01/07/2015 11:12AM

Re: How To Use More Resources

480

Rick James

01/07/2015 07:14PM

Re: How To Use More Resources

606

Luis Cavazos

01/07/2015 09:14PM

Re: How To Use More Resources

693

Rick James

01/07/2015 11:21PM

Re: How To Use More Resources

428

Rick James

01/07/2015 11:42PM

Re: How To Use More Resources

432

Luis Cavazos

01/08/2015 05:48PM

Re: How To Use More Resources

515

Rick James

01/09/2015 02:39PM

How to use performance_schema.tables

966

jongse park

01/07/2015 02:05AM

Re: How to use performance_schema.tables

456

Øystein Grøvlen

01/07/2015 03:41AM

Re: How to use performance_schema.tables

535

Rick James

01/07/2015 05:02PM

lockfree approach to creating a single unique row without unique index

1,113

Andrew Nuss

01/03/2015 03:43PM

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

417

Rick James

01/05/2015 12:17AM

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

435

Rick James

01/05/2015 11:04AM

COUNT_STAR, SUM_TIMER_WAIT

1,109

jongse park

12/26/2014 02:08AM

Re: COUNT_STAR, SUM_TIMER_WAIT

596

Øystein Grøvlen

01/05/2015 04:27AM

what does table_open_cache_overflow=0 means?

1,199

jongse park

12/29/2014 07:42PM

Re: what does table_open_cache_overflow=0 means?

1,204

Rick James

12/31/2014 04:59PM

innodb_buffer_pool_read_requests global status wraparound

1,318

Wilson Hauck

11/18/2014 10:18AM

Re: innodb_buffer_pool_read_requests global status wraparound

576

Rick James

11/18/2014 10:40PM

Re: innodb_buffer_pool_read_requests global status wraparound

510

Wilson Hauck

11/19/2014 07:31AM

Re: innodb_buffer_pool_read_requests global status wraparound

488

Wilson Hauck

11/19/2014 10:19AM

Re: innodb_buffer_pool_read_requests global status wraparound

468

Rick James

12/22/2014 01:37AM

Re: innodb_buffer_pool_read_requests global status wraparound

501

Wilson Hauck

11/19/2014 03:00PM

Re: innodb_buffer_pool_read_requests global status wraparound

448

Wilson Hauck

12/20/2014 12:15PM

25.000+ rows - MySQL SELECT consecutive numbers performance issue

1,198

Daniel Negoita

12/12/2014 08:55AM

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

790

Daniel Negoita

12/12/2014 09:18AM

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

517

Peter Brawley

12/12/2014 12:18PM

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

788

Rick James

12/14/2014 01:42PM

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

693

Peter Brawley

12/14/2014 04:19PM

innodb_checksum_algorithm stic_crc32 is slow response

1,290

Ankur Kaushik

12/08/2014 04:29AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

601

Ankur Kaushik

12/08/2014 04:32AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

538

Øystein Grøvlen

12/08/2014 05:45AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

526

Rick James

12/08/2014 10:52AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

482

Ankur Kaushik

12/09/2014 06:44AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

582

Rick James

12/09/2014 03:34PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

538

Ankur Kaushik

12/13/2014 08:47PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

554

Ankur Kaushik

12/13/2014 08:49PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

501

Rick James

12/14/2014 11:51AM

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

1,651

Daniel Chiaramello

12/04/2014 05:05AM

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

876

Rick James

12/06/2014 02:40PM

Write Operations very slow in InnoDB engine when compared to MyIsam

1,080

MURALI NARAYANASWAMY

11/28/2014 07:07AM

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

460

Rick James

11/28/2014 06:59PM

Cardinality Problem

1,004

Katja Kahl

11/26/2014 06:53AM

Re: Cardinality Problem

446

Peter Brawley

11/26/2014 12:03PM

Re: Cardinality Problem

497

Katja Kahl

11/27/2014 03:08AM

Re: Cardinality Problem

405

Rick James

11/28/2014 06:56PM

Reduce the Query Execution Time Between MYSQL & VC++

1,308

saraswathi srinath

11/12/2014 05:01AM

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

522

Rick James

11/13/2014 06:50PM

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

534

saraswathi srinath

11/13/2014 10:29PM

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

531

Rick James

11/14/2014 07:55PM

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

619

saraswathi srinath

11/14/2014 10:33PM

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

557

Rick James

11/15/2014 08:43PM

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

557

saraswathi srinath

11/16/2014 10:19PM

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

509

saraswathi srinath

11/16/2014 10:37PM

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

442

Rick James

11/17/2014 08:06PM

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

469

saraswathi srinath

11/19/2014 11:09PM

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

476

Rick James

11/20/2014 07:59PM

Which server hardware would you pick?

1,082

Robert Gunther

11/14/2014 08:24PM

Re: Which server hardware would you pick?

537

Rick James

11/15/2014 08:46PM

Re: Which server hardware would you pick?

471

Robert Gunther

11/16/2014 06:25PM

Re: Which server hardware would you pick?

490

Rick James

11/17/2014 03:42PM

Re: Which server hardware would you pick?

523

Robert Gunther

11/18/2014 09:08AM

Re: Which server hardware would you pick?

473

Rick James

11/19/2014 05:02PM

MySQL query execution time differs between executions

1,799

Ofer Bechar

11/16/2014 09:49AM

Re: MySQL query execution time differs between executions

642

Peter Brawley

11/16/2014 12:19PM

Re: MySQL query execution time differs between executions

588

Rick James

11/16/2014 03:24PM

Re: MySQL query execution time differs between executions

620

Ofer Bechar

11/17/2014 02:57AM

Re: MySQL query execution time differs between executions

655

Rick James

11/17/2014 04:09PM

Re: MySQL query execution time differs between executions

593

Ofer Bechar

11/17/2014 02:30AM

Why INSERT performance has not increase in sub-table?

1,389

Yao Yao

11/03/2014 03:02AM

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

482

Dexter Yao

11/03/2014 09:07AM

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

439

Rick James

11/03/2014 09:31AM

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

427

Dexter Yao

11/03/2014 11:56AM

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

570

Rick James

11/03/2014 01:12PM

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

444

Dexter Yao

11/03/2014 09:43PM

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

511

Rick James

11/04/2014 08:57AM

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

429

Dexter Yao

11/05/2014 04:39AM

Performance of insert on duplicate key update

4,394

Ravi Malghan

10/23/2014 02:03PM

Re: Performance of insert on duplicate key update

2,146

Rick James

10/24/2014 10:39AM

Re: Performance of insert on duplicate key update

1,524

Ravi Malghan

10/24/2014 11:54AM

Re: Performance of insert on duplicate key update

1,292

Rick James

10/25/2014 12:51PM

Re: Performance of insert on duplicate key update

1,090

Ravi Malghan

10/27/2014 07:44AM

Re: Performance of insert on duplicate key update

1,070

Rick James

10/28/2014 11:33AM

Re: Performance of insert on duplicate key update

830

Ravi Malghan

11/04/2014 06:40AM

msyql 5.0.22 and multi-core server support

1,354

Christine Ross

10/31/2014 10:30AM

Re: msyql 5.0.22 and multi-core server support

663

Peter Brawley

10/31/2014 11:14AM

Re: msyql 5.0.22 and multi-core server support

596

Christine Ross

10/31/2014 01:38PM

Re: msyql 5.0.22 and multi-core server support

822

Rick James

11/02/2014 09:33AM

GROUP causing Using Temporary Using Filesort

11,083

RT Lee

07/31/2014 02:35PM

Re: GROUP causing Using Temporary Using Filesort

3,741

Peter Brawley

07/31/2014 03:24PM

Re: GROUP causing Using Temporary Using Filesort

3,096

RT Lee

07/31/2014 05:45PM

Re: GROUP causing Using Temporary Using Filesort

2,724

Rick James

08/01/2014 04:45PM

Re: GROUP causing Using Temporary Using Filesort

1,988

RT Lee

08/01/2014 08:26PM

Re: GROUP causing Using Temporary Using Filesort

1,694

Rick James

08/01/2014 11:45PM

Re: GROUP causing Using Temporary Using Filesort

1,603

RT Lee

08/02/2014 08:23AM

Re: GROUP causing Using Temporary Using Filesort

1,687

Rick James

08/02/2014 12:44PM

Re: GROUP causing Using Temporary Using Filesort

1,093

Leonardo Duque

10/30/2014 12:57PM

Leonardo, please do not hijack threads

820

Peter Brawley

10/31/2014 11:15AM

Eliminate filesort in update query

1,508

Matzz -

09/23/2014 02:48AM

Re: Eliminate filesort in update query

574

Rick James

09/23/2014 09:59PM

Re: Eliminate filesort in update query

536

Matzz -

09/24/2014 01:25AM

Re: Eliminate filesort in update query

618

Rick James

09/24/2014 08:40PM

Re: Eliminate filesort in update query

575

Matzz -

09/25/2014 05:48AM

Re: Eliminate filesort in update query

540

Rick James

09/26/2014 04:39PM

Re: Eliminate filesort in update query

555

Matzz -

10/01/2014 06:49AM

Re: Eliminate filesort in update query

599

Rick James

10/03/2014 10:09PM

Re: Eliminate filesort in update query

619

Matzz -

10/04/2014 03:13AM

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

1,272

Jeetu Gaur

09/26/2014 06:48AM

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

566

Rick James

09/27/2014 08:16AM

Slow response time due queries

2,587

Jens Meier

09/23/2014 01:32AM

Re: Slow response time due queries

975

Rick James

09/23/2014 10:11PM

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

1,627

Caleb Pitman

09/21/2014 11:04AM

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

705

Rick James

09/22/2014 03:39PM

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

820

Caleb Pitman

09/22/2014 04:55PM

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

572

Rick James

09/23/2014 03:21PM

How to set mysql CPU affinity?

2,560

Metal Messiah

09/21/2014 01:33PM

Re: How to set mysql CPU affinity?

1,149

Rick James

09/22/2014 03:25PM

Re: How to set mysql CPU affinity?

1,160

Sophia Parsons

09/23/2014 01:30AM

Re: How to set mysql CPU affinity?

1,067

Rick James

09/23/2014 11:03AM

Query optimization to reduce execution time.

1,321

Neetu Nayak

09/22/2014 07:33AM

Re: Query optimization to reduce execution time.

575

Rick James

09/22/2014 08:46PM

Re: Query optimization to reduce execution time.

537

Neetu Nayak

09/23/2014 12:38AM

Re: Query optimization to reduce execution time.

604

Neetu Nayak

09/23/2014 01:42AM

Mass Update optimization

1,720

Susan Lin

09/14/2014 06:00PM

Re: Mass Update optimization

642

Rick James

09/15/2014 11:38AM

Re: Mass Update optimization

593

Sophia Parsons

09/23/2014 01:36AM

Optimising query with composite index, which says using where

1,156

Timothy Mifsud

09/06/2014 12:38AM

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

494

Timothy Mifsud

09/06/2014 01:53AM

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

500

Rick James

09/07/2014 10:46PM

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

481

Øystein Grøvlen

09/15/2014 06:03AM

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

489

Rick James

09/15/2014 10:03AM

Slow Performance with Multi-threaded app

1,255

Minesh Desai

09/12/2014 09:24AM

Re: Slow Performance with Multi-threaded app

582

Rick James

09/13/2014 09:47AM

InnoDB and locking, UPDATE and SELECT

1,234

Andreas Greulich

09/10/2014 01:18AM

Re: InnoDB and locking, UPDATE and SELECT

472

Rick James

09/13/2014 12:09AM

MySQL using too much CPU

1,556

31 Special

08/29/2014 05:12PM

Re: MySQL using too much CPU

656

Rick James

08/30/2014 05:27PM

Re: MySQL using too much CPU

863

31 Special

08/31/2014 10:13PM

Understanding Explain

1,200

J M

08/27/2014 07:31AM

Re: Understanding Explain

568

Peter Brawley

08/27/2014 10:35AM

Re: Understanding Explain

523

J M

08/27/2014 10:51AM

Re: Understanding Explain

566

Øystein Grøvlen

08/28/2014 03:00PM

Re: Understanding Explain

425

Rick James

08/29/2014 09:45PM

Need help to otimize my query

1,068

GAURAV JAIN

08/21/2014 07:28AM

Re: Need help to otimize my query

555

Rick James

08/24/2014 09:17PM

Slow response in MY SQL 5.5.1.8

1,069

Amila Kumara

07/16/2014 01:30AM

Re: Slow response in MY SQL 5.5.1.8

562

Rick James

07/16/2014 09:04PM

Re: Slow response in MY SQL 5.5.1.8

576

Amila Kumara

07/21/2014 05:02AM

Re: Slow response in MY SQL 5.5.1.8

607

Rick James

07/23/2014 12:19AM

Help in tuning MySQL 5.6 database

1,088

Deepak Dambe

07/17/2014 05:26AM

Re: Help in tuning MySQL 5.6 database

547

Rick James

07/18/2014 12:12PM

Query slows down over time

1,528

Sameer Shah

05/28/2014 09:35AM