MySQL Forums
Forum List  »  Performance
Announcements Last Post
•   MySQL Connector/NET 6.10.8 has been released 08/15/2018 12:29AM
•   MySQL Connector/ODBC 5.3.11 has been released 07/30/2018 01:00PM
•   MySQL Shell 8.0.12 for MySQL Server 8.0 and 5.7 has been released 07/27/2018 04:33PM
•   MySQL Cluster 7.3.22 has been released 07/27/2018 02:45PM
•   MySQL Connector/Node.js 8.0.12 has been released 07/27/2018 02:44PM

Subject
Views
Written By
Posted
Re: high cpu on request with JOIN  
451
01/15/2016 05:43AM
Re: Lock wait timeout exceeded; try restarting transaction  
2,174
01/07/2016 10:47PM
Re: Lock wait timeout exceeded; try restarting transaction  
1,826
01/08/2016 12:45AM
Re: Lock wait timeout exceeded; try restarting transaction  
1,444
01/08/2016 06:23AM
Re: Lock wait timeout exceeded; try restarting transaction  
1,452
01/09/2016 11:52PM
Re: 1 blob table vs multiple blob tables  
415
01/08/2016 02:26AM
1,688
01/04/2016 11:50AM
Re: Thread State - Query End  
932
01/05/2016 03:09AM
Re: Thread State - Query End  
631
01/06/2016 02:28AM
Re: thread_cache_size: Need suggestion on this paramateer  
417
12/27/2015 10:17AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
656
12/19/2015 01:21PM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
425
12/20/2015 07:31PM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
456
12/21/2015 06:38AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
415
12/21/2015 03:41AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
416
12/21/2015 06:40AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
439
12/21/2015 07:22AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
415
12/22/2015 01:57AM
Re: how to find out all sql and table of running transaction  
427
12/17/2015 03:08AM
1,140
12/15/2015 07:23PM
Re: show open tables in_use is high  
492
12/16/2015 08:08PM
993
12/11/2015 01:00PM
Re: Slow query  
477
12/11/2015 05:00PM
Re: Slow query  
448
12/11/2015 06:56PM
Re: Slow query (solved)  
425
12/12/2015 07:34AM
Re: Slow query  
436
12/14/2015 02:34AM
Re: Slow query  
390
12/15/2015 08:48AM
Re: Slow query  
455
12/15/2015 10:57AM
Re: Slow query  
464
12/16/2015 02:33AM
Re: query with bad performance after migration to mysql 5.6  
560
12/05/2015 01:54PM
Re: query with bad performance after migration to mysql 5.6  
468
12/07/2015 01:05AM
Re: query with bad performance after migration to mysql 5.6  
591
12/09/2015 03:22AM
Re: query with bad performance after migration to mysql 5.6  
631
12/09/2015 03:38AM
Re: query with bad performance after migration to mysql 5.6  
451
12/09/2015 04:21AM
Re: query with bad performance after migration to mysql 5.6  
596
12/09/2015 06:31AM
Re: query with bad performance after migration to mysql 5.6  
522
12/09/2015 09:30AM
Re: query with bad performance after migration to mysql 5.6  
508
12/09/2015 09:49AM
Re: query with bad performance after migration to mysql 5.6  
470
12/09/2015 09:59AM
Re: query with bad performance after migration to mysql 5.6  
539
12/10/2015 04:37AM
Re: query with bad performance after migration to mysql 5.6  
490
12/10/2015 07:39AM
Re: query with bad performance after migration to mysql 5.6  
585
12/10/2015 08:09AM
Re: query with bad performance after migration to mysql 5.6  
717
12/09/2015 03:44AM
Re: Another Using temporary; Using filesort performance problem  
624
12/07/2015 07:39PM
Re: Another Using temporary; Using filesort performance problem  
509
12/08/2015 08:52PM
Re: Another Using temporary; Using filesort performance problem  
692
12/09/2015 10:31AM
919
11/25/2015 04:42AM
Re: Chinese data not appraing  
447
11/29/2015 11:25AM
Re: Chinese data not appraing  
478
11/30/2015 01:24AM
Re: Chinese data not appraing  
509
12/01/2015 06:14PM
Re: Chinese data not appraing  
496
12/02/2015 01:12AM
Re: Chinese data not appraing  
444
12/07/2015 01:22AM
Re: Chinese data not appraing  
460
12/07/2015 10:24AM
Re: Chinese data not appraing  
412
12/08/2015 08:58PM
Re: Chinese data not appraing  
498
12/09/2015 01:04AM
Re: Slow mysql query, copying to tmp table, using filesort  
695
12/08/2015 08:59PM
Re: Slow mysql query, copying to tmp table, using filesort  
988
12/08/2015 10:48PM
930
11/25/2015 05:48AM
Re: drop and recreate index in mysql DB  
606
11/26/2015 02:31PM
Re: drop and recreate index in mysql DB  
495
11/27/2015 12:33AM
Re: drop and recreate index in mysql DB  
683
11/29/2015 11:38AM
Re: drop and recreate index in mysql DB  
688
11/30/2015 01:34AM
Re: Single host configuration suggest  
429
11/17/2015 06:05AM
Re: Single host configuration suggest  
371
11/29/2015 12:20PM
Re: Suddenly mysql server performance degraded  
432
11/05/2015 11:41PM
Re: Suddenly mysql server performance degraded  
591
11/26/2015 10:01PM
1,102
11/05/2015 01:42AM
Re: Query optimization needed  
383
11/05/2015 11:40PM
Re: Query optimization needed  
442
11/06/2015 11:25PM
Re: Query optimization needed  
473
11/08/2015 04:32PM
Re: Query optimization needed  
415
11/17/2015 05:43AM
Re: Query optimization needed  
417
11/26/2015 09:21PM
1,042
11/05/2015 04:15PM
Re: Foreman query optimization  
450
11/05/2015 05:42PM
Re: Foreman query optimization  
455
11/05/2015 06:54PM
Re: Foreman query optimization  
420
11/05/2015 11:19PM
Re: Foreman query optimization  
439
11/06/2015 11:58AM
Re: Foreman query optimization  
389
11/06/2015 12:35PM
Re: Foreman query optimization  
420
11/06/2015 06:44PM
Re: Foreman query optimization  
436
11/26/2015 08:56PM
Re: MySQL read/Write very slow in a table because of long blob columns  
550
11/25/2015 02:04AM
Re: MySQL read/Write very slow in a table because of long blob columns  
490
11/26/2015 02:49PM
737
11/19/2015 09:02AM
Re: Slow query on tmp table  
330
11/19/2015 12:08PM
Re: Slow query on tmp table  
408
11/26/2015 02:44PM
846
10/06/2015 08:45AM
Re: Slow Join Performance  
427
10/06/2015 02:38PM
Re: Slow Join Performance  
480
10/06/2015 03:42PM
Re: Slow Join Performance  
411
11/14/2015 10:24AM
Re: Slow Join Performance  
346
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  
456
11/11/2015 12:33PM
Re: distinct clause issue for 600000 records  
377
11/12/2015 12:49AM
Re: distinct clause issue for 600000 records  
476
11/12/2015 03:20AM
Re: distinct clause issue for 600000 records  
427
11/12/2015 07:24PM
Re: distinct clause issue for 600000 records  
435
11/12/2015 07:08AM
Re: distinct clause issue for 600000 records  
423
11/12/2015 07:18AM
Re: distinct clause issue for 600000 records  
449
11/12/2015 07:43AM
Re: distinct clause issue for 600000 records  
445
11/13/2015 12:37AM
Re: distinct clause issue for 600000 records  
400
11/13/2015 12:45AM
Re: distinct clause issue for 600000 records  
372
11/13/2015 02:42AM
Re: distinct clause issue for 600000 records  
476
11/13/2015 05:56AM
Re: distinct clause issue for 600000 records  
456
11/13/2015 06:38AM
Re: distinct clause issue for 600000 records  
424
11/13/2015 07:15AM
Re: distinct clause issue for 600000 records  
528
11/13/2015 08:11AM
Re: distinct clause issue for 600000 records  
445
11/13/2015 11:35AM
Re: distinct clause issue for 600000 records  
503
11/16/2015 03:04AM
Re: distinct clause issue for 600000 records  
474
11/16/2015 04:12AM
Re: distinct clause issue for 600000 records  
390
11/16/2015 05:54AM
Re: Values not inserting into MySQL Database table  
707
11/11/2015 12:28PM
Re: Values not inserting into MySQL Database table  
427
11/11/2015 12:49PM
Re: Values not inserting into MySQL Database table  
359
11/12/2015 07:01AM
Re: Values not inserting into MySQL Database table  
491
11/12/2015 07:06AM
Re: Values not inserting into MySQL Database table  
404
11/12/2015 07:11AM
Re: Values not inserting into MySQL Database table  
471
11/12/2015 01:53PM
Re: Values not inserting into MySQL Database table  
472
11/12/2015 07:21PM
Re: does this "top-200" query do a table scan  
353
10/31/2015 12:22AM
Re: does this "top-200" query do a table scan  
442
10/31/2015 10:15AM
Re: does this "top-200" query do a table scan  
313
10/31/2015 01:03PM
Re: does this "top-200" query do a table scan  
401
10/31/2015 05:51PM
877
10/29/2015 12:47AM
Re: Mysterious Cache Problem  
357
10/29/2015 03:04AM
Re: Mysterious Cache Problem  
373
10/30/2015 06:16PM
Re: Optimisation of a query using Group by and a Join  
536
10/19/2015 02:10PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
564
10/03/2015 08:01PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
557
10/03/2015 08:34PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
489
10/05/2015 10:38AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
503
10/05/2015 10:41AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
483
10/05/2015 10:50AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
447
10/04/2015 08:28PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
469
10/05/2015 12:26PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
462
10/06/2015 11:00AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
846
10/06/2015 11:50PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
449
10/07/2015 08:12PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
505
10/08/2015 11:17PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
485
10/09/2015 10:34PM
Re: Too much time in Copy to Tmp Table  
565
10/02/2015 02:08PM
Re: Too much time in Copy to Tmp Table  
526
10/05/2015 02:36PM
Re: Too much time in Copy to Tmp Table  
492
10/05/2015 02:48PM
Re: Too much time in Copy to Tmp Table  
509
10/05/2015 02:55PM
Re: Too much time in Copy to Tmp Table  
571
10/06/2015 10:32PM
Re: Too much time in Copy to Tmp Table  
656
10/08/2015 07:21PM
Re: Index suggestion needed for performance improvement  
434
10/02/2015 09:14PM
Re: Index suggestion needed for performance improvement  
487
10/03/2015 12:14AM
Re: Index suggestion needed for performance improvement  
501
10/03/2015 12:40AM
Re: Index suggestion needed for performance improvement  
500
10/03/2015 02:10AM
Re: Index suggestion needed for performance improvement  
468
10/04/2015 01:15PM
Re: Index suggestion needed for performance improvement  
471
10/04/2015 09:18PM
Re: Index suggestion needed for performance improvement  
534
10/04/2015 01:22PM
Re: Utilize maximum system resources for better performance  
692
07/14/2015 01:58AM
Re: Utilize maximum system resources for better performance  
626
07/14/2015 02:12AM
Re: Utilize maximum system resources for better performance  
612
07/14/2015 11:30AM
Re: Utilize maximum system resources for better performance  
618
07/14/2015 11:57AM
Re: Utilize maximum system resources for better performance  
682
07/15/2015 08:36PM
Re: Utilize maximum system resources for better performance  
785
07/30/2015 07:22AM
Re: Utilize maximum system resources for better performance  
667
07/30/2015 07:26AM
Re: Utilize maximum system resources for better performance  
677
07/31/2015 10:20PM
Re: Utilize maximum system resources for better performance  
636
08/02/2015 01:27AM
Re: Utilize maximum system resources for better performance  
648
08/02/2015 11:10AM
Re: Utilize maximum system resources for better performance  
779
08/08/2015 01:27AM
Re: Utilize maximum system resources for better performance  
607
08/08/2015 11:49AM
Re: Utilize maximum system resources for better performance  
545
08/08/2015 01:01PM
Re: Utilize maximum system resources for better performance  
630
08/08/2015 03:43PM
Re: Utilize maximum system resources for better performance  
700
08/09/2015 12:40AM
Re: Utilize maximum system resources for better performance  
555
08/09/2015 07:33AM
Re: Utilize maximum system resources for better performance  
580
08/09/2015 03:53PM
Re: Utilize maximum system resources for better performance  
647
08/09/2015 08:04PM
Re: Utilize maximum system resources for better performance  
495
08/09/2015 11:17PM
Re: Utilize maximum system resources for better performance  
621
08/10/2015 12:00AM
Re: Utilize maximum system resources for better performance  
600
08/10/2015 08:36AM
Re: Utilize maximum system resources for better performance  
784
08/10/2015 11:00AM
Re: Utilize maximum system resources for better performance  
657
08/10/2015 11:03AM
Re: Utilize maximum system resources for better performance  
642
09/16/2015 11:39AM
Re: Utilize maximum system resources for better performance  
694
09/18/2015 09:54PM
Re: Utilize maximum system resources for better performance  
449
09/19/2015 01:18AM
Re: Utilize maximum system resources for better performance  
619
10/02/2015 08:50PM
Re: Utilize maximum system resources for better performance  
520
10/02/2015 09:09PM
Re: Utilize maximum system resources for better performance  
513
10/03/2015 04:46PM
Re: Utilize maximum system resources for better performance  
640
08/09/2015 01:07AM
Re: Utilize maximum system resources for better performance  
478
09/23/2015 09:58AM
Re: Hints on what to check for bad performance  
449
09/21/2015 10:01PM
Re: Hints on what to check for bad performance  
405
09/25/2015 07:55AM
Re: Hints on what to check for bad performance  
364
10/02/2015 09:59PM
Re: Memory/cache usage with innodb_flush_method values  
548
10/02/2015 09:41PM
961
08/21/2015 08:08AM
Re: Deleted Records and Optimize  
448
08/22/2015 11:13AM
Re: Deleted Records and Optimize  
410
09/08/2015 03:51PM
Re: Deleted Records and Optimize  
437
09/09/2015 06:42PM
Re: MYSql Query - #2013 - Lost connection to MySQL server during query  
474
08/27/2015 09:43PM
Re: Delete query not using index and cause deadlock  
1,062
08/21/2015 07:13AM
Re: Delete query not using index and cause deadlock  
842
08/22/2015 03:48PM
Re: Delete query not using index and cause deadlock  
808
08/24/2015 02:35AM
Re: Delete query not using index and cause deadlock  
767
08/24/2015 12:27PM
Re: Delete query not using index and cause deadlock  
654
08/25/2015 02:57AM
Re: Help for checking server configuration  
442
08/17/2015 10:56AM
Re: Help for checking server configuration  
567
08/19/2015 09:32AM
Re: Help for checking server configuration  
559
08/22/2015 02:59PM
Re: Deadlock issue and table lock frequently  
474
08/07/2015 10:09PM
Re: Deadlock issue and table lock frequently  
505
08/17/2015 02:50AM
Re: Deadlock issue and table lock frequently  
427
08/18/2015 09:23PM
Re: Deadlock issue and table lock frequently  
841
08/20/2015 12:06AM
Re: Deadlock issue and table lock frequently  
476
08/22/2015 01:45PM
1,377
08/13/2015 01:19AM
Re: table_cache  
511
08/15/2015 04:19PM
Re: table_cache  
565
08/16/2015 01:24PM
Re: table_cache  
635
08/17/2015 09:30AM
1,374
08/09/2015 11:35PM
Re: Best Index Strategy  
485
08/10/2015 07:02AM
Re: Best Index Strategy  
437
08/10/2015 07:17AM
Re: Best Index Strategy  
442
08/10/2015 11:30PM
Re: Best Index Strategy  
430
08/12/2015 10:53PM
Re: Best Index Strategy  
433
08/15/2015 04:34PM
Re: Best Index Strategy  
449
08/16/2015 11:53PM
1,086
08/04/2015 08:47AM
Re: Select last date check all rows  
419
08/05/2015 05:49PM
Re: Select last date check all rows  
465
08/06/2015 03:11AM
Re: Select last date check all rows  
356
08/06/2015 03:13AM
Re: Select last date check all rows  
375
08/06/2015 10:36PM
Re: Select last date check all rows  
533
08/07/2015 04:12AM
Re: Select last date check all rows  
449
08/08/2015 11:11AM
Re: Number of table Partitions  
1,525
07/24/2015 03:14PM
Re: Number of table Partitions  
625
07/31/2015 02:15PM
1,036
a m
07/23/2015 09:21AM
Re: Slow Query Urgent  
431
07/23/2015 10:19AM
Re: Slow Query Urgent  
381
07/24/2015 04:00PM
Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU  
395
07/16/2015 09:39AM
Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU  
599
07/17/2015 04:01PM
1,134
07/06/2015 10:08PM
Re: SELECT never completes  
453
07/06/2015 11:51PM
Re: SELECT never completes  
671
07/07/2015 02:16AM
Re: SELECT never completes  
445
07/09/2015 12:55AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
567
05/22/2015 02:19AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
559
05/22/2015 08:15AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
422
06/06/2015 12:30PM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
491
06/26/2015 08:24AM
Re: Performance Issue for select query  
554
06/09/2015 11:42PM
2,593
05/27/2015 05:40PM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
912
05/28/2015 02:18AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
728
05/28/2015 07:22AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
554
05/28/2015 07:49AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
628
06/06/2015 12:16PM
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.