MySQL :: MySQL Forums :: Performance

Announcements	Last Post
• Announcing August 2026 Releases featuring MySQL Server, MySQL NDB Cluster, Shell and Connector/ODBC	08/25/2026 01:01AM

New Topic

Pages:

« 1

...

7 8 9 10 11

...

78 »

Subject

Views

Written By

Posted

Mysql performance between installation

2,178

Patrick MORAND

01/16/2015 07:32AM

Re: Mysql performance between installation

950

Rick James

01/17/2015 11:50AM

Re: Mysql performance between installation

1,000

Patrick MORAND

01/19/2015 08:26AM

Re: Mysql performance between installation

1,082

Rick James

01/20/2015 04:57PM

Re: Mysql performance between installation

1,036

Patrick MORAND

01/21/2015 02:30AM

RAM consideration/ IO usage

1,954

Jawahar muthukrishnan

01/13/2015 12:39PM

Re: RAM consideration/ IO usage

1,204

Rick James

01/14/2015 01:47PM

Re: RAM consideration/ IO usage

1,080

Jawahar muthukrishnan

01/15/2015 03:07PM

Re: RAM consideration/ IO usage

1,408

Rick James

01/16/2015 02:14PM

Unusually high cpu usage

3,588

Fabrizio Bartolomucci

01/11/2015 02:55PM

Re: Unusually high cpu usage

1,437

Rick James

01/12/2015 09:49PM

Re: Unusually high cpu usage

1,275

Fabrizio Bartolomucci

01/13/2015 09:32AM

Re: Unusually high cpu usage

1,621

Fabrizio Bartolomucci

01/13/2015 11:47AM

Re: Unusually high cpu usage

1,305

Rick James

01/13/2015 04:21PM

How To Use More Resources

2,154

Luis Cavazos

01/07/2015 11:12AM

Re: How To Use More Resources

973

Rick James

01/07/2015 07:14PM

Re: How To Use More Resources

1,389

Luis Cavazos

01/07/2015 09:14PM

Re: How To Use More Resources

1,359

Rick James

01/07/2015 11:21PM

Re: How To Use More Resources

994

Rick James

01/07/2015 11:42PM

Re: How To Use More Resources

1,016

Luis Cavazos

01/08/2015 05:48PM

Re: How To Use More Resources

1,118

Rick James

01/09/2015 02:39PM

How to use performance_schema.tables

1,990

jongse park

01/07/2015 02:05AM

Re: How to use performance_schema.tables

1,013

Øystein Grøvlen

01/07/2015 03:41AM

Re: How to use performance_schema.tables

1,084

Rick James

01/07/2015 05:02PM

lockfree approach to creating a single unique row without unique index

2,141

Andrew Nuss

01/03/2015 03:43PM

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

957

Rick James

01/05/2015 12:17AM

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

950

Rick James

01/05/2015 11:04AM

COUNT_STAR, SUM_TIMER_WAIT

2,481

jongse park

12/26/2014 02:08AM

Re: COUNT_STAR, SUM_TIMER_WAIT

1,286

Øystein Grøvlen

01/05/2015 04:27AM

what does table_open_cache_overflow=0 means?

2,618

jongse park

12/29/2014 07:42PM

Re: what does table_open_cache_overflow=0 means?

4,096

Rick James

12/31/2014 04:59PM

innodb_buffer_pool_read_requests global status wraparound

2,269

Wilson Hauck

11/18/2014 10:18AM

Re: innodb_buffer_pool_read_requests global status wraparound

1,163

Rick James

11/18/2014 10:40PM

Re: innodb_buffer_pool_read_requests global status wraparound

1,018

Wilson Hauck

11/19/2014 07:31AM

Re: innodb_buffer_pool_read_requests global status wraparound

1,089

Wilson Hauck

11/19/2014 10:19AM

Re: innodb_buffer_pool_read_requests global status wraparound

1,191

