MySQL :: MySQL Forums :: Performance

New Topic

Pages:

« 1

...

5 6 7 8 9

...

76 »

Subject

Views

Written By

Posted

Avoid subquery

1,604

Wolfgang Jacques

05/12/2015 08:40AM

Re: Avoid subquery

804

Peter Brawley

05/12/2015 11:06AM

Re: Avoid subquery

625

Wolfgang Jacques

05/12/2015 01:29PM

Re: Avoid subquery

599

Peter Brawley

05/12/2015 01:41PM

Re: Avoid subquery

742

Rick James

05/17/2015 12:11AM

MYSQL Table Optimization

1,227

Yudhveer Kandukuri

05/13/2015 09:53PM

Re: MYSQL Table Optimization

555

Rick James

05/15/2015 11:02AM

Slow query

1,588

Manu Swami

04/21/2015 11:15AM

Re: Slow query

757

Maulik Parekh

04/22/2015 07:17AM

Re: Slow query

714

Rick James

04/22/2015 07:05PM

Re: Slow query

898

Manu Swami

04/23/2015 11:42PM

Re: Slow query

685

Manu Swami

04/23/2015 11:55PM

Re: Slow query

666

Rick James

04/24/2015 05:22PM

Re: Slow query

676

Manu Swami

04/25/2015 02:31AM

Re: Slow query

732

Manu Swami

04/25/2015 02:41AM

Re: Slow query

1,274

Manu Swami

04/25/2015 05:22AM

Re: Slow query

748

Rick James

04/25/2015 10:42PM

Re: Slow query

691

Øystein Grøvlen

05/13/2015 03:30AM

Re: Slow query

807

Manu Swami

04/28/2015 03:40AM

CPU usage extremely high

2,885

Temu Kinn

04/28/2015 08:55AM

Re: CPU usage extremely high

1,332

Temu Kinn

04/28/2015 09:03AM

Re: CPU usage extremely high

1,065

Rick James

04/29/2015 05:43PM

Re: CPU usage extremely high

1,094

Temu Kinn

05/09/2015 07:22AM

Re: CPU usage extremely high

950

Temu Kinn

05/09/2015 07:38AM

Re: CPU usage extremely high

977

Rick James

05/11/2015 06:30PM

Mysql indexes weird behavior

1,156

Nikhil Khekade

05/02/2015 02:17AM

Re: Mysql indexes weird behavior

522

Rick James

05/03/2015 06:21PM

slow query sorting result - sending data

2,713

Hugo Rodriguez

04/28/2015 07:27PM

Re: slow query sorting result - sending data

981

Peter Brawley

04/28/2015 10:38PM

Re: slow query sorting result - sending data

881

Rick James

05/01/2015 10:08PM

PROFILING

1,382

Khurram Naseem

04/27/2015 04:26AM

Re: PROFILING

633

Rick James

04/29/2015 06:53PM

Query time difference

1,610

Ofer Bechar

04/26/2015 07:28AM

Re: Query time difference

574

Rick James

04/27/2015 02:39PM

Re: Query time difference

607

Ofer Bechar

04/27/2015 11:29PM

Re: Query time difference

593

Rick James

04/29/2015 05:50PM

Performance issues with INNODB vs MyISAM

2,687

Milovan Krivokapic

04/17/2015 01:20PM

Re: Performance issues with INNODB vs MyISAM

1,162

Rick James

04/19/2015 01:22PM

Re: Performance issues with INNODB vs MyISAM

854

Milovan Krivokapic

04/27/2015 11:15AM

Re: Performance issues with INNODB vs MyISAM

775

Rick James

04/28/2015 10:34AM

Why mysqlslap doesn't return the correct Benchmark time?

1,343

Cai Vincent

04/20/2015 08:07AM

Writing at 847 MB/sec ???

1,272

Robert Gunther

04/11/2015 05:50AM

Re: Writing at 847 MB/sec ???

731

Rick James

04/15/2015 11:03PM

Re: Writing at 847 MB/sec ???

712

Robert Gunther

04/17/2015 08:45AM

Re: Writing at 847 MB/sec ???

639

Rick James

