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)  
400
Edwin Desouza
04/30/2020 02:58PM
Sticky:  Book: MySQL 8 Query Performance Tuning (1 Posts)  
404
Edwin Desouza
03/20/2020 10:01PM
Sticky:  MySQL 8.0: EXPLAIN ANALYZE (1 Posts)  
533
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)  
532
Edwin Desouza
08/16/2019 10:01AM
Sticky:  MySQL 8.0: Perfomance Benchmarks (1 Posts)  
3,185
Edwin Desouza
05/09/2017 05:24PM
Sticky:  MySQL Performance Schema Benchmarks: OLTP RW (1 Posts)  
1,314
Edwin Desouza
01/26/2017 03:33PM
Sticky:  MySQL 8.0: Performance Schema (1 Posts)  
1,897
Edwin Desouza
09/16/2016 09:07AM
Sticky:  MySQL XProtocol: Asynchronous Query Execution (1 Posts)  
1,803
Edwin Desouza
05/27/2016 03:34PM
Sticky:  MySQL 5.7: Performance Benchmarks -- 1.6million QPS (1 Posts)  
2,918
Edwin Desouza
10/27/2015 08:14AM
Sticky:  MySQL 5.7: includes SYS Schema (metrics, instumentation) (1 Posts)  
2,672
Edwin Desouza
04/10/2015 02:40PM
Sticky:  MySQL Performance Tuning: Deep Dive (1 Posts)  
3,756
Edwin Desouza
02/27/2015 08:09PM
Sticky:  MySQL Workbench: Performance Dashboard (1 Posts)  
3,982
Edwin Desouza
04/01/2014 08:21AM
Sticky:  MySQL 5.6: Performance Benchmarks (1 Posts)  
5,510
Edwin Desouza
02/12/2013 06:11PM
Sticky:  Finding/killing long running InnoDB transactions (1 Posts)  
7,732
Edwin DeSouza
08/04/2011 09:09AM
Sticky:  MySQL Performance Tuning: Benchmarks, Best Practices, FAQs (1 Posts)  
173,789
Edwin DeSouza
05/25/2006 10:50AM
Memory saturated MySQL  
54
Edwin Desouza
03/16/2021 08:57AM
Re: Memory saturated MySQL  
13
Peter Brawley
03/16/2021 10:34AM
Deep Dive into MySQL Workload Analysis  
43
Edwin Desouza
02/26/2021 10:25AM
InnoDB Data Locking – Part 3 “Deadlocks”  
56
Edwin Desouza
02/09/2021 10:37AM
MySQL 8.0.23: A 250x improvement to InnoDB Tablespace truncation  
86
Edwin Desouza
01/26/2021 12:56PM
events_statements_summary_by_digest.DIGEST_TEXT includes parse_gcol_expr for slow INSERTs  
168
Lee Marshall
10/09/2020 05:17PM
Re: events_statements_summary_by_digest.DIGEST_TEXT includes parse_gcol_expr for slow INSERTs  
34
Lee Marshall
01/07/2021 04:41PM
Re: events_statements_summary_by_digest.DIGEST_TEXT includes parse_gcol_expr for slow INSERTs  
39
Peter Brawley
01/07/2021 07:02PM
About the IO 、CPU and duation used by the sql statement.  
135
Terry Xia
12/17/2020 09:57PM
Re: About the IO 、CPU and duation used by the sql statement.  
36
Terry Xia
12/21/2020 07:58PM
Re: About the IO 、CPU and duation used by the sql statement.  
34
Peter Brawley
12/22/2020 09:44AM
Mysql 5.5 memory issues.  
151
Alex Titley
10/02/2020 11:26AM
Re: Mysql 5.5 memory issues.  
80
Peter Brawley
10/02/2020 12:21PM
Re: Mysql 5.5 memory issues.  
75
Alex Titley
10/02/2020 01:16PM
Re: Mysql 5.5 memory issues.  
72
Peter Brawley
10/02/2020 10:24PM
Execution Plan of stored procedure/Functions  
159
Sourav Mukherjee
09/29/2020 10:59AM
MySQL + Dynimize: 3.6 Million Queries per Second on a Single VM  
121
Edwin Desouza
09/22/2020 01:11PM
MySQL-8.0 performance degradation vs MySQL-5.7  
248
Eugene Polovnikov
09/10/2020 04:17AM
Re: MySQL-8.0 performance degradation vs MySQL-5.7  
107
Peter Brawley
09/10/2020 09:17AM
Re: MySQL-8.0 performance degradation vs MySQL-5.7  
102
Eugene Polovnikov
09/11/2020 01:19AM
Re: MySQL-8.0 performance degradation vs MySQL-5.7  
101
Peter Brawley
09/11/2020 09:33AM
Query optimization and index suggestion needed  
192
Pandit P
09/09/2020 10:01AM
Re: Query optimization and index suggestion needed  
101
Peter Brawley
09/09/2020 10:34AM
Re: Query optimization and index suggestion needed  
83
Pandit P
09/09/2020 01:08PM
Re: Query optimization and index suggestion needed  
79
Peter Brawley
09/09/2020 02:36PM
Re: Query optimization and index suggestion needed  
78
Pandit P
09/09/2020 11:38PM
How to design my data structure to optimize it.thank you  
181
xiangsheng jiang
09/05/2020 10:14PM
Re: How to design my data structure to optimize it.thank you  
76
Peter Brawley
09/06/2020 11:13AM
Commit is slow in Mysql 5.7  
211
Himanshu Patel
09/05/2020 02:49AM
Re: Commit is slow in Mysql 5.7  
87
Peter Brawley
09/05/2020 01:04PM
MySQL Performance : Understanding InnoDB IO Internals & "Checkpointing"  
165
Edwin Desouza
08/13/2020 06:59PM
MySQL 8.0 Indexes, Histograms, and Other Ways to Speed Up Your Queries  
168
Edwin Desouza
08/04/2020 07:57PM
Speeding up large searches  
175
Greg Knox
08/03/2020 11:07AM
Re: Speeding up large searches  
78
Peter Brawley
08/03/2020 12:23PM
select into outfile by chunk  
199
Wueh Chia Lee
07/16/2020 02:10AM
Re: select into outfile by chunk  
81
Peter Brawley
07/16/2020 10:30AM
MYSQL issues with query performance  
322
Wouter Platteeuw
06/24/2020 02:47PM
Re: MYSQL issues with query performance  
124
Peter Brawley
06/24/2020 06:55PM
Re: MYSQL issues with query performance  
127
Wouter Platteeuw
06/29/2020 06:32AM
Re: MYSQL issues with query performance  
109
Peter Brawley
06/29/2020 02:55PM
Re: MYSQL issues with query performance  
106
Wouter Platteeuw
06/30/2020 06:13AM
Re: MYSQL issues with query performance  
97
Peter Brawley
06/30/2020 08:15AM
Re: MYSQL issues with query performance  
104
Wouter Platteeuw
06/30/2020 10:09AM
Re: MYSQL issues with query performance  
102
Peter Brawley
06/30/2020 03:50PM
Re: MYSQL issues with query performance  
105
Wouter Platteeuw
07/01/2020 08:04AM
MySQL Performance : TPCC "Mystery" [SOLVED]  
232
Edwin Desouza
06/30/2020 04:59PM
slow performance, parameters or size and amounts of databases?  
212
Kristof Schevernels
06/19/2020 08:20AM
Re: slow performance, parameters or size and amounts of databases?  
269
Peter Brawley
06/19/2020 10:37AM
Yet another RAM question  
211
Nuno Donato
05/16/2020 06:18AM
Re: Yet another RAM question  
117
Peter Brawley
05/16/2020 08:48AM
MyISAM move from 5.1 to 5.7 - performance simple SELECT  
190
Christine Antoine
05/13/2020 03:02AM
MySQL DDL performance  
249
Stepan Furman
04/06/2020 05:46AM
Re: MySQL DDL performance  
113
Edwin Desouza
04/30/2020 03:00PM
MySQL 8.0.20 Performance : New InnoDB Double Write Buffer in Action  
217
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  
664
Stepan Furman
04/02/2020 03:57AM
Long start service MySQL 5.5 on Win 16  
267
Vladimir Gusev
03/30/2020 04:28AM
Re: Long start service MySQL 5.5 on Win 16  
130
Peter Brawley
03/30/2020 08:25AM
Re: Long start service MySQL 5.5 on Win 16  
126
Edwin Desouza
03/30/2020 10:23AM
Performance benchmark  
254
mmmm mmmm
03/16/2020 05:55PM
Re: Performance benchmark  
141
Peter Brawley
03/20/2020 06:21PM
Re: Performance benchmark  
131
Edwin Desouza
03/20/2020 07:38PM
Scaling mysql  
226
mmmm mmmm
03/20/2020 05:15PM
High memory used by MySQL  
476
Damian Kolany
02/12/2020 02:45AM
Re: High memory used by MySQL  
262
Peter Brawley
02/12/2020 11:41AM
Re: High memory used by MySQL  
210
Damian Kolany
02/13/2020 09:24AM
Re: High memory used by MySQL  
205
Peter Brawley
02/13/2020 11:49AM
Re: High memory used by MySQL  
195
Damian Kolany
02/14/2020 09:05AM
Re: High memory used by MySQL  
196
Peter Brawley
02/14/2020 11:06AM
Re: High memory used by MySQL  
190
Damian Kolany
03/02/2020 04:12AM
Re: High memory used by MySQL  
175
Peter Brawley
03/02/2020 04:17PM
Re: High memory used by MySQL  
170
Edwin Desouza
03/02/2020 08:35PM
Re: High memory used by MySQL  
199
Edwin Desouza
03/02/2020 08:36PM
Re: High memory used by MySQL  
156
Damian Kolany
03/03/2020 06:12AM
Re: High memory used by MySQL  
136
Peter Brawley
03/03/2020 11:51AM
SQL performance tuning advice  
339
Oliver C
02/21/2020 09:58AM
Re: SQL performance tuning advice  
148
Peter Brawley
02/21/2020 11:58AM
Re: SQL performance tuning advice  
150
Edwin Desouza
02/21/2020 06:39PM
Re: SQL performance tuning advice  
146
Oliver C
02/22/2020 08:02AM
why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
759
Sudarshan m
01/28/2020 12:09PM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
255
Edwin Desouza
01/28/2020 03:42PM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
196
Sudarshan m
01/29/2020 04:05AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
211
Peter Brawley
01/28/2020 06:42PM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
211
Sudarshan m
01/29/2020 04:02AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
204
Sudarshan m
01/31/2020 04:10AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
210
Peter Brawley
01/31/2020 10:15AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
209
Edwin Desouza
01/31/2020 11:41AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
210
Sudarshan m
02/03/2020 05:01AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
215
Peter Brawley
02/03/2020 11:00AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
179
Sudarshan m
02/06/2020 05:01AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
209
Peter Brawley
02/06/2020 06:50AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
203
Sudarshan m
02/03/2020 04:54AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
189
Frederic Descamps
02/03/2020 12:35PM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
187
Sudarshan m
02/06/2020 04:32AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
193
Frederic Descamps
02/06/2020 11:56PM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
198
Edwin Desouza
02/07/2020 12:03AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
233
Sudarshan m
02/10/2020 09:09AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
206
Peter Brawley
02/10/2020 09:45AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
201
Edwin Desouza
02/10/2020 06:16PM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
342
Sudarshan m
02/11/2020 04:13AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
211
Edwin Desouza
02/11/2020 11:14AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
194
Edwin Desouza
02/11/2020 11:16AM
Re: why MySql 8.0.17 Select query performance is slower than Mysql 5.7.26?  
203
Peter Brawley
02/11/2020 12:45PM
MySQL 8.0: Hash Join  
239
Edwin Desouza
02/09/2020 05:09PM
MySQL Server 5.1 max output  
303
Sugihono Budiman
02/07/2020 10:34AM
Re: MySQL Server 5.1 max output  
142
Peter Brawley
02/07/2020 12:19PM
Re: MySQL Server 5.1 max output  
168
Bobby Male
02/08/2020 08:37AM
Re: MySQL Server 5.1 max output  
145
Peter Brawley
02/08/2020 10:41AM
Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
1,451
anand aundhekar
09/18/2019 11:26PM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
328
Peter Brawley
09/19/2019 09:21AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
295
anand aundhekar
09/20/2019 03:26AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
297
Peter Brawley
09/20/2019 09:57AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
262
anand aundhekar
09/24/2019 03:09AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
274
Peter Brawley
09/24/2019 10:06AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
290
anand aundhekar
10/11/2019 12:18AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
719
Peter Brawley
10/15/2019 02:12PM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
278
anand aundhekar
01/27/2020 12:44AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
245
Peter Brawley
01/27/2020 12:34PM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
203
anand aundhekar
02/06/2020 01:14AM
Re: Inserts in MySQL 8 are slower than Inserts in MySQL 5.6  
238
Peter Brawley
02/06/2020 02:28PM
MySQL 5.7 simple count query sometimes fast and sometimes very slow  
543
Li Steven
12/23/2019 02:10AM
Re: MySQL 5.7 simple count query sometimes fast and sometimes very slow  
182
Peter Brawley
01/15/2020 11:55AM
MySQL 8.0: Simple way to figure out why your recursive CTE is running away  
274
Edwin Desouza
01/15/2020 06:06AM
SHOW FULL TABLES - Very Slow  
484
Sreedhar Vengala
12/19/2019 11:18PM
MySQL 8.0: AntiJoin  
284
Edwin Desouza
12/18/2019 07:53AM
Mysql GROUP BY performance realle slow on views  
350
Vincenzo Stigliano
12/15/2019 03:53AM
Re: Mysql GROUP BY performance realle slow on views  
169
Peter Brawley
12/15/2019 10:35AM
Bad order by performance (5.7.12 under Aurora)  
642
Nicola Farina
11/26/2019 03:43AM
Re: Bad order by performance (5.7.12 under Aurora)  
194
Frederic Descamps
11/26/2019 01:46PM
Re: Bad order by performance (5.7.12 under Aurora)  
210
Peter Brawley
11/26/2019 02:05PM
Re: Bad order by performance (5.7.12 under Aurora)  
239
Nicola Farina
11/26/2019 03:29PM
Re: Bad order by performance (5.7.12 under Aurora)  
207
Peter Brawley
11/26/2019 05:00PM
Re: Bad order by performance (5.7.12 under Aurora)  
193
Nicola Farina
11/27/2019 02:03AM
Re: Bad order by performance (5.7.12 under Aurora)  
228
Frederic Descamps
11/27/2019 04:21AM
Re: Bad order by performance (5.7.12 under Aurora)  
214
Nicola Farina
11/27/2019 05:46AM
MySQL 8.0 Performance: Scalability & Benchmarks (2019)  
436
Edwin Desouza
10/02/2019 11:05AM
MySQL Performance Tuning: The Perfect Scalability  
451
Edwin Desouza
09/21/2019 04:16PM
MySQL 8.0 - View Performance  
959
dino cummings
09/20/2019 07:47PM
Re: MySQL 8.0 - View Performance  
457
Peter Brawley
09/20/2019 09:14PM
Re: MySQL 8.0 - View Performance  
244
dino cummings
09/20/2019 10:29PM
Re: MySQL 8.0 - View Performance  
247
Peter Brawley
09/20/2019 11:18PM
Re: MySQL 8.0 - View Performance  
255
dino cummings
09/21/2019 12:18AM
Mysql 8 memory leak  
1,285
Pavel Dvořák
09/17/2019 03:58PM
Re: Mysql 8 memory leak  
374
Peter Brawley
09/17/2019 07:14PM
Re: Mysql 8 memory leak  
761
Pavel Dvořák
09/18/2019 02:41AM
Re: Mysql 8 memory leak  
401
Pavel Dvořák
09/18/2019 02:44AM
Re: Mysql 8 memory leak  
407
Peter Brawley
09/18/2019 09:38AM
Re: Mysql 8 memory leak  
390
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,639
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  
279
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  
294
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  
236
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  
264
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  
238
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  
246
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  
262
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  
251
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  
241
james wang
08/19/2019 02:44AM
MySQL8.0.16 TPC-C Benchmark on Persistent Memory  
1,110
Shohei Matsuura
07/12/2019 12:28AM
MySQL 5.6 Maximum Database instance  
940
Edgar Abellana
06/07/2019 07:10PM
Re: MySQL 5.6 Maximum Database instance  
270
Peter Brawley
06/07/2019 07:42PM
Re: MySQL 5.6 Maximum Database instance  
280
Edgar Abellana
06/07/2019 08:46PM
MySQL 8.0: Scalability & Benchmarks  
544
Edwin Desouza
05/31/2019 10:20PM
MySQL 8.0: Performance Tuning  
608
Edwin Desouza
05/31/2019 10:20PM
Help with MYSQL Very high processes.  
931
Miguel Bueno Joshimar
05/14/2019 07:30PM
Re: Help with MYSQL Very high processes.  
294
Peter Brawley
05/14/2019 09:41PM
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.