MySQL Forums
Forum List  »  Performance
Announcements Last Post
•   MySQL Cluster 7.6.5-dmr has been released 04/20/2018 07:21PM
•   MySQL Cluster 7.4.20 has been released 04/20/2018 08:56AM
•   MySQL Cluster 7.5.10 has been released 04/20/2018 06:34AM
•   MySQL Cluster 7.3.21 has been released 04/20/2018 04:59AM
•   MySQL Enterprise Monitor 8.0.0 GA has been released 04/19/2018 11:00AM

Advanced Search
New Topic
Pages:
« 1 2 3 4 5
...
74 »

Subject
Views
Written By
Posted
Index suggestion needed for performance improvement  
1,015
Ronald Brown
09/23/2015 11:49AM
Re: Index suggestion needed for performance improvement  
412
Rick James
10/02/2015 09:14PM
Re: Index suggestion needed for performance improvement  
467
Ronald Brown
10/03/2015 12:14AM
Re: Index suggestion needed for performance improvement  
470
Ronald Brown
10/03/2015 12:40AM
Re: Index suggestion needed for performance improvement  
477
Ronald Brown
10/03/2015 02:10AM
Re: Index suggestion needed for performance improvement  
439
Rick James
10/04/2015 01:15PM
Re: Index suggestion needed for performance improvement  
442
Ronald Brown
10/04/2015 09:18PM
Re: Index suggestion needed for performance improvement  
489
Rick James
10/04/2015 01:22PM
Utilize maximum system resources for better performance  
1,449
Ronald Brown
07/14/2015 01:54AM
Re: Utilize maximum system resources for better performance  
660
Ronald Brown
07/14/2015 01:58AM
Re: Utilize maximum system resources for better performance  
604
Ronald Brown
07/14/2015 02:12AM
Re: Utilize maximum system resources for better performance  
587
Peter Brawley
07/14/2015 11:30AM
Re: Utilize maximum system resources for better performance  
589
Ronald Brown
07/14/2015 11:57AM
Re: Utilize maximum system resources for better performance  
655
Rick James
07/15/2015 08:36PM
Re: Utilize maximum system resources for better performance  
752
Ronald Brown
07/30/2015 07:22AM
Re: Utilize maximum system resources for better performance  
645
Ronald Brown
07/30/2015 07:26AM
Re: Utilize maximum system resources for better performance  
649
Rick James
07/31/2015 10:20PM
Re: Utilize maximum system resources for better performance  
608
Ronald Brown
08/02/2015 01:27AM
Re: Utilize maximum system resources for better performance  
624
Rick James
08/02/2015 11:10AM
Re: Utilize maximum system resources for better performance  
736
Ronald Brown
08/08/2015 01:27AM
Re: Utilize maximum system resources for better performance  
577
Rick James
08/08/2015 11:49AM
Re: Utilize maximum system resources for better performance  
516
Ronald Brown
08/08/2015 01:01PM
Re: Utilize maximum system resources for better performance  
593
Rick James
08/08/2015 03:43PM
Re: Utilize maximum system resources for better performance  
673
Ronald Brown
08/09/2015 12:40AM
Re: Utilize maximum system resources for better performance  
518
Ronald Brown
08/09/2015 07:33AM
Re: Utilize maximum system resources for better performance  
553
Rick James
08/09/2015 03:53PM
Re: Utilize maximum system resources for better performance  
597
Ronald Brown
08/09/2015 08:04PM
Re: Utilize maximum system resources for better performance  
466
Rick James
08/09/2015 11:17PM
Re: Utilize maximum system resources for better performance  
591
Ronald Brown
08/10/2015 12:00AM
Re: Utilize maximum system resources for better performance  
566
Ronald Brown
08/10/2015 08:36AM
Re: Utilize maximum system resources for better performance  
760
Rick James
08/10/2015 11:00AM
Re: Utilize maximum system resources for better performance  
632
Rick James
08/10/2015 11:03AM
Re: Utilize maximum system resources for better performance  
616
Ronald Brown
09/16/2015 11:39AM
Re: Utilize maximum system resources for better performance  
662
Rick James
09/18/2015 09:54PM
Re: Utilize maximum system resources for better performance  
432
Ronald Brown
09/19/2015 01:18AM
Re: Utilize maximum system resources for better performance  
581
Rick James
10/02/2015 08:50PM
Re: Utilize maximum system resources for better performance  
485
Ronald Brown
10/02/2015 09:09PM
Re: Utilize maximum system resources for better performance  
485
Rick James
10/03/2015 04:46PM
Re: Utilize maximum system resources for better performance  
604
Ronald Brown
08/09/2015 01:07AM
Re: Utilize maximum system resources for better performance  
444
Ronald Brown
09/23/2015 09:58AM
Hints on what to check for bad performance  
859
Ulf Zimmermann
09/21/2015 08:47PM
Re: Hints on what to check for bad performance  
426
Peter Brawley
09/21/2015 10:01PM
Re: Hints on what to check for bad performance  
378
Chandan Kumar
09/25/2015 07:55AM
Re: Hints on what to check for bad performance  
339
Rick James
10/02/2015 09:59PM
Memory/cache usage with innodb_flush_method values  
1,357
Brad Alberts
09/28/2015 08:52PM
Re: Memory/cache usage with innodb_flush_method values  
519
Rick James
10/02/2015 09:41PM
MySQL 5.7: Performance Schema & Sys Schema  
722
Edwin Desouza
09/22/2015 09:05AM
Deleted Records and Optimize  
923
Luis Cavazos
08/21/2015 08:08AM
Re: Deleted Records and Optimize  
426
Rick James
08/22/2015 11:13AM
Re: Deleted Records and Optimize  
392
Luis Cavazos
09/08/2015 03:51PM
Re: Deleted Records and Optimize  
410
Rick James
09/09/2015 06:42PM
MYSql Query - #2013 - Lost connection to MySQL server during query  
1,040
gourav kaila
08/27/2015 01:50PM
Re: MYSql Query - #2013 - Lost connection to MySQL server during query  
446
Peter Brawley
08/27/2015 09:43PM
Delete query not using index and cause deadlock  
2,361
Devrishi Shandilya
08/20/2015 06:28AM
Re: Delete query not using index and cause deadlock  
876
Øystein Grøvlen
08/21/2015 07:13AM
Re: Delete query not using index and cause deadlock  
709
Rick James
08/22/2015 03:48PM
Re: Delete query not using index and cause deadlock  
702
Øystein Grøvlen
08/24/2015 02:35AM
Re: Delete query not using index and cause deadlock  
672
Rick James
08/24/2015 12:27PM
Re: Delete query not using index and cause deadlock  
567
Øystein Grøvlen
08/25/2015 02:57AM
Help for checking server configuration  
855
Michele Quaini
08/16/2015 11:08AM
Re: Help for checking server configuration  
422
Rick James
08/17/2015 10:56AM
Re: Help for checking server configuration  
534
Michele Quaini
08/19/2015 09:32AM
Re: Help for checking server configuration  
534
Rick James
08/22/2015 02:59PM
Deadlock issue and table lock frequently  
1,241
Devrishi Shandilya
08/07/2015 02:57AM
Re: Deadlock issue and table lock frequently  
450
Rick James
08/07/2015 10:09PM
Re: Deadlock issue and table lock frequently  
472
Devrishi Shandilya
08/17/2015 02:50AM
Re: Deadlock issue and table lock frequently  
387
Rick James
08/18/2015 09:23PM
Re: Deadlock issue and table lock frequently  
718
Devrishi Shandilya
08/20/2015 12:06AM
Re: Deadlock issue and table lock frequently  
415
Rick James
08/22/2015 01:45PM
table_cache  
1,326
Julian König
08/13/2015 01:19AM
Re: table_cache  
494
Rick James
08/15/2015 04:19PM
Re: table_cache  
545
Julian König
08/16/2015 01:24PM
Re: table_cache  
606
Rick James
08/17/2015 09:30AM
Best Index Strategy  
1,327
Devrishi Shandilya
08/09/2015 11:35PM
Re: Best Index Strategy  
463
Rick James
08/10/2015 07:02AM
Re: Best Index Strategy  
408
Rick James
08/10/2015 07:17AM
Re: Best Index Strategy  
416
Devrishi Shandilya
08/10/2015 11:30PM
Re: Best Index Strategy  
408
Devrishi Shandilya
08/12/2015 10:53PM
Re: Best Index Strategy  
408
Rick James
08/15/2015 04:34PM
Re: Best Index Strategy  
422
Devrishi Shandilya
08/16/2015 11:53PM
Select last date check all rows  
1,047
Pär Nordlund
08/04/2015 08:47AM
Re: Select last date check all rows  
392
Rick James
08/05/2015 05:49PM
Re: Select last date check all rows  
433
Pär Nordlund
08/06/2015 03:11AM
Re: Select last date check all rows  
339
Pär Nordlund
08/06/2015 03:13AM
Re: Select last date check all rows  
356
Rick James
08/06/2015 10:36PM
Re: Select last date check all rows  
508
Pär Nordlund
08/07/2015 04:12AM
Re: Select last date check all rows  
427
Rick James
08/08/2015 11:11AM
Number of table Partitions  
1,118
Jawahar muthukrishnan
07/22/2015 01:24PM
Re: Number of table Partitions  
1,463
Rick James
07/24/2015 03:14PM
Re: Number of table Partitions  
586
Jeeva M
07/31/2015 02:15PM
Slow Query Urgent  
1,008
a m
07/23/2015 09:21AM
Re: Slow Query Urgent  
412
Peter Brawley
07/23/2015 10:19AM
Re: Slow Query Urgent  
368
Rick James
07/24/2015 04:00PM
MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU  
1,229
Timothy Mifsud
07/16/2015 07:50AM
Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU  
379
Peter Brawley
07/16/2015 09:39AM
Re: MyISAM INSERT ON DUPLICATE KEY on huge table consumes 100% CPU  
562
Rick James
07/17/2015 04:01PM
SELECT never completes  
1,106
James Cobban
07/06/2015 10:08PM
Re: SELECT never completes  
429
Peter Brawley
07/06/2015 11:51PM
Re: SELECT never completes  
635
James Cobban
07/07/2015 02:16AM
Re: SELECT never completes  
429
Rick James
07/09/2015 12:55AM
5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
1,087
Andy Theuninck
05/21/2015 10:09AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
536
Øystein Grøvlen
05/22/2015 02:19AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
539
Andy Theuninck
05/22/2015 08:15AM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
399
Rick James
06/06/2015 12:30PM
Re: 5.5: UPDATE massively slower than SELECT. Both affect zero rows.  
465
Chandan Kumar
06/26/2015 08:24AM
Performance Issue for select query  
896
amar singh chawan
06/08/2015 04:58AM
Re: Performance Issue for select query  
536
Rick James
06/09/2015 11:42PM
Best Training Institute for Mysql performace tuning and Database scalabulity  
910
amar singh chawan
06/07/2015 11:42PM
Is ORDER BY RAND() LIMIT 1 optimized?  
2,114
Markus M.
05/27/2015 05:40PM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
790
Øystein Grøvlen
05/28/2015 02:18AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
653
Markus M.
05/28/2015 07:22AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
495
Øystein Grøvlen
05/28/2015 07:49AM
Re: Is ORDER BY RAND() LIMIT 1 optimized?  
558
Rick James
06/06/2015 12:16PM
Strange behavior of MySQL server  
993
Deepak Itkar
05/27/2015 07:33AM
Re: Strange behavior of MySQL server  
427
Rick James
06/06/2015 11:51AM
heavy read workload with high cpu usage  
1,368
kim alex
05/28/2015 04:37AM
Re: heavy read workload with high cpu usage  
513
Rick James
06/04/2015 08:35AM
query performance on partitioning table  
1,437
sixin yang
05/12/2015 09:00AM
Re: query performance on partitioning table  
710
Rick James
05/16/2015 11:49PM
Re: query performance on partitioning table  
623
sixin yang
05/18/2015 08:30AM
Re: query performance on partitioning table  
555
Rick James
06/04/2015 08:22AM
Avoid subquery  
1,084
Wolfgang Jacques
05/12/2015 08:40AM
Re: Avoid subquery  
470
Peter Brawley
05/12/2015 11:06AM
Re: Avoid subquery  
437
Wolfgang Jacques
05/12/2015 01:29PM
Re: Avoid subquery  
411
Peter Brawley
05/12/2015 01:41PM
Re: Avoid subquery  
561
Rick James
05/17/2015 12:11AM
MYSQL Table Optimization  
994
Yudhveer Kandukuri
05/13/2015 09:53PM
Re: MYSQL Table Optimization  
403
Rick James
05/15/2015 11:02AM
Slow query  
1,147
Manu Swami
04/21/2015 11:15AM
Re: Slow query  
485
Maulik Parekh
04/22/2015 07:17AM
Re: Slow query  
450
Rick James
04/22/2015 07:05PM
Re: Slow query  
595
Manu Swami
04/23/2015 11:42PM
Re: Slow query  
447
Manu Swami
04/23/2015 11:55PM
Re: Slow query  
438
Rick James
04/24/2015 05:22PM
Re: Slow query  
434
Manu Swami
04/25/2015 02:31AM
Re: Slow query  
514
Manu Swami
04/25/2015 02:41AM
Re: Slow query  
782
Manu Swami
04/25/2015 05:22AM
Re: Slow query  
478
Rick James
04/25/2015 10:42PM
Re: Slow query  
441
Øystein Grøvlen
05/13/2015 03:30AM
Re: Slow query  
549
Manu Swami
04/28/2015 03:40AM
CPU usage extremely high  
1,925
Temu Kinn
04/28/2015 08:55AM
Re: CPU usage extremely high  
880
Temu Kinn
04/28/2015 09:03AM
Re: CPU usage extremely high  
677
Rick James
04/29/2015 05:43PM
Re: CPU usage extremely high  
796
Temu Kinn
05/09/2015 07:22AM
Re: CPU usage extremely high  
614
Temu Kinn
05/09/2015 07:38AM
Re: CPU usage extremely high  
631
Rick James
05/11/2015 06:30PM
Mysql indexes weird behavior  
880
Nikhil Khekade
05/02/2015 02:17AM
Re: Mysql indexes weird behavior  
347
Rick James
05/03/2015 06:21PM
slow query sorting result - sending data  
1,801
Hugo Rodriguez
04/28/2015 07:27PM
Re: slow query sorting result - sending data  
609
Peter Brawley
04/28/2015 10:38PM
Re: slow query sorting result - sending data  
577
Rick James
05/01/2015 10:08PM
PROFILING  
1,086
Khurram Naseem
04/27/2015 04:26AM
Re: PROFILING  
455
Rick James
04/29/2015 06:53PM
Query time difference  
1,323
Ofer Bechar
04/26/2015 07:28AM
Re: Query time difference  
396
Rick James
04/27/2015 02:39PM
Re: Query time difference  
434
Ofer Bechar
04/27/2015 11:29PM
Re: Query time difference  
403
Rick James
04/29/2015 05:50PM
Performance issues with INNODB vs MyISAM  
1,901
Milovan Krivokapic
04/17/2015 01:20PM
Re: Performance issues with INNODB vs MyISAM  
803
Rick James
04/19/2015 01:22PM
Re: Performance issues with INNODB vs MyISAM  
604
Milovan Krivokapic
04/27/2015 11:15AM
Re: Performance issues with INNODB vs MyISAM  
489
Rick James
04/28/2015 10:34AM
Why mysqlslap doesn't return the correct Benchmark time?  
990
Cai Vincent
04/20/2015 08:07AM
Writing at 847 MB/sec ???  
952
Robert Gunther
04/11/2015 05:50AM
Re: Writing at 847 MB/sec ???  
522
Rick James
04/15/2015 11:03PM
Re: Writing at 847 MB/sec ???  
560
Robert Gunther
04/17/2015 08:45AM
Re: Writing at 847 MB/sec ???  
473
Rick James
04/19/2015 01:38PM
Re: Writing at 847 MB/sec ???  
531
Robert Gunther
04/20/2015 01:00AM
Mysql is consuming xtremely high CPU above 1000%  
1,667
Eric Leung
04/11/2015 04:38PM
Re: Mysql is consuming xtremely high CPU above 1000%  
1,187
Eric Leung
04/11/2015 04:47PM
Re: Mysql is consuming xtremely high CPU above 1000%  
759
Rick James
04/15/2015 10:36PM
Re: Mysql is consuming xtremely high CPU above 1000%  
638
Eric Leung
04/16/2015 11:45AM
Re: Mysql is consuming xtremely high CPU above 1000%  
702
Rick James
04/17/2015 08:05PM
Re: Mysql is consuming xtremely high CPU above 1000%  
823
Eric Leung
04/18/2015 06:07AM
Re: Mysql is consuming xtremely high CPU above 1000%  
924
Rick James
04/19/2015 02:19PM
Client to server connection  
898
Dan Toškan
04/14/2015 12:40PM
Re: Client to server connection  
384
Peter Brawley
04/14/2015 11:18PM
Re: Client to server connection  
349
Rick James
04/17/2015 08:09PM
This topic has been moved.:  Mysql NDB Cluster  
36
SRINIVASA RAO PUJARI
04/01/2015 11:23PM
Fast way to have an inparameter match all values? (COALESCE slow)  
1,063
Ola Arwidsson
03/26/2015 06:40AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)  
535
Peter Brawley
03/26/2015 10:45AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)  
499
Ola Arwidsson
03/30/2015 01:22AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)  
543
Ola Arwidsson
03/30/2015 03:27AM
Re: Fast way to have an inparameter match all values? (COALESCE slow)  
444
Peter Brawley
03/30/2015 11:16AM
system table space vs file per table space  
893
jongse park
03/27/2015 12:35AM
Re: system table space vs file per table space  
440
Rick James
03/28/2015 03:36PM
Slow COUNT + GROUP BY  
1,214
Refael Dakar
03/20/2015 07:00AM
Re: Slow COUNT + GROUP BY  
518
Jeremy Smyth
03/20/2015 07:55AM
Re: Slow COUNT + GROUP BY  
496
Refael Dakar
03/20/2015 08:00AM
Re: Slow COUNT + GROUP BY  
482
Rick James
03/22/2015 04:11PM
Re: Slow COUNT + GROUP BY  
457
Refael Dakar
03/23/2015 12:46AM
Re: Slow COUNT + GROUP BY  
564
Øystein Grøvlen
03/23/2015 02:45AM
Re: Slow COUNT + GROUP BY  
641
Matan K
03/23/2015 04:30AM
Re: Slow COUNT + GROUP BY  
581
Øystein Grøvlen
03/23/2015 06:04AM
Re: Slow COUNT + GROUP BY  
458
Matan K
03/23/2015 08:13AM
Re: Slow COUNT + GROUP BY  
488
Øystein Grøvlen
03/24/2015 02:02AM
Re: Slow COUNT + GROUP BY  
460
Matan K
03/24/2015 02:51AM
Re: Slow COUNT + GROUP BY  
515
Øystein Grøvlen
03/24/2015 03:37AM
Query Optimization Needed  
1,079
Devrishi Shandilya
02/11/2015 01:31AM
Re: Query Optimization Needed  
489
Peter Brawley
02/11/2015 12:42PM
Re: Query Optimization Needed  
563
Devrishi Shandilya
02/12/2015 03:51AM
Re: Query Optimization Needed  
534
Peter Brawley
02/12/2015 01:24PM
Re: Query Optimization Needed  
531
Devrishi Shandilya
02/13/2015 06:53AM
Re: Query Optimization Needed  
461
Peter Brawley
02/13/2015 07:36AM
Re: Query Optimization Needed  
472
Rick James
02/14/2015 01:04AM
Re: Query Optimization Needed  
495
Devrishi Shandilya
02/15/2015 11:07PM
Re: Query Optimization Needed  
523
Rick James
02/16/2015 12:15AM
Re: Query Optimization Needed  
435
Peter Brawley
03/13/2015 11:15AM
Exceedingly slow create table performance  
1,580
Ronald Van Iwaarden
03/06/2015 10:51AM
Re: Exceedingly slow create table performance  
684
Rick James
03/07/2015 11:03AM
Re: Exceedingly slow create table performance  
632
Ronald Van Iwaarden
03/09/2015 10:10AM
Left join optimization- query is very slow  
2,271
Devrishi Shandilya
03/05/2015 05:23AM
Re: Left join optimization- query is very slow  
823
Øystein Grøvlen
03/05/2015 09:12AM
Re: Left join optimization- query is very slow  
1,073
Rick James
03/06/2015 06:48PM
Re: Left join optimization- query is very slow  
672
Devrishi Shandilya
03/08/2015 11:32PM
COUNT with GROUP BY, JOIN and SUBQUERY very slow  
1,589
Anderson Scouto da Silva Dan
02/28/2015 03:15AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow  
694
Øystein Grøvlen
03/02/2015 02:05AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow  
514
Øystein Grøvlen
03/02/2015 02:13AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow  
810
Anderson Scouto da Silva Dan
03/02/2015 02:28PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow  
525
Øystein Grøvlen
03/03/2015 01:27AM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow  
579
Rick James
03/02/2015 06:13PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow  
484
Anderson Scouto da Silva Dan
03/02/2015 07:14PM
Re: COUNT with GROUP BY, JOIN and SUBQUERY very slow  
525
Anderson Scouto da Silva Dan
03/02/2015 07:20PM
Slow performance when using LIMIT 1000  
1,118
Christian Esborg
02/25/2015 07:43AM
Re: Slow performance when using LIMIT 1000  
481
Øystein Grøvlen
02/26/2015 04:13AM
Re: Slow performance when using LIMIT 1000  
603
Rick James
02/27/2015 01:09AM
Analyse-Optimize and tablecache  
1,153
Samuel Mutel
02/16/2015 03:49AM
Re: Analyse-Optimize and tablecache  
509
Rick James
02/18/2015 03:54PM
Temp tables on Disk issue  
948
Devrishi Shandilya
02/15/2015 11:17PM
Re: Temp tables on Disk issue  
422
Rick James
02/16/2015 12:19AM
5.6 -> 5.7 - huge jump in memory usage, CentOS 7.  
1,387
Pól Ua Laoínecháin
02/04/2015 08:21PM
Re: 5.6 -> 5.7 - huge jump in memory usage, CentOS 7.  
573
Øystein Grøvlen
02/05/2015 01:51AM
Mysql performance between installation  
1,242
Patrick MORAND
01/16/2015 07:32AM
Re: Mysql performance between installation  
501
Rick James
01/17/2015 11:50AM
Re: Mysql performance between installation  
560
Patrick MORAND
01/19/2015 08:26AM
Re: Mysql performance between installation  
635
Rick James
01/20/2015 04:57PM
Re: Mysql performance between installation  
542
Patrick MORAND
01/21/2015 02:30AM
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.