MySQL :: MySQL Forums :: Performance

Announcements	Last Post
• Announcing a new webcast video that completes a deep dive into how to download and use Enterprise Manager for MySQL	04/04/2024 03:01PM

New Topic

Pages:

« 1

...

6 7 8 9 10

...

77 »

Subject

Views

Written By

Posted

Number of table Partitions

2,935

Jawahar muthukrishnan

07/22/2015 01:24PM

Re: Number of table Partitions

2,453

Rick James

07/24/2015 03:14PM

Re: Number of table Partitions

1,244

Jeeva M

07/31/2015 02:15PM

Slow Query Urgent

1,525

a m

07/23/2015 09:21AM

Re: Slow Query Urgent

667

Peter Brawley

07/23/2015 10:19AM

Re: Slow Query Urgent

626

Rick James

07/24/2015 04:00PM

MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU

2,029

Timothy Mifsud

07/16/2015 07:50AM

Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU

763

Peter Brawley

07/16/2015 09:39AM

Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU

997

Rick James

07/17/2015 04:01PM

SELECT never completes

1,592

James Cobban

07/06/2015 10:08PM

Re: SELECT never completes

780

Peter Brawley

07/06/2015 11:51PM

Re: SELECT never completes

1,246

James Cobban

07/07/2015 02:16AM

Re: SELECT never completes

746

Rick James

07/09/2015 12:55AM

5.5: UPDATE massively slower than SELECT. Both affect zero rows.

1,933

Andy Theuninck

05/21/2015 10:09AM

Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.

927

Øystein Grøvlen

05/22/2015 02:19AM

Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.

892

Andy Theuninck

05/22/2015 08:15AM

Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.

783

Rick James

06/06/2015 12:30PM

Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.

858

Chandan Kumar

06/26/2015 08:24AM

Performance Issue for select query

1,454

amar singh chawan

06/08/2015 04:58AM

Re: Performance Issue for select query

858

Rick James

06/09/2015 11:42PM

Best Training Institute for Mysql performace tuning and Database scalabulity

1,344

amar singh chawan

06/07/2015 11:42PM

Is ORDER BY RAND() LIMIT 1 optimized?

6,687

Markus M.

05/27/2015 05:40PM

Re: Is ORDER BY RAND() LIMIT 1 optimized?

1,900

Øystein Grøvlen

05/28/2015 02:18AM

Re: Is ORDER BY RAND() LIMIT 1 optimized?

1,448

Markus M.

05/28/2015 07:22AM

Re: Is ORDER BY RAND() LIMIT 1 optimized?

1,185

Øystein Grøvlen

05/28/2015 07:49AM

Re: Is ORDER BY RAND() LIMIT 1 optimized?

1,276

Rick James

06/06/2015 12:16PM

Strange behavior of MySQL server

1,597

Deepak Itkar

05/27/2015 07:33AM

Re: Strange behavior of MySQL server

705

Rick James

06/06/2015 11:51AM

heavy read workload with high cpu usage

2,235

kim alex

05/28/2015 04:37AM

Re: heavy read workload with high cpu usage

860

Rick James

06/04/2015 08:35AM

query performance on partitioning table

3,293

sixin yang

05/12/2015 09:00AM

Re: query performance on partitioning table

2,134

Rick James

05/16/2015 11:49PM

Re: query performance on partitioning table

1,139

sixin yang

05/18/2015 08:30AM

Re: query performance on partitioning table

1,094

Rick James

06/04/2015 08:22AM

Avoid subquery

1,810

Wolfgang Jacques

05/12/2015 08:40AM

Re: Avoid subquery

965

Peter Brawley

05/12/2015 11:06AM

Re: Avoid subquery

716

Wolfgang Jacques

05/12/2015 01:29PM

Re: Avoid subquery

681

Peter Brawley

05/12/2015 01:41PM

Re: Avoid subquery

831

Rick James

05/17/2015 12:11AM

MYSQL Table Optimization

1,352

Yudhveer Kandukuri

05/13/2015 09:53PM

Re: MYSQL Table Optimization

622

Rick James

05/15/2015 11:02AM

Slow query

2,034

Manu Swami

04/21/2015 11:15AM

Re: Slow query

849

Maulik Parekh

04/22/2015 07:17AM

Re: Slow query

787

Rick James

04/22/2015 07:05PM

Re: Slow query

992

Manu Swami

04/23/2015 11:42PM

Re: Slow query

789

Manu Swami

04/23/2015 11:55PM

Re: Slow query

767

Rick James

04/24/2015 05:22PM

Re: Slow query

769

Manu Swami

04/25/2015 02:31AM

Re: Slow query

855

Manu Swami

04/25/2015 02:41AM

Re: Slow query

1,477

Manu Swami

04/25/2015 05:22AM

Re: Slow query

823

Rick James

