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
...
4 5 6 7 8
...
77 »

Subject
Views
Written By
Posted
How to log slow DMLs  
1,258
Susan Lam
01/10/2017 04:01PM
Re: How to log slow DMLs  
575
Peter Brawley
01/10/2017 04:45PM
Re: How to log slow DMLs  
644
Susan Lam
01/10/2017 06:54PM
Improve performance when Insert into ... select ...  
1,786
Lyu Joey
12/15/2016 03:59AM
Re: Improve performance when Insert into ... select ...  
2,301
Peter Brawley
12/15/2016 10:00AM
Re: Improve performance when Insert into ... select ...  
1,266
Lyu Joey
12/15/2016 07:34PM
Re: Improve performance when Insert into ... select ...  
1,215
Lyu Joey
12/15/2016 08:08PM
Re: Improve performance when Insert into ... select ...  
1,376
Lyu Joey
12/15/2016 08:18PM
Re: Improve performance when Insert into ... select ...  
1,131
Peter Brawley
12/15/2016 09:16PM
Recent Upgrade from MySQL 5.1 to 5.5  
2,017
Alex Titley
12/07/2016 10:22AM
Re: Recent Upgrade from MySQL 5.1 to 5.5  
853
Edwin Desouza
12/07/2016 08:47PM
Re: Recent Upgrade from MySQL 5.1 to 5.5  
835
Alex Titley
12/08/2016 05:07AM
Re: Recent Upgrade from MySQL 5.1 to 5.5  
796
Rick James
12/12/2016 02:08PM
Re: Recent Upgrade from MySQL 5.1 to 5.5  
939
Alex Titley
12/14/2016 07:27AM
Re: Recent Upgrade from MySQL 5.1 to 5.5  
782
Peter Brawley
12/14/2016 08:56AM
Select Query and Two Tables  
1,146
Steve Royle
12/05/2016 09:43AM
Re: Select Query and Two Tables  
1,117
Peter Brawley
12/05/2016 11:01AM
Re: Select Query and Two Tables  
762
Steve Royle
12/07/2016 05:05AM
Performance issues afre upgrading to 5.7  
2,039
Alexandru Badulescu
11/24/2016 08:48AM
Re: Performance issues afre upgrading to 5.7  
1,067
Peter Brawley
11/24/2016 11:32AM
Re: Performance issues afre upgrading to 5.7  
1,029
Øystein Grøvlen
11/25/2016 07:28AM
Re: Performance issues afre upgrading to 5.7  
1,223
Øystein Grøvlen
11/25/2016 06:16AM
Re: Performance issues afre upgrading to 5.7  
917
Alexandru Badulescu
11/25/2016 06:59AM
Re: Performance issues afre upgrading to 5.7  
1,012
Øystein Grøvlen
11/25/2016 07:53AM
Re: Performance issues afre upgrading to 5.7  
989
Rick James
11/25/2016 08:18PM
why select @@session.tx_read_only take long time  
3,499
h h
10/31/2016 01:53AM
Re: why select @@session.tx_read_only take long time  
2,969
Rick James
11/02/2016 11:43AM
Query optimizatoin  
1,181
Syed Anjum
10/26/2016 03:32AM
Re: Query optimizatoin  
741
Øystein Grøvlen
10/26/2016 04:41AM
Writing sample data very fast from (TwinCAT) PLC to a MySQL database?  
1,694
sdgbfdsg fdhgfdhds
10/18/2016 08:14AM
Re: Writing sample data very fast from (TwinCAT) PLC to a MySQL database?  
1,568
Rick James
10/23/2016 12:08AM
How to Analyze and Tune MySQL Queries for Better Performance  
1,089
Edwin Desouza
10/21/2016 09:57AM
Locked queries  
2,177
Juan Nino
09/28/2016 06:31PM
Re: Locked queries  
1,026
Peter Brawley
09/29/2016 09:39AM
MySQL optimisation for single laptop with 16 GB RAM  
1,743
Philip Gladwin
09/08/2016 05:58AM
Re: MySQL optimisation for single laptop with 16 GB RAM  
974
Rick James
09/10/2016 12:17AM
Relationship between MySQL variable open_files_limit and table_open_cache  
1,677
salman khan
09/09/2016 04:34AM
Re: Relationship between MySQL variable open_files_limit and table_open_cache  
1,005
Rick James
09/10/2016 12:13AM
Millions of rows, storing aggregate/rollup results help please  
1,818
Jacqueline Jacobin
08/28/2016 12:23PM
Re: Millions of rows, storing aggregate/rollup results help please  
1,125
Rick James
08/30/2016 02:47PM
Re: Millions of rows, storing aggregate/rollup results help please  
1,016
Jacqueline Jacobin
08/31/2016 07:03AM
Re: Millions of rows, storing aggregate/rollup results help please  
946
Rick James
09/01/2016 04:35PM
Multiple indexes - how do they work?  
1,525
Rathi Rao
08/25/2016 03:51AM
Re: Multiple indexes - how do they work?  
716
Peter Brawley
08/25/2016 11:29AM
Re: Multiple indexes - how do they work?  
783
Rathi Rao
08/29/2016 03:48AM
Re: Multiple indexes - how do they work?  
796
Rick James
08/26/2016 02:20PM
Re: Multiple indexes - how do they work?  
745
Rathi Rao
08/29/2016 03:46AM
Re: Multiple indexes - how do they work?  
942
Øystein Grøvlen
08/29/2016 01:23AM
Re: Multiple indexes - how do they work?  
781
Rathi Rao
08/29/2016 03:45AM
Re: Multiple indexes - how do they work?  
865
Øystein Grøvlen
08/29/2016 04:17AM
Re: Multiple indexes - how do they work?  
744
Rathi Rao
08/29/2016 04:39AM
MySQL Table Valued Parameter  
4,979
tony mendoza
08/23/2016 11:29AM
Re: MySQL Table Valued Parameter  
1,985
Rick James
08/26/2016 02:17PM
Partitioned table details in the Explain Plan  
1,373
Rathi Rao
08/19/2016 01:54AM
Re: Partitioned table details in the Explain Plan  
730
Øystein Grøvlen
08/19/2016 07:00AM
Re: Partitioned table details in the Explain Plan  
789
Rick James
08/20/2016 06:10PM
Rolling unique user counts  
1,550
Paul Stam
08/09/2016 02:06AM
Re: Rolling unique user counts  
889
Rick James
08/14/2016 06:22PM
Re: Rolling unique user counts  
842
Paul Stam
08/15/2016 01:49AM
Re: Rolling unique user counts  
812
Paul Stam
08/18/2016 06:03AM
Re: Rolling unique user counts  
854
Rick James
08/18/2016 04:37PM
Wrong estimation of Rows in explain  
2,050
Rathi Rao
07/27/2016 06:19AM
Re: Wrong estimation of Rows in explain  
1,042
Peter Brawley
07/27/2016 08:55AM
Re: Wrong estimation of Rows in explain  
1,077
Rathi Rao
07/27/2016 11:58PM
Re: Wrong estimation of Rows in explain  
984
Peter Brawley
07/28/2016 09:14AM
Re: Wrong estimation of Rows in explain  
944
Rathi Rao
07/29/2016 05:11AM
Re: Wrong estimation of Rows in explain  
927
Peter Brawley
07/29/2016 01:10PM
Re: Wrong estimation of Rows in explain  
973
Rick James
07/29/2016 06:58PM
Re: Wrong estimation of Rows in explain  
913
Rathi Rao
08/02/2016 05:48AM
Re: Wrong estimation of Rows in explain  
975
Rick James
08/02/2016 06:23PM
Re: Wrong estimation of Rows in explain  
908
Rathi Rao
08/02/2016 05:38AM
Re: Wrong estimation of Rows in explain  
929
james wang
08/04/2016 05:31AM
30 millions reads/day  
1,308
Srinivas K
07/29/2016 05:34AM
Re: 30 millions reads/day  
844
Rick James
07/29/2016 07:03PM
Re: 30 millions reads/day  
796
james wang
08/04/2016 05:15AM
mysql commit slow,please help me  
2,047
jw maple
07/27/2016 02:11AM
Re: mysql commit slow,please help me  
1,024
Rick James
07/29/2016 05:15PM
Very slow query when too many joins  
4,462
As Os
06/05/2016 09:17AM
Re: Very slow query when too many joins  
1,682
As Os
06/05/2016 09:27AM
Re: Very slow query when too many joins  
1,473
Peter Brawley
06/05/2016 10:14AM
Re: Very slow query when too many joins  
1,299
As Os
06/05/2016 10:48AM
Re: Very slow query when too many joins  
1,302
Peter Brawley
06/05/2016 10:56AM
Re: Very slow query when too many joins  
1,281
As Os
06/05/2016 03:33PM
Re: Very slow query when too many joins  
1,133
Peter Brawley
06/05/2016 03:41PM
Re: Very slow query when too many joins  
1,200
Rick James
06/05/2016 05:36PM
Re: Very slow query when too many joins  
1,142
As Os
06/06/2016 02:23AM
Re: Very slow query when too many joins  
1,111
As Os
06/06/2016 03:33AM
Re: Very slow query when too many joins  
985
As Os
06/06/2016 08:36AM
Re: Very slow query when too many joins  
1,082
Peter Brawley
06/06/2016 08:52AM
Re: Very slow query when too many joins  
1,150
As Os
06/06/2016 09:02AM
Re: Very slow query when too many joins  
1,120
Peter Brawley
06/06/2016 11:16AM
Re: Very slow query when too many joins  
1,224
Peter Brawley
06/06/2016 08:29AM
Re: Very slow query when too many joins  
1,062
As Os
06/06/2016 11:30AM
Re: Very slow query when too many joins  
1,137
Peter Brawley
06/06/2016 12:08PM
Re: Very slow query when too many joins  
1,089
As Os
06/06/2016 02:11PM
Re: Very slow query when too many joins  
1,104
Rick James
06/07/2016 03:40PM
Re: Very slow query when too many joins  
1,167
james wang
07/20/2016 05:34AM
Re: Very slow query when too many joins  
1,131
Rick James
07/20/2016 09:37AM
Re: Very slow query when too many joins  
1,197
james wang
07/21/2016 04:43AM
Re: Very slow query when too many joins  
1,036
Rick James
07/22/2016 10:59PM
MySQL data volume  
1,245
Parfait Fortuné NDOLO
07/21/2016 10:21AM
Re: MySQL data volume  
757
Peter Brawley
07/21/2016 11:41PM
Re: MySQL data volume  
888
Rick James
07/22/2016 10:57PM
Query optimize on large database  
1,481
Pavel Volkov
07/13/2016 01:40AM
Re: Query optimize on large database  
893
Rick James
07/15/2016 05:12PM
Re: Query optimize on large database  
872
Pavel Volkov
07/16/2016 04:15AM
Re: Query optimize on large database  
804
Peter Brawley
07/16/2016 12:09PM
Re: Query optimize on large database  
878
Pavel Volkov
07/16/2016 12:36PM
Re: Query optimize on large database  
812
Rick James
07/16/2016 02:46PM
Re: Query optimize on large database  
889
Peter Brawley
07/17/2016 11:22AM
Re: Query optimize on large database  
847
Pavel Volkov
07/18/2016 04:28AM
Re: Query optimize on large database  
820
Peter Brawley
07/18/2016 08:40AM
Re: Query optimize on large database  
797
james wang
07/20/2016 04:46AM
Re: Query optimize on large database  
864
Pavel Volkov
07/20/2016 08:06AM
Re: Query optimize on large database  
852
Rick James
07/20/2016 09:29AM
Re: Query optimize on large database  
851
james wang
07/21/2016 04:35AM
Unexplained very bad subquery performance  
1,712
Arnaud Bertrand
07/18/2016 04:29AM
Re: Unexplained very bad subquery performance  
905
Peter Brawley
07/18/2016 08:44AM
Re: Unexplained very bad subquery performance  
1,020
Arnaud Bertrand
07/18/2016 01:06PM
Re: Unexplained very bad subquery performance  
843
Peter Brawley
07/18/2016 03:30PM
Re: Unexplained very bad subquery performance  
942
Arnaud Bertrand
07/19/2016 03:16AM
Re: Unexplained very bad subquery performance  
847
Peter Brawley
07/19/2016 04:21AM
Re: Unexplained very bad subquery performance  
861
james wang
07/20/2016 04:35AM
specify conditions from outer query on a materialized subquery  
1,239
Pratik Gandhi
07/12/2016 10:55PM
Re: specify conditions from outer query on a materialized subquery  
716
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,437
Ra Nala
06/28/2016 06:22AM
Re: count(*) or count(id)  
1,447
Ra Nala
06/28/2016 06:26AM
Re: count(*) or count(id)  
1,260
Peter Brawley
06/28/2016 05:18PM
Re: count(*) or count(id)  
1,380
Rick James
07/04/2016 01:04PM
Re: count(*) or count(id)  
1,018
Ra Nala
07/06/2016 12:30AM
CREATE INDEX Online DDL Not Working  
1,623
Jayanath Dissanayake
06/20/2016 05:02AM
Re: CREATE INDEX Online DDL Not Working  
920
Øystein Grøvlen
06/22/2016 12:43AM
Re: CREATE INDEX Online DDL Not Working  
861
Rick James
06/23/2016 07:07PM
Select random rows when using UUID  
2,901
Jonathan Keen
06/09/2016 11:43AM
Re: Select random rows when using UUID  
2,007
Rick James
06/13/2016 01:36AM
Re: Select random rows when using UUID  
1,302
Jonathan Keen
06/14/2016 11:23AM
Re: Select random rows when using UUID  
1,121
Rick James
06/18/2016 01:35AM
SQLSTATE[HY000] [1044] Access denied  
10,743
YOONTAE KIM
06/16/2016 07:55PM
Index Not being used.  
2,850
Greg Mundt
05/26/2016 02:29PM
Re: Index Not being used.  
1,290
Peter Brawley
05/26/2016 03:53PM
Re: Index Not being used.  
1,131
Øystein Grøvlen
05/27/2016 12:45AM
Re: Index Not being used.  
1,041
Greg Mundt
05/27/2016 07:05AM
Re: Index Not being used.  
1,041
Rick James
05/27/2016 11:29PM
Re: Index Not being used.  
1,156
Greg Mundt
05/31/2016 07:04AM
Re: Index Not being used.  
995
Rick James
05/31/2016 09:26PM
Re: Index Not being used.  
1,050
Greg Mundt
06/01/2016 05:40AM
Re: Index Not being used.  
861
Rick James
06/01/2016 11:29AM
Re: Index Not being used.  
1,092
Greg Mundt
06/01/2016 11:41AM
Re: Index Not being used.  
1,031
Rick James
06/04/2016 05:14PM
Re: Index Not being used.  
1,055
Greg Mundt
05/27/2016 10:14AM
A proposal to make disk IO much faster under SSD  
1,860
suiyemin sui
05/29/2016 09:16PM
Re: A proposal to make disk IO much faster under SSD  
1,061
Rick James
05/31/2016 09:48PM
Re: A proposal to make disk IO much faster under SSD  
983
suiyemin sui
06/01/2016 02:05AM
Re: A proposal to make disk IO much faster under SSD  
934
Rick James
06/04/2016 04:38PM
query taking really long time.  
1,464
Mehraz Ahmed Sheikh
05/16/2016 09:45AM
Re: query taking really long time.  
872
Rick James
05/23/2016 02:58PM
Left join vs Inner join  
2,032
Vikas Sood
05/09/2016 06:10PM
Re: Left join vs Inner join  
1,089
Øystein Grøvlen
05/10/2016 08:04AM
Re: Left join vs Inner join  
990
Vikas Sood
05/10/2016 10:40AM
Re: Left join vs Inner join  
974
Rick James
05/10/2016 07:23PM
How can I improve the import speed of a large SQL file?  
21,122
Jeff Vincent
05/06/2016 09:46AM
Re: How can I improve the import speed of a large SQL file?  
8,157
Peter Brawley
05/06/2016 11:49AM
Re: How can I improve the import speed of a large SQL file?  
5,432
Jeff Vincent
05/06/2016 12:17PM
Re: How can I improve the import speed of a large SQL file?  
5,222
Rick James
05/06/2016 05:44PM
Re: How can I improve the import speed of a large SQL file?  
4,612
Shane Bester
05/08/2016 04:49AM
text vs varchar  
2,794
hua kai
04/28/2016 08:36AM
Re: text vs varchar  
2,483
Øystein Grøvlen
04/29/2016 12:41AM
Re: text vs varchar  
1,745
Rick James
04/30/2016 11:51PM
Re: text vs varchar  
1,606
Øystein Grøvlen
05/02/2016 04:37AM
Re: text vs varchar  
1,405
hua kai
05/02/2016 09:14PM
Re: text vs varchar  
1,539
Øystein Grøvlen
05/03/2016 02:19AM
Re: text vs varchar  
2,557
hua kai
05/03/2016 04:12AM
Re: text vs varchar  
1,471
hua kai
05/02/2016 08:02PM
Re: text vs varchar  
1,686
Øystein Grøvlen
05/03/2016 02:25AM
Query with 2 x subquery  
1,796
Jes Ramsing
04/29/2016 06:44AM
Re: Query with 2 x subquery  
949
Øystein Grøvlen
04/29/2016 08:01AM
Re: Query with 2 x subquery  
952
Jes Ramsing
05/01/2016 11:57PM
Re: Query with 2 x subquery  
994
Øystein Grøvlen
05/02/2016 03:45AM
Re: Query with 2 x subquery  
989
Jes Ramsing
05/02/2016 05:32AM
Re: Query with 2 x subquery  
967
Rick James
05/01/2016 11:58PM
Re: Query with 2 x subquery  
1,026
Jes Ramsing
05/02/2016 02:16AM
Slow Query, Optimization Advice Needed  
1,702
Michael Lawson
04/26/2016 09:30AM
Re: Slow Query, Optimization Advice Needed  
878
Øystein Grøvlen
04/27/2016 01:02AM
Re: Slow Query, Optimization Advice Needed  
1,013
Michael Lawson
04/27/2016 07:20PM
Re: Slow Query, Optimization Advice Needed  
804
Peter Brawley
04/27/2016 11:28PM
Re: Slow Query, Optimization Advice Needed  
1,002
Øystein Grøvlen
04/28/2016 01:25AM
Re: Slow Query, Optimization Advice Needed  
925
Rick James
05/01/2016 11:47PM
Re: Slow Query, Optimization Advice Needed  
923
Øystein Grøvlen
05/02/2016 01:28AM
Re: Slow Query, Optimization Advice Needed  
961
Øystein Grøvlen
04/28/2016 01:12AM
Reg table design and query performances  
1,645
Devrishi Shandilya
04/26/2016 03:02AM
Re: Reg table design and query performances  
928
Øystein Grøvlen
04/26/2016 06:02AM
Re: Reg table design and query performances  
1,052
Devrishi Shandilya
04/26/2016 06:16AM
Re: Reg table design and query performances  
914
Øystein Grøvlen
04/26/2016 06:35AM
Re: Reg table design and query performances  
874
Devrishi Shandilya
04/26/2016 06:50AM
Re: Reg table design and query performances  
1,048
Øystein Grøvlen
04/26/2016 07:04AM
Re: Reg table design and query performances  
774
Rick James
04/30/2016 11:46PM
Re: Reg table design and query performances  
833
Øystein Grøvlen
05/02/2016 01:00AM
Memory benefits of huge pages  
4,923
Olga Turetskaya
04/30/2016 11:21AM
Re: Memory benefits of huge pages  
2,180
Rick James
05/01/2016 02:36PM
Configuration review requested  
2,184
Jens Meier
04/13/2016 11:55AM
Re: Configuration review requested  
890
Rick James
04/14/2016 01:39PM
block_ops_in and block_ops_out meaning  
4,792
hua kai
03/18/2016 02:33AM
Re: block_ops_in and block_ops_out meaning  
2,094
Rick James
03/21/2016 11:34PM
Re: block_ops_in and block_ops_out meaning  
2,090
Peter Brawley
03/22/2016 02:03AM
Re: block_ops_in and block_ops_out meaning  
2,034
hua kai
03/25/2016 12:30AM
Re: block_ops_in and block_ops_out meaning  
1,807
hua kai
04/14/2016 12:52AM
order by primary key slowly  
2,774
varky chan
04/05/2016 10:42PM
Re: order by primary key slowly  
1,230
Øystein Grøvlen
04/06/2016 04:35AM
Re: order by primary key slowly  
1,205
varky chan
04/06/2016 10:15AM
Re: order by primary key slowly  
1,236
Peter Brawley
04/06/2016 11:23AM
Re: order by primary key slowly  
1,338
varky chan
04/06/2016 08:11PM
Re: order by primary key slowly  
1,269
Peter Brawley
04/06/2016 10:35PM
Re: order by primary key slowly  
1,245
varky chan
04/07/2016 12:34AM
Re: order by primary key slowly  
3,628
Øystein Grøvlen
04/07/2016 07:21AM
Re: order by primary key slowly  
1,304
Peter Brawley
04/07/2016 10:20AM
Re: order by primary key slowly  
1,214
varky chan
04/07/2016 11:26PM
Re: order by primary key slowly  
1,317
Rick James
04/12/2016 07:42PM
Re: order by primary key slowly  
1,175
Peter Brawley
04/06/2016 08:57AM
Re: order by primary key slowly  
1,194
varky chan
04/06/2016 10:17AM
[INNODB] why there are many "waiting for table level lock"?  
1,654
HANWEN YIN
04/11/2016 12:08AM
Re: [INNODB] why there are many "waiting for table level lock"?  
1,025
Rick James
04/12/2016 07:27PM
Improve performance when altering huge tables  
2,106
Davide Cicuta
04/04/2016 07:24AM
Re: Improve performance when altering huge tables  
1,073
Rick James
04/05/2016 02:59PM
MySql 5.7 - Poor Performance PURGE BINARY LOGS  
2,575
Davy Campano
03/23/2016 08:08PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS  
1,114
Rick James
03/26/2016 11:58PM
Re: MySql 5.7 - Poor Performance PURGE BINARY LOGS  
1,118
Davy Campano
03/29/2016 09:44AM
where the snapshot for select in transaction stored  
1,401
hua kai
03/21/2016 03:03AM
Re: where the snapshot for select in transaction stored  
811
Rick James
03/21/2016 11:21PM
Difference execution plans for same query  
1,841
Devrishi Shandilya
02/25/2016 12:05AM
Re: Difference execution plans for same query  
963
Peter Brawley
02/25/2016 01:51AM
Re: Difference execution plans for same query  
986
Øystein Grøvlen
02/25/2016 03:51AM
Re: Difference execution plans for same query  
971
Rick James
03/05/2016 01:19AM
Slow join performance  
1,845
Ra Nala
11/27/2015 04:55AM
Re: Slow join performance  
1,051
Rick James
11/28/2015 03:02PM
Re: Slow join performance  
1,003
Ra Nala
02/25/2016 06:22AM
which is best for JOIN approach  
1,700
Ra Nala
11/24/2015 09:39AM
Re: which is best for JOIN approach  
1,032
Øystein Grøvlen
11/25/2015 02:14AM
Re: which is best for JOIN approach  
1,077
Ra Nala
11/25/2015 02:42AM
Re: which is best for JOIN approach  
1,092
Rick James
11/29/2015 11:53AM
Re: which is best for JOIN approach  
958
Ra Nala
02/19/2016 05:28AM
Re: which is best for JOIN approach  
902
Peter Brawley
02/21/2016 04:56PM
Re: which is best for JOIN approach  
995
Ra Nala
02/19/2016 05:31AM
Re: which is best for JOIN approach  
877
Rick James
02/21/2016 01:40PM
Re: which is best for JOIN approach  
932
Rick James
02/21/2016 01:43PM
Re: which is best for JOIN approach  
928
Ra Nala
02/25/2016 05:50AM
This topic has been moved.:  MySQL optimisation for single laptop with 16 GB RAM  
0
Philip Gladwin
09/08/2016 09:41AM
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.