Rick James

12/22/2014 01:37AM

Re: innodb_buffer_pool_read_requests global status wraparound

971

Wilson Hauck

11/19/2014 03:00PM

Re: innodb_buffer_pool_read_requests global status wraparound

1,036

Wilson Hauck

12/20/2014 12:15PM

25.000+ rows - MySQL SELECT consecutive numbers performance issue

2,507

Daniel Negoita

12/12/2014 08:55AM

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

1,804

Daniel Negoita

12/12/2014 09:18AM

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

1,407

Peter Brawley

12/12/2014 12:18PM

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

1,507

Rick James

12/14/2014 01:42PM

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

1,218

Peter Brawley

12/14/2014 04:19PM

innodb_checksum_algorithm stic_crc32 is slow response

2,816

Ankur Kaushik

12/08/2014 04:29AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

1,302

Ankur Kaushik

12/08/2014 04:32AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

1,438

Øystein Grøvlen

12/08/2014 05:45AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

1,184

Rick James

12/08/2014 10:52AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

1,195

Ankur Kaushik

12/09/2014 06:44AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

1,251

Rick James

12/09/2014 03:34PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

1,187

Ankur Kaushik

12/13/2014 08:47PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

1,158

Ankur Kaushik

12/13/2014 08:49PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

1,208

Rick James

12/14/2014 11:51AM

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

2,733

Daniel Chiaramello

12/04/2014 05:05AM

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

1,546

Rick James

12/06/2014 02:40PM

Write Operations very slow in InnoDB engine when compared to MyIsam

2,061

MURALI NARAYANASWAMY

11/28/2014 07:07AM

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

873

Rick James

11/28/2014 06:59PM

Cardinality Problem

1,963

Katja Kahl

11/26/2014 06:53AM

Re: Cardinality Problem

941

Peter Brawley

11/26/2014 12:03PM

Re: Cardinality Problem

892

Katja Kahl

11/27/2014 03:08AM

Re: Cardinality Problem

854

Rick James

11/28/2014 06:56PM

Reduce the Query Execution Time Between MYSQL & VC++

2,318

saraswathi srinath

11/12/2014 05:01AM

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

1,050

Rick James

11/13/2014 06:50PM

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

1,127

saraswathi srinath

11/13/2014 10:29PM

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

1,019

Rick James

11/14/2014 07:55PM

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

1,211

saraswathi srinath

11/14/2014 10:33PM

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

989

Rick James

11/15/2014 08:43PM

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

1,075

saraswathi srinath

11/16/2014 10:19PM

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

1,049

saraswathi srinath

11/16/2014 10:37PM

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

910

Rick James

11/17/2014 08:06PM

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

958

saraswathi srinath

11/19/2014 11:09PM

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

962

Rick James

11/20/2014 07:59PM

Which server hardware would you pick?

1,984

Robert Gunther

11/14/2014 08:24PM

Re: Which server hardware would you pick?

1,028

Rick James

11/15/2014 08:46PM

Re: Which server hardware would you pick?

964

Robert Gunther

11/16/2014 06:25PM

Re: Which server hardware would you pick?

932

Rick James

11/17/2014 03:42PM

Re: Which server hardware would you pick?

1,178

Robert Gunther

11/18/2014 09:08AM

Re: Which server hardware would you pick?

949

Rick James

11/19/2014 05:02PM

MySQL query execution time differs between executions

4,247

Ofer Bechar

11/16/2014 09:49AM

Re: MySQL query execution time differs between executions

1,291

Peter Brawley

11/16/2014 12:19PM

Re: MySQL query execution time differs between executions

1,269

Rick James

11/16/2014 03:24PM

Re: MySQL query execution time differs between executions

1,278

Ofer Bechar

11/17/2014 02:57AM

Re: MySQL query execution time differs between executions

1,560

Rick James

11/17/2014 04:09PM

Re: MySQL query execution time differs between executions

