MySQL :: MySQL Forums :: Performance

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Pages:

« 1 2 3 4 5

...

75 »

Subject

Views

Written By

Posted

text vs varchar

1,165

hua kai

04/28/2016 08:36AM

Re: text vs varchar

736

Øystein Grøvlen

04/29/2016 12:41AM

Re: text vs varchar

659

Rick James

04/30/2016 11:51PM

Re: text vs varchar

640

Øystein Grøvlen

05/02/2016 04:37AM

Re: text vs varchar

607

hua kai

05/02/2016 09:14PM

Re: text vs varchar

598

Øystein Grøvlen

05/03/2016 02:19AM

Re: text vs varchar

1,215

hua kai

05/03/2016 04:12AM

Re: text vs varchar

597

hua kai

05/02/2016 08:02PM

Re: text vs varchar

753

Øystein Grøvlen

05/03/2016 02:25AM

Query with 2 x subquery

981

Jes Ramsing

04/29/2016 06:44AM

Re: Query with 2 x subquery

564

Øystein Grøvlen

04/29/2016 08:01AM

Re: Query with 2 x subquery

533

Jes Ramsing

05/01/2016 11:57PM

Re: Query with 2 x subquery

527

Øystein Grøvlen

05/02/2016 03:45AM

Re: Query with 2 x subquery

521

Jes Ramsing

05/02/2016 05:32AM

Re: Query with 2 x subquery

526

Rick James

05/01/2016 11:58PM

Re: Query with 2 x subquery

575

Jes Ramsing

05/02/2016 02:16AM

Slow Query, Optimization Advice Needed

1,042

04/26/2016 09:30AM

Re: Slow Query, Optimization Advice Needed

534

Øystein Grøvlen

04/27/2016 01:02AM

Re: Slow Query, Optimization Advice Needed

622

04/27/2016 07:20PM

Re: Slow Query, Optimization Advice Needed

488

Peter Brawley

04/27/2016 11:28PM

Re: Slow Query, Optimization Advice Needed

538

Øystein Grøvlen

04/28/2016 01:25AM

Re: Slow Query, Optimization Advice Needed

522

Rick James

05/01/2016 11:47PM

Re: Slow Query, Optimization Advice Needed

536

Øystein Grøvlen

05/02/2016 01:28AM

Re: Slow Query, Optimization Advice Needed

565

Øystein Grøvlen

04/28/2016 01:12AM

Reg table design and query performances

969

Devrishi Shandilya

04/26/2016 03:02AM

Re: Reg table design and query performances

532

Øystein Grøvlen

04/26/2016 06:02AM

Re: Reg table design and query performances

643

Devrishi Shandilya

04/26/2016 06:16AM

Re: Reg table design and query performances

541

Øystein Grøvlen

04/26/2016 06:35AM

Re: Reg table design and query performances

507

Devrishi Shandilya

04/26/2016 06:50AM

Re: Reg table design and query performances

512

Øystein Grøvlen

04/26/2016 07:04AM

Re: Reg table design and query performances

483

Rick James

04/30/2016 11:46PM

Re: Reg table design and query performances

477

Øystein Grøvlen

05/02/2016 01:00AM

Memory benefits of huge pages

2,613

Olga Turetskaya

04/30/2016 11:21AM

Re: Memory benefits of huge pages

1,265

Rick James

05/01/2016 02:36PM

Configuration review requested

1,336

Jens Meier

04/13/2016 11:55AM

Re: Configuration review requested

561

Rick James

04/14/2016 01:39PM

block_ops_in and block_ops_out meaning

2,145

hua kai

03/18/2016 02:33AM

Re: block_ops_in and block_ops_out meaning

1,009

Rick James

03/21/2016 11:34PM

Re: block_ops_in and block_ops_out meaning

1,023

Peter Brawley

03/22/2016 02:03AM

Re: block_ops_in and block_ops_out meaning

1,004

hua kai

03/25/2016 12:30AM

Re: block_ops_in and block_ops_out meaning

948

hua kai

04/14/2016 12:52AM

order by primary key slowly

1,277

varky chan

04/05/2016 10:42PM

