MySQL :: MySQL Forums :: Optimizer & Parser

Announcements	Last Post
• MySQL for Excel 1.3.8 has been released	06/10/2019 10:21PM

New Topic

Pages:

1 2 3 4 5

...

18 »

Subject

Views

Written By

Posted

Sticky: MySQL 8.0: One Giant Leap For SQL (1 Posts)

324

Edwin Desouza

04/25/2018 10:16AM

Sticky: Unofficial MySQL 8.0 Optimizer Guide (1 Posts)

590

Edwin Desouza

02/13/2017 04:16PM

Sticky: MySQL 8.0: Window Functions (1 Posts)

514

Edwin Desouza

02/04/2017 08:57PM

Sticky: MySQL 8.0: CTEs (1 Posts)

842

Edwin Desouza

10/18/2016 09:38AM

Sticky: MySQL 8.0: Optimizer & Parser (1 Posts)

920

Edwin Desouza

09/13/2016 10:54AM

Sticky: MySQL Performance Tuning (1 Posts)

1,656

Edwin Desouza

07/06/2015 10:37AM

Sticky: MySQL Parser (1 Posts)

2,335

Edwin Desouza

04/03/2014 03:31PM

Sticky: MySQL Optimizer: Features in MySQL 5.7 (1 Posts)

3,769

Edwin Desouza

12/18/2012 11:38AM

Sticky: MySQL EXPLAIN (1 Posts)

4,267

Edwin Desouza

07/10/2012 10:32AM

Sticky: MySQL Optimizer: Blogs (1 Posts)

9,956

Edwin DeSouza

04/28/2007 06:20PM

Slow Query

Deepak Nirmul

06/21/2019 04:47AM

Re: Slow Query

Peter Brawley

06/21/2019 10:17AM

Re: Slow Query

Deepak Nirmul

06/24/2019 02:18AM

Re: Slow Query

Peter Brawley

06/24/2019 09:56AM

Re: Slow Query

Deepak Nirmul

06/24/2019 10:15AM

Re: Slow Query

Peter Brawley

06/24/2019 10:45AM

Query optimization and indexing - Help needed

Pandit P

06/13/2019 06:41AM

Re: Query optimization and indexing - Help needed

Peter Brawley

06/13/2019 12:55PM

Re: Query optimization and indexing - Help needed

Pandit P

06/14/2019 12:01AM

Re: Query optimization and indexing - Help needed

Peter Brawley

06/14/2019 07:51AM

Is the query order guaranteed using Btree indexes and no ORDER BY

Ted Johnson

05/29/2019 02:12PM

Re: Is the query order guaranteed using Btree indexes and no ORDER BY

Peter Brawley

05/29/2019 03:00PM

Re: Is the query order guaranteed using Btree indexes and no ORDER BY

Ted Johnson

05/29/2019 04:41PM

CHECK constraints in MySQL

Edwin Desouza

05/14/2019 09:37AM

MySQL 8.0: Removal of implicit and explicit sorting for GROUP BY

Edwin Desouza

04/10/2019 09:14AM

Comparing two columns on big table

Krzysztof Wróblewski

03/21/2019 03:24PM

Re: Comparing two columns on big table

Peter Brawley

03/21/2019 04:24PM

help with this query

sha fendi

03/16/2019 09:17PM

Re: help with this query

Peter Brawley

03/17/2019 11:04AM

MySQL Functional Indexes

Edwin Desouza

03/14/2019 09:49AM

MySQL 8.0: Query analytics [CTEs, Window Functions]

Edwin Desouza

03/09/2019 11:04PM

MySQL 8.0: Improvements to ROLLUP

Edwin Desouza

03/05/2019 11:53AM

MySQL 8.0: Window Functions for JSON

Edwin Desouza

02/21/2019 11:08AM

what's the execution order of each part of a sql query

100

aaron chan

02/19/2019 09:00PM

Re: what's the execution order of each part of a sql query

Peter Brawley

02/20/2019 10:47AM

MySQL 8.0: New Index Features

108

Edwin Desouza

02/08/2019 11:18AM

MySQL 8.0: support for LATERAL derived tables

Edwin Desouza

01/31/2019 11:07AM

MySQL 8.0: Keywords

182

Edwin Desouza

01/10/2019 09:22PM

MySQL 8.0: Window Functions with Unusual Boundaries

157

Edwin Desouza

11/08/2018 02:42PM

More SQL in MySQL 8.0

169

Edwin Desouza

11/06/2018 07:28PM

MySQL 8.0: What Is New in Optimizer and Executor?

157

Edwin Desouza

11/01/2018 11:10AM

Optimizer Improvements in MySQL 8.0

149

Edwin Desouza

10/31/2018 09:31PM

Indexes are not working after restoring dump

194

Amit K

09/27/2018 11:25AM

Re: Indexes are not working after restoring dump