04/25/2015 10:42PM

Re: Slow query

797

Øystein Grøvlen

05/13/2015 03:30AM

Re: Slow query

877

Manu Swami

04/28/2015 03:40AM

CPU usage extremely high

3,059

Temu Kinn

04/28/2015 08:55AM

Re: CPU usage extremely high

1,428

Temu Kinn

04/28/2015 09:03AM

Re: CPU usage extremely high

1,168

Rick James

04/29/2015 05:43PM

Re: CPU usage extremely high

1,195

Temu Kinn

05/09/2015 07:22AM

Re: CPU usage extremely high

1,072

Temu Kinn

05/09/2015 07:38AM

Re: CPU usage extremely high

1,082

Rick James

05/11/2015 06:30PM

Mysql indexes weird behavior

1,293

Nikhil Khekade

05/02/2015 02:17AM

Re: Mysql indexes weird behavior

599

Rick James

05/03/2015 06:21PM

slow query sorting result - sending data

3,119

Hugo Rodriguez

04/28/2015 07:27PM

Re: slow query sorting result - sending data

1,088

Peter Brawley

04/28/2015 10:38PM

Re: slow query sorting result - sending data

977

Rick James

05/01/2015 10:08PM

PROFILING

1,530

Khurram Naseem

04/27/2015 04:26AM

Re: PROFILING

707

Rick James

04/29/2015 06:53PM

Query time difference

1,723

Ofer Bechar

04/26/2015 07:28AM

Re: Query time difference

649

Rick James

04/27/2015 02:39PM

Re: Query time difference

690

Ofer Bechar

04/27/2015 11:29PM

Re: Query time difference

660

Rick James

04/29/2015 05:50PM

Performance issues with INNODB vs MyISAM

2,916

Milovan Krivokapic

04/17/2015 01:20PM

Re: Performance issues with INNODB vs MyISAM

1,234

Rick James

04/19/2015 01:22PM

Re: Performance issues with INNODB vs MyISAM

916

Milovan Krivokapic

04/27/2015 11:15AM

Re: Performance issues with INNODB vs MyISAM

876

Rick James

04/28/2015 10:34AM

Why mysqlslap doesn't return the correct Benchmark time?

1,498

Cai Vincent

04/20/2015 08:07AM

Writing at 847 MB/sec ???

1,424

Robert Gunther

04/11/2015 05:50AM

Re: Writing at 847 MB/sec ???

806

Rick James

04/15/2015 11:03PM

Re: Writing at 847 MB/sec ???

789

Robert Gunther

04/17/2015 08:45AM

Re: Writing at 847 MB/sec ???

713

Rick James

04/19/2015 01:38PM

Re: Writing at 847 MB/sec ???

766

Robert Gunther

04/20/2015 01:00AM

Mysql is consuming xtremely high CPU above 1000%

3,650

Eric Leung

04/11/2015 04:38PM

Re: Mysql is consuming xtremely high CPU above 1000%

2,804

Eric Leung

04/11/2015 04:47PM

Re: Mysql is consuming xtremely high CPU above 1000%

1,468

Rick James

04/15/2015 10:36PM

Re: Mysql is consuming xtremely high CPU above 1000%

1,235

Eric Leung

04/16/2015 11:45AM

Re: Mysql is consuming xtremely high CPU above 1000%

1,331

Rick James

04/17/2015 08:05PM

Re: Mysql is consuming xtremely high CPU above 1000%

1,433

Eric Leung

04/18/2015 06:07AM

Re: Mysql is consuming xtremely high CPU above 1000%

1,729

Rick James

04/19/2015 02:19PM

Client to server connection

1,419

Dan Toškan

04/14/2015 12:40PM

Re: Client to server connection

593

Peter Brawley

04/14/2015 11:18PM

Re: Client to server connection

573

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,395

Ola Arwidsson

03/26/2015 06:40AM

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

846

Peter Brawley

03/26/2015 10:45AM

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

733

Ola Arwidsson

03/30/2015 01:22AM

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

806

Ola Arwidsson

03/30/2015 03:27AM

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

663

Peter Brawley

03/30/2015 11:16AM

system table space vs file per table space

1,368

jongse park

03/27/2015 12:35AM

Re: system table space vs file per table space

674

Rick James

03/28/2015 03:36PM

Slow COUNT + GROUP BY

1,741

Refael Dakar

03/20/2015 07:00AM

Re: Slow COUNT + GROUP BY

783

Jeremy Smyth

03/20/2015 07:55AM

Re: Slow COUNT + GROUP BY

757

Refael Dakar

03/20/2015 08:00AM

Re: Slow COUNT + GROUP BY

739

Rick James

03/22/2015 04:11PM

Re: Slow COUNT + GROUP BY

718

Refael Dakar

03/23/2015 12:46AM