04/19/2015 01:38PM

Re: Writing at 847 MB/sec ???

688

Robert Gunther

04/20/2015 01:00AM

Mysql is consuming xtremely high CPU above 1000%

3,046

Eric Leung

04/11/2015 04:38PM

Re: Mysql is consuming xtremely high CPU above 1000%

2,536

Eric Leung

04/11/2015 04:47PM

Re: Mysql is consuming xtremely high CPU above 1000%

1,341

Rick James

04/15/2015 10:36PM

Re: Mysql is consuming xtremely high CPU above 1000%

1,111

Eric Leung

04/16/2015 11:45AM

Re: Mysql is consuming xtremely high CPU above 1000%

1,185

Rick James

04/17/2015 08:05PM

Re: Mysql is consuming xtremely high CPU above 1000%

1,266

Eric Leung

04/18/2015 06:07AM

Re: Mysql is consuming xtremely high CPU above 1000%

1,541

Rick James

04/19/2015 02:19PM

Client to server connection

1,248

Dan Toškan

04/14/2015 12:40PM

Re: Client to server connection

538

Peter Brawley

04/14/2015 11:18PM

Re: Client to server connection

472

Rick James

04/17/2015 08:09PM

This topic has been moved.: Mysql NDB Cluster

SRINIVASA RAO PUJARI

04/01/2015 11:23PM

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

1,279

Ola Arwidsson

03/26/2015 06:40AM

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

772

Peter Brawley

03/26/2015 10:45AM

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

667

Ola Arwidsson

03/30/2015 01:22AM

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

730

Ola Arwidsson

03/30/2015 03:27AM

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

594

Peter Brawley

03/30/2015 11:16AM

system table space vs file per table space

1,240

jongse park

03/27/2015 12:35AM

Re: system table space vs file per table space

610

Rick James

03/28/2015 03:36PM

Slow COUNT + GROUP BY

1,567

Refael Dakar

03/20/2015 07:00AM

Re: Slow COUNT + GROUP BY

696

Jeremy Smyth

03/20/2015 07:55AM

Re: Slow COUNT + GROUP BY

673

Refael Dakar

03/20/2015 08:00AM

Re: Slow COUNT + GROUP BY

655

Rick James

03/22/2015 04:11PM

Re: Slow COUNT + GROUP BY

632

Refael Dakar

03/23/2015 12:46AM

Re: Slow COUNT + GROUP BY

1,012

Øystein Grøvlen

03/23/2015 02:45AM

Re: Slow COUNT + GROUP BY

884

Matan K

03/23/2015 04:30AM

Re: Slow COUNT + GROUP BY

776

Øystein Grøvlen

03/23/2015 06:04AM

Re: Slow COUNT + GROUP BY

679

Matan K

03/23/2015 08:13AM

Re: Slow COUNT + GROUP BY

683

Øystein Grøvlen

03/24/2015 02:02AM

Re: Slow COUNT + GROUP BY

675

Matan K

03/24/2015 02:51AM

Re: Slow COUNT + GROUP BY

695

Øystein Grøvlen

03/24/2015 03:37AM

Query Optimization Needed

1,517

Devrishi Shandilya

02/11/2015 01:31AM

Re: Query Optimization Needed

701

Peter Brawley

02/11/2015 12:42PM

Re: Query Optimization Needed

800

Devrishi Shandilya

02/12/2015 03:51AM

Re: Query Optimization Needed

726

Peter Brawley

02/12/2015 01:24PM

Re: Query Optimization Needed

698

Devrishi Shandilya

02/13/2015 06:53AM

Re: Query Optimization Needed

606

Peter Brawley

02/13/2015 07:36AM

Re: Query Optimization Needed

639

Rick James

02/14/2015 01:04AM

Re: Query Optimization Needed

702

Devrishi Shandilya

02/15/2015 11:07PM

Re: Query Optimization Needed

717

Rick James

02/16/2015 12:15AM

Re: Query Optimization Needed

578

Peter Brawley

03/13/2015 11:15AM

Exceedingly slow create table performance

3,491

Ronald Van Iwaarden

03/06/2015 10:51AM

