MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing July 2026 Releases featuring MySQL Server 26.7.0, 9.7.2 and 8.4.11 08/01/2026 04:40AM

Advanced Search
New Topic
Pages:
« 1
...
10 11 12 13 14
...
19 »

Subject
Views
Written By
Posted
varchar index vs. integer index  
14,172
Alex P
03/09/2009 03:27AM
Re: varchar index vs. integer index  
6,666
Rick James
03/10/2009 08:28PM
Performing multiple updates and selects  
4,973
Kristian Schmidt
03/06/2009 05:56AM
Re: Performing multiple updates and selects  
2,879
Rick James
03/07/2009 11:02AM
Re: Performing multiple updates and selects  
2,766
Kristian Schmidt
03/08/2009 08:23AM
Re: Performing multiple updates and selects  
2,696
Rick James
03/08/2009 01:12PM
Re: Performing multiple updates and selects  
2,684
Kristian Schmidt
03/08/2009 03:53PM
Use two indexes (filter "temporary results")  
4,615
Zoltán Lehóczky
12/21/2008 02:06PM
Re: Use two indexes (filter "temporary results")  
2,533
Rick James
03/01/2009 01:18AM
Large range query stops using indexes  
8,661
Solomon Chang
06/11/2007 10:43PM
Re: Large range query stops using indexes  
3,355
Joe Kuan
02/28/2009 04:49AM
Re: Large range query stops using indexes  
3,801
KimSeong Loh
06/12/2007 09:51PM
Re: Large range query stops using indexes  
3,863
Solomon Chang
06/20/2007 11:06AM
Re: Large range query stops using indexes  
3,796
KimSeong Loh
06/21/2007 03:20AM
MySQL Optimizer Code  
4,368
Tobias Zahn
02/22/2009 12:40PM
Re: MySQL Optimizer Code  
2,846
Rick James
02/22/2009 03:20PM
Re: MySQL Optimizer Code  
2,837
Tobias Zahn
02/23/2009 05:15AM
Re: MySQL Optimizer Code  
2,607
Tobias Zahn
02/27/2009 06:40AM
CONCAT IN WHERE  
13,259
Justin Johnson
02/23/2009 09:09PM
Distinct seems to mess up query results  
3,754
Premal Shah
02/18/2009 04:54PM
8 CPU Cores.....only 1 or 2 being used at the same time...  
6,745
Tobias Marx
02/11/2009 02:29PM
Re: 8 CPU Cores.....only 1 or 2 being used at the same time...  
3,529
Rick James
02/13/2009 12:22AM
low priority select  
7,094
Erel Segal
02/02/2009 06:08AM
Re: low priority select  
4,224
KimSeong Loh
02/02/2009 09:19PM
Re: low priority select  
3,508
Rick James
02/02/2009 09:33PM
Re: low priority select  
3,394
Erel Segal
02/04/2009 01:41AM
Script Running for 8 Hours! Need to optimise DESPERATELY!  
4,122
Graham Hemson
01/28/2009 05:27AM
Re: Script Running for 8 Hours! Need to optimise DESPERATELY!  
2,431
Rick James
01/29/2009 10:58PM
Splitting complex SQL select query in to independent sequence of small queries.  
6,643
Prasanth Reddy
01/28/2009 11:10AM
Re: Splitting complex SQL select query in to independent sequence of small queries.  
3,651
Rick James
01/29/2009 12:40AM
Re: Splitting complex SQL select query in to independent sequence of small queries.  
3,279
Vince Gatto
01/28/2009 01:53PM
WHERE clause in View  
17,486
John Kounis
01/24/2009 04:48PM
Re: WHERE clause in View  
4,907
Rick James
01/24/2009 06:55PM
Re: WHERE clause in View  
4,539
John Kounis
01/24/2009 07:08PM
Re: WHERE clause in View  
3,670
Rick James
01/24/2009 10:12PM
Re: WHERE clause in View  
5,620
John Kounis
01/25/2009 01:15PM
Re: WHERE clause in View  
3,482
Rick James
01/25/2009 10:28PM
Re: WHERE clause in View  
3,563
John Kounis
01/26/2009 12:42PM
Re: WHERE clause in View  
3,321
Rick James
01/26/2009 07:13PM
Re: WHERE clause in View  
3,657
John Kounis
01/28/2009 02:11PM
Loose Index  
3,628
Dheleban india
01/22/2009 08:26AM
Re: Loose Index  
2,518
Rick James
01/23/2009 12:47AM
Query Cache Behaviour  
3,604
walter stanish
01/21/2009 10:01PM
Re: Query Cache Behaviour  
2,545
Rick James
01/21/2009 11:47PM
Loads slow when 130+ online  
3,711
Crisy Fallows
01/16/2009 08:58AM
Re: Loads slow when 130+ online  
2,596
Rick James
01/19/2009 09:47PM
Re: Loads slow when 130+ online  
2,502
Crisy Fallows
01/21/2009 07:59PM
Re: Loads slow when 130+ online  
2,427
Rick James
01/21/2009 11:32PM
Optimizing ORDER BY in "complex" query  
3,770
Julien Genestoux
01/09/2009 06:36PM
Re: Optimizing ORDER BY in "complex" query  
2,486
Rick James
01/19/2009 10:03PM
Re: Optimizing ORDER BY in "complex" query  
2,505
Ryan Lowe
01/10/2009 04:38PM
Optimizer??  
3,472
James Brown
01/14/2009 08:57AM
Re: Optimizer??  
2,242
Rick James
01/19/2009 09:54PM
still stuck on Using temporary; Using filesort  
8,382
Johannes Fosseus
11/21/2008 03:34AM
Re: still stuck on Using temporary; Using filesort  
3,649
Zoltán Lehóczky
12/21/2008 01:43PM
How to optimize a range  
9,512
David Spindler
08/02/2006 07:56AM
Re: How to optimize a range  
9,176
Björn Steinbrink
07/18/2007 04:52PM
Re: How to optimize a range  
3,704
keith cascio
12/13/2008 09:32PM
Re: How to optimize a range  
4,272
Niko Viitala
07/13/2007 03:30AM
Re: How to optimize a range  
4,381
Toa Sty
08/04/2006 09:00AM
Optimizing for e-commerce  
3,314
karl lillrud
12/13/2008 09:22PM
why is MySQL not using an available index?  
7,808
Raymond Davis
12/20/2007 01:11PM
Re: why is MySQL not using an available index?  
5,002
KimSeong Loh
12/25/2007 11:48PM
Re: why is MySQL not using an available index?  
3,633
Ted Smith
12/04/2008 03:10PM
Need Suggestion for Large Database  
3,901
Kausik Sarkar
10/02/2008 01:54PM
Re: Need Suggestion for Large Database  
2,440
Ted Smith
12/04/2008 02:51PM
Re: Need Suggestion for Large Database  
2,657
Rick James
10/02/2008 08:13PM
Re: Need Suggestion for Large Database  
2,572
david yeung
10/22/2008 11:23PM
THERE IS NO OPTIMIZER IN MYSQL!!!!  
3,285
Ted Smith
12/04/2008 02:50PM
MySql Optimizer really sucks sometimes :D  
4,094
Thibault Delor
11/25/2008 10:45AM
Re: MySql Optimizer really sucks sometimes :D  
2,661
KimSeong Loh
11/25/2008 11:46PM
Re: MySql Optimizer really sucks sometimes :D  
2,680
Thibault Delor
11/29/2008 05:31AM
INDEXES on JOINS - example + question  
5,460
Firstname lastname
11/27/2008 02:37PM
Re: INDEXES on JOINS - example + question  
2,930
KimSeong Loh
11/28/2008 01:21AM
Re: INDEXES on JOINS - example + question  
2,688
Firstname lastname
11/28/2008 04:01AM
query takes a long time with large database  
5,659
Harish Balakrishnan Marar
11/25/2008 03:02AM
Re: query takes a long time with large database  
2,633
KimSeong Loh
11/25/2008 11:49PM
Dependent subquery oddness  
4,521
Matt C
09/05/2008 02:23PM
Re: Dependent subquery oddness  
2,903
Vasile Ceteras
11/24/2008 08:37AM
two tabel join result in: Using where; Using temporary; Using filesort  
7,068
Johannes Fosseus
11/20/2008 04:33PM
Re: two tabel join result in: Using where; Using temporary; Using filesort  
3,271
KimSeong Loh
11/20/2008 06:09PM
Re: two tabel join result in: Using where; Using temporary; Using filesort  
2,960
Johannes Fosseus
11/21/2008 01:12AM
Why isn't table using an index?  
3,391
Christie Sorenson
11/17/2008 03:46PM
Filesort & limit: poor optimization?  
3,668
Olaf van der Spek
11/17/2008 08:18AM
Why is this query table scanning?  
3,843
alan langridge
11/11/2008 10:54AM
Re: Why is this query table scanning?  
2,286
KimSeong Loh
11/13/2008 08:22PM
MySQL 5 using too many resources  
5,405
john marshall
11/12/2008 03:18AM
Re: MySQL 5 using too many resources  
3,084
john marshall
11/13/2008 08:17AM
Re: MySQL 5 using too many resources  
3,005
john marshall
11/12/2008 05:42AM
Help with slow select due to complex order-by  
5,149
Mark Williams
11/10/2008 06:44AM
Re: Help with slow select due to complex order-by  
2,735
kkmr india
11/11/2008 07:11AM
PRIMARY key not being used as key  
3,896
Jeff Strahl
10/29/2008 11:38AM
Re: PRIMARY key not being used as key  
2,566
KimSeong Loh
11/10/2008 06:20PM
Speed up INSERT/UPDATE Process  
11,599
Irfan Ali
09/26/2008 10:42PM
Re: Speed up INSERT/UPDATE Process  
7,084
Rick James
09/26/2008 10:57PM
Re: Speed up INSERT/UPDATE Process  
7,035
Irfan Ali
09/27/2008 02:32AM
Re: Speed up INSERT/UPDATE Process  
5,626
david yeung
10/22/2008 11:43PM
ORDER BY on SUM() results  
25,210
Lamaru Omar
04/10/2007 08:16AM
Re: ORDER BY on SUM() results  
4,975
hieu ngoc
04/04/2008 02:09AM
Re: ORDER BY on SUM() results  
5,819
KimSeong Loh
07/19/2007 07:07PM
Re: ORDER BY on SUM() results  
8,864
Martijn Dijkstra
07/19/2007 10:17AM
Re: ORDER BY on SUM() results  
5,214
david yeung
10/22/2008 11:37PM
1 second query even as a Heap table  
4,253
Tobias Marx
04/26/2008 05:11AM
Re: 1 second query even as a Heap table  
2,581
Rick James
10/02/2008 08:14PM
Re: 1 second query even as a Heap table  
2,512
david yeung
10/22/2008 11:26PM
InnoDB seemingly fails to use the full resources while inserting  
3,596
Frans Grotepass
10/20/2008 08:40AM
it will be an stupid error but...  
3,985
artica brd
10/17/2008 02:30AM
Resolved  
2,367
artica brd
10/17/2008 04:53AM
MySQL CPU Issue  
3,831
Mathieu Louis
10/17/2008 01:25AM
mySQL QUERY  
3,724
Lauren Halupke
10/14/2008 01:55PM
Optimizer optimizes dependent on data in tables?  
3,818
Daniel Haas
08/18/2008 11:02AM
Re: Optimizer optimizes dependent on data in tables?  
2,548
Rick James
09/26/2008 11:29PM
Re: Optimizer optimizes dependent on data in tables?  
2,536
Rey Wang
10/12/2008 04:16PM
InnoDB + Update Statistics  
3,751
Leopold Vallauri
10/09/2008 03:52AM
Paging on Union queries  
8,416
Tobias Marx
03/24/2008 11:23AM
Re: Paging on Union queries  
3,633
Rick James
09/28/2008 03:51PM
error on optimize table : The table '#sql-1be4_8' is full  
6,908
Delphine PIN
04/10/2008 05:50AM
Re: error on optimize table : The table '#sql-1be4_8' is full  
3,184
Rick James
09/28/2008 03:36PM
optimizing by adding a new field  
4,367
spam Mcbain
04/03/2008 05:32AM
Re: optimizing by adding a new field  
2,584
Rick James
09/28/2008 03:34PM
Re: optimizing by adding a new field  
2,801
spam Mcbain
04/08/2008 02:27AM
Millions of Rows - Several GB - How to Optimize these queries  
9,728
Mike K
02/18/2008 07:46PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
3,782
Rick James
09/28/2008 03:27PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
4,647
Mike K
02/18/2008 08:52PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
4,309
Benoit St-Jean
04/03/2008 07:14AM
Not using index from 'possible_keys'  
7,148
Maciej Nadolski
05/08/2008 05:52AM
Re: Not using index from 'possible_keys'  
3,269
Rick James
09/28/2008 03:13PM
Something is wrong, help me please!!!!  
4,687
hieu ngoc
04/04/2008 12:32AM
Re: Something is wrong, help me please!!!!  
2,602
Lars Johansson
05/17/2008 10:46PM
Re: Something is wrong, help me please!!!!  
2,384
Rick James
09/28/2008 03:08PM
Re: Something is wrong, help me please!!!!  
2,694
KimSeong Loh
04/04/2008 09:16PM
Log Query not using indexes  
6,300
benoit plessis
04/09/2008 10:07AM
Re: Log Query not using indexes  
3,021
Maciej Nadolski
05/11/2008 11:38PM
Re: Log Query not using indexes  
2,626
Rick James
09/27/2008 10:24PM
Re: Log Query not using indexes  
2,954
benoit plessis
09/28/2008 04:49AM
Re: Log Query not using indexes  
2,625
Rick James
09/28/2008 03:02PM
Pages:
« 1
...
10 11 12 13 14
...
19 »

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.