Re: Slow COUNT + GROUP BY

1,098

Øystein Grøvlen

03/23/2015 02:45AM

Re: Slow COUNT + GROUP BY

998

Matan K

03/23/2015 04:30AM

Re: Slow COUNT + GROUP BY

899

Øystein Grøvlen

03/23/2015 06:04AM

Re: Slow COUNT + GROUP BY

765

Matan K

03/23/2015 08:13AM

Re: Slow COUNT + GROUP BY

774

Øystein Grøvlen

03/24/2015 02:02AM

Re: Slow COUNT + GROUP BY

764

Matan K

03/24/2015 02:51AM

Re: Slow COUNT + GROUP BY

785

Øystein Grøvlen

03/24/2015 03:37AM

Query Optimization Needed

1,672

Devrishi Shandilya

02/11/2015 01:31AM

Re: Query Optimization Needed

753

Peter Brawley

02/11/2015 12:42PM

Re: Query Optimization Needed

855

Devrishi Shandilya

02/12/2015 03:51AM

Re: Query Optimization Needed

787

Peter Brawley

02/12/2015 01:24PM

Re: Query Optimization Needed

754

Devrishi Shandilya

02/13/2015 06:53AM

Re: Query Optimization Needed

687

Peter Brawley

02/13/2015 07:36AM

Re: Query Optimization Needed

709

Rick James

02/14/2015 01:04AM

Re: Query Optimization Needed

784

Devrishi Shandilya

02/15/2015 11:07PM

Re: Query Optimization Needed

800

Rick James

02/16/2015 12:15AM

Re: Query Optimization Needed

661

Peter Brawley

03/13/2015 11:15AM

Exceedingly slow create table performance

4,093

Ronald Van Iwaarden

03/06/2015 10:51AM

Re: Exceedingly slow create table performance

1,653

Rick James

03/07/2015 11:03AM

Re: Exceedingly slow create table performance

1,717

Ronald Van Iwaarden

03/09/2015 10:10AM

Left join optimization- query is very slow

7,559

Devrishi Shandilya

03/05/2015 05:23AM

Re: Left join optimization- query is very slow

2,197

Øystein Grøvlen

03/05/2015 09:12AM

Re: Left join optimization- query is very slow

2,255

Rick James

03/06/2015 06:48PM

Re: Left join optimization- query is very slow

1,538

Devrishi Shandilya

03/08/2015 11:32PM

COUNT with GROUP BY, JOIN and SUBQUERY very slow

2,790

Anderson Scouto da Silva Dan

02/28/2015 03:15AM

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

2,431

Øystein Grøvlen

03/02/2015 02:05AM

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

1,033

Øystein Grøvlen

03/02/2015 02:13AM

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

1,592

Anderson Scouto da Silva Dan

03/02/2015 02:28PM

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

1,050

Øystein Grøvlen

03/03/2015 01:27AM

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

1,187

Rick James

03/02/2015 06:13PM

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

922

Anderson Scouto da Silva Dan

03/02/2015 07:14PM

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

966

Anderson Scouto da Silva Dan

03/02/2015 07:20PM

Slow performance when using LIMIT 1000

1,696

Christian Esborg

02/25/2015 07:43AM

Re: Slow performance when using LIMIT 1000

725

Øystein Grøvlen

02/26/2015 04:13AM

Re: Slow performance when using LIMIT 1000

894

Rick James

02/27/2015 01:09AM

Analyse-Optimize and tablecache

1,694

Samuel Mutel

02/16/2015 03:49AM

Re: Analyse-Optimize and tablecache

742

Rick James

02/18/2015 03:54PM

Temp tables on Disk issue

1,409

Devrishi Shandilya

02/15/2015 11:17PM

Re: Temp tables on Disk issue

638

Rick James

02/16/2015 12:19AM

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

1,951

Pól Ua Laoínecháin

02/04/2015 08:21PM

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

843

Øystein Grøvlen

02/05/2015 01:51AM

Mysql performance between installation

1,774

Patrick MORAND

01/16/2015 07:32AM

Re: Mysql performance between installation

764

Rick James

01/17/2015 11:50AM

Re: Mysql performance between installation

829

Patrick MORAND

01/19/2015 08:26AM

Re: Mysql performance between installation

908

Rick James

01/20/2015 04:57PM

Re: Mysql performance between installation

836

Patrick MORAND

01/21/2015 02:30AM

RAM consideration/ IO usage

1,600

Jawahar muthukrishnan

01/13/2015 12:39PM

Re: RAM consideration/ IO usage

980

Rick James

01/14/2015 01:47PM

Re: RAM consideration/ IO usage

877

Jawahar muthukrishnan

01/15/2015 03:07PM

Re: RAM consideration/ IO usage

1,177

Rick James

01/16/2015 02:14PM