Re: Exceedingly slow create table performance

1,472

Rick James

03/07/2015 11:03AM

Re: Exceedingly slow create table performance

1,310

Ronald Van Iwaarden

03/09/2015 10:10AM

Left join optimization- query is very slow

7,088

Devrishi Shandilya

03/05/2015 05:23AM

Re: Left join optimization- query is very slow

2,027

Øystein Grøvlen

03/05/2015 09:12AM

Re: Left join optimization- query is very slow

2,072

Rick James

03/06/2015 06:48PM

Re: Left join optimization- query is very slow

1,406

Devrishi Shandilya

03/08/2015 11:32PM

COUNT with GROUP BY, JOIN and SUBQUERY very slow

2,393

Anderson Scouto da Silva Dan

02/28/2015 03:15AM

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

2,082

Øystein Grøvlen

03/02/2015 02:05AM

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

871

Øystein Grøvlen

03/02/2015 02:13AM

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

1,363

Anderson Scouto da Silva Dan

03/02/2015 02:28PM

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

907

Øystein Grøvlen

03/03/2015 01:27AM

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

934

Rick James

03/02/2015 06:13PM

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

753

Anderson Scouto da Silva Dan

03/02/2015 07:14PM

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

810

Anderson Scouto da Silva Dan

03/02/2015 07:20PM

Slow performance when using LIMIT 1000

1,480

Christian Esborg

02/25/2015 07:43AM

Re: Slow performance when using LIMIT 1000

620

Øystein Grøvlen

02/26/2015 04:13AM

Re: Slow performance when using LIMIT 1000

789

Rick James

02/27/2015 01:09AM

Analyse-Optimize and tablecache

1,452

Samuel Mutel

02/16/2015 03:49AM

Re: Analyse-Optimize and tablecache

663

Rick James

02/18/2015 03:54PM

Temp tables on Disk issue

1,259

Devrishi Shandilya

02/15/2015 11:17PM

Re: Temp tables on Disk issue

557

Rick James

02/16/2015 12:19AM

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

1,793

Pól Ua Laoínecháin

02/04/2015 08:21PM

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

780

Øystein Grøvlen

02/05/2015 01:51AM

Mysql performance between installation

1,630

Patrick MORAND

01/16/2015 07:32AM

Re: Mysql performance between installation

691

Rick James

01/17/2015 11:50AM

Re: Mysql performance between installation

762

Patrick MORAND

01/19/2015 08:26AM

Re: Mysql performance between installation

856

Rick James

01/20/2015 04:57PM

Re: Mysql performance between installation

761

Patrick MORAND

01/21/2015 02:30AM

RAM consideration/ IO usage

1,452

Jawahar muthukrishnan

01/13/2015 12:39PM

Re: RAM consideration/ IO usage

863

Rick James

01/14/2015 01:47PM

Re: RAM consideration/ IO usage

804

Jawahar muthukrishnan

01/15/2015 03:07PM

Re: RAM consideration/ IO usage

1,100

Rick James

01/16/2015 02:14PM

Unusually high cpu usage

2,719

Fabrizio Bartolomucci

01/11/2015 02:55PM

Re: Unusually high cpu usage

1,095

Rick James

01/12/2015 09:49PM

Re: Unusually high cpu usage

956

Fabrizio Bartolomucci

01/13/2015 09:32AM

Re: Unusually high cpu usage

1,252

Fabrizio Bartolomucci

01/13/2015 11:47AM

Re: Unusually high cpu usage

968

Rick James

01/13/2015 04:21PM

How To Use More Resources

1,602

Luis Cavazos

01/07/2015 11:12AM

Re: How To Use More Resources

669

Rick James

01/07/2015 07:14PM

Re: How To Use More Resources

1,026

Luis Cavazos

01/07/2015 09:14PM

Re: How To Use More Resources

976

Rick James

01/07/2015 11:21PM

Re: How To Use More Resources

613

Rick James

01/07/2015 11:42PM

Re: How To Use More Resources

695

Luis Cavazos

01/08/2015 05:48PM

Re: How To Use More Resources

715

Rick James

01/09/2015 02:39PM

