MySQL Forums
Forum List  »  Performance
Announcements Last Post
•   MySQL Enterprise Monitor 8.0.3 has been released 10/17/2018 07:33PM
•   MySQL Enterprise Monitor 4.0.7 has been released 10/17/2018 07:32PM
•   MySQL Enterprise Monitor 3.4.10 has been released 10/17/2018 07:29PM

Subject
Views
Written By
Posted
1,078
11/24/2015 09:39AM
Re: which is best for JOIN approach  
649
11/25/2015 02:14AM
Re: which is best for JOIN approach  
640
11/25/2015 02:42AM
Re: which is best for JOIN approach  
616
11/29/2015 11:53AM
Re: which is best for JOIN approach  
530
02/19/2016 05:28AM
Re: which is best for JOIN approach  
512
02/21/2016 04:56PM
Re: which is best for JOIN approach  
493
02/19/2016 05:31AM
Re: which is best for JOIN approach  
488
02/21/2016 01:40PM
Re: which is best for JOIN approach  
522
02/21/2016 01:43PM
Re: which is best for JOIN approach  
532
02/25/2016 05:50AM
832
02/23/2016 01:54PM
Re: Why is wrong index being selected  
437
02/23/2016 11:39PM
Re: Why is wrong index being selected  
525
02/24/2016 03:22AM
Re: Why is wrong index being selected  
460
02/25/2016 02:47AM
1,046
02/22/2016 08:50AM
Re: Distinct or Group by which is faster  
495
02/22/2016 12:33PM
Re: Distinct or Group by which is faster  
475
02/23/2016 12:51PM
Re: MySQL server is not disk bound, how do I make it faster?  
423
02/22/2016 12:38PM
Re: MySQL server is not disk bound, how do I make it faster?  
449
02/22/2016 06:18PM
Re: mysql text datatype SELECT query slow even with tmp dir on tmpfs  
423
02/22/2016 12:35PM
Re: How can I improve this table and query  
480
02/17/2016 06:07AM
Re: How can I improve this table and query  
529
02/17/2016 08:25AM
Re: How can I improve this table and query  
418
02/17/2016 08:26AM
Re: How can I improve this table and query  
481
02/17/2016 08:51AM
Re: How can I improve this table and query  
621
02/17/2016 09:03AM
Re: How can I improve this table and query  
421
02/21/2016 11:14PM
Re: Does prefixing field names with their table name improve query speed?  
435
02/18/2016 05:21PM
Re: Does prefixing field names with their table name improve query speed?  
474
02/21/2016 07:19PM
Re: slow response when where clause has a field from 2nd table in a left join  
521
02/15/2016 02:10AM
Re: slow response when where clause has a field from 2nd table in a left join  
385
02/15/2016 04:17PM
Re: slow response when where clause has a field from 2nd table in a left join  
391
02/19/2016 10:18AM
1,096
02/02/2016 05:12AM
Re: max_allowed_packet error  
419
02/06/2016 07:26PM
Re: Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)  
502
12/10/2015 03:53AM
Re: Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)  
587
02/04/2016 04:15PM
Re: query performance optimization  
496
01/19/2016 02:30AM
Re: query performance optimization  
491
01/19/2016 02:50AM
Re: query performance optimization  
512
01/19/2016 06:24AM
Re: query performance optimization  
514
01/22/2016 06:29PM
Re: query performance optimization  
465
01/29/2016 04:37AM
Re: query performance optimization  
823
01/22/2016 06:18AM
Re: query performance optimization  
427
01/27/2016 06:56AM
Re: query performance optimization  
475
01/22/2016 01:08PM
Re: query performance optimization  
486
01/22/2016 11:10PM
Re: Slow performance on join query using indexes  
677
01/22/2016 03:02AM
Re: Slow performance on join query using indexes  
501
01/23/2016 07:43PM
Re: high cpu on request with JOIN  
462
01/15/2016 05:43AM
Re: Lock wait timeout exceeded; try restarting transaction  
2,240
01/07/2016 10:47PM
Re: Lock wait timeout exceeded; try restarting transaction  
1,896
01/08/2016 12:45AM
Re: Lock wait timeout exceeded; try restarting transaction  
1,490
01/08/2016 06:23AM
Re: Lock wait timeout exceeded; try restarting transaction  
1,505
01/09/2016 11:52PM
Re: 1 blob table vs multiple blob tables  
425
01/08/2016 02:26AM
1,827
01/04/2016 11:50AM
Re: Thread State - Query End  
998
01/05/2016 03:09AM
Re: Thread State - Query End  
682
01/06/2016 02:28AM
Re: thread_cache_size: Need suggestion on this paramateer  
434
12/27/2015 10:17AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
674
12/19/2015 01:21PM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
442
12/20/2015 07:31PM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
475
12/21/2015 06:38AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
428
12/21/2015 03:41AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
429
12/21/2015 06:40AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
454
12/21/2015 07:22AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
429
12/22/2015 01:57AM
Re: how to find out all sql and table of running transaction  
445
12/17/2015 03:08AM
1,180
12/15/2015 07:23PM
Re: show open tables in_use is high  
506
12/16/2015 08:08PM
1,022
12/11/2015 01:00PM
Re: Slow query  
497
12/11/2015 05:00PM
Re: Slow query  
466
12/11/2015 06:56PM
Re: Slow query (solved)  
434
12/12/2015 07:34AM
Re: Slow query  
452
12/14/2015 02:34AM
Re: Slow query  
398
12/15/2015 08:48AM
Re: Slow query  
470
12/15/2015 10:57AM
Re: Slow query  
483
12/16/2015 02:33AM
Re: query with bad performance after migration to mysql 5.6  
591
12/05/2015 01:54PM
Re: query with bad performance after migration to mysql 5.6  
492
12/07/2015 01:05AM
Re: query with bad performance after migration to mysql 5.6  
617
12/09/2015 03:22AM
Re: query with bad performance after migration to mysql 5.6  
655
12/09/2015 03:38AM
Re: query with bad performance after migration to mysql 5.6  
473
12/09/2015 04:21AM
Re: query with bad performance after migration to mysql 5.6  
630
12/09/2015 06:31AM
Re: query with bad performance after migration to mysql 5.6  
551
12/09/2015 09:30AM
Re: query with bad performance after migration to mysql 5.6  
529
12/09/2015 09:49AM
Re: query with bad performance after migration to mysql 5.6  
492
12/09/2015 09:59AM
Re: query with bad performance after migration to mysql 5.6  
565
12/10/2015 04:37AM
Re: query with bad performance after migration to mysql 5.6  
515
12/10/2015 07:39AM
Re: query with bad performance after migration to mysql 5.6  
615
12/10/2015 08:09AM
Re: query with bad performance after migration to mysql 5.6  
732
12/09/2015 03:44AM
Re: Another Using temporary; Using filesort performance problem  
638
12/07/2015 07:39PM
Re: Another Using temporary; Using filesort performance problem  
520
12/08/2015 08:52PM
Re: Another Using temporary; Using filesort performance problem  
707
12/09/2015 10:31AM
948
11/25/2015 04:42AM
Re: Chinese data not appraing  
465
11/29/2015 11:25AM
Re: Chinese data not appraing  
492
11/30/2015 01:24AM
Re: Chinese data not appraing  
520
12/01/2015 06:14PM
Re: Chinese data not appraing  
508
12/02/2015 01:12AM
Re: Chinese data not appraing  
460
12/07/2015 01:22AM
Re: Chinese data not appraing  
479
12/07/2015 10:24AM
Re: Chinese data not appraing  
420
12/08/2015 08:58PM
Re: Chinese data not appraing  
510
12/09/2015 01:04AM
Re: Slow mysql query, copying to tmp table, using filesort  
712
12/08/2015 08:59PM
Re: Slow mysql query, copying to tmp table, using filesort  
1,006
12/08/2015 10:48PM
959
11/25/2015 05:48AM
Re: drop and recreate index in mysql DB  
621
11/26/2015 02:31PM
Re: drop and recreate index in mysql DB  
517
11/27/2015 12:33AM
Re: drop and recreate index in mysql DB  
745
11/29/2015 11:38AM
Re: drop and recreate index in mysql DB  
716
11/30/2015 01:34AM
Re: Single host configuration suggest  
441
11/17/2015 06:05AM
Re: Single host configuration suggest  
378
11/29/2015 12:20PM
Re: Suddenly mysql server performance degraded  
447
11/05/2015 11:41PM
Re: Suddenly mysql server performance degraded  
617
11/26/2015 10:01PM
1,130
11/05/2015 01:42AM
Re: Query optimization needed  
399
11/05/2015 11:40PM
Re: Query optimization needed  
454
11/06/2015 11:25PM
Re: Query optimization needed  
489
11/08/2015 04:32PM
Re: Query optimization needed  
431
11/17/2015 05:43AM
Re: Query optimization needed  
434
11/26/2015 09:21PM
1,076
11/05/2015 04:15PM
Re: Foreman query optimization  
464
11/05/2015 05:42PM
Re: Foreman query optimization  
470
11/05/2015 06:54PM
Re: Foreman query optimization  
427
11/05/2015 11:19PM
Re: Foreman query optimization  
455
11/06/2015 11:58AM
Re: Foreman query optimization  
402
11/06/2015 12:35PM
Re: Foreman query optimization  
427
11/06/2015 06:44PM
Re: Foreman query optimization  
450
11/26/2015 08:56PM
Re: MySQL read/Write very slow in a table because of long blob columns  
578
11/25/2015 02:04AM
Re: MySQL read/Write very slow in a table because of long blob columns  
508
11/26/2015 02:49PM
751
11/19/2015 09:02AM
Re: Slow query on tmp table  
340
11/19/2015 12:08PM
Re: Slow query on tmp table  
419
11/26/2015 02:44PM
871
10/06/2015 08:45AM
Re: Slow Join Performance  
440
10/06/2015 02:38PM
Re: Slow Join Performance  
492
10/06/2015 03:42PM
Re: Slow Join Performance  
433
11/14/2015 10:24AM
Re: Slow Join Performance  
360
11/26/2015 02:39PM
This topic has been moved.:  NOLOCK for multiple tables  
32
11/18/2015 03:51PM
Re: distinct clause issue for 600000 records  
475
11/11/2015 12:33PM
Re: distinct clause issue for 600000 records  
390
11/12/2015 12:49AM
Re: distinct clause issue for 600000 records  
488
11/12/2015 03:20AM
Re: distinct clause issue for 600000 records  
446
11/12/2015 07:24PM
Re: distinct clause issue for 600000 records  
451
11/12/2015 07:08AM
Re: distinct clause issue for 600000 records  
438
11/12/2015 07:18AM
Re: distinct clause issue for 600000 records  
463
11/12/2015 07:43AM
Re: distinct clause issue for 600000 records  
462
11/13/2015 12:37AM
Re: distinct clause issue for 600000 records  
417
11/13/2015 12:45AM
Re: distinct clause issue for 600000 records  
385
11/13/2015 02:42AM
Re: distinct clause issue for 600000 records  
499
11/13/2015 05:56AM
Re: distinct clause issue for 600000 records  
471
11/13/2015 06:38AM
Re: distinct clause issue for 600000 records  
440
11/13/2015 07:15AM
Re: distinct clause issue for 600000 records  
545
11/13/2015 08:11AM
Re: distinct clause issue for 600000 records  
459
11/13/2015 11:35AM
Re: distinct clause issue for 600000 records  
524
11/16/2015 03:04AM
Re: distinct clause issue for 600000 records  
496
11/16/2015 04:12AM
Re: distinct clause issue for 600000 records  
411
11/16/2015 05:54AM
Re: Values not inserting into MySQL Database table  
760
11/11/2015 12:28PM
Re: Values not inserting into MySQL Database table  
457
11/11/2015 12:49PM
Re: Values not inserting into MySQL Database table  
375
11/12/2015 07:01AM
Re: Values not inserting into MySQL Database table  
515
11/12/2015 07:06AM
Re: Values not inserting into MySQL Database table  
421
11/12/2015 07:11AM
Re: Values not inserting into MySQL Database table  
496
11/12/2015 01:53PM
Re: Values not inserting into MySQL Database table  
486
11/12/2015 07:21PM
Re: does this "top-200" query do a table scan  
365
10/31/2015 12:22AM
Re: does this "top-200" query do a table scan  
455
10/31/2015 10:15AM
Re: does this "top-200" query do a table scan  
320
10/31/2015 01:03PM
Re: does this "top-200" query do a table scan  
408
10/31/2015 05:51PM
899
10/29/2015 12:47AM
Re: Mysterious Cache Problem  
366
10/29/2015 03:04AM
Re: Mysterious Cache Problem  
380
10/30/2015 06:16PM
Re: Optimisation of a query using Group by and a Join  
547
10/19/2015 02:10PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
588
10/03/2015 08:01PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
582
10/03/2015 08:34PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
514
10/05/2015 10:38AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
525
10/05/2015 10:41AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
504
10/05/2015 10:50AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
473
10/04/2015 08:28PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
492
10/05/2015 12:26PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
483
10/06/2015 11:00AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
945
10/06/2015 11:50PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
471
10/07/2015 08:12PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
526
10/08/2015 11:17PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
511
10/09/2015 10:34PM
Re: Too much time in Copy to Tmp Table  
607
10/02/2015 02:08PM
Re: Too much time in Copy to Tmp Table  
556
10/05/2015 02:36PM
Re: Too much time in Copy to Tmp Table  
515
10/05/2015 02:48PM
Re: Too much time in Copy to Tmp Table  
540
10/05/2015 02:55PM
Re: Too much time in Copy to Tmp Table  
592
10/06/2015 10:32PM
Re: Too much time in Copy to Tmp Table  
698
10/08/2015 07:21PM
Re: Index suggestion needed for performance improvement  
448
10/02/2015 09:14PM
Re: Index suggestion needed for performance improvement  
500
10/03/2015 12:14AM
Re: Index suggestion needed for performance improvement  
514
10/03/2015 12:40AM
Re: Index suggestion needed for performance improvement  
517
10/03/2015 02:10AM
Re: Index suggestion needed for performance improvement  
493
10/04/2015 01:15PM
Re: Index suggestion needed for performance improvement  
487
10/04/2015 09:18PM
Re: Index suggestion needed for performance improvement  
551
10/04/2015 01:22PM
Re: Utilize maximum system resources for better performance  
706
07/14/2015 01:58AM
Re: Utilize maximum system resources for better performance  
644
07/14/2015 02:12AM
Re: Utilize maximum system resources for better performance  
625
07/14/2015 11:30AM
Re: Utilize maximum system resources for better performance  
638
07/14/2015 11:57AM
Re: Utilize maximum system resources for better performance  
700
07/15/2015 08:36PM
Re: Utilize maximum system resources for better performance  
806
07/30/2015 07:22AM
Re: Utilize maximum system resources for better performance  
684
07/30/2015 07:26AM
Re: Utilize maximum system resources for better performance  
692
07/31/2015 10:20PM
Re: Utilize maximum system resources for better performance  
651
08/02/2015 01:27AM
Re: Utilize maximum system resources for better performance  
661
08/02/2015 11:10AM
Re: Utilize maximum system resources for better performance  
807
08/08/2015 01:27AM
Re: Utilize maximum system resources for better performance  
626
08/08/2015 11:49AM
Re: Utilize maximum system resources for better performance  
570
08/08/2015 01:01PM
Re: Utilize maximum system resources for better performance  
653
08/08/2015 03:43PM
Re: Utilize maximum system resources for better performance  
720
08/09/2015 12:40AM
Re: Utilize maximum system resources for better performance  
571
08/09/2015 07:33AM
Re: Utilize maximum system resources for better performance  
596
08/09/2015 03:53PM
Re: Utilize maximum system resources for better performance  
685
08/09/2015 08:04PM
Re: Utilize maximum system resources for better performance  
516
08/09/2015 11:17PM
Re: Utilize maximum system resources for better performance  
637
08/10/2015 12:00AM
Re: Utilize maximum system resources for better performance  
622
08/10/2015 08:36AM
Re: Utilize maximum system resources for better performance  
808
08/10/2015 11:00AM
Re: Utilize maximum system resources for better performance  
678
08/10/2015 11:03AM
Re: Utilize maximum system resources for better performance  
664
09/16/2015 11:39AM
Re: Utilize maximum system resources for better performance  
715
09/18/2015 09:54PM
Re: Utilize maximum system resources for better performance  
462
09/19/2015 01:18AM
Re: Utilize maximum system resources for better performance  
644
10/02/2015 08:50PM
Re: Utilize maximum system resources for better performance  
537
10/02/2015 09:09PM
Re: Utilize maximum system resources for better performance  
534
10/03/2015 04:46PM
Re: Utilize maximum system resources for better performance  
663
08/09/2015 01:07AM
Re: Utilize maximum system resources for better performance  
498
09/23/2015 09:58AM
Re: Hints on what to check for bad performance  
457
09/21/2015 10:01PM
Re: Hints on what to check for bad performance  
418
09/25/2015 07:55AM
Re: Hints on what to check for bad performance  
376
10/02/2015 09:59PM
Re: Memory/cache usage with innodb_flush_method values  
562
10/02/2015 09:41PM
979
08/21/2015 08:08AM
Re: Deleted Records and Optimize  
460
08/22/2015 11:13AM
Re: Deleted Records and Optimize  
421
09/08/2015 03:51PM
Re: Deleted Records and Optimize  
448
09/09/2015 06:42PM
Re: MYSql Query - #2013 - Lost connection to MySQL server during query  
488
08/27/2015 09:43PM
Re: Delete query not using index and cause deadlock  
1,156
08/21/2015 07:13AM
Re: Delete query not using index and cause deadlock  
921
08/22/2015 03:48PM
Re: Delete query not using index and cause deadlock  
872
08/24/2015 02:35AM
Re: Delete query not using index and cause deadlock  
812
08/24/2015 12:27PM
Re: Delete query not using index and cause deadlock  
697
08/25/2015 02:57AM
Re: Help for checking server configuration  
452
08/17/2015 10:56AM
Re: Help for checking server configuration  
587
08/19/2015 09:32AM
Re: Help for checking server configuration  
573
08/22/2015 02:59PM
Pages:
« 1 2 3 4 5
...
74 »

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.