MySQL Forums
Forum List  »  Performance
Announcements Last Post
•   Announcing January 2023 Releases featuring MySQL 8.0.32 01/17/2023 10:40PM

Advanced Search
New Topic
Pages:
« 1
...
4 5 6 7 8
...
77 »

Subject
Views
Written By
Posted
mysql commit slow,please help me  
1,849
jw maple
07/27/2016 02:11AM
Re: mysql commit slow,please help me  
955
Rick James
07/29/2016 05:15PM
Very slow query when too many joins  
4,088
As Os
06/05/2016 09:17AM
Re: Very slow query when too many joins  
1,536
As Os
06/05/2016 09:27AM
Re: Very slow query when too many joins  
1,368
Peter Brawley
06/05/2016 10:14AM
Re: Very slow query when too many joins  
1,175
As Os
06/05/2016 10:48AM
Re: Very slow query when too many joins  
1,194
Peter Brawley
06/05/2016 10:56AM
Re: Very slow query when too many joins  
1,115
As Os
06/05/2016 03:33PM
Re: Very slow query when too many joins  
1,036
Peter Brawley
06/05/2016 03:41PM
Re: Very slow query when too many joins  
1,081
Rick James
06/05/2016 05:36PM
Re: Very slow query when too many joins  
1,053
As Os
06/06/2016 02:23AM
Re: Very slow query when too many joins  
1,011
As Os
06/06/2016 03:33AM
Re: Very slow query when too many joins  
905
As Os
06/06/2016 08:36AM
Re: Very slow query when too many joins  
945
Peter Brawley
06/06/2016 08:52AM
Re: Very slow query when too many joins  
1,032
As Os
06/06/2016 09:02AM
Re: Very slow query when too many joins  
1,014
Peter Brawley
06/06/2016 11:16AM
Re: Very slow query when too many joins  
1,115
Peter Brawley
06/06/2016 08:29AM
Re: Very slow query when too many joins  
1,001
As Os
06/06/2016 11:30AM
Re: Very slow query when too many joins  
1,033
Peter Brawley
06/06/2016 12:08PM
Re: Very slow query when too many joins  
1,008
As Os
06/06/2016 02:11PM
Re: Very slow query when too many joins  
1,019
Rick James
06/07/2016 03:40PM
Re: Very slow query when too many joins  
1,037
james wang
07/20/2016 05:34AM
Re: Very slow query when too many joins  
1,000
Rick James
07/20/2016 09:37AM
Re: Very slow query when too many joins  
1,008
james wang
07/21/2016 04:43AM
Re: Very slow query when too many joins  
946
Rick James
07/22/2016 10:59PM
MySQL data volume  
1,160
Parfait Fortuné NDOLO
07/21/2016 10:21AM
Re: MySQL data volume  
719
Peter Brawley
07/21/2016 11:41PM
Re: MySQL data volume  
830
Rick James
07/22/2016 10:57PM
Query optimize on large database  
1,366
Pavel Volkov
07/13/2016 01:40AM
Re: Query optimize on large database  
792
Rick James
07/15/2016 05:12PM
Re: Query optimize on large database  
774
Pavel Volkov
07/16/2016 04:15AM
Re: Query optimize on large database  
735
Peter Brawley
07/16/2016 12:09PM
Re: Query optimize on large database  
799
Pavel Volkov
07/16/2016 12:36PM
Re: Query optimize on large database  
762
Rick James
07/16/2016 02:46PM
Re: Query optimize on large database  
800
Peter Brawley
07/17/2016 11:22AM
Re: Query optimize on large database  
779
Pavel Volkov
07/18/2016 04:28AM
Re: Query optimize on large database  
740
Peter Brawley
07/18/2016 08:40AM
Re: Query optimize on large database  
731
james wang
07/20/2016 04:46AM
Re: Query optimize on large database  
795
Pavel Volkov
07/20/2016 08:06AM
Re: Query optimize on large database  
748
Rick James
07/20/2016 09:29AM
Re: Query optimize on large database  
777
james wang
07/21/2016 04:35AM
Unexplained very bad subquery performance  
1,476
Arnaud Bertrand
07/18/2016 04:29AM
Re: Unexplained very bad subquery performance  
803
Peter Brawley
07/18/2016 08:44AM
Re: Unexplained very bad subquery performance  
872
Arnaud Bertrand
07/18/2016 01:06PM
Re: Unexplained very bad subquery performance  
766
Peter Brawley
07/18/2016 03:30PM
Re: Unexplained very bad subquery performance  
861
Arnaud Bertrand
07/19/2016 03:16AM
Re: Unexplained very bad subquery performance  
771
Peter Brawley
07/19/2016 04:21AM
Re: Unexplained very bad subquery performance  
763
james wang
07/20/2016 04:35AM
specify conditions from outer query on a materialized subquery  
1,118
Pratik Gandhi
07/12/2016 10:55PM
Re: specify conditions from outer query on a materialized subquery  
637
Rick James
07/15/2016 05:15PM
This topic has been moved.:  GOT PACKETS OUT OF ORDER  
12
Jeisson Sierra
07/11/2016 07:48PM
count(*) or count(id)  
4,014
Ra Nala
06/28/2016 06:22AM
Re: count(*) or count(id)  
1,280
Ra Nala
06/28/2016 06:26AM
Re: count(*) or count(id)  
1,084
Peter Brawley
06/28/2016 05:18PM
Re: count(*) or count(id)  
1,223
Rick James
07/04/2016 01:04PM
Re: count(*) or count(id)  
926
Ra Nala
07/06/2016 12:30AM
CREATE INDEX Online DDL Not Working  
1,372
Jayanath Dissanayake
06/20/2016 05:02AM
Re: CREATE INDEX Online DDL Not Working  
808
Øystein Grøvlen
06/22/2016 12:43AM
Re: CREATE INDEX Online DDL Not Working  
780
Rick James
06/23/2016 07:07PM
Select random rows when using UUID  
2,456
Jonathan Keen
06/09/2016 11:43AM
Re: Select random rows when using UUID  
1,752
Rick James
06/13/2016 01:36AM
Re: Select random rows when using UUID  
1,196
Jonathan Keen
06/14/2016 11:23AM
Re: Select random rows when using UUID  
1,020
Rick James
06/18/2016 01:35AM
SQLSTATE[HY000] [1044] Access denied  
9,934
YOONTAE KIM
06/16/2016 07:55PM
Index Not being used.  
2,671
Greg Mundt
05/26/2016 02:29PM
Re: Index Not being used.  
1,200
Peter Brawley
05/26/2016 03:53PM
Re: Index Not being used.  
1,050
Øystein Grøvlen
05/27/2016 12:45AM
Re: Index Not being used.  
964
Greg Mundt
05/27/2016 07:05AM
Re: Index Not being used.  
949
Rick James
05/27/2016 11:29PM
Re: Index Not being used.  
1,069
Greg Mundt
05/31/2016 07:04AM
Re: Index Not being used.  
903
Rick James
05/31/2016 09:26PM
Re: Index Not being used.  
967
Greg Mundt
06/01/2016 05:40AM
Re: Index Not being used.  
772
Rick James
06/01/2016 11:29AM
Re: Index Not being used.  
995
Greg Mundt
06/01/2016 11:41AM
Re: Index Not being used.  
924
Rick James
06/04/2016 05:14PM
Re: Index Not being used.  
962
Greg Mundt
05/27/2016 10:14AM
A proposal to make disk IO much faster under SSD  
1,662
suiyemin sui
05/29/2016 09:16PM
Re: A proposal to make disk IO much faster under SSD  
964
Rick James
05/31/2016 09:48PM
Re: A proposal to make disk IO much faster under SSD  
906
suiyemin sui
06/01/2016 02:05AM
Re: A proposal to make disk IO much faster under SSD  
824
Rick James
06/04/2016 04:38PM
query taking really long time.  
1,302
Mehraz Ahmed Sheikh
05/16/2016 09:45AM
Re: query taking really long time.  
783
Rick James
05/23/2016 02:58PM
Left join vs Inner join  
1,778
Vikas Sood
05/09/2016 06:10PM
Re: Left join vs Inner join  
972
Øystein Grøvlen
05/10/2016 08:04AM
Re: Left join vs Inner join  
884
Vikas Sood
05/10/2016 10:40AM
Re: Left join vs Inner join  
857
Rick James
05/10/2016 07:23PM
How can I improve the import speed of a large SQL file?  
20,099
Jeff Vincent
05/06/2016 09:46AM
Re: How can I improve the import speed of a large SQL file?  
7,876
Peter Brawley
05/06/2016 11:49AM
Re: How can I improve the import speed of a large SQL file?  
5,227
Jeff Vincent
05/06/2016 12:17PM
Re: How can I improve the import speed of a large SQL file?  
4,961
Rick James
05/06/2016 05:44PM
Re: How can I improve the import speed of a large SQL file?  
4,403
Shane Bester
05/08/2016 04:49AM
text vs varchar  
2,467
hua kai
04/28/2016 08:36AM
Re: text vs varchar  
2,094
Øystein Grøvlen
04/29/2016 12:41AM
Re: text vs varchar  
1,545
Rick James
04/30/2016 11:51PM
Re: text vs varchar  
1,421
Øystein Grøvlen
05/02/2016 04:37AM
Re: text vs varchar  
1,319
hua kai
05/02/2016 09:14PM
Re: text vs varchar  
1,354
Øystein Grøvlen
05/03/2016 02:19AM
Re: text vs varchar  
2,317
hua kai
05/03/2016 04:12AM
Re: text vs varchar  
1,321
hua kai
05/02/2016 08:02PM
Re: text vs varchar  
1,526
Øystein Grøvlen
05/03/2016 02:25AM
Query with 2 x subquery  
1,668
Jes Ramsing
04/29/2016 06:44AM
Re: Query with 2 x subquery  
861
Øystein Grøvlen
04/29/2016 08:01AM
Re: Query with 2 x subquery  
828
Jes Ramsing
05/01/2016 11:57PM
Re: Query with 2 x subquery  
902
Øystein Grøvlen
05/02/2016 03:45AM
Re: Query with 2 x subquery  
872
Jes Ramsing
05/02/2016 05:32AM
Re: Query with 2 x subquery  
860
Rick James
05/01/2016 11:58PM
Re: Query with 2 x subquery  
904
Jes Ramsing
05/02/2016 02:16AM
Slow Query, Optimization Advice Needed  
1,537
Michael Lawson
04/26/2016 09:30AM
Re: Slow Query, Optimization Advice Needed  
785
Øystein Grøvlen
04/27/2016 01:02AM
Re: Slow Query, Optimization Advice Needed  
903
Michael Lawson
04/27/2016 07:20PM
Re: Slow Query, Optimization Advice Needed  
730
Peter Brawley
04/27/2016 11:28PM
Re: Slow Query, Optimization Advice Needed  
867
Øystein Grøvlen
04/28/2016 01:25AM
Re: Slow Query, Optimization Advice Needed  
829
Rick James
05/01/2016 11:47PM
Re: Slow Query, Optimization Advice Needed  
807
Øystein Grøvlen
05/02/2016 01:28AM
Re: Slow Query, Optimization Advice Needed  
877
Øystein Grøvlen
04/28/2016 01:12AM
Reg table design and query performances  
1,507
Devrishi Shandilya
04/26/2016 03:02AM
Re: Reg table design and query performances  
813
Øystein Grøvlen
04/26/2016 06:02AM
Re: Reg table design and query performances  
977
Devrishi Shandilya
04/26/2016 06:16AM
Re: Reg table design and query performances  
833
Øystein Grøvlen
04/26/2016 06:35AM
Re: Reg table design and query performances  
773
Devrishi Shandilya
04/26/2016 06:50AM
Re: Reg table design and query performances  
851
Øystein Grøvlen
04/26/2016 07:04AM
Re: Reg table design and query performances  
700
Rick James
04/30/2016 11:46PM
Re: Reg table design and query performances  
739
Øystein Grøvlen
05/02/2016 01:00AM
Memory benefits of huge pages  
4,631
Olga Turetskaya
04/30/2016 11:21AM
Re: Memory benefits of huge pages  
2,098
Rick James
05/01/2016 02:36PM
Configuration review requested  
1,956
Jens Meier
04/13/2016 11:55AM
Re: Configuration review requested  
814
Rick James
04/14/2016 01:39PM
block_ops_in and block_ops_out meaning  
4,171
hua kai
03/18/2016 02:33AM
Re: block_ops_in and block_ops_out meaning  
1,964
Rick James
03/21/2016 11:34PM
Re: block_ops_in and block_ops_out meaning  
1,899
Peter Brawley
03/22/2016 02:03AM
Re: block_ops_in and block_ops_out meaning  
1,896
hua kai
03/25/2016 12:30AM
Re: block_ops_in and block_ops_out meaning  
1,635
hua kai
04/14/2016 12:52AM
order by primary key slowly  
2,385
varky chan
04/05/2016 10:42PM
Re: order by primary key slowly  
1,097
Øystein Grøvlen
04/06/2016 04:35AM
Re: order by primary key slowly  
1,061
varky chan
04/06/2016 10:15AM
Re: order by primary key slowly  
1,097
Peter Brawley
04/06/2016 11:23AM
Re: order by primary key slowly  
1,170
varky chan
04/06/2016 08:11PM
Re: order by primary key slowly  
1,140
Peter Brawley
04/06/2016 10:35PM
Re: order by primary key slowly  
1,071
varky chan
04/07/2016 12:34AM
Re: order by primary key slowly  
3,009
Øystein Grøvlen
04/07/2016 07:21AM
Re: order by primary key slowly  
1,146
Peter Brawley
04/07/2016 10:20AM
Re: order by primary key slowly  
1,027
varky chan
04/07/2016 11:26PM
Re: order by primary key slowly  
1,153
Rick James
04/12/2016 07:42PM
Re: order by primary key slowly  
1,046
Peter Brawley
04/06/2016 08:57AM
Re: order by primary key slowly  
1,029
varky chan
04/06/2016 10:17AM
[INNODB] why there are many "waiting for table level lock"?  
1,495
HANWEN YIN
04/11/2016 12:08AM
Re: [INNODB] why there are many "waiting for table level lock"?  
953
Rick James
04/12/2016 07:27PM
Improve performance when altering huge tables  
1,844
Davide Cicuta
04/04/2016 07:24AM
Re: Improve performance when altering huge tables  
964
Rick James
04/05/2016 02:59PM
MySql 5.7 - Poor Performance PURGE BINARY LOGS  
2,269
Davy Campano
03/23/2016 08:08PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS  
1,029
Rick James
03/26/2016 11:58PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS  
991
Davy Campano
03/29/2016 09:44AM
where the snapshot for select in transaction stored  
1,265
hua kai
03/21/2016 03:03AM
Re: where the snapshot for select in transaction stored  
753
Rick James
03/21/2016 11:21PM
Difference execution plans for same query  
1,670
Devrishi Shandilya
02/25/2016 12:05AM
Re: Difference execution plans for same query  
854
Peter Brawley
02/25/2016 01:51AM
Re: Difference execution plans for same query  
874
Øystein Grøvlen
02/25/2016 03:51AM
Re: Difference execution plans for same query  
868
Rick James
03/05/2016 01:19AM
Slow join performance  
1,673
Ra Nala
11/27/2015 04:55AM
Re: Slow join performance  
980
Rick James
11/28/2015 03:02PM
Re: Slow join performance  
834
Ra Nala
02/25/2016 06:22AM
which is best for JOIN approach  
1,551
Ra Nala
11/24/2015 09:39AM
Re: which is best for JOIN approach  
937
Øystein Grøvlen
11/25/2015 02:14AM
Re: which is best for JOIN approach  
965
Ra Nala
11/25/2015 02:42AM
Re: which is best for JOIN approach  
961
Rick James
11/29/2015 11:53AM
Re: which is best for JOIN approach  
883
Ra Nala
02/19/2016 05:28AM
Re: which is best for JOIN approach  
827
Peter Brawley
02/21/2016 04:56PM
Re: which is best for JOIN approach  
890
Ra Nala
02/19/2016 05:31AM
Re: which is best for JOIN approach  
780
Rick James
02/21/2016 01:40PM
Re: which is best for JOIN approach  
832
Rick James
02/21/2016 01:43PM
Re: which is best for JOIN approach  
851
Ra Nala
02/25/2016 05:50AM
Why is wrong index being selected  
1,241
Steve Bell
02/23/2016 01:54PM
Re: Why is wrong index being selected  
721
Rick James
02/23/2016 11:39PM
Re: Why is wrong index being selected  
867
Øystein Grøvlen
02/24/2016 03:22AM
Re: Why is wrong index being selected  
719
Steve Bell
02/25/2016 02:47AM
Distinct or Group by which is faster  
1,658
Ra Nala
02/22/2016 08:50AM
Re: Distinct or Group by which is faster  
842
Peter Brawley
02/22/2016 12:33PM
Re: Distinct or Group by which is faster  
802
Chandan Kumar
02/23/2016 12:51PM
MySQL server is not disk bound, how do I make it faster?  
1,374
Robert Gunther
02/21/2016 09:35PM
Re: MySQL server is not disk bound, how do I make it faster?  
646
Peter Brawley
02/22/2016 12:38PM
Re: MySQL server is not disk bound, how do I make it faster?  
702
Rick James
02/22/2016 06:18PM
mysql text datatype SELECT query slow even with tmp dir on tmpfs  
1,304
Muhammad Omair
02/22/2016 08:36AM
Re: mysql text datatype SELECT query slow even with tmp dir on tmpfs  
652
Peter Brawley
02/22/2016 12:35PM
How can I improve this table and query  
1,787
Adam Copley
02/17/2016 04:49AM
Re: How can I improve this table and query  
828
Øystein Grøvlen
02/17/2016 06:07AM
Re: How can I improve this table and query  
893
Adam Copley
02/17/2016 08:25AM
Re: How can I improve this table and query  
635
Adam Copley
02/17/2016 08:26AM
Re: How can I improve this table and query  
757
Øystein Grøvlen
02/17/2016 08:51AM
Re: How can I improve this table and query  
1,208
Adam Copley
02/17/2016 09:03AM
Re: How can I improve this table and query  
718
Rick James
02/21/2016 11:14PM
Does prefixing field names with their table name improve query speed?  
1,292
Guillaume TRUCHOT
02/18/2016 04:02PM
Re: Does prefixing field names with their table name improve query speed?  
698
Peter Brawley
02/18/2016 05:21PM
Re: Does prefixing field names with their table name improve query speed?  
737
Rick James
02/21/2016 07:19PM
slow response when where clause has a field from 2nd table in a left join  
1,255
Ravi Malghan
02/12/2016 12:51PM
Re: slow response when where clause has a field from 2nd table in a left join  
819
Øystein Grøvlen
02/15/2016 02:10AM
Re: slow response when where clause has a field from 2nd table in a left join  
642
Rick James
02/15/2016 04:17PM
Re: slow response when where clause has a field from 2nd table in a left join  
605
Ravi Malghan
02/19/2016 10:18AM
max_allowed_packet error  
1,893
Ra Nala
02/02/2016 05:12AM
Re: max_allowed_packet error  
706
Rick James
02/06/2016 07:26PM
Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)  
1,559
Bill Joyce
12/06/2015 11:41PM
Re: Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)  
833
Mayank Prasad
12/10/2015 03:53AM
Re: Getting NULL digest_text for all queries in 2 of my 3 DBs (performance_schema)  
913
Bill Joyce
02/04/2016 04:15PM
query performance optimization  
2,014
Devrishi Shandilya
01/18/2016 04:49AM
Re: query performance optimization  
821
Øystein Grøvlen
01/19/2016 02:30AM
Re: query performance optimization  
788
Devrishi Shandilya
01/19/2016 02:50AM
Re: query performance optimization  
1,388
Øystein Grøvlen
01/19/2016 06:24AM
Re: query performance optimization  
891
Rick James
01/22/2016 06:29PM
Re: query performance optimization  
843
Øystein Grøvlen
01/29/2016 04:37AM
Re: query performance optimization  
1,225
Devrishi Shandilya
01/22/2016 06:18AM
Re: query performance optimization  
738
Øystein Grøvlen
01/27/2016 06:56AM
Re: query performance optimization  
778
Peter Brawley
01/22/2016 01:08PM
Re: query performance optimization  
806
Peter Brawley
01/22/2016 11:10PM
Slow performance on join query using indexes  
1,924
Amit Kapoor
01/21/2016 02:36PM
Re: Slow performance on join query using indexes  
1,061
Øystein Grøvlen
01/22/2016 03:02AM
Re: Slow performance on join query using indexes  
836
Rick James
01/23/2016 07:43PM
high cpu on request with JOIN  
1,436
Gérard Moisset
01/15/2016 03:49AM
Re: high cpu on request with JOIN  
717
Øystein Grøvlen
01/15/2016 05:43AM
Lock wait timeout exceeded; try restarting transaction  
11,868
Ra Nala
01/07/2016 05:28AM
Re: Lock wait timeout exceeded; try restarting transaction  
2,852
Rick James
01/07/2016 10:47PM
Re: Lock wait timeout exceeded; try restarting transaction  
2,811
Ra Nala
01/08/2016 12:45AM
Re: Lock wait timeout exceeded; try restarting transaction  
2,037
Ra Nala
01/08/2016 06:23AM
Re: Lock wait timeout exceeded; try restarting transaction  
2,123
Rick James
01/09/2016 11:52PM
1 blob table vs multiple blob tables  
1,416
charles candy
01/08/2016 01:03AM
Re: 1 blob table vs multiple blob tables  
711
Benoit St-Jean
01/08/2016 02:26AM
Thread State - Query End  
4,244
Simon Green
01/04/2016 11:50AM
Re: Thread State - Query End  
1,846
Øystein Grøvlen
01/05/2016 03:09AM
Re: Thread State - Query End  
1,332
Øystein Grøvlen
01/06/2016 02:28AM
thread_cache_size: Need suggestion on this paramateer  
1,307
Gnanasekar A.
12/26/2015 10:49AM
Re: thread_cache_size: Need suggestion on this paramateer  
713
Rick James
12/27/2015 10:17AM
query hangs after migration from mysql 5.5 to mysql 5.6  
1,702
walter verdelocco
12/19/2015 12:00PM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
987
walter verdelocco
12/19/2015 01:21PM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
769
Rick James
12/20/2015 07:31PM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
762
walter verdelocco
12/21/2015 06:38AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
760
Øystein Grøvlen
12/21/2015 03:41AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
704
walter verdelocco
12/21/2015 06:40AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
773
Øystein Grøvlen
12/21/2015 07:22AM
Re: query hangs after migration from mysql 5.5 to mysql 5.6  
719
walter verdelocco
12/22/2015 01:57AM
how to find out all sql and table of running transaction  
1,502
elison chen
12/17/2015 01:30AM
Re: how to find out all sql and table of running transaction  
692
Øystein Grøvlen
12/17/2015 03:08AM
show open tables in_use is high  
1,936
elison chen
12/15/2015 07:23PM
Re: show open tables in_use is high  
773
Rick James
12/16/2015 08:08PM
Pages:
« 1
...
4 5 6 7 8
...
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.