How to use performance_schema.tables

1,471

jongse park

01/07/2015 02:05AM

Re: How to use performance_schema.tables

698

Øystein Grøvlen

01/07/2015 03:41AM

Re: How to use performance_schema.tables

839

Rick James

01/07/2015 05:02PM

lockfree approach to creating a single unique row without unique index

1,450

Andrew Nuss

01/03/2015 03:43PM

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

624

Rick James

01/05/2015 12:17AM

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

615

Rick James

01/05/2015 11:04AM

COUNT_STAR, SUM_TIMER_WAIT

1,721

jongse park

12/26/2014 02:08AM

Re: COUNT_STAR, SUM_TIMER_WAIT

943

Øystein Grøvlen

01/05/2015 04:27AM

what does table_open_cache_overflow=0 means?

1,889

jongse park

12/29/2014 07:42PM

Re: what does table_open_cache_overflow=0 means?

3,026

Rick James

12/31/2014 04:59PM

innodb_buffer_pool_read_requests global status wraparound

1,769

Wilson Hauck

11/18/2014 10:18AM

Re: innodb_buffer_pool_read_requests global status wraparound

860

Rick James

11/18/2014 10:40PM

Re: innodb_buffer_pool_read_requests global status wraparound

758

Wilson Hauck

11/19/2014 07:31AM

Re: innodb_buffer_pool_read_requests global status wraparound

701

Wilson Hauck

11/19/2014 10:19AM

Re: innodb_buffer_pool_read_requests global status wraparound

772

Rick James

12/22/2014 01:37AM

Re: innodb_buffer_pool_read_requests global status wraparound

689

Wilson Hauck

11/19/2014 03:00PM

Re: innodb_buffer_pool_read_requests global status wraparound

665

Wilson Hauck

12/20/2014 12:15PM

25.000+ rows - MySQL SELECT consecutive numbers performance issue

1,850

Daniel Negoita

12/12/2014 08:55AM

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

1,424

Daniel Negoita

12/12/2014 09:18AM

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

951

Peter Brawley

12/12/2014 12:18PM

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

1,226

Rick James

12/14/2014 01:42PM

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

943

Peter Brawley

12/14/2014 04:19PM

innodb_checksum_algorithm stic_crc32 is slow response

1,945

Ankur Kaushik

12/08/2014 04:29AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

947

Ankur Kaushik

12/08/2014 04:32AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

953

Øystein Grøvlen

12/08/2014 05:45AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

853

Rick James

12/08/2014 10:52AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

817

Ankur Kaushik

12/09/2014 06:44AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

877

Rick James

12/09/2014 03:34PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

837

Ankur Kaushik

12/13/2014 08:47PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

802

Ankur Kaushik

12/13/2014 08:49PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

862

Rick James

12/14/2014 11:51AM

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

2,161

Daniel Chiaramello

12/04/2014 05:05AM

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

1,202

Rick James

12/06/2014 02:40PM

Write Operations very slow in InnoDB engine when compared to MyIsam

1,563

MURALI NARAYANASWAMY

11/28/2014 07:07AM

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

659

Rick James

11/28/2014 06:59PM

Cardinality Problem

1,491

Katja Kahl

11/26/2014 06:53AM

Re: Cardinality Problem

693

Peter Brawley

11/26/2014 12:03PM

Re: Cardinality Problem

679

Katja Kahl

11/27/2014 03:08AM

Re: Cardinality Problem

613

Rick James

11/28/2014 06:56PM

Reduce the Query Execution Time Between MYSQL & VC++

1,850

saraswathi srinath

11/12/2014 05:01AM

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

773

Rick James

11/13/2014 06:50PM

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

835

saraswathi srinath

11/13/2014 10:29PM

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

763

Rick James

11/14/2014 07:55PM

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

968

saraswathi srinath

11/14/2014 10:33PM

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

748

Rick James

11/15/2014 08:43PM

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

832

saraswathi srinath

11/16/2014 10:19PM

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

833

saraswathi srinath

11/16/2014 10:37PM

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

673

Rick James

11/17/2014 08:06PM

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

733

saraswathi srinath