Re: order by primary key slowly

563

Øystein Grøvlen

04/06/2016 04:35AM

Re: order by primary key slowly

585

varky chan

04/06/2016 10:15AM

Re: order by primary key slowly

609

Peter Brawley

04/06/2016 11:23AM

Re: order by primary key slowly

665

varky chan

04/06/2016 08:11PM

Re: order by primary key slowly

567

Peter Brawley

04/06/2016 10:35PM

Re: order by primary key slowly

591

varky chan

04/07/2016 12:34AM

Re: order by primary key slowly

688

Øystein Grøvlen

04/07/2016 07:21AM

Re: order by primary key slowly

619

Peter Brawley

04/07/2016 10:20AM

Re: order by primary key slowly

585

varky chan

04/07/2016 11:26PM

Re: order by primary key slowly

602

Rick James

04/12/2016 07:42PM

Re: order by primary key slowly

571

Peter Brawley

04/06/2016 08:57AM

Re: order by primary key slowly

559

varky chan

04/06/2016 10:17AM

[INNODB] why there are many "waiting for table level lock"?

1,052

HANWEN YIN

04/11/2016 12:08AM

Re: [INNODB] why there are many "waiting for table level lock"?

692

Rick James

04/12/2016 07:27PM

Improve performance when altering huge tables

1,019

Davide Cicuta

04/04/2016 07:24AM

Re: Improve performance when altering huge tables

591

Rick James

04/05/2016 02:59PM

MySql 5.7 - Poor Performance PURGE BINARY LOGS

1,530

Davy Campano

03/23/2016 08:08PM

Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS

646

Rick James

03/26/2016 11:58PM

Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS

654

Davy Campano

03/29/2016 09:44AM

where the snapshot for select in transaction stored

930

hua kai

03/21/2016 03:03AM

Re: where the snapshot for select in transaction stored

495

Rick James

03/21/2016 11:21PM

Difference execution plans for same query

1,206

Devrishi Shandilya

02/25/2016 12:05AM

Re: Difference execution plans for same query

572

Peter Brawley

02/25/2016 01:51AM

Re: Difference execution plans for same query

617

Øystein Grøvlen

02/25/2016 03:51AM

Re: Difference execution plans for same query

615

Rick James

03/05/2016 01:19AM

Slow join performance

1,142

Ra Nala

11/27/2015 04:55AM

Re: Slow join performance

652

Rick James

11/28/2015 03:02PM

Re: Slow join performance

533

Ra Nala

02/25/2016 06:22AM

which is best for JOIN approach

1,125

Ra Nala

11/24/2015 09:39AM

Re: which is best for JOIN approach

677

Øystein Grøvlen

11/25/2015 02:14AM

Re: which is best for JOIN approach

688

Ra Nala

11/25/2015 02:42AM

Re: which is best for JOIN approach

659

Rick James

11/29/2015 11:53AM

Re: which is best for JOIN approach

583

Ra Nala

02/19/2016 05:28AM

Re: which is best for JOIN approach

554

Peter Brawley

02/21/2016 04:56PM

Re: which is best for JOIN approach

543

Ra Nala

02/19/2016 05:31AM

Re: which is best for JOIN approach

529

Rick James

02/21/2016 01:40PM

Re: which is best for JOIN approach

567

Rick James

02/21/2016 01:43PM

Re: which is best for JOIN approach

585

Ra Nala

02/25/2016 05:50AM

Why is wrong index being selected

877

Steve Bell

02/23/2016 01:54PM

Re: Why is wrong index being selected

466

Rick James

02/23/2016 11:39PM

Re: Why is wrong index being selected

568

Øystein Grøvlen

02/24/2016 03:22AM

Re: Why is wrong index being selected

483

Steve Bell

02/25/2016 02:47AM

Distinct or Group by which is faster

1,120

Ra Nala

02/22/2016 08:50AM

Re: Distinct or Group by which is faster

536

Peter Brawley

02/22/2016 12:33PM

Re: Distinct or Group by which is faster

509

Chandan Kumar

02/23/2016 12:51PM

MySQL server is not disk bound, how do I make it faster?

