MySQL Forums
Forum List  »  Performance
Announcements Last Post
•   MySQL Shell 1.0.10 GA has been released 07/28/2017 05:28AM
•   MySQL Connector/C 6.1.11 GA has been released 07/24/2017 10:19AM
•   MySQL Router 2.1.4 GA has been released 07/24/2017 09:15AM
•   MySQL Connector/ODBC 5.3.9 has been released 07/24/2017 08:59AM
•   MySQL Connector/J 5.1.43 has been released 07/21/2017 02:07PM

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  
316
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  
358
11/12/2015 07:24PM
Re: distinct clause issue for 600000 records  
353
11/12/2015 07:08AM
Re: distinct clause issue for 600000 records  
355
11/12/2015 07:18AM
Re: distinct clause issue for 600000 records  
372
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  
329
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  
384
11/13/2015 05:56AM
Re: distinct clause issue for 600000 records  
394
11/13/2015 06:38AM
Re: distinct clause issue for 600000 records  
353
11/13/2015 07:15AM
Re: distinct clause issue for 600000 records  
459
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  
418
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  
322
11/16/2015 05:54AM
Re: Values not inserting into MySQL Database table  
513
11/11/2015 12:28PM
Re: Values not inserting into MySQL Database table  
316
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  
313
11/12/2015 07:11AM
Re: Values not inserting into MySQL Database table  
384
11/12/2015 01:53PM
Re: Values not inserting into MySQL Database table  
380
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  
320
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  
344
10/31/2015 05:51PM
751
10/29/2015 12:47AM
Re: Mysterious Cache Problem  
305
10/29/2015 03:04AM
Re: Mysterious Cache Problem  
319
10/30/2015 06:16PM
Re: Optimisation of a query using Group by and a Join  
452
10/19/2015 02:10PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
443
10/03/2015 08:01PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
450
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 ?  
419
10/05/2015 10:41AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
406
10/05/2015 10:50AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
378
10/04/2015 08:28PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
390
10/05/2015 12:26PM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
391
10/06/2015 11:00AM
Re: Why is ORDER BY ASC is slow but ORDER DESC is fast ? and how can i fix it ?  
552
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 ?  
374
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  
413
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  
467
10/06/2015 10:32PM
Re: Too much time in Copy to Tmp Table  
507
10/08/2015 07:21PM
Re: Index suggestion needed for performance improvement  
366
10/02/2015 09:14PM
Re: Index suggestion needed for performance improvement  
434
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  
411
10/03/2015 02:10AM
Re: Index suggestion needed for performance improvement  
363
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  
397
10/04/2015 01:22PM
Re: Utilize maximum system resources for better performance  
599
07/14/2015 01:58AM
Re: Utilize maximum system resources for better performance  
560
07/14/2015 02:12AM
Re: Utilize maximum system resources for better performance  
509
07/14/2015 11:30AM
Re: Utilize maximum system resources for better performance  
547
07/14/2015 11:57AM
Re: Utilize maximum system resources for better performance  
588
07/15/2015 08:36PM
Re: Utilize maximum system resources for better performance  
622
07/30/2015 07:22AM
Re: Utilize maximum system resources for better performance  
596
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  
545
08/02/2015 01:27AM
Re: Utilize maximum system resources for better performance  
553
08/02/2015 11:10AM
Re: Utilize maximum system resources for better performance  
664
08/08/2015 01:27AM
Re: Utilize maximum system resources for better performance  
522
08/08/2015 11:49AM
Re: Utilize maximum system resources for better performance  
477
08/08/2015 01:01PM
Re: Utilize maximum system resources for better performance  
528
08/08/2015 03:43PM
Re: Utilize maximum system resources for better performance  
559
08/09/2015 12:40AM
Re: Utilize maximum system resources for better performance  
469
08/09/2015 07:33AM
Re: Utilize maximum system resources for better performance  
510
08/09/2015 03:53PM
Re: Utilize maximum system resources for better performance  
503
08/09/2015 08:04PM
Re: Utilize maximum system resources for better performance  
422
08/09/2015 11:17PM
Re: Utilize maximum system resources for better performance  
546
08/10/2015 12:00AM
Re: Utilize maximum system resources for better performance  
509
08/10/2015 08:36AM
Re: Utilize maximum system resources for better performance  
570
08/10/2015 11:00AM
Re: Utilize maximum system resources for better performance  
459
08/10/2015 11:03AM
Re: Utilize maximum system resources for better performance  
577
09/16/2015 11:39AM
Re: Utilize maximum system resources for better performance  
603
09/18/2015 09:54PM
Re: Utilize maximum system resources for better performance  
397
09/19/2015 01:18AM
Re: Utilize maximum system resources for better performance  
532
10/02/2015 08:50PM
Re: Utilize maximum system resources for better performance  
413
10/02/2015 09:09PM
Re: Utilize maximum system resources for better performance  
445
10/03/2015 04:46PM
Re: Utilize maximum system resources for better performance  
538
08/09/2015 01:07AM
Re: Utilize maximum system resources for better performance  
411
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  
451
10/02/2015 09:41PM
785
08/21/2015 08:08AM
Re: Deleted Records and Optimize  
384
08/22/2015 11:13AM
Re: Deleted Records and Optimize  
357
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  
386
08/27/2015 09:43PM
Re: Delete query not using index and cause deadlock  
545
08/21/2015 07:13AM
Re: Delete query not using index and cause deadlock  
461
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  
435
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  
378
08/17/2015 10:56AM
Re: Help for checking server configuration  
475
08/19/2015 09:32AM
Re: Help for checking server configuration  
471
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  
418
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  
575
08/20/2015 12:06AM
Re: Deadlock issue and table lock frequently  
365
08/22/2015 01:45PM
1,226
08/13/2015 01:19AM
Re: table_cache  
467
08/15/2015 04:19PM
Re: table_cache  
495
08/16/2015 01:24PM
Re: table_cache  
545
08/17/2015 09:30AM
1,214
08/09/2015 11:35PM
Re: Best Index Strategy  
418
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  
388
08/16/2015 11:53PM
Re: Select last date check all rows  
341
08/05/2015 05:49PM
Re: Select last date check all rows  
350
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  
326
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  
378
08/08/2015 11:11AM
Re: Number of table Partitions  
595
07/24/2015 03:14PM
Re: Number of table Partitions  
509
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  
430
07/17/2015 04:01PM
1,028
07/06/2015 10:08PM
Re: SELECT never completes  
388
07/06/2015 11:51PM
Re: SELECT never completes  
572
07/07/2015 02:16AM
Re: SELECT never completes  
377
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  
504
06/09/2015 11:42PM
1,519
05/27/2015 05:40PM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
648
05/28/2015 02:18AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
515
05/28/2015 07:22AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
413
05/28/2015 07:49AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
452
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  
428
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  
408
05/12/2015 01:29PM
Re: Avoid subquery  
386
05/12/2015 01:41PM
Re: Avoid subquery  
514
05/17/2015 12:11AM
847
05/13/2015 09:53PM
Re: MYSQL Table Optimization  
381
05/15/2015 11:02AM
1,077
04/21/2015 11:15AM
Re: Slow query  
427
04/22/2015 07:17AM
Re: Slow query  
419
04/22/2015 07:05PM
Re: Slow query  
539
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  
405
04/25/2015 02:31AM
Re: Slow query  
483
04/25/2015 02:41AM
Re: Slow query  
671
04/25/2015 05:22AM
Re: Slow query  
427
04/25/2015 10:42PM
Re: Slow query  
410
05/13/2015 03:30AM
Re: Slow query  
518
04/28/2015 03:40AM
1,532
04/28/2015 08:55AM
Re: CPU usage extremely high  
699
04/28/2015 09:03AM
Re: CPU usage extremely high  
528
04/29/2015 05:43PM
Re: CPU usage extremely high  
645
05/09/2015 07:22AM
Re: CPU usage extremely high  
490
05/09/2015 07:38AM
Re: CPU usage extremely high  
519
05/11/2015 06:30PM
837
05/02/2015 02:17AM
Re: Mysql indexes weird behavior  
323
05/03/2015 06:21PM
Re: slow query sorting result - sending data  
549
04/28/2015 10:38PM
Re: slow query sorting result - sending data  
526
05/01/2015 10:08PM
1,019
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  
405
04/27/2015 11:29PM
Re: Query time difference  
363
04/29/2015 05:50PM
Re: Performance issues with INNODB vs MyISAM  
730
04/19/2015 01:22PM
Re: Performance issues with INNODB vs MyISAM  
547
04/27/2015 11:15AM
Re: Performance issues with INNODB vs MyISAM  
439
04/28/2015 10:34AM
898
04/11/2015 05:50AM
Re: Writing at 847 MB/sec ???  
494
04/15/2015 11:03PM
Re: Writing at 847 MB/sec ???  
520
04/17/2015 08:45AM
Re: Writing at 847 MB/sec ???  
451
04/19/2015 01:38PM
Re: Writing at 847 MB/sec ???  
510
04/20/2015 01:00AM
Re: Mysql is consuming xtremely high CPU above 1000%  
769
04/11/2015 04:47PM
Re: Mysql is consuming xtremely high CPU above 1000%  
578
04/15/2015 10:36PM
Re: Mysql is consuming xtremely high CPU above 1000%  
519
04/16/2015 11:45AM
Re: Mysql is consuming xtremely high CPU above 1000%  
568
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
829
04/14/2015 12:40PM
Re: Client to server connection  
357
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,152
03/20/2015 07:00AM
Re: Slow COUNT + GROUP BY  
480
03/20/2015 07:55AM
Re: Slow COUNT + GROUP BY  
463
03/20/2015 08:00AM
Re: Slow COUNT + GROUP BY  
430
03/22/2015 04:11PM
Re: Slow COUNT + GROUP BY  
415
03/23/2015 12:46AM
Re: Slow COUNT + GROUP BY  
520
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  
411
03/23/2015 08:13AM
Re: Slow COUNT + GROUP BY  
453
03/24/2015 02:02AM
Re: Slow COUNT + GROUP BY  
420
03/24/2015 02:51AM
Re: Slow COUNT + GROUP BY  
478
03/24/2015 03:37AM
1,007
02/11/2015 01:31AM
Re: Query Optimization Needed  
456
02/11/2015 12:42PM
Re: Query Optimization Needed  
531
02/12/2015 03:51AM
Re: Query Optimization Needed  
506
02/12/2015 01:24PM
Re: Query Optimization Needed  
501
02/13/2015 06:53AM
Re: Query Optimization Needed  
435
02/13/2015 07:36AM
Re: Query Optimization Needed  
445
02/14/2015 01:04AM
Re: Query Optimization Needed  
460
02/15/2015 11:07PM
Re: Query Optimization Needed  
487
02/16/2015 12:15AM
Re: Query Optimization Needed  
389
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.