11/19/2014 11:09PM

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

735

Rick James

11/20/2014 07:59PM

Which server hardware would you pick?

1,523

Robert Gunther

11/14/2014 08:24PM

Re: Which server hardware would you pick?

772

Rick James

11/15/2014 08:46PM

Re: Which server hardware would you pick?

726

Robert Gunther

11/16/2014 06:25PM

Re: Which server hardware would you pick?

683

Rick James

11/17/2014 03:42PM

Re: Which server hardware would you pick?

864

Robert Gunther

11/18/2014 09:08AM

Re: Which server hardware would you pick?

673

Rick James

11/19/2014 05:02PM

MySQL query execution time differs between executions

3,239

Ofer Bechar

11/16/2014 09:49AM

Re: MySQL query execution time differs between executions

972

Peter Brawley

11/16/2014 12:19PM

Re: MySQL query execution time differs between executions

981

Rick James

11/16/2014 03:24PM

Re: MySQL query execution time differs between executions

1,009

Ofer Bechar

11/17/2014 02:57AM

Re: MySQL query execution time differs between executions

1,161

Rick James

11/17/2014 04:09PM

Re: MySQL query execution time differs between executions

947

Ofer Bechar

11/17/2014 02:30AM

Why INSERT performance has not increase in sub-table?

2,283

Yao Yao

11/03/2014 03:02AM

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

715

Dexter Yao

11/03/2014 09:07AM

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

780

Rick James

11/03/2014 09:31AM

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

707

Dexter Yao

11/03/2014 11:56AM

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

870

Rick James

11/03/2014 01:12PM

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

703

Dexter Yao

11/03/2014 09:43PM

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

846

Rick James

11/04/2014 08:57AM

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

641

Dexter Yao

11/05/2014 04:39AM

Performance of insert on duplicate key update

8,902

Ravi Malghan

10/23/2014 02:03PM

Re: Performance of insert on duplicate key update

4,166

Rick James

10/24/2014 10:39AM

Re: Performance of insert on duplicate key update

2,868

Ravi Malghan

10/24/2014 11:54AM

Re: Performance of insert on duplicate key update

2,841

Rick James

10/25/2014 12:51PM

Re: Performance of insert on duplicate key update

2,264

Ravi Malghan

10/27/2014 07:44AM

Re: Performance of insert on duplicate key update

2,249

Rick James

10/28/2014 11:33AM

Re: Performance of insert on duplicate key update

1,729

Ravi Malghan

11/04/2014 06:40AM

msyql 5.0.22 and multi-core server support

2,015

Christine Ross

10/31/2014 10:30AM

Re: msyql 5.0.22 and multi-core server support

938

Peter Brawley

10/31/2014 11:14AM

Re: msyql 5.0.22 and multi-core server support

843

Christine Ross

10/31/2014 01:38PM

Re: msyql 5.0.22 and multi-core server support

1,165

Rick James

11/02/2014 09:33AM

GROUP causing Using Temporary Using Filesort

22,086

RT Lee

07/31/2014 02:35PM

Re: GROUP causing Using Temporary Using Filesort

6,465

Peter Brawley

07/31/2014 03:24PM

Re: GROUP causing Using Temporary Using Filesort

5,032

RT Lee

07/31/2014 05:45PM

Re: GROUP causing Using Temporary Using Filesort

4,484

Rick James

08/01/2014 04:45PM

Re: GROUP causing Using Temporary Using Filesort

3,134

RT Lee

08/01/2014 08:26PM

Re: GROUP causing Using Temporary Using Filesort

2,727

Rick James

08/01/2014 11:45PM

Re: GROUP causing Using Temporary Using Filesort

2,565

RT Lee

08/02/2014 08:23AM

Re: GROUP causing Using Temporary Using Filesort

2,781

Rick James

08/02/2014 12:44PM

Re: GROUP causing Using Temporary Using Filesort

1,805

Leonardo Duque

10/30/2014 12:57PM

Leonardo, please do not hijack threads

1,322

Peter Brawley

10/31/2014 11:15AM

Eliminate filesort in update query

2,163

Matzz -

09/23/2014 02:48AM