928

02/21/2016 09:35PM

Re: MySQL server is not disk bound, how do I make it faster?

442

Peter Brawley

02/22/2016 12:38PM

Re: MySQL server is not disk bound, how do I make it faster?

480

Rick James

02/22/2016 06:18PM

mysql text datatype SELECT query slow even with tmp dir on tmpfs

939

02/22/2016 08:36AM

Re: mysql text datatype SELECT query slow even with tmp dir on tmpfs

436

Peter Brawley

02/22/2016 12:35PM

How can I improve this table and query

1,112

Adam Copley

02/17/2016 04:49AM

Re: How can I improve this table and query

541

Øystein Grøvlen

02/17/2016 06:07AM

Re: How can I improve this table and query

573

Adam Copley

02/17/2016 08:25AM

Re: How can I improve this table and query

441

Adam Copley

02/17/2016 08:26AM

Re: How can I improve this table and query

515

Øystein Grøvlen

02/17/2016 08:51AM

Re: How can I improve this table and query

689

Adam Copley

02/17/2016 09:03AM

Re: How can I improve this table and query

450

Rick James

02/21/2016 11:14PM

Does prefixing field names with their table name improve query speed?

873

Guillaume TRUCHOT

02/18/2016 04:02PM

Re: Does prefixing field names with their table name improve query speed?

470

Peter Brawley

02/18/2016 05:21PM

Re: Does prefixing field names with their table name improve query speed?

498

Rick James

02/21/2016 07:19PM

slow response when where clause has a field from 2nd table in a left join

875

Ravi Malghan

02/12/2016 12:51PM

Re: slow response when where clause has a field from 2nd table in a left join

554

Øystein Grøvlen

02/15/2016 02:10AM

Re: slow response when where clause has a field from 2nd table in a left join

426

Rick James

02/15/2016 04:17PM

Re: slow response when where clause has a field from 2nd table in a left join

420

Ravi Malghan

02/19/2016 10:18AM

max_allowed_packet error

1,180

Ra Nala

02/02/2016 05:12AM

Re: max_allowed_packet error

453

Rick James

02/06/2016 07:26PM

Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)

1,088

Bill Joyce

12/06/2015 11:41PM

Re: Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)

557

Mayank Prasad

12/10/2015 03:53AM

Re: Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)

640

Bill Joyce

02/04/2016 04:15PM

query performance optimization

1,489

Devrishi Shandilya

01/18/2016 04:49AM

Re: query performance optimization

542

Øystein Grøvlen

01/19/2016 02:30AM

Re: query performance optimization

530

Devrishi Shandilya

01/19/2016 02:50AM

Re: query performance optimization

557

Øystein Grøvlen

01/19/2016 06:24AM

Re: query performance optimization

556

Rick James

01/22/2016 06:29PM

Re: query performance optimization

489

Øystein Grøvlen

01/29/2016 04:37AM

Re: query performance optimization

890

Devrishi Shandilya

01/22/2016 06:18AM

Re: query performance optimization

472

Øystein Grøvlen

01/27/2016 06:56AM

Re: query performance optimization

517

Peter Brawley

01/22/2016 01:08PM

Re: query performance optimization

525

Peter Brawley

01/22/2016 11:10PM

Slow performance on join query using indexes

1,324

Amit Kapoor

01/21/2016 02:36PM

Re: Slow performance on join query using indexes

724

Øystein Grøvlen

01/22/2016 03:02AM

Re: Slow performance on join query using indexes

542

Rick James

01/23/2016 07:43PM

high cpu on request with JOIN

1,045

Gérard Moisset

01/15/2016 03:49AM

Re: high cpu on request with JOIN

487

Øystein Grøvlen

01/15/2016 05:43AM

Lock wait timeout exceeded; try restarting transaction

9,831

Ra Nala

01/07/2016 05:28AM

Re: Lock wait timeout exceeded; try restarting transaction

2,352

Rick James

01/07/2016 10:47PM

Re: Lock wait timeout exceeded; try restarting transaction

2,014

Ra Nala

01/08/2016 12:45AM

Re: Lock wait timeout exceeded; try restarting transaction