118

Amit K

09/27/2018 01:39PM

Re: Indexes are not working after restoring dump

110

Amit K

09/27/2018 01:45PM

Re: Indexes are not working after restoring dump

100

Øystein Grøvlen

09/28/2018 12:21AM

Re: Indexes are not working after restoring dump

120

Peter Brawley

09/27/2018 07:14PM

Re: Indexes are not working after restoring dump

114

Amit K

09/27/2018 08:31PM

Re: Indexes are not working after restoring dump

Peter Brawley

09/28/2018 11:08AM

Optimizer produces incorrect resultset

145

J Barchan

09/27/2018 09:35AM

Manipulating queries with non-conforming data via MySQL Query Rewrite Plugin, triggers and stored procedures

173

Edwin Desouza

09/07/2018 10:34AM

Where Clause Optimization

249

Mohammed Yehia El Sayed Abdoh

08/31/2018 06:47AM

Re: Where Clause Optimization

120

Peter Brawley

08/31/2018 01:55PM

Re: Where Clause Optimization

115

Mohammed Yehia El Sayed Abdoh

08/31/2018 03:08PM

Re: Where Clause Optimization

116

Øystein Grøvlen

09/03/2018 02:45AM

long execution time of all requests, drop base

390

Уррик Зарик

06/10/2018 06:10AM

Re: long execution time of all requests, drop base

157

Peter Brawley

06/10/2018 12:24PM

Re: long execution time of all requests, drop base

123

Уррик Зарик

06/10/2018 12:40PM

Re: long execution time of all requests, drop base

153

Peter Brawley

06/10/2018 02:24PM

Re: long execution time of all requests, drop base

167

Urri Zar

06/11/2018 12:09AM

Re: long execution time of all requests, drop base

119

Urri Zar

06/12/2018 10:25AM

Re: long execution time of all requests, drop base

126

Peter Brawley

06/12/2018 10:27AM

Re: long execution time of all requests, drop base

173

Urri Zar

06/12/2018 10:34AM

Re: long execution time of all requests, drop base

207

Peter Brawley

06/12/2018 12:00PM

Create index for Join some table in MySQL

250

Kenny Nguyen

05/20/2018 10:51PM

Re: Create index for Join some table in MySQL

160

Øystein Grøvlen

05/30/2018 12:50AM

Determine time taken by commit statement after insert or update statement

313

Priya Pawar

05/07/2018 02:01AM

Re: Determine time taken by commit statement after insert or update statement

172

Jesús Uzcanga

05/07/2018 08:43AM

Re: Determine time taken by commit statement after insert or update statement

152

Priya Pawar

05/08/2018 12:03AM

MySQL 8.0: One Giant Leap For SQL

185

Edwin Desouza

04/25/2018 10:14AM

how to speed up query on a table with over 20million records?

353

li zheng

03/25/2018 07:27AM

Re: how to speed up query on a table with over 20million records?

199

li zheng

03/25/2018 08:38AM

Re: how to speed up query on a table with over 20million records?

167

Peter Brawley

03/25/2018 01:59PM

Re: how to speed up query on a table with over 20million records?

192

Peter Brawley

03/25/2018 03:04PM

Re: how to speed up query on a table with over 20million records?

168

li zheng

03/25/2018 08:13PM

Re: how to speed up query on a table with over 20million records?

190

Peter Brawley

03/25/2018 10:03PM

Re: how to speed up query on a table with over 20million records?

164

li zheng

03/26/2018 02:41AM

optimize range query(using between, group by and order by)

612

Özgen Erbakan

03/20/2018 02:34AM

Re: optimize range query(using between, group by and order by)

353

Øystein Grøvlen

03/20/2018 03:52AM

Slow DELETE-Statement since update on 5.7

492

engram GmbH

03/19/2018 07:51AM

Re: Slow DELETE-Statement since update on 5.7

221

Peter Brawley

03/19/2018 11:40AM

Re: Slow DELETE-Statement since update on 5.7

244

Øystein Grøvlen

03/19/2018 01:15PM

Re: Slow DELETE-Statement since update on 5.7

270

engram GmbH

03/20/2018 02:09AM

Optimizer choosing wrong index

197

Daniel Kasak

03/19/2018 05:48PM

MySQL 8.0: Histograms

225

Edwin Desouza

03/01/2018 02:27PM

Indexing a small table increases the query cost

372

Aram Mirzadeh

02/28/2018 04:52AM

Re: Indexing a small table increases the query cost

168

Peter Brawley

02/28/2018 08:50AM

Re: Indexing a small table increases the query cost

190

Aram Mirzadeh

02/28/2018 11:24AM

Re: Indexing a small table increases the query cost

180

Aram Mirzadeh

02/28/2018 11:30AM

Re: Indexing a small table increases the query cost

159

Peter Brawley

