MySQL Forums
Forum List  »  Performance

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

Subject
Views
Written By
Posted
Sticky:  MySQL 8.0.20 Performance : The New InnoDB Double Write Buffer in Action (1 Posts)  
367
Edwin Desouza
04/30/2020 02:58PM
Sticky:  Book: MySQL 8 Query Performance Tuning (1 Posts)  
361
Edwin Desouza
03/20/2020 10:01PM
Sticky:  MySQL 8.0: EXPLAIN ANALYZE (1 Posts)  
509
Edwin Desouza
10/17/2019 07:16AM
Sticky:  MySQL 8.0: if I should optimize only one query, which one should it be ? (1 Posts)  
509
Edwin Desouza
08/16/2019 10:01AM
Sticky:  MySQL 8.0: Perfomance Benchmarks (1 Posts)  
3,094
Edwin Desouza
05/09/2017 05:24PM
Sticky:  MySQL Performance Schema Benchmarks: OLTP RW (1 Posts)  
1,299
Edwin Desouza
01/26/2017 03:33PM
Sticky:  MySQL 8.0: Performance Schema (1 Posts)  
1,867
Edwin Desouza
09/16/2016 09:07AM
Sticky:  MySQL XProtocol: Asynchronous Query Execution (1 Posts)  
1,781
Edwin Desouza
05/27/2016 03:34PM
Sticky:  MySQL 5.7: Performance Benchmarks -- 1.6million QPS (1 Posts)  
2,891
Edwin Desouza
10/27/2015 08:14AM
Sticky:  MySQL 5.7: includes SYS Schema (metrics, instumentation) (1 Posts)  
2,642
Edwin Desouza
04/10/2015 02:40PM
Sticky:  MySQL Performance Tuning: Deep Dive (1 Posts)  
3,727
Edwin Desouza
02/27/2015 08:09PM
Sticky:  MySQL Workbench: Performance Dashboard (1 Posts)  
3,955
Edwin Desouza
04/01/2014 08:21AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)  
5,480
Edwin Desouza
02/12/2013 06:11PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)  
7,714
Edwin DeSouza
08/04/2011 09:09AM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)  
173,657
Edwin DeSouza
05/25/2006 10:50AM
Deep Dive into MySQL Workload Analysis  
22
Edwin Desouza
02/26/2021 10:25AM
InnoDB Data Locking – Part 3 “Deadlocks”  
38
Edwin Desouza
02/09/2021 10:37AM
MySQL 8.0.23: A 250x improvement to InnoDB Tablespace truncation  
65
Edwin Desouza
01/26/2021 12:56PM
events_statements_summary_by_digest.DIGEST_TEXT includes parse_gcol_expr for slow INSERTs  
122
Lee Marshall
10/09/2020 05:17PM
Re: events_statements_summary_by_digest.DIGEST_TEXT includes parse_gcol_expr for slow INSERTs  
20
Lee Marshall
01/07/2021 04:41PM
Re: events_statements_summary_by_digest.DIGEST_TEXT includes parse_gcol_expr for slow INSERTs  
24
Peter Brawley
01/07/2021 07:02PM
About the IO 、CPU and duation used by the sql statement.  
95
Terry Xia
12/17/2020 09:57PM
Re: About the IO 、CPU and duation used by the sql statement.  
20
Terry Xia
12/21/2020 07:58PM
Re: About the IO 、CPU and duation used by the sql statement.  
21
Peter Brawley
12/22/2020 09:44AM
Mysql 5.5 memory issues.  
122
Alex Titley
10/02/2020 11:26AM
Re: Mysql 5.5 memory issues.  
61
Peter Brawley
10/02/2020 12:21PM
Re: Mysql 5.5 memory issues.  
56
Alex Titley
10/02/2020 01:16PM
Re: Mysql 5.5 memory issues.  
53
Peter Brawley
10/02/2020 10:24PM
Execution Plan of stored procedure/Functions  
134
Sourav Mukherjee
09/29/2020 10:59AM
MySQL + Dynimize: 3.6 Million Queries per Second on a Single VM  
106
Edwin Desouza
09/22/2020 01:11PM
MySQL-8.0 performance degradation vs MySQL-5.7  
211
Eugene Polovnikov
09/10/2020 04:17AM
Re: MySQL-8.0 performance degradation vs MySQL-5.7  
91
Peter Brawley
09/10/2020 09:17AM
Re: MySQL-8.0 performance degradation vs MySQL-5.7  
87
Eugene Polovnikov
09/11/2020 01:19AM
Re: MySQL-8.0 performance degradation vs MySQL-5.7  
88
Peter Brawley
09/11/2020 09:33AM
Query optimization and index suggestion needed  
171
Pandit P
09/09/2020 10:01AM
Re: Query optimization and index suggestion needed  
85
Peter Brawley
09/09/2020 10:34AM
Re: Query optimization and index suggestion needed  
72
Pandit P
09/09/2020 01:08PM
Re: Query optimization and index suggestion needed  
67
Peter Brawley
09/09/2020 02:36PM
Re: Query optimization and index suggestion needed  
67
Pandit P
09/09/2020 11:38PM
How to design my data structure to optimize it.thank you  
155
xiangsheng jiang
09/05/2020 10:14PM
Re: How to design my data structure to optimize it.thank you  
66
Peter Brawley
09/06/2020 11:13AM
Commit is slow in Mysql 5.7  
170
Himanshu Patel
09/05/2020 02:49AM
Re: Commit is slow in Mysql 5.7  
72
Peter Brawley
09/05/2020 01:04PM
MySQL Performance : Understanding InnoDB IO Internals & "Checkpointing"  
143
Edwin Desouza
08/13/2020 06:59PM
MySQL 8.0 Indexes, Histograms, and Other Ways to Speed Up Your Queries  
151
Edwin Desouza
08/04/2020 07:57PM
Speeding up large searches  
156
Greg Knox
08/03/2020 11:07AM
Re: Speeding up large searches  
67
Peter Brawley
08/03/2020 12:23PM
select into outfile by chunk  
174
Wueh Chia Lee
07/16/2020 02:10AM
Re: select into outfile by chunk  
71
Peter Brawley
07/16/2020 10:30AM
MYSQL issues with query performance  
293
Wouter Platteeuw
06/24/2020 02:47PM
Re: MYSQL issues with query performance  
110
Peter Brawley
06/24/2020 06:55PM
Re: MYSQL issues with query performance  
108
Wouter Platteeuw
06/29/2020 06:32AM
Re: MYSQL issues with query performance  
93
Peter Brawley
06/29/2020 02:55PM
Re: MYSQL issues with query performance  
91
Wouter Platteeuw
06/30/2020 06:13AM
Re: MYSQL issues with query performance  
86
Peter Brawley
06/30/2020 08:15AM
Re: MYSQL issues with query performance  
92
Wouter Platteeuw
06/30/2020 10:09AM
Re: MYSQL issues with query performance  
91
Peter Brawley
06/30/2020 03:50PM
Re: MYSQL issues with query performance  
92
Wouter Platteeuw
07/01/2020 08:04AM
MySQL Performance : TPCC "Mystery" [SOLVED]  
209
Edwin Desouza
06/30/2020 04:59PM
slow performance, parameters or size and amounts of databases?  
189
Kristof Schevernels
06/19/2020 08:20AM
Re: slow performance, parameters or size and amounts of databases?  
256
Peter Brawley
06/19/2020 10:37AM
Yet another RAM question  
194
Nuno Donato
05/16/2020 06:18AM
Re: Yet another RAM question  
103
Peter Brawley
05/16/2020 08:48AM
MyISAM move from 5.1 to 5.7 - performance simple SELECT  
177
Christine Antoine
05/13/2020 03:02AM
MySQL DDL performance  
229
Stepan Furman
04/06/2020 05:46AM
Re: MySQL DDL performance  
102
Edwin Desouza
04/30/2020 03:00PM
MySQL 8.0.20 Performance : New InnoDB Double Write Buffer in Action  
197
Edwin Desouza
04/30/2020 02:59PM
Default of (var)binary column shown as hex if query this from information_schema even with --skip-binary-as-hex flag  
630
Stepan Furman
04/02/2020 03:57AM
Long start service MySQL 5.5 on Win 16  
244
Vladimir Gusev
03/30/2020 04:28AM
Re: Long start service MySQL 5.5 on Win 16  
118
Peter Brawley
03/30/2020 08:25AM
Re: Long start service MySQL 5.5 on Win 16  
116
Edwin Desouza
03/30/2020 10:23AM
Performance benchmark  
237
mmmm mmmm
03/16/2020 05:55PM
Re: Performance benchmark  
128
Peter Brawley
03/20/2020 06:21PM
Re: Performance benchmark  
119
Edwin Desouza
03/20/2020 07:38PM
Scaling mysql  
208
mmmm mmmm
03/20/2020 05:15PM
High memory used by MySQL  
429
Damian Kolany
02/12/2020 02:45AM
Re: High memory used by MySQL  
239
Peter Brawley
02/12/2020 11:41AM
Re: High memory used by MySQL  
195
Damian Kolany
02/13/2020 09:24AM
Re: High memory used by MySQL  
185
Peter Brawley
02/13/2020 11:49AM
Re: High memory used by MySQL  
178
Damian Kolany
02/14/2020 09:05AM
Re: High memory used by MySQL  
171
Peter Brawley
02/14/2020 11:06AM
Re: High memory used by MySQL  
169
Damian Kolany
03/02/2020 04:12AM
Re: High memory used by MySQL  
157
Peter Brawley
03/02/2020 04:17PM
Re: High memory used by MySQL  
155
Edwin Desouza
03/02/2020 08:35PM
Re: High memory used by MySQL  
184
Edwin Desouza
03/02/2020 08:36PM
Re: High memory used by MySQL  
144
Damian Kolany
03/03/2020 06:12AM
Re: High memory used by MySQL  
122
Peter Brawley
03/03/2020 11:51AM
SQL performance tuning advice  
310
Oliver C
02/21/2020 09:58AM
Re: SQL performance tuning advice  
132
Peter Brawley
02/21/2020 11:58AM
Re: SQL performance tuning advice  
136
Edwin Desouza
02/21/2020 06:39PM
Re: SQL performance tuning advice  
132
Oliver C
02/22/2020 08:02AM
why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
715
Sudarshan m
01/28/2020 12:09PM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
227
Edwin Desouza
01/28/2020 03:42PM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
180
Sudarshan m
01/29/2020 04:05AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
185
Peter Brawley
01/28/2020 06:42PM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
193
Sudarshan m
01/29/2020 04:02AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
182
Sudarshan m
01/31/2020 04:10AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
193
Peter Brawley
01/31/2020 10:15AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
191
Edwin Desouza
01/31/2020 11:41AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
188
Sudarshan m
02/03/2020 05:01AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
196
Peter Brawley
02/03/2020 11:00AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
164
Sudarshan m
02/06/2020 05:01AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
193
Peter Brawley
02/06/2020 06:50AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
185
Sudarshan m
02/03/2020 04:54AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
170
Frederic Descamps
02/03/2020 12:35PM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
169
Sudarshan m
02/06/2020 04:32AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
175
Frederic Descamps
02/06/2020 11:56PM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
168
Edwin Desouza
02/07/2020 12:03AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
175
Sudarshan m
02/10/2020 09:09AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
189
Peter Brawley
02/10/2020 09:45AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
179
Edwin Desouza
02/10/2020 06:16PM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
284
Sudarshan m
02/11/2020 04:13AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
187
Edwin Desouza
02/11/2020 11:14AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
173
Edwin Desouza
02/11/2020 11:16AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
184
Peter Brawley
02/11/2020 12:45PM
MySQL 8.0: Hash Join  
225
Edwin Desouza
02/09/2020 05:09PM
MySQL Server 5.1 max output  
276
Sugihono Budiman
02/07/2020 10:34AM
Re: MySQL Server 5.1 max output  
124
Peter Brawley
02/07/2020 12:19PM
Re: MySQL Server 5.1 max output  
149
Bobby Male
02/08/2020 08:37AM
Re: MySQL Server 5.1 max output  
129
Peter Brawley
02/08/2020 10:41AM
Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
1,412
anand aundhekar
09/18/2019 11:26PM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
303
Peter Brawley
09/19/2019 09:21AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
272
anand aundhekar
09/20/2019 03:26AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
273
Peter Brawley
09/20/2019 09:57AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
232
anand aundhekar
09/24/2019 03:09AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
250
Peter Brawley
09/24/2019 10:06AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
263
anand aundhekar
10/11/2019 12:18AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
618
Peter Brawley
10/15/2019 02:12PM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
246
anand aundhekar
01/27/2020 12:44AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
219
Peter Brawley
01/27/2020 12:34PM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
177
anand aundhekar
02/06/2020 01:14AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
206
Peter Brawley
02/06/2020 02:28PM
MySQL 5.7 simple count query sometimes fast and sometimes very slow  
492
Li Steven
12/23/2019 02:10AM
Re: MySQL 5.7 simple count query sometimes fast and sometimes very slow  
167
Peter Brawley
01/15/2020 11:55AM
MySQL 8.0: Simple way to figure out why your recursive CTE is running away  
255
Edwin Desouza
01/15/2020 06:06AM
SHOW FULL TABLES - Very Slow  
441
Sreedhar Vengala
12/19/2019 11:18PM
MySQL 8.0: AntiJoin  
268
Edwin Desouza
12/18/2019 07:53AM
Mysql GROUP BY performance realle slow on views  
328
Vincenzo Stigliano
12/15/2019 03:53AM
Re: Mysql GROUP BY performance realle slow on views  
158
Peter Brawley
12/15/2019 10:35AM
Bad order by performance (5.7.12 under Aurora)  
579
Nicola Farina
11/26/2019 03:43AM
Re: Bad order by performance (5.7.12 under Aurora)  
171
Frederic Descamps
11/26/2019 01:46PM
Re: Bad order by performance (5.7.12 under Aurora)  
191
Peter Brawley
11/26/2019 02:05PM
Re: Bad order by performance (5.7.12 under Aurora)  
218
Nicola Farina
11/26/2019 03:29PM
Re: Bad order by performance (5.7.12 under Aurora)  
184
Peter Brawley
11/26/2019 05:00PM
Re: Bad order by performance (5.7.12 under Aurora)  
169
Nicola Farina
11/27/2019 02:03AM
Re: Bad order by performance (5.7.12 under Aurora)  
198
Frederic Descamps
11/27/2019 04:21AM
Re: Bad order by performance (5.7.12 under Aurora)  
191
Nicola Farina
11/27/2019 05:46AM
MySQL 8.0 Performance: Scalability & Benchmarks (2019)  
419
Edwin Desouza
10/02/2019 11:05AM
MySQL Performance Tuning: The Perfect Scalability  
432
Edwin Desouza
09/21/2019 04:16PM
MySQL 8.0 - View Performance  
929
dino cummings
09/20/2019 07:47PM
Re: MySQL 8.0 - View Performance  
396
Peter Brawley
09/20/2019 09:14PM
Re: MySQL 8.0 - View Performance  
224
dino cummings
09/20/2019 10:29PM
Re: MySQL 8.0 - View Performance  
223
Peter Brawley
09/20/2019 11:18PM
Re: MySQL 8.0 - View Performance  
236
dino cummings
09/21/2019 12:18AM
Mysql 8 memory leak  
1,245
Pavel Dvořák
09/17/2019 03:58PM
Re: Mysql 8 memory leak  
339
Peter Brawley
09/17/2019 07:14PM
Re: Mysql 8 memory leak  
697
Pavel Dvořák
09/18/2019 02:41AM
Re: Mysql 8 memory leak  
374
Pavel Dvořák
09/18/2019 02:44AM
Re: Mysql 8 memory leak  
385
Peter Brawley
09/18/2019 09:38AM
Re: Mysql 8 memory leak  
365
Pavel Dvořák
09/19/2019 04:56AM
MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock  
1,611
Christine Antoine
07/17/2019 08:30AM
Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock  
270
Olivier Dasini
07/18/2019 02:55AM
Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock  
278
Christine Antoine
07/18/2019 03:11AM
Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock  
226
Olivier Dasini
07/18/2019 03:52AM
Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock  
247
Christine Antoine
07/18/2019 04:01AM
Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock  
226
Olivier Dasini
07/18/2019 04:09AM
Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock  
231
Christine Antoine
07/18/2019 04:20AM
Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock  
249
Olivier Dasini
07/18/2019 04:28AM
Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock  
238
Christine Antoine
07/18/2019 04:29AM
Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock  
224
james wang
08/19/2019 02:44AM
MySQL8.0.16 TPC-C Benchmark on Persistent Memory  
1,035
Shohei Matsuura
07/12/2019 12:28AM
MySQL 5.6 Maximum Database instance  
914
Edgar Abellana
06/07/2019 07:10PM
Re: MySQL 5.6 Maximum Database instance  
257
Peter Brawley
06/07/2019 07:42PM
Re: MySQL 5.6 Maximum Database instance  
267
Edgar Abellana
06/07/2019 08:46PM
MySQL 8.0: Scalability & Benchmarks  
522
Edwin Desouza
05/31/2019 10:20PM
MySQL 8.0: Performance Tuning  
588
Edwin Desouza
05/31/2019 10:20PM
Help with MYSQL Very high processes.  
903
Miguel Bueno Joshimar
05/14/2019 07:30PM
Re: Help with MYSQL Very high processes.  
280
Peter Brawley
05/14/2019 09:41PM
MySQL 8 - terrible performance  
5,797
Hans Meiser
02/11/2019 02:09AM
Re: MySQL 8 - terrible performance  
1,709
Peter Brawley
02/11/2019 10:47AM
Re: MySQL 8 - terrible performance  
1,500
Edwin Desouza
02/11/2019 11:55AM
Re: MySQL 8 - terrible performance  
1,381
Edwin Desouza
02/11/2019 12:52PM
Re: MySQL 8 - terrible performance  
1,201
Benoit St-Jean
02/11/2019 08:13PM
Re: MySQL 8 - terrible performance  
1,150
Frederic Descamps
02/12/2019 02:59AM
Re: MySQL 8 - terrible performance  
1,204
Hans Meiser
02/13/2019 03:36AM
Re: MySQL 8 - terrible performance  
992
Frederic Descamps
02/14/2019 12:28AM
Re: MySQL 8 - terrible performance  
1,044
Hans Meiser
02/14/2019 03:33AM
Re: MySQL 8 - terrible performance  
903
Frederic Descamps
02/15/2019 03:32AM
Re: MySQL 8 - terrible performance  
912
Hans Meiser
02/15/2019 05:23AM
Re: MySQL 8 - terrible performance  
875
Hans Meiser
03/18/2019 05:19AM
Re: MySQL 8 - terrible performance  
1,160
Edwin Desouza
03/18/2019 10:42AM
Re: MySQL 8 - terrible performance  
1,033
Dimitri Kravtchuk
04/30/2019 02:21PM
This topic has been moved.:  Speeding up large searches  
0
Greg Knox
08/03/2020 12:23PM
This topic has been moved.:  MYSQL issues with query performance  
0
Wouter Platteeuw
06/24/2020 06:21PM
This topic has been moved.:  MySQL 5.6 Maximum Database instance  
0
Edgar Abellana
06/07/2019 07:43PM
This topic has been moved.:  Help with MYSQL Very high processes.  
7
Miguel Bueno Joshimar
05/14/2019 09:32PM
Pages:
1 2 3 4 5
...
76 »

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.