1,569

Ra Nala

01/08/2016 06:23AM

Re: Lock wait timeout exceeded; try restarting transaction

1,599

Rick James

01/09/2016 11:52PM

1 blob table vs multiple blob tables

994

charles candy

01/08/2016 01:03AM

Re: 1 blob table vs multiple blob tables

446

01/08/2016 02:26AM

Thread State - Query End

2,159

Simon Green

01/04/2016 11:50AM

Re: Thread State - Query End

1,134

Øystein Grøvlen

01/05/2016 03:09AM

Re: Thread State - Query End

792

Øystein Grøvlen

01/06/2016 02:28AM

thread_cache_size: Need suggestion on this paramateer

853

Gnanasekar A.

12/26/2015 10:49AM

Re: thread_cache_size: Need suggestion on this paramateer

463

Rick James

12/27/2015 10:17AM

query hangs after migration from mysql 5.5 to mysql 5.6

1,083

walter verdelocco

12/19/2015 12:00PM

Re: query hangs after migration from mysql 5.5 to mysql 5.6

716

walter verdelocco

12/19/2015 01:21PM

Re: query hangs after migration from mysql 5.5 to mysql 5.6

480

Rick James

12/20/2015 07:31PM

Re: query hangs after migration from mysql 5.5 to mysql 5.6

516

walter verdelocco

12/21/2015 06:38AM

Re: query hangs after migration from mysql 5.5 to mysql 5.6

465

Øystein Grøvlen

12/21/2015 03:41AM

Re: query hangs after migration from mysql 5.5 to mysql 5.6

468

walter verdelocco

12/21/2015 06:40AM

Re: query hangs after migration from mysql 5.5 to mysql 5.6

502

Øystein Grøvlen

12/21/2015 07:22AM

Re: query hangs after migration from mysql 5.5 to mysql 5.6

464

walter verdelocco

12/22/2015 01:57AM

how to find out all sql and table of running transaction

1,051

elison chen

12/17/2015 01:30AM

Re: how to find out all sql and table of running transaction

478

Øystein Grøvlen

12/17/2015 03:08AM

show open tables in_use is high

1,255

elison chen

12/15/2015 07:23PM

Re: show open tables in_use is high

522

Rick James

12/16/2015 08:08PM

Slow query

1,112

Gerry Whitmarsh

12/11/2015 01:00PM

Re: Slow query

544

Peter Brawley

12/11/2015 05:00PM

Re: Slow query

515

Rick James

12/11/2015 06:56PM

Re: Slow query (solved)

463

Gerry Whitmarsh

12/12/2015 07:34AM

Re: Slow query

489

Øystein Grøvlen

12/14/2015 02:34AM

Re: Slow query

430

Gerry Whitmarsh

12/15/2015 08:48AM

Re: Slow query

500

Rick James

12/15/2015 10:57AM

Re: Slow query

520

Øystein Grøvlen

12/16/2015 02:33AM

query with bad performance after migration to mysql 5.6

1,378

walter verdelocco

12/04/2015 05:35AM

Re: query with bad performance after migration to mysql 5.6

657

Peter Brawley

12/05/2015 01:54PM

Re: query with bad performance after migration to mysql 5.6

541

Rick James

12/07/2015 01:05AM

Re: query with bad performance after migration to mysql 5.6

684

Øystein Grøvlen

12/09/2015 03:22AM

Re: query with bad performance after migration to mysql 5.6

724

walter verdelocco

12/09/2015 03:38AM

Re: query with bad performance after migration to mysql 5.6

520

Øystein Grøvlen

12/09/2015 04:21AM

Re: query with bad performance after migration to mysql 5.6

708

walter verdelocco

12/09/2015 06:31AM

Re: query with bad performance after migration to mysql 5.6

609

Øystein Grøvlen

12/09/2015 09:30AM

Re: query with bad performance after migration to mysql 5.6

581

walter verdelocco

12/09/2015 09:49AM

Re: query with bad performance after migration to mysql 5.6

537

walter verdelocco

12/09/2015 09:59AM

Re: query with bad performance after migration to mysql 5.6

646