02/28/2018 12:58PM

Re: Indexing a small table increases the query cost

215

Øystein Grøvlen

03/01/2018 03:15AM

MySQL: Ranking techniques

264

Edwin Desouza

01/23/2018 11:23AM

MySQL 8.0: Row numbering, ranking: using Window Functions

278

Edwin Desouza

12/22/2017 11:41PM

My query take along time

409

Murawweh Daher

12/17/2017 07:18AM

Muranweh, please don't double-post

158

Peter Brawley

12/17/2017 09:48AM

MySQL 8.0: Query Optimizer Takes Data Buffering into Account

247

Edwin Desouza

12/07/2017 11:21AM

Compound index (pkey) not used when it should be

362

Dan Parker

11/29/2017 01:39PM

Re: Compound index (pkey) not used when it should be

244

Peter Brawley

11/29/2017 04:21PM

Re: Compound index (pkey) not used when it should be

228

Dan Parker

11/29/2017 04:38PM

Re: Compound index (pkey) not used when it should be

235

Peter Brawley

11/29/2017 05:16PM

Re: Compound index (pkey) not used when it should be

221

Dan Parker

11/29/2017 05:25PM

Re: Compound index (pkey) not used when it should be

224

Peter Brawley

11/29/2017 06:13PM

Re: Compound index (pkey) not used when it should be

244

Dan Parker

11/29/2017 06:23PM

Re: Compound index (pkey) not used when it should be

206

Peter Brawley

11/29/2017 07:46PM

Re: Compound index (pkey) not used when it should be

226

Dan Parker

11/30/2017 10:31AM

Re: Compound index (pkey) not used when it should be

217

Peter Brawley

12/01/2017 11:02AM

Re: Compound index (pkey) not used when it should be

220

Dan Parker

12/01/2017 11:05AM

Re: Compound index (pkey) not used when it should be

213

Peter Brawley

12/01/2017 11:19AM

Re: Compound index (pkey) not used when it should be

210

Dan Parker

12/01/2017 11:26AM

Re: Compound index (pkey) not used when it should be

217

Peter Brawley

12/01/2017 01:04PM

Re: Compound index (pkey) not used when it should be

223

Dan Parker

12/01/2017 01:10PM

Re: Compound index (pkey) not used when it should be

210

Peter Brawley

12/01/2017 05:01PM

Re: Compound index (pkey) not used when it should be

222

Øystein Grøvlen

12/01/2017 10:10AM

Re: Compound index (pkey) not used when it should be

217

Dan Parker

12/01/2017 10:36AM

Confirmation on possible parser bug

373

Patrick Meredith

11/27/2017 10:47AM

Re: Confirmation on possible parser bug

169

Peter Brawley

11/30/2017 11:20AM

Source code question related to sql_optimizer.cc line 8583

412

Petru-Florin Mihancea

11/28/2017 04:20AM

Re: Source code question related to sql_optimizer.cc line 8583

193

Øystein Grøvlen

11/28/2017 07:01AM

MySQL 8.0: Optimization to skip index dives with FORCE INDEX.

403

Edwin Desouza

11/17/2017 09:50AM

Is Union Queries run in Parallel form or not.

489

Azeem Haider

10/17/2017 11:40PM

Re: Is Union Queries run in Parallel form or not.

235

Peter Brawley

10/18/2017 08:32AM

Re: Is Union Queries run in Parallel form or not.

252

Azeem Haider

10/18/2017 10:43PM

Re: Is Union Queries run in Parallel form or not.

217

Peter Brawley

10/18/2017 10:55PM

Re: Is Union Queries run in Parallel form or not.

286

Øystein Grøvlen

10/19/2017 03:02AM

MySQL 8.0: Window Functions

291

Edwin Desouza

10/04/2017 06:03PM

Grammer Rule for Parenthesis in Select Statement

487

Sushant Choudhary

09/21/2017 12:47PM

Please don't duplicate posts

276

Peter Brawley

09/21/2017 12:49PM

Help with explain on query

396

Alex Titley

08/16/2017 09:09AM

Re: Help with explain on query

205

Peter Brawley

08/16/2017 10:07AM

Optimizer Stablility

370

Chris Reston

08/16/2017 12:56AM

Re: Optimizer Stablility

241

Øystein Grøvlen

08/16/2017 02:19AM

Way to avoid fragmentation of MySQL tables

359

Priya Pawar

07/30/2017 11:01AM

Re: Way to avoid fragmentation of MySQL tables

280

Peter Brawley

07/30/2017 04:41PM

Re: Way to avoid fragmentation of MySQL tables

219

Priya Pawar

07/30/2017 11:10PM

MySQL 8.0.2: Introducing Window Functions

342

Edwin Desouza

07/18/2017 10:33AM

Can anyone help speed up this query?

445

Search Team

06/21/2017 11:07AM