1,289

Ofer Bechar

11/17/2014 02:30AM

Why INSERT performance has not increase in sub-table?

3,163

Yao Yao

11/03/2014 03:02AM

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

1,029

Dexter Yao

11/03/2014 09:07AM

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

1,090

Rick James

11/03/2014 09:31AM

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

1,026

Dexter Yao

11/03/2014 11:56AM

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

1,181

Rick James

11/03/2014 01:12PM

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

1,017

Dexter Yao

11/03/2014 09:43PM

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

1,141

Rick James

11/04/2014 08:57AM

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

977

Dexter Yao

11/05/2014 04:39AM

Performance of insert on duplicate key update

13,962

Ravi Malghan

10/23/2014 02:03PM

Re: Performance of insert on duplicate key update

4,900

Rick James

10/24/2014 10:39AM

Re: Performance of insert on duplicate key update

3,487

Ravi Malghan

10/24/2014 11:54AM

Re: Performance of insert on duplicate key update

3,839

Rick James

10/25/2014 12:51PM

Re: Performance of insert on duplicate key update

2,834

Ravi Malghan

10/27/2014 07:44AM

Re: Performance of insert on duplicate key update

3,621

Rick James

10/28/2014 11:33AM

Re: Performance of insert on duplicate key update

2,134

Ravi Malghan

11/04/2014 06:40AM

msyql 5.0.22 and multi-core server support

2,572

Christine Ross

10/31/2014 10:30AM

Re: msyql 5.0.22 and multi-core server support

1,223

Peter Brawley

10/31/2014 11:14AM

Re: msyql 5.0.22 and multi-core server support

1,131

Christine Ross

10/31/2014 01:38PM

Re: msyql 5.0.22 and multi-core server support

1,495

Rick James

11/02/2014 09:33AM

GROUP causing Using Temporary Using Filesort

27,740

RT Lee

07/31/2014 02:35PM

Re: GROUP causing Using Temporary Using Filesort

7,289

Peter Brawley

07/31/2014 03:24PM

Re: GROUP causing Using Temporary Using Filesort

5,712

RT Lee

07/31/2014 05:45PM

Re: GROUP causing Using Temporary Using Filesort

5,221

Rick James

08/01/2014 04:45PM

Re: GROUP causing Using Temporary Using Filesort

3,705

RT Lee

08/01/2014 08:26PM

Re: GROUP causing Using Temporary Using Filesort

3,354

Rick James

08/01/2014 11:45PM

Re: GROUP causing Using Temporary Using Filesort

3,139

RT Lee

08/02/2014 08:23AM

Re: GROUP causing Using Temporary Using Filesort

3,459

Rick James

08/02/2014 12:44PM

Re: GROUP causing Using Temporary Using Filesort

2,263

Leonardo Duque

10/30/2014 12:57PM

Leonardo, please do not hijack threads

1,678

Peter Brawley

10/31/2014 11:15AM

Eliminate filesort in update query

3,153

Matzz -

09/23/2014 02:48AM

Re: Eliminate filesort in update query

1,202

Rick James

09/23/2014 09:59PM

Re: Eliminate filesort in update query

1,154

Matzz -

09/24/2014 01:25AM

Re: Eliminate filesort in update query

1,228

Rick James

09/24/2014 08:40PM

Re: Eliminate filesort in update query

1,191

Matzz -

09/25/2014 05:48AM

Re: Eliminate filesort in update query

1,125

Rick James

09/26/2014 04:39PM

Re: Eliminate filesort in update query

1,185

Matzz -

10/01/2014 06:49AM

Re: Eliminate filesort in update query

1,227

Rick James

10/03/2014 10:09PM

Re: Eliminate filesort in update query

1,237

Matzz -

10/04/2014 03:13AM

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

2,494

Jeetu Gaur

09/26/2014 06:48AM

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

1,189

Rick James

09/27/2014 08:16AM