Øystein Grøvlen

12/10/2015 04:37AM

Re: query with bad performance after migration to mysql 5.6

573

walter verdelocco

12/10/2015 07:39AM

Re: query with bad performance after migration to mysql 5.6

695

walter verdelocco

12/10/2015 08:09AM

Re: query with bad performance after migration to mysql 5.6

789

walter verdelocco

12/09/2015 03:44AM

Another Using temporary; Using filesort performance problem

1,133

Drew Tennenbaum

12/07/2015 06:37PM

Re: Another Using temporary; Using filesort performance problem

681

Drew Tennenbaum

12/07/2015 07:39PM

Re: Another Using temporary; Using filesort performance problem

556

Rick James

12/08/2015 08:52PM

Re: Another Using temporary; Using filesort performance problem

744

Drew Tanner

12/09/2015 10:31AM

Chinese data not appraing

995

Ra Nala

11/25/2015 04:42AM

Re: Chinese data not appraing

503

Rick James

11/29/2015 11:25AM

Re: Chinese data not appraing

538

Ra Nala

11/30/2015 01:24AM

Re: Chinese data not appraing

558

Rick James

12/01/2015 06:14PM

Re: Chinese data not appraing

545

Ra Nala

12/02/2015 01:12AM

Re: Chinese data not appraing

513

Rick James

12/07/2015 01:22AM

Re: Chinese data not appraing

521

Ra Nala

12/07/2015 10:24AM

Re: Chinese data not appraing

445

Rick James

12/08/2015 08:58PM

Re: Chinese data not appraing

535

Ra Nala

12/09/2015 01:04AM

Slow mysql query, copying to tmp table, using filesort

1,487

Aaron Bains

12/07/2015 04:50AM

Re: Slow mysql query, copying to tmp table, using filesort

740

Rick James

12/08/2015 08:59PM

Re: Slow mysql query, copying to tmp table, using filesort

1,039

Peter Brawley

12/08/2015 10:48PM

drop and recreate index in mysql DB

1,053

Ra Nala

11/25/2015 05:48AM

Re: drop and recreate index in mysql DB

666

Rick James

11/26/2015 02:31PM

Re: drop and recreate index in mysql DB

567

Ra Nala

11/27/2015 12:33AM

Re: drop and recreate index in mysql DB

873

Rick James

11/29/2015 11:38AM

Re: drop and recreate index in mysql DB

771

Ra Nala

11/30/2015 01:34AM

Single host configuration suggest

1,021

Yury Tsaregorodtsev

11/08/2015 01:50PM

Re: Single host configuration suggest

480

Øystein Grøvlen

11/17/2015 06:05AM

Re: Single host configuration suggest

406

Rick James

11/29/2015 12:20PM

Suddenly mysql server performance degraded

1,109

Devrishi Shandilya

11/05/2015 12:26AM

Re: Suddenly mysql server performance degraded

483

Peter Brawley

11/05/2015 11:41PM

Re: Suddenly mysql server performance degraded

666

Rick James

11/26/2015 10:01PM

Query optimization needed

1,199

Devrishi Shandilya

11/05/2015 01:42AM

Re: Query optimization needed

435

Peter Brawley

11/05/2015 11:40PM

Re: Query optimization needed

487

Devrishi Shandilya

11/06/2015 11:25PM

Re: Query optimization needed

521

Peter Brawley

11/08/2015 04:32PM

Re: Query optimization needed

469

Øystein Grøvlen

11/17/2015 05:43AM

Re: Query optimization needed

471

Rick James

11/26/2015 09:21PM

Foreman query optimization

1,156

Kyle Flavin

11/05/2015 04:15PM

Re: Foreman query optimization

496

Peter Brawley

11/05/2015 05:42PM

Re: Foreman query optimization

508

Kyle Flavin

11/05/2015 06:54PM

Re: Foreman query optimization

450

Peter Brawley

11/05/2015 11:19PM

Re: Foreman query optimization

481

Kyle Flavin

11/06/2015 11:58AM

Re: Foreman query optimization

427

Peter Brawley

11/06/2015 12:35PM

Re: Foreman query optimization

