MySQL Forums
Forum List  »  Performance
Announcements Last Post
•   Announcing July 2024 off-cycle Releases featuring MySQL Server 9.0.1 Innovation, 8.4.2 LTS and 8.0.39 07/24/2024 11:15AM
•   Announcing July 2024 Releases featuring MySQL Server 9.0.0 Innovation, 8.4.1 LTS and 8.0.38 07/02/2024 06:42AM

Advanced Search
New Topic
Pages:
« 1
...
7 8 9 10 11
...
77 »

Subject
Views
Written By
Posted
UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?  
2,370
Daniel Chiaramello
12/04/2014 05:05AM
Re: UPDATE .. WHERE or INSERT .. ON DUPLICATE KEY UPDATE?  
1,324
Rick James
12/06/2014 02:40PM
Write Operations very slow in InnoDB engine when compared to MyIsam  
1,710
MURALI NARAYANASWAMY
11/28/2014 07:07AM
Re: Write Operations very slow in InnoDB engine when compared to MyIsam  
711
Rick James
11/28/2014 06:59PM
Cardinality Problem  
1,613
Katja Kahl
11/26/2014 06:53AM
Re: Cardinality Problem  
770
Peter Brawley
11/26/2014 12:03PM
Re: Cardinality Problem  
720
Katja Kahl
11/27/2014 03:08AM
Re: Cardinality Problem  
688
Rick James
11/28/2014 06:56PM
Reduce the Query Execution Time Between MYSQL & VC++  
2,014
saraswathi srinath
11/12/2014 05:01AM
Re: Reduce the Query Execution Time Between MYSQL & VC++  
869
Rick James
11/13/2014 06:50PM
Re: Reduce the Query Execution Time Between MYSQL & VC++  
915
saraswathi srinath
11/13/2014 10:29PM
Re: Reduce the Query Execution Time Between MYSQL & VC++  
845
Rick James
11/14/2014 07:55PM
Re: Reduce the Query Execution Time Between MYSQL & VC++  
1,042
saraswathi srinath
11/14/2014 10:33PM
Re: Reduce the Query Execution Time Between MYSQL & VC++  
811
Rick James
11/15/2014 08:43PM
Re: Reduce the Query Execution Time Between MYSQL & VC++  
910
saraswathi srinath
11/16/2014 10:19PM
Re: Reduce the Query Execution Time Between MYSQL & VC++  
896
saraswathi srinath
11/16/2014 10:37PM
Re: Reduce the Query Execution Time Between MYSQL & VC++  
746
Rick James
11/17/2014 08:06PM
Re: Reduce the Query Execution Time Between MYSQL & VC++  
804
saraswathi srinath
11/19/2014 11:09PM
Re: Reduce the Query Execution Time Between MYSQL & VC++  
808
Rick James
11/20/2014 07:59PM
Which server hardware would you pick?  
1,647
Robert Gunther
11/14/2014 08:24PM
Re: Which server hardware would you pick?  
870
Rick James
11/15/2014 08:46PM
Re: Which server hardware would you pick?  
795
Robert Gunther
11/16/2014 06:25PM
Re: Which server hardware would you pick?  
774
Rick James
11/17/2014 03:42PM
Re: Which server hardware would you pick?  
976
Robert Gunther
11/18/2014 09:08AM
Re: Which server hardware would you pick?  
744
Rick James
11/19/2014 05:02PM
MySQL query execution time differs between executions  
3,506
Ofer Bechar
11/16/2014 09:49AM
Re: MySQL query execution time differs between executions  
1,093
Peter Brawley
11/16/2014 12:19PM
Re: MySQL query execution time differs between executions  
1,091
Rick James
11/16/2014 03:24PM
Re: MySQL query execution time differs between executions  
1,099
Ofer Bechar
11/17/2014 02:57AM
Re: MySQL query execution time differs between executions  
1,326
Rick James
11/17/2014 04:09PM
Re: MySQL query execution time differs between executions  
1,064
Ofer Bechar
11/17/2014 02:30AM
Why INSERT performance has not increase in sub-table?  
2,592
Yao Yao
11/03/2014 03:02AM
Re: Why INSERT performance has not increase in sub-table?  
819
Dexter Yao
11/03/2014 09:07AM
Re: Why INSERT performance has not increase in sub-table?  
896
Rick James
11/03/2014 09:31AM
Re: Why INSERT performance has not increase in sub-table?  
836
Dexter Yao
11/03/2014 11:56AM
Re: Why INSERT performance has not increase in sub-table?  
981
Rick James
11/03/2014 01:12PM
Re: Why INSERT performance has not increase in sub-table?  
829
Dexter Yao
11/03/2014 09:43PM
Re: Why INSERT performance has not increase in sub-table?  
968
Rick James
11/04/2014 08:57AM
Re: Why INSERT performance has not increase in sub-table?  
786
Dexter Yao
11/05/2014 04:39AM
Performance of insert on duplicate key update  
9,749
Ravi Malghan
10/23/2014 02:03PM
Re: Performance of insert on duplicate key update  
4,538
Rick James
10/24/2014 10:39AM
Re: Performance of insert on duplicate key update  
3,167
Ravi Malghan
10/24/2014 11:54AM
Re: Performance of insert on duplicate key update  
3,197
Rick James
10/25/2014 12:51PM
Re: Performance of insert on duplicate key update  
2,515
Ravi Malghan
10/27/2014 07:44AM
Re: Performance of insert on duplicate key update  
2,593
Rick James
10/28/2014 11:33AM
Re: Performance of insert on duplicate key update  
1,901
Ravi Malghan
11/04/2014 06:40AM
msyql 5.0.22 and multi-core server support  
2,190
Christine Ross
10/31/2014 10:30AM
Re: msyql 5.0.22 and multi-core server support  
1,019
Peter Brawley
10/31/2014 11:14AM
Re: msyql 5.0.22 and multi-core server support  
934
Christine Ross
10/31/2014 01:38PM
Re: msyql 5.0.22 and multi-core server support  
1,285
Rick James
11/02/2014 09:33AM
GROUP causing Using Temporary Using Filesort  
24,810
RT Lee
07/31/2014 02:35PM
Re: GROUP causing Using Temporary Using Filesort  
7,026
Peter Brawley
07/31/2014 03:24PM
Re: GROUP causing Using Temporary Using Filesort  
5,463
RT Lee
07/31/2014 05:45PM
Re: GROUP causing Using Temporary Using Filesort  
4,872
Rick James
08/01/2014 04:45PM
Re: GROUP causing Using Temporary Using Filesort  
3,460
RT Lee
08/01/2014 08:26PM
Re: GROUP causing Using Temporary Using Filesort  
3,055
Rick James
08/01/2014 11:45PM
Re: GROUP causing Using Temporary Using Filesort  
2,883
RT Lee
08/02/2014 08:23AM
Re: GROUP causing Using Temporary Using Filesort  
3,127
Rick James
08/02/2014 12:44PM
Re: GROUP causing Using Temporary Using Filesort  
2,024
Leonardo Duque
10/30/2014 12:57PM
Leonardo, please do not hijack threads  
1,481
Peter Brawley
10/31/2014 11:15AM
Eliminate filesort in update query  
2,565
Matzz -
09/23/2014 02:48AM
Re: Eliminate filesort in update query  
1,019
Rick James
09/23/2014 09:59PM
Re: Eliminate filesort in update query  
951
Matzz -
09/24/2014 01:25AM
Re: Eliminate filesort in update query  
997
Rick James
09/24/2014 08:40PM
Re: Eliminate filesort in update query  
1,000
Matzz -
09/25/2014 05:48AM
Re: Eliminate filesort in update query  
933
Rick James
09/26/2014 04:39PM
Re: Eliminate filesort in update query  
981
Matzz -
10/01/2014 06:49AM
Re: Eliminate filesort in update query  
1,001
Rick James
10/03/2014 10:09PM
Re: Eliminate filesort in update query  
1,029
Matzz -
10/04/2014 03:13AM
How to get fast Performance during Insert Large Volume of records into table  
2,121
Jeetu Gaur
09/26/2014 06:48AM
Re: How to get fast Performance during Insert Large Volume of records into table  
987
Rick James
09/27/2014 08:16AM
Slow response time due queries  
5,408
Jens Meier
09/23/2014 01:32AM
Re: Slow response time due queries  
1,767
Rick James
09/23/2014 10:11PM
PHP/MySQL to use all CPU/memory to increase performance  
2,920
Caleb Pitman
09/21/2014 11:04AM
Re: PHP/MySQL to use all CPU/memory to increase performance  
1,150
Rick James
09/22/2014 03:39PM
Re: PHP/MySQL to use all CPU/memory to increase performance  
1,244
Caleb Pitman
09/22/2014 04:55PM
Re: PHP/MySQL to use all CPU/memory to increase performance  
1,294
Rick James
09/23/2014 03:21PM
How to set mysql CPU affinity?  
5,779
Metal Messiah
09/21/2014 01:33PM
Re: How to set mysql CPU affinity?  
2,504
Rick James
09/22/2014 03:25PM
Re: How to set mysql CPU affinity?  
2,334
Sophia Parsons
09/23/2014 01:30AM
Re: How to set mysql CPU affinity?  
2,019
Rick James
09/23/2014 11:03AM
Query optimization to reduce execution time.  
2,093
Neetu Nayak
09/22/2014 07:33AM
Re: Query optimization to reduce execution time.  
985
Rick James
09/22/2014 08:46PM
Re: Query optimization to reduce execution time.  
790
Neetu Nayak
09/23/2014 12:38AM
Re: Query optimization to reduce execution time.  
928
Neetu Nayak
09/23/2014 01:42AM
Mass Update optimization  
2,608
Susan Lin
09/14/2014 06:00PM
Re: Mass Update optimization  
1,045
Rick James
09/15/2014 11:38AM
Re: Mass Update optimization  
1,009
Sophia Parsons
09/23/2014 01:36AM
Optimising query with composite index, which says using where  
1,726
Timothy Mifsud
09/06/2014 12:38AM
Re: Optimising query with composite index, which says using where  
726
Timothy Mifsud
09/06/2014 01:53AM
Re: Optimising query with composite index, which says using where  
756
Rick James
09/07/2014 10:46PM
Re: Optimising query with composite index, which says using where  
734
Øystein Grøvlen
09/15/2014 06:03AM
Re: Optimising query with composite index, which says using where  
825
Rick James
09/15/2014 10:03AM
Slow Performance with Multi-threaded app  
1,796
Minesh Desai
09/12/2014 09:24AM
Re: Slow Performance with Multi-threaded app  
843
Rick James
09/13/2014 09:47AM
InnoDB and locking, UPDATE and SELECT  
1,807
Andreas Greulich
09/10/2014 01:18AM
Re: InnoDB and locking, UPDATE and SELECT  
758
Rick James
09/13/2014 12:09AM
MySQL using too much CPU  
2,233
31 Special
08/29/2014 05:12PM
Re: MySQL using too much CPU  
1,015
Rick James
08/30/2014 05:27PM
Re: MySQL using too much CPU  
1,132
31 Special
08/31/2014 10:13PM
Understanding Explain  
1,771
J M
08/27/2014 07:31AM
Re: Understanding Explain  
815
Peter Brawley
08/27/2014 10:35AM
Re: Understanding Explain  
768
J M
08/27/2014 10:51AM
Re: Understanding Explain  
772
Øystein Grøvlen
08/28/2014 03:00PM
Re: Understanding Explain  
716
Rick James
08/29/2014 09:45PM
Need help to otimize my query  
1,502
GAURAV JAIN
08/21/2014 07:28AM
Re: Need help to otimize my query  
824
Rick James
08/24/2014 09:17PM
Slow response in MY SQL 5.5.1.8  
1,585
Amila Kumara
07/16/2014 01:30AM
Re: Slow response in MY SQL 5.5.1.8  
881
Rick James
07/16/2014 09:04PM
Re: Slow response in MY SQL 5.5.1.8  
902
Amila Kumara
07/21/2014 05:02AM
Re: Slow response in MY SQL 5.5.1.8  
830
Rick James
07/23/2014 12:19AM
Help in tuning MySQL 5.6 database  
1,720
Deepak Dambe
07/17/2014 05:26AM
Re: Help in tuning MySQL 5.6 database  
840
Rick James
07/18/2014 12:12PM
Query slows down over time  
2,367
Sameer Shah
05/28/2014 09:35AM
Re: Query slows down over time  
1,206
Peter Brawley
05/28/2014 12:45PM
Re: Query slows down over time  
1,046
Sameer Shah
05/28/2014 01:24PM
Re: Query slows down over time  
1,129
Rick James
05/28/2014 04:57PM
Re: Query slows down over time  
1,180
Sameer Shah
05/28/2014 05:46PM
Re: Query slows down over time  
1,121
Rick James
05/28/2014 07:23PM
Re: Query slows down over time  
3,722
Sam Shah
05/29/2014 05:38AM
Re: Query slows down over time  
1,454
Rick James
05/29/2014 09:49AM
Re: Query slows down over time  
1,293
Sam Shah
05/29/2014 03:12PM
Re: Query slows down over time  
1,401
Sam Shah
07/15/2014 12:10PM
Re: Query slows down over time  
1,141
Peter Brawley
07/15/2014 12:33PM
Re: Query slows down over time  
1,058
Rick James
07/16/2014 11:19AM
Performance problem with outer join  
1,932
RT Lee
07/11/2014 07:53AM
Re: Performance problem with outer join  
778
Peter Brawley
07/11/2014 09:26AM
Re: Performance problem with outer join  
846
Rick James
07/11/2014 04:26PM
Re: Performance problem with outer join  
865
RT Lee
07/13/2014 12:29PM
Where to look for server freezes  
1,511
Michael Muratet
07/10/2014 10:08AM
Re: Where to look for server freezes  
663
Rick James
07/11/2014 04:14PM
Slow query when joining 2 very large tables with Group and Order  
1,956
bolden kintaro
06/20/2014 07:30AM
Re: Slow query when joining 2 very large tables with Group and Order  
1,010
Øystein Grøvlen
06/23/2014 04:02AM
Re: Slow query when joining 2 very large tables with Group and Order  
1,475
bolden kintaro
06/24/2014 01:26AM
Re: Slow query when joining 2 very large tables with Group and Order  
900
Øystein Grøvlen
06/24/2014 02:28AM
Re: Slow query when joining 2 very large tables with Group and Order  
1,077
Rick James
06/26/2014 08:25PM
sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance  
6,364
Bill Plimpton
06/23/2014 04:52PM
Re: sync_binlog=1 and innodb_flush_log_at_trx_commit = 1 killing write performance  
1,639
Rick James
06/26/2014 06:19PM
MySQL hangs due to large delete  
2,074
Akshay Viswanathan
06/25/2014 08:51AM
Re: MySQL hangs due to large delete  
746
Rick James
06/26/2014 06:13PM
Superkey vs Primary Key  
5,174
Mario Schill
06/16/2014 04:13AM
Re: Superkey vs Primary Key  
1,492
Peter Brawley
06/16/2014 10:42AM
Re: Superkey vs Primary Key  
1,052
Mario Schill
06/17/2014 12:57AM
Re: Superkey vs Primary Key  
1,079
Peter Brawley
06/17/2014 03:42AM
DML operations slow down  
1,834
Sivaprakash Gopal
06/04/2014 04:43PM
Re: DML operations slow down  
924
Rick James
06/06/2014 09:18AM
how to configure my.cnf for mysql 5.1, using too much cpu?  
2,872
Aamir Sohail
06/05/2014 06:15AM
Re: how to configure my.cnf for mysql 5.1, using too much cpu?  
1,207
Rick James
06/06/2014 09:09AM
'Compound' INDEXes  
1,968
lee fei
06/04/2014 03:24AM
Re: 'Compound' INDEXes  
947
Rick James
06/05/2014 09:12PM
Delete slow... randomly  
2,851
Francesco De Carlo
06/02/2014 09:15AM
Re: Delete slow... randomly  
1,106
Rick James
06/03/2014 09:51AM
Re: Delete slow... randomly  
1,063
Francesco De Carlo
06/04/2014 03:43AM
Re: Delete slow... randomly  
926
Rick James
06/05/2014 08:01PM
concurrent_insert  
1,484
Ben Zhou
06/01/2014 08:15AM
Re: concurrent_insert  
992
Rick James
06/02/2014 11:53AM
Re: concurrent_insert  
833
Ben Zhou
06/04/2014 08:37AM
Re: concurrent_insert  
915
Rick James
06/05/2014 07:55PM
Queriy taking long time in OTRS  
2,782
Rajkumar D
05/29/2014 03:53AM
Re: Queriy taking long time in OTRS  
946
Rajkumar D
05/29/2014 01:11PM
Re: Queriy taking long time in OTRS  
2,947
Rick James
05/30/2014 10:41AM
Re: Queriy taking long time in OTRS  
1,130
Rajkumar D
05/30/2014 12:45PM
Re: Queriy taking long time in OTRS  
1,409
Øystein Grøvlen
06/02/2014 03:52AM
Query attacks against read-only database  
1,498
joe blake
05/29/2014 09:46PM
Re: Query attacks against read-only database  
797
Rick James
05/31/2014 08:04AM
my.cnf file with mysql tuner  
3,448
maurizio ca
05/26/2014 03:03AM
Re: my.cnf file with mysql tuner  
1,615
Rick James
05/26/2014 07:29PM
Out of memory - on any moderate query  
1,662
rol and
05/23/2014 12:58PM
Re: Out of memory - on any moderate query  
993
Peter Brawley
05/23/2014 10:59PM
Re: Out of memory - on any moderate query  
875
Rick James
05/24/2014 03:18PM
Low priority SELECT  
3,429
Glas Host
05/21/2014 07:18AM
Re: Low priority SELECT  
1,466
Rick James
05/24/2014 03:05PM
Performance improvement with my.cnf configs  
2,234
Manohar K
04/23/2014 10:23AM
Re: Performance improvement with my.cnf configs  
910
Rick James
04/24/2014 08:08PM
Re: Performance improvement with my.cnf configs  
962
Manohar K
04/24/2014 09:41PM
Re: Performance improvement with my.cnf configs  
943
Rick James
04/25/2014 08:24PM
Re: Performance improvement with my.cnf configs  
765
Manohar K
05/06/2014 10:22AM
Adding index kills query  
2,316
Robert Stafford
04/23/2014 06:10PM
Re: Adding index kills query  
1,034
Robert Stafford
04/23/2014 06:14PM
Re: Adding index kills query  
1,076
Øystein Grøvlen
04/24/2014 02:44AM
Re: Adding index kills query  
1,214
Robert Stafford
04/24/2014 09:07AM
Re: Adding index kills query  
1,031
Øystein Grøvlen
04/25/2014 07:39AM
Re: Adding index kills query  
1,151
Robert Stafford
04/25/2014 11:54AM
Re: Adding index kills query  
1,077
Rick James
04/25/2014 02:25PM
Re: Adding index kills query  
1,136
Øystein Grøvlen
04/28/2014 06:06AM
Re: Adding index kills query  
950
Peter Brawley
04/24/2014 09:37AM
Re: Adding index kills query  
999
Robert Stafford
04/24/2014 06:31PM
Re: Adding index kills query  
1,280
Peter Brawley
04/24/2014 07:10PM
Re: Adding index kills query  
1,106
Robert Stafford
04/24/2014 07:19PM
Re: Adding index kills query  
1,250
Rick James
04/25/2014 10:55AM
Re: Adding index kills query  
960
Øystein Grøvlen
04/25/2014 11:02PM
Re: Adding index kills query  
1,914
Robert Stafford
04/27/2014 07:53PM
Re: Adding index kills query  
1,038
Peter Brawley
04/27/2014 08:50PM
Re: Adding index kills query  
1,024
Rick James
04/27/2014 09:00PM
No response to SELECT with IN clause  
2,198
James Cobban
04/21/2014 06:39PM
Re: No response to SELECT with IN clause  
866
Peter Brawley
04/21/2014 09:54PM
Re: No response to SELECT with IN clause  
861
Rick James
04/22/2014 12:01AM
Recommended changes to my.cnf  
2,171
W B
04/19/2014 01:56PM
Re: Recommended changes to my.cnf  
956
Rick James
04/20/2014 04:53PM
Re: Recommended changes to my.cnf  
1,010
W B
04/20/2014 05:01PM
Re: Recommended changes to my.cnf  
915
Rick James
04/21/2014 11:24PM
MySQL MyISAM sorting query makes it slower  
2,238
Timothy Mifsud
04/13/2014 03:06AM
Re: MySQL MyISAM sorting query makes it slower  
923
Rick James
04/13/2014 10:39PM
Re: MySQL MyISAM sorting query makes it slower  
961
Timothy Mifsud
04/14/2014 02:10AM
Re: MySQL MyISAM sorting query makes it slower  
1,268
Rick James
04/14/2014 12:23PM
Re: MySQL MyISAM sorting query makes it slower  
1,045
Timothy Mifsud
04/14/2014 04:13PM
Re: MySQL MyISAM sorting query makes it slower  
846
Rick James
04/14/2014 07:01PM
Re: MySQL MyISAM sorting query makes it slower  
950
Timothy Mifsud
04/15/2014 01:00PM
Re: MySQL MyISAM sorting query makes it slower  
878
Rick James
04/16/2014 12:26PM
MySQL query with timestamp not using index  
5,726
Bruno Miguel
04/11/2014 11:52AM
Re: MySQL query with timestamp not using index  
1,819
Bruno Miguel
04/11/2014 12:35PM
Re: MySQL query with timestamp not using index  
1,892
Rick James
04/12/2014 09:49AM
Re: MySQL query with timestamp not using index  
2,491
Bruno Miguel
04/14/2014 08:17AM
Re: MySQL query with timestamp not using index  
1,851
Rick James
04/15/2014 03:21PM
MySQL MyISAM - Insert takes much longer on LIVE environment than locally  
1,809
Timothy Mifsud
04/14/2014 08:40AM
Re: MySQL MyISAM - Insert takes much longer on LIVE environment than locally  
754
Edwin Desouza
04/14/2014 09:16AM
Re: MySQL MyISAM - Insert takes much longer on LIVE environment than locally  
799
Timothy Mifsud
04/14/2014 02:33PM
MySQL 5.5 who is creating temp tables on disk  
1,438
Till Brinkmann
04/08/2014 02:36AM
Re: MySQL 5.5 who is creating temp tables on disk  
807
Øystein Grøvlen
04/09/2014 05:58AM
Re: MySQL 5.5 who is creating temp tables on disk  
896
Rick James
04/09/2014 02:30PM
Pages:
« 1
...
7 8 9 10 11
...
77 »

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.