Slow response time due queries

6,023

Jens Meier

09/23/2014 01:32AM

Re: Slow response time due queries

1,974

Rick James

09/23/2014 10:11PM

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

3,470

Caleb Pitman

09/21/2014 11:04AM

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

1,339

Rick James

09/22/2014 03:39PM

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

1,460

Caleb Pitman

09/22/2014 04:55PM

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

1,952

Rick James

09/23/2014 03:21PM

How to set mysql CPU affinity?

6,588

Metal Messiah

09/21/2014 01:33PM

Re: How to set mysql CPU affinity?

2,766

Rick James

09/22/2014 03:25PM

Re: How to set mysql CPU affinity?

2,539

Sophia Parsons

09/23/2014 01:30AM

Re: How to set mysql CPU affinity?

2,257

Rick James

09/23/2014 11:03AM

Query optimization to reduce execution time.

2,474

Neetu Nayak

09/22/2014 07:33AM

Re: Query optimization to reduce execution time.

1,157

Rick James

09/22/2014 08:46PM

Re: Query optimization to reduce execution time.

968

Neetu Nayak

09/23/2014 12:38AM

Re: Query optimization to reduce execution time.

1,109

Neetu Nayak

09/23/2014 01:42AM

Mass Update optimization

2,994

Susan Lin

09/14/2014 06:00PM

Re: Mass Update optimization

1,240

Rick James

09/15/2014 11:38AM

Re: Mass Update optimization

1,153

Sophia Parsons

09/23/2014 01:36AM

Optimising query with composite index, which says using where

2,090

Timothy Mifsud

09/06/2014 12:38AM

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

885

Timothy Mifsud

09/06/2014 01:53AM

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

936

Rick James

09/07/2014 10:46PM

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

923

Øystein Grøvlen

09/15/2014 06:03AM

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

1,014

Rick James

09/15/2014 10:03AM

Slow Performance with Multi-threaded app

2,151

Minesh Desai

09/12/2014 09:24AM

Re: Slow Performance with Multi-threaded app

1,001

Rick James

09/13/2014 09:47AM

InnoDB and locking, UPDATE and SELECT

2,134

Andreas Greulich

09/10/2014 01:18AM

Re: InnoDB and locking, UPDATE and SELECT

932

Rick James

09/13/2014 12:09AM

MySQL using too much CPU

2,551

31 Special

08/29/2014 05:12PM

Re: MySQL using too much CPU

1,186

Rick James

08/30/2014 05:27PM

Re: MySQL using too much CPU

1,283

31 Special

08/31/2014 10:13PM

Understanding Explain

2,151

J M

08/27/2014 07:31AM

Re: Understanding Explain

979

Peter Brawley

08/27/2014 10:35AM

Re: Understanding Explain

915

J M

08/27/2014 10:51AM

Re: Understanding Explain

939

Øystein Grøvlen

08/28/2014 03:00PM

Re: Understanding Explain

927

Rick James

08/29/2014 09:45PM

Need help to otimize my query

1,825

GAURAV JAIN

08/21/2014 07:28AM

Re: Need help to otimize my query

998

Rick James

08/24/2014 09:17PM

Slow response in MY SQL 5.5.1.8

1,900

Amila Kumara

07/16/2014 01:30AM

Re: Slow response in MY SQL 5.5.1.8

1,058

Rick James

07/16/2014 09:04PM

Re: Slow response in MY SQL 5.5.1.8

1,065

Amila Kumara

07/21/2014 05:02AM

Re: Slow response in MY SQL 5.5.1.8

990

Rick James

07/23/2014 12:19AM

Help in tuning MySQL 5.6 database

2,119

Deepak Dambe

07/17/2014 05:26AM

Re: Help in tuning MySQL 5.6 database

1,034

Rick James

07/18/2014 12:12PM

Query slows down over time

2,802

Sameer Shah

05/28/2014 09:35AM