448

Kyle Flavin

11/06/2015 06:44PM

Re: Foreman query optimization

491

Rick James

11/26/2015 08:56PM

MySQL read/Write very slow in a table because of long blob columns

964

Mahesh Kakara

11/23/2015 11:31PM

Re: MySQL read/Write very slow in a table because of long blob columns

644

Øystein Grøvlen

11/25/2015 02:04AM

Re: MySQL read/Write very slow in a table because of long blob columns

562

Rick James

11/26/2015 02:49PM

Slow query on tmp table

789

Eric Colson

11/19/2015 09:02AM

Re: Slow query on tmp table

352

Peter Brawley

11/19/2015 12:08PM

Re: Slow query on tmp table

455

Rick James

11/26/2015 02:44PM

Slow Join Performance

919

Dereck E

10/06/2015 08:45AM

Re: Slow Join Performance

474

Rick James

10/06/2015 02:38PM

Re: Slow Join Performance

515

Dereck E

10/06/2015 03:42PM

Re: Slow Join Performance

482

Ra Nala

11/14/2015 10:24AM

Re: Slow Join Performance

377

Rick James

11/26/2015 02:39PM

This topic has been moved.: NOLOCK for multiple tables

32

Ra Nala

11/18/2015 03:51PM

distinct clause issue for 600000 records

950

11/10/2015 08:57AM

Re: distinct clause issue for 600000 records

530

Peter Brawley

11/11/2015 12:33PM

Re: distinct clause issue for 600000 records

424

Ra Nala

11/12/2015 12:49AM

Re: distinct clause issue for 600000 records

536

Ra Nala

11/12/2015 03:20AM

Re: distinct clause issue for 600000 records

486

Peter Brawley

11/12/2015 07:24PM

Re: distinct clause issue for 600000 records

497

Øystein Grøvlen

11/12/2015 07:08AM

Re: distinct clause issue for 600000 records

490

Ra Nala

11/12/2015 07:18AM

Re: distinct clause issue for 600000 records

492

Øystein Grøvlen

11/12/2015 07:43AM

Re: distinct clause issue for 600000 records

500

Ra Nala

11/13/2015 12:37AM

Re: distinct clause issue for 600000 records

471

Ra Nala

11/13/2015 12:45AM

Re: distinct clause issue for 600000 records

423

Øystein Grøvlen

11/13/2015 02:42AM

Re: distinct clause issue for 600000 records

556

Ra Nala

11/13/2015 05:56AM

Re: distinct clause issue for 600000 records

516

Øystein Grøvlen

11/13/2015 06:38AM

Re: distinct clause issue for 600000 records

489

Ra Nala

11/13/2015 07:15AM

Re: distinct clause issue for 600000 records

582

Øystein Grøvlen

11/13/2015 08:11AM

Re: distinct clause issue for 600000 records

503

Ra Nala

11/13/2015 11:35AM

Re: distinct clause issue for 600000 records

578

Øystein Grøvlen

11/16/2015 03:04AM

Re: distinct clause issue for 600000 records

544

Ra Nala

11/16/2015 04:12AM

Re: distinct clause issue for 600000 records

458

Øystein Grøvlen

11/16/2015 05:54AM

Values not inserting into MySQL Database table

2,577

Shan Abdussalam

11/11/2015 06:13AM

Re: Values not inserting into MySQL Database table

886

Peter Brawley

11/11/2015 12:28PM

Re: Values not inserting into MySQL Database table

527

Shan Abdussalam

11/11/2015 12:49PM

Re: Values not inserting into MySQL Database table

415

Øystein Grøvlen

11/12/2015 07:01AM

Re: Values not inserting into MySQL Database table

567

Shan Abdussalam

11/12/2015 07:06AM

Re: Values not inserting into MySQL Database table

488

Øystein Grøvlen

11/12/2015 07:11AM

Re: Values not inserting into MySQL Database table

551

Shan Abdussalam

11/12/2015 01:53PM

Re: Values not inserting into MySQL Database table

538

Peter Brawley

11/12/2015 07:21PM

Pages:

« 1 2 3 4 5

...

75 »

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.