Unusually high cpu usage

2,967

Fabrizio Bartolomucci

01/11/2015 02:55PM

Re: Unusually high cpu usage

1,192

Rick James

01/12/2015 09:49PM

Re: Unusually high cpu usage

1,048

Fabrizio Bartolomucci

01/13/2015 09:32AM

Re: Unusually high cpu usage

1,376

Fabrizio Bartolomucci

01/13/2015 11:47AM

Re: Unusually high cpu usage

1,065

Rick James

01/13/2015 04:21PM

How To Use More Resources

1,765

Luis Cavazos

01/07/2015 11:12AM

Re: How To Use More Resources

754

Rick James

01/07/2015 07:14PM

Re: How To Use More Resources

1,142

Luis Cavazos

01/07/2015 09:14PM

Re: How To Use More Resources

1,097

Rick James

01/07/2015 11:21PM

Re: How To Use More Resources

717

Rick James

01/07/2015 11:42PM

Re: How To Use More Resources

791

Luis Cavazos

01/08/2015 05:48PM

Re: How To Use More Resources

854

Rick James

01/09/2015 02:39PM

How to use performance_schema.tables

1,636

jongse park

01/07/2015 02:05AM

Re: How to use performance_schema.tables

819

Øystein Grøvlen

01/07/2015 03:41AM

Re: How to use performance_schema.tables

916

Rick James

01/07/2015 05:02PM

lockfree approach to creating a single unique row without unique index

1,660

Andrew Nuss

01/03/2015 03:43PM

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

737

Rick James

01/05/2015 12:17AM

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

729

Rick James

01/05/2015 11:04AM

COUNT_STAR, SUM_TIMER_WAIT

2,037

jongse park

12/26/2014 02:08AM

Re: COUNT_STAR, SUM_TIMER_WAIT

1,074

Øystein Grøvlen

01/05/2015 04:27AM

what does table_open_cache_overflow=0 means?

2,089

jongse park

12/29/2014 07:42PM

Re: what does table_open_cache_overflow=0 means?

3,527

Rick James

12/31/2014 04:59PM

innodb_buffer_pool_read_requests global status wraparound

1,943

Wilson Hauck

11/18/2014 10:18AM

Re: innodb_buffer_pool_read_requests global status wraparound

965

Rick James

11/18/2014 10:40PM

Re: innodb_buffer_pool_read_requests global status wraparound

855

Wilson Hauck

11/19/2014 07:31AM

Re: innodb_buffer_pool_read_requests global status wraparound

857

Wilson Hauck

11/19/2014 10:19AM

Re: innodb_buffer_pool_read_requests global status wraparound

918

Rick James

12/22/2014 01:37AM

Re: innodb_buffer_pool_read_requests global status wraparound

787

Wilson Hauck

11/19/2014 03:00PM

Re: innodb_buffer_pool_read_requests global status wraparound

801

Wilson Hauck

12/20/2014 12:15PM

25.000+ rows - MySQL SELECT consecutive numbers performance issue

2,039

Daniel Negoita

12/12/2014 08:55AM

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

1,561

Daniel Negoita

12/12/2014 09:18AM

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

1,084

Peter Brawley

12/12/2014 12:18PM

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

1,305

Rick James

12/14/2014 01:42PM

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

1,020

Peter Brawley

12/14/2014 04:19PM

innodb_checksum_algorithm stic_crc32 is slow response

2,325

Ankur Kaushik

12/08/2014 04:29AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

1,079

Ankur Kaushik

12/08/2014 04:32AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

1,202

Øystein Grøvlen

12/08/2014 05:45AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

980

Rick James

12/08/2014 10:52AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

956

Ankur Kaushik

12/09/2014 06:44AM

Re: innodb_checksum_algorithm stic_crc32 is slow response

987

Rick James

12/09/2014 03:34PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

954

Ankur Kaushik

12/13/2014 08:47PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

921

Ankur Kaushik

12/13/2014 08:49PM

Re: innodb_checksum_algorithm stic_crc32 is slow response

979

Rick James

12/14/2014 11:51AM

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

2,341

Daniel Chiaramello

12/04/2014 05:05AM

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

1,318

Rick James

12/06/2014 02:40PM

Write Operations very slow in InnoDB engine when compared to MyIsam

1,680

MURALI NARAYANASWAMY

11/28/2014 07:07AM

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

706

Rick James

11/28/2014 06:59PM

Cardinality Problem

1,600

Katja Kahl

11/26/2014 06:53AM

Re: Cardinality Problem

758

Peter Brawley

11/26/2014 12:03PM

Re: Cardinality Problem

713

Katja Kahl

11/27/2014 03:08AM

Re: Cardinality Problem

679

Rick James

11/28/2014 06:56PM

Pages:

« 1

...

6 7 8 9 10

...

77 »

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.