MySQL Forums
Forum List  »  Performance
Announcements Last Post
•   MySQL Cluster 7.5.7 has been released 07/19/2017 04:43AM
•   MySQL Cluster 7.4.16 has been released 07/18/2017 01:43PM
•   MySQL Cluster 7.2.30 has been released 07/18/2017 10:21AM
•   MySQL Community Server 8.0.2-dmr has been released (part 2/2) 07/18/2017 01:08AM
•   MySQL Community Server 8.0.2-dmr has been released (part 1/2) 07/18/2017 01:06AM

Subject
Views
Written By
Posted
This topic has been moved.:  NOLOCK for multiple tables  
32
11/18/2015 03:51PM
Re: distinct clause issue for 600000 records  
367
11/11/2015 12:33PM
Re: distinct clause issue for 600000 records  
315
11/12/2015 12:49AM
Re: distinct clause issue for 600000 records  
416
11/12/2015 03:20AM
Re: distinct clause issue for 600000 records  
356
11/12/2015 07:24PM
Re: distinct clause issue for 600000 records  
352
11/12/2015 07:08AM
Re: distinct clause issue for 600000 records  
353
11/12/2015 07:18AM
Re: distinct clause issue for 600000 records  
371
11/12/2015 07:43AM
Re: distinct clause issue for 600000 records  
369
11/13/2015 12:37AM
Re: distinct clause issue for 600000 records  
328
11/13/2015 12:45AM
Re: distinct clause issue for 600000 records  
309
11/13/2015 02:42AM
Re: distinct clause issue for 600000 records  
382
11/13/2015 05:56AM
Re: distinct clause issue for 600000 records  
392
11/13/2015 06:38AM
Re: distinct clause issue for 600000 records  
351
11/13/2015 07:15AM
Re: distinct clause issue for 600000 records  
457
11/13/2015 08:11AM
Re: distinct clause issue for 600000 records  
386
11/13/2015 11:35AM
Re: distinct clause issue for 600000 records  
417
11/16/2015 03:04AM
Re: distinct clause issue for 600000 records  
401
11/16/2015 04:12AM
Re: distinct clause issue for 600000 records  
320
11/16/2015 05:54AM
Re: Values not inserting into MySQL Database table  
511
11/11/2015 12:28PM
Re: Values not inserting into MySQL Database table  
315
11/11/2015 12:49PM
Re: Values not inserting into MySQL Database table  
278
11/12/2015 07:01AM
Re: Values not inserting into MySQL Database table  
391
11/12/2015 07:06AM
Re: Values not inserting into MySQL Database table  
311
11/12/2015 07:11AM
Re: Values not inserting into MySQL Database table  
382
11/12/2015 01:53PM
Re: Values not inserting into MySQL Database table  
379
11/12/2015 07:21PM
Re: does this "top-200" query do a table scan  
277
10/31/2015 12:22AM
Re: does this "top-200" query do a table scan  
297
10/31/2015 10:15AM
Re: does this "top-200" query do a table scan  
262
10/31/2015 01:03PM
Re: does this "top-200" query do a table scan  
341
10/31/2015 05:51PM
750
10/29/2015 12:47AM
Re: Mysterious Cache Problem  
304
10/29/2015 03:04AM
Re: Mysterious Cache Problem  
318
10/30/2015 06:16PM
Re: Optimisation of a query using Group by and a Join  
450
10/19/2015 02:10PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
441
10/03/2015 08:01PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
449
10/03/2015 08:34PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
378
10/05/2015 10:38AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
418
10/05/2015 10:41AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
404
10/05/2015 10:50AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
377
10/04/2015 08:28PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
388
10/05/2015 12:26PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
388
10/06/2015 11:00AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
550
10/06/2015 11:50PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
356
10/07/2015 08:12PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
404
10/08/2015 11:17PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
371
10/09/2015 10:34PM
Re: Too much time in Copy to Tmp Table  
437
10/02/2015 02:08PM
Re: Too much time in Copy to Tmp Table  
412
10/05/2015 02:36PM
Re: Too much time in Copy to Tmp Table  
385
10/05/2015 02:48PM
Re: Too much time in Copy to Tmp Table  
391
10/05/2015 02:55PM
Re: Too much time in Copy to Tmp Table  
465
10/06/2015 10:32PM
Re: Too much time in Copy to Tmp Table  
505
10/08/2015 07:21PM
Re: Index suggestion needed for performance improvement  
365
10/02/2015 09:14PM
Re: Index suggestion needed for performance improvement  
433
10/03/2015 12:14AM
Re: Index suggestion needed for performance improvement  
405
10/03/2015 12:40AM
Re: Index suggestion needed for performance improvement  
409
10/03/2015 02:10AM
Re: Index suggestion needed for performance improvement  
361
10/04/2015 01:15PM
Re: Index suggestion needed for performance improvement  
403
10/04/2015 09:18PM
Re: Index suggestion needed for performance improvement  
395
10/04/2015 01:22PM
Re: Utilize maximum system resources for better performance  
596
07/14/2015 01:58AM
Re: Utilize maximum system resources for better performance  
559
07/14/2015 02:12AM
Re: Utilize maximum system resources for better performance  
507
07/14/2015 11:30AM
Re: Utilize maximum system resources for better performance  
545
07/14/2015 11:57AM
Re: Utilize maximum system resources for better performance  
585
07/15/2015 08:36PM
Re: Utilize maximum system resources for better performance  
620
07/30/2015 07:22AM
Re: Utilize maximum system resources for better performance  
593
07/30/2015 07:26AM
Re: Utilize maximum system resources for better performance  
597
07/31/2015 10:20PM
Re: Utilize maximum system resources for better performance  
542
08/02/2015 01:27AM
Re: Utilize maximum system resources for better performance  
526
08/02/2015 11:10AM
Re: Utilize maximum system resources for better performance  
658
08/08/2015 01:27AM
Re: Utilize maximum system resources for better performance  
518
08/08/2015 11:49AM
Re: Utilize maximum system resources for better performance  
475
08/08/2015 01:01PM
Re: Utilize maximum system resources for better performance  
527
08/08/2015 03:43PM
Re: Utilize maximum system resources for better performance  
557
08/09/2015 12:40AM
Re: Utilize maximum system resources for better performance  
468
08/09/2015 07:33AM
Re: Utilize maximum system resources for better performance  
509
08/09/2015 03:53PM
Re: Utilize maximum system resources for better performance  
500
08/09/2015 08:04PM
Re: Utilize maximum system resources for better performance  
421
08/09/2015 11:17PM
Re: Utilize maximum system resources for better performance  
544
08/10/2015 12:00AM
Re: Utilize maximum system resources for better performance  
508
08/10/2015 08:36AM
Re: Utilize maximum system resources for better performance  
568
08/10/2015 11:00AM
Re: Utilize maximum system resources for better performance  
458
08/10/2015 11:03AM
Re: Utilize maximum system resources for better performance  
566
09/16/2015 11:39AM
Re: Utilize maximum system resources for better performance  
601
09/18/2015 09:54PM
Re: Utilize maximum system resources for better performance  
391
09/19/2015 01:18AM
Re: Utilize maximum system resources for better performance  
526
10/02/2015 08:50PM
Re: Utilize maximum system resources for better performance  
410
10/02/2015 09:09PM
Re: Utilize maximum system resources for better performance  
441
10/03/2015 04:46PM
Re: Utilize maximum system resources for better performance  
536
08/09/2015 01:07AM
Re: Utilize maximum system resources for better performance  
410
09/23/2015 09:58AM
Re: Hints on what to check for bad performance  
385
09/21/2015 10:01PM
Re: Hints on what to check for bad performance  
342
09/25/2015 07:55AM
Re: Hints on what to check for bad performance  
300
10/02/2015 09:59PM
Re: Memory/cache usage with innodb_flush_method values  
449
10/02/2015 09:41PM
767
08/21/2015 08:08AM
Re: Deleted Records and Optimize  
384
08/22/2015 11:13AM
Re: Deleted Records and Optimize  
356
09/08/2015 03:51PM
Re: Deleted Records and Optimize  
358
09/09/2015 06:42PM
Re: MYSql Query - #2013 - Lost connection to MySQL server during query  
383
08/27/2015 09:43PM
Re: Delete query not using index and cause deadlock  
544
08/21/2015 07:13AM
Re: Delete query not using index and cause deadlock  
460
08/22/2015 03:48PM
Re: Delete query not using index and cause deadlock  
500
08/24/2015 02:35AM
Re: Delete query not using index and cause deadlock  
433
08/24/2015 12:27PM
Re: Delete query not using index and cause deadlock  
400
08/25/2015 02:57AM
Re: Help for checking server configuration  
376
08/17/2015 10:56AM
Re: Help for checking server configuration  
471
08/19/2015 09:32AM
Re: Help for checking server configuration  
467
08/22/2015 02:59PM
Re: Deadlock issue and table lock frequently  
402
08/07/2015 10:09PM
Re: Deadlock issue and table lock frequently  
417
08/17/2015 02:50AM
Re: Deadlock issue and table lock frequently  
339
08/18/2015 09:23PM
Re: Deadlock issue and table lock frequently  
573
08/20/2015 12:06AM
Re: Deadlock issue and table lock frequently  
364
08/22/2015 01:45PM
1,221
08/13/2015 01:19AM
Re: table_cache  
467
08/15/2015 04:19PM
Re: table_cache  
493
08/16/2015 01:24PM
Re: table_cache  
545
08/17/2015 09:30AM
1,212
08/09/2015 11:35PM
Re: Best Index Strategy  
417
08/10/2015 07:02AM
Re: Best Index Strategy  
364
08/10/2015 07:17AM
Re: Best Index Strategy  
380
08/10/2015 11:30PM
Re: Best Index Strategy  
370
08/12/2015 10:53PM
Re: Best Index Strategy  
349
08/15/2015 04:34PM
Re: Best Index Strategy  
387
08/16/2015 11:53PM
Re: Select last date check all rows  
340
08/05/2015 05:49PM
Re: Select last date check all rows  
349
08/06/2015 03:11AM
Re: Select last date check all rows  
312
08/06/2015 03:13AM
Re: Select last date check all rows  
325
08/06/2015 10:36PM
Re: Select last date check all rows  
469
08/07/2015 04:12AM
Re: Select last date check all rows  
377
08/08/2015 11:11AM
Re: Number of table Partitions  
595
07/24/2015 03:14PM
Re: Number of table Partitions  
508
07/31/2015 02:15PM
923
a m
07/23/2015 09:21AM
Re: Slow Query Urgent  
381
07/23/2015 10:19AM
Re: Slow Query Urgent  
346
07/24/2015 04:00PM
Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU  
337
07/16/2015 09:39AM
Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU  
428
07/17/2015 04:01PM
1,024
07/06/2015 10:08PM
Re: SELECT never completes  
387
07/06/2015 11:51PM
Re: SELECT never completes  
572
07/07/2015 02:16AM
Re: SELECT never completes  
376
07/09/2015 12:55AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
501
05/22/2015 02:19AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
502
05/22/2015 08:15AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
372
06/06/2015 12:30PM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
435
06/26/2015 08:24AM
Re: Performance Issue for select query  
501
06/09/2015 11:42PM
1,507
05/27/2015 05:40PM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
643
05/28/2015 02:18AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
512
05/28/2015 07:22AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
410
05/28/2015 07:49AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
450
06/06/2015 12:16PM
Re: Strange behavior of MySQL server  
395
06/06/2015 11:51AM
Re: heavy read workload with high cpu usage  
427
06/04/2015 08:35AM
Re: query performance on partitioning table  
537
05/16/2015 11:49PM
Re: query performance on partitioning table  
514
05/18/2015 08:30AM
Re: query performance on partitioning table  
458
06/04/2015 08:22AM
1,005
05/12/2015 08:40AM
Re: Avoid subquery  
429
05/12/2015 11:06AM
Re: Avoid subquery  
406
05/12/2015 01:29PM
Re: Avoid subquery  
386
05/12/2015 01:41PM
Re: Avoid subquery  
513
05/17/2015 12:11AM
846
05/13/2015 09:53PM
Re: MYSQL Table Optimization  
381
05/15/2015 11:02AM
1,075
04/21/2015 11:15AM
Re: Slow query  
427
04/22/2015 07:17AM
Re: Slow query  
418
04/22/2015 07:05PM
Re: Slow query  
535
04/23/2015 11:42PM
Re: Slow query  
416
04/23/2015 11:55PM
Re: Slow query  
404
04/24/2015 05:22PM
Re: Slow query  
403
04/25/2015 02:31AM
Re: Slow query  
482
04/25/2015 02:41AM
Re: Slow query  
669
04/25/2015 05:22AM
Re: Slow query  
426
04/25/2015 10:42PM
Re: Slow query  
409
05/13/2015 03:30AM
Re: Slow query  
516
04/28/2015 03:40AM
1,526
04/28/2015 08:55AM
Re: CPU usage extremely high  
697
04/28/2015 09:03AM
Re: CPU usage extremely high  
524
04/29/2015 05:43PM
Re: CPU usage extremely high  
637
05/09/2015 07:22AM
Re: CPU usage extremely high  
483
05/09/2015 07:38AM
Re: CPU usage extremely high  
515
05/11/2015 06:30PM
828
05/02/2015 02:17AM
Re: Mysql indexes weird behavior  
322
05/03/2015 06:21PM
Re: slow query sorting result - sending data  
544
04/28/2015 10:38PM
Re: slow query sorting result - sending data  
524
05/01/2015 10:08PM
1,018
04/27/2015 04:26AM
Re: PROFILING  
435
04/29/2015 06:53PM
1,270
04/26/2015 07:28AM
Re: Query time difference  
372
04/27/2015 02:39PM
Re: Query time difference  
404
04/27/2015 11:29PM
Re: Query time difference  
362
04/29/2015 05:50PM
Re: Performance issues with INNODB vs MyISAM  
728
04/19/2015 01:22PM
Re: Performance issues with INNODB vs MyISAM  
546
04/27/2015 11:15AM
Re: Performance issues with INNODB vs MyISAM  
438
04/28/2015 10:34AM
897
04/11/2015 05:50AM
Re: Writing at 847 MB/sec ???  
492
04/15/2015 11:03PM
Re: Writing at 847 MB/sec ???  
520
04/17/2015 08:45AM
Re: Writing at 847 MB/sec ???  
450
04/19/2015 01:38PM
Re: Writing at 847 MB/sec ???  
509
04/20/2015 01:00AM
Re: Mysql is consuming xtremely high CPU above 1000%  
761
04/11/2015 04:47PM
Re: Mysql is consuming xtremely high CPU above 1000%  
575
04/15/2015 10:36PM
Re: Mysql is consuming xtremely high CPU above 1000%  
516
04/16/2015 11:45AM
Re: Mysql is consuming xtremely high CPU above 1000%  
559
04/17/2015 08:05PM
Re: Mysql is consuming xtremely high CPU above 1000%  
717
04/18/2015 06:07AM
Re: Mysql is consuming xtremely high CPU above 1000%  
757
04/19/2015 02:19PM
827
04/14/2015 12:40PM
Re: Client to server connection  
356
04/14/2015 11:18PM
Re: Client to server connection  
328
04/17/2015 08:09PM
This topic has been moved.:  Mysql NDB Cluster  
36
04/01/2015 11:23PM
Re: Fast way to have an inparameter match all values? (COALESCE slow)  
484
03/26/2015 10:45AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)  
432
03/30/2015 01:22AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)  
518
03/30/2015 03:27AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)  
418
03/30/2015 11:16AM
Re: system table space vs file per table space  
420
03/28/2015 03:36PM
1,151
03/20/2015 07:00AM
Re: Slow COUNT + GROUP BY  
478
03/20/2015 07:55AM
Re: Slow COUNT + GROUP BY  
462
03/20/2015 08:00AM
Re: Slow COUNT + GROUP BY  
425
03/22/2015 04:11PM
Re: Slow COUNT + GROUP BY  
413
03/23/2015 12:46AM
Re: Slow COUNT + GROUP BY  
519
03/23/2015 02:45AM
Re: Slow COUNT + GROUP BY  
591
03/23/2015 04:30AM
Re: Slow COUNT + GROUP BY  
551
03/23/2015 06:04AM
Re: Slow COUNT + GROUP BY  
410
03/23/2015 08:13AM
Re: Slow COUNT + GROUP BY  
452
03/24/2015 02:02AM
Re: Slow COUNT + GROUP BY  
419
03/24/2015 02:51AM
Re: Slow COUNT + GROUP BY  
477
03/24/2015 03:37AM
1,005
02/11/2015 01:31AM
Re: Query Optimization Needed  
454
02/11/2015 12:42PM
Re: Query Optimization Needed  
530
02/12/2015 03:51AM
Re: Query Optimization Needed  
505
02/12/2015 01:24PM
Re: Query Optimization Needed  
500
02/13/2015 06:53AM
Re: Query Optimization Needed  
435
02/13/2015 07:36AM
Re: Query Optimization Needed  
444
02/14/2015 01:04AM
Re: Query Optimization Needed  
459
02/15/2015 11:07PM
Re: Query Optimization Needed  
486
02/16/2015 12:15AM
Re: Query Optimization Needed  
388
03/13/2015 11:15AM
Pages:
« 1 2 3 4 5
...
73 »

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.