MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing January 2026 Releases featuring MySQL Server 9.6.0 Innovation, 8.4.8 LTS and 8.0.45 01/23/2026 11:56AM

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

Subject
Views
Written By
Posted
varchar index vs. integer index  
13,987
Alex P
03/09/2009 03:27AM
Re: varchar index vs. integer index  
6,609
Rick James
03/10/2009 08:28PM
Performing multiple updates and selects  
4,840
Kristian Schmidt
03/06/2009 05:56AM
Re: Performing multiple updates and selects  
2,816
Rick James
03/07/2009 11:02AM
Re: Performing multiple updates and selects  
2,726
Kristian Schmidt
03/08/2009 08:23AM
Re: Performing multiple updates and selects  
2,656
Rick James
03/08/2009 01:12PM
Re: Performing multiple updates and selects  
2,640
Kristian Schmidt
03/08/2009 03:53PM
Use two indexes (filter "temporary results")  
4,542
Zoltán Lehóczky
12/21/2008 02:06PM
Re: Use two indexes (filter "temporary results")  
2,497
Rick James
03/01/2009 01:18AM
Large range query stops using indexes  
8,512
Solomon Chang
06/11/2007 10:43PM
Re: Large range query stops using indexes  
3,324
Joe Kuan
02/28/2009 04:49AM
Re: Large range query stops using indexes  
3,769
KimSeong Loh
06/12/2007 09:51PM
Re: Large range query stops using indexes  
3,826
Solomon Chang
06/20/2007 11:06AM
Re: Large range query stops using indexes  
3,758
KimSeong Loh
06/21/2007 03:20AM
MySQL Optimizer Code  
4,278
Tobias Zahn
02/22/2009 12:40PM
Re: MySQL Optimizer Code  
2,807
Rick James
02/22/2009 03:20PM
Re: MySQL Optimizer Code  
2,795
Tobias Zahn
02/23/2009 05:15AM
Re: MySQL Optimizer Code  
2,570
Tobias Zahn
02/27/2009 06:40AM
CONCAT IN WHERE  
13,158
Justin Johnson
02/23/2009 09:09PM
Distinct seems to mess up query results  
3,679
Premal Shah
02/18/2009 04:54PM
8 CPU Cores.....only 1 or 2 being used at the same time...  
6,522
Tobias Marx
02/11/2009 02:29PM
Re: 8 CPU Cores.....only 1 or 2 being used at the same time...  
3,504
Rick James
02/13/2009 12:22AM
low priority select  
7,019
Erel Segal
02/02/2009 06:08AM
Re: low priority select  
4,200
KimSeong Loh
02/02/2009 09:19PM
Re: low priority select  
3,470
Rick James
02/02/2009 09:33PM
Re: low priority select  
3,352
Erel Segal
02/04/2009 01:41AM
Script Running for 8 Hours! Need to optimise DESPERATELY!  
4,050
Graham Hemson
01/28/2009 05:27AM
Re: Script Running for 8 Hours! Need to optimise DESPERATELY!  
2,396
Rick James
01/29/2009 10:58PM
Splitting complex SQL select query in to independent sequence of small queries.  
6,533
Prasanth Reddy
01/28/2009 11:10AM
Re: Splitting complex SQL select query in to independent sequence of small queries.  
3,617
Rick James
01/29/2009 12:40AM
Re: Splitting complex SQL select query in to independent sequence of small queries.  
3,230
Vince Gatto
01/28/2009 01:53PM
WHERE clause in View  
17,292
John Kounis
01/24/2009 04:48PM
Re: WHERE clause in View  
4,868
Rick James
01/24/2009 06:55PM
Re: WHERE clause in View  
4,503
John Kounis
01/24/2009 07:08PM
Re: WHERE clause in View  
3,631
Rick James
01/24/2009 10:12PM
Re: WHERE clause in View  
5,580
John Kounis
01/25/2009 01:15PM
Re: WHERE clause in View  
3,432
Rick James
01/25/2009 10:28PM
Re: WHERE clause in View  
3,522
John Kounis
01/26/2009 12:42PM
Re: WHERE clause in View  
3,290
Rick James
01/26/2009 07:13PM
Re: WHERE clause in View  
3,618
John Kounis
01/28/2009 02:11PM
Loose Index  
3,550
Dheleban india
01/22/2009 08:26AM
Re: Loose Index  
2,490
Rick James
01/23/2009 12:47AM
Query Cache Behaviour  
3,535
walter stanish
01/21/2009 10:01PM
Re: Query Cache Behaviour  
2,513
Rick James
01/21/2009 11:47PM
Loads slow when 130+ online  
3,633
Crisy Fallows
01/16/2009 08:58AM
Re: Loads slow when 130+ online  
2,559
Rick James
01/19/2009 09:47PM
Re: Loads slow when 130+ online  
2,463
Crisy Fallows
01/21/2009 07:59PM
Re: Loads slow when 130+ online  
2,397
Rick James
01/21/2009 11:32PM
Optimizing ORDER BY in "complex" query  
3,715
Julien Genestoux
01/09/2009 06:36PM
Re: Optimizing ORDER BY in "complex" query  
2,454
Rick James
01/19/2009 10:03PM
Re: Optimizing ORDER BY in "complex" query  
2,445
Ryan Lowe
01/10/2009 04:38PM
Optimizer??  
3,419
James Brown
01/14/2009 08:57AM
Re: Optimizer??  
2,212
Rick James
01/19/2009 09:54PM
still stuck on Using temporary; Using filesort  
8,317
Johannes Fosseus
11/21/2008 03:34AM
Re: still stuck on Using temporary; Using filesort  
3,611
Zoltán Lehóczky
12/21/2008 01:43PM
How to optimize a range  
9,426
David Spindler
08/02/2006 07:56AM
Re: How to optimize a range  
9,128
Björn Steinbrink
07/18/2007 04:52PM
Re: How to optimize a range  
3,666
keith cascio
12/13/2008 09:32PM
Re: How to optimize a range  
4,231
Niko Viitala
07/13/2007 03:30AM
Re: How to optimize a range  
4,343
Toa Sty
08/04/2006 09:00AM
Optimizing for e-commerce  
3,264
karl lillrud
12/13/2008 09:22PM
why is MySQL not using an available index?  
7,742
Raymond Davis
12/20/2007 01:11PM
Re: why is MySQL not using an available index?  
4,979
KimSeong Loh
12/25/2007 11:48PM
Re: why is MySQL not using an available index?  
3,610
Ted Smith
12/04/2008 03:10PM
Need Suggestion for Large Database  
3,840
Kausik Sarkar
10/02/2008 01:54PM
Re: Need Suggestion for Large Database  
2,411
Ted Smith
12/04/2008 02:51PM
Re: Need Suggestion for Large Database  
2,630
Rick James
10/02/2008 08:13PM
Re: Need Suggestion for Large Database  
2,540
david yeung
10/22/2008 11:23PM
THERE IS NO OPTIMIZER IN MYSQL!!!!  
3,232
Ted Smith
12/04/2008 02:50PM
MySql Optimizer really sucks sometimes :D  
4,020
Thibault Delor
11/25/2008 10:45AM
Re: MySql Optimizer really sucks sometimes :D  
2,623
KimSeong Loh
11/25/2008 11:46PM
Re: MySql Optimizer really sucks sometimes :D  
2,645
Thibault Delor
11/29/2008 05:31AM
INDEXES on JOINS - example + question  
5,399
Firstname lastname
11/27/2008 02:37PM
Re: INDEXES on JOINS - example + question  
2,889
KimSeong Loh
11/28/2008 01:21AM
Re: INDEXES on JOINS - example + question  
2,651
Firstname lastname
11/28/2008 04:01AM
query takes a long time with large database  
5,586
Harish Balakrishnan Marar
11/25/2008 03:02AM
Re: query takes a long time with large database  
2,602
KimSeong Loh
11/25/2008 11:49PM
Dependent subquery oddness  
4,467
Matt C
09/05/2008 02:23PM
Re: Dependent subquery oddness  
2,853
Vasile Ceteras
11/24/2008 08:37AM
two tabel join result in: Using where; Using temporary; Using filesort  
7,006
Johannes Fosseus
11/20/2008 04:33PM
Re: two tabel join result in: Using where; Using temporary; Using filesort  
3,233
KimSeong Loh
11/20/2008 06:09PM
Re: two tabel join result in: Using where; Using temporary; Using filesort  
2,931
Johannes Fosseus
11/21/2008 01:12AM
Why isn't table using an index?  
3,315
Christie Sorenson
11/17/2008 03:46PM
Filesort & limit: poor optimization?  
3,586
Olaf van der Spek
11/17/2008 08:18AM
Why is this query table scanning?  
3,777
alan langridge
11/11/2008 10:54AM
Re: Why is this query table scanning?  
2,249
KimSeong Loh
11/13/2008 08:22PM
MySQL 5 using too many resources  
5,344
john marshall
11/12/2008 03:18AM
Re: MySQL 5 using too many resources  
3,045
john marshall
11/13/2008 08:17AM
Re: MySQL 5 using too many resources  
2,967
john marshall
11/12/2008 05:42AM
Help with slow select due to complex order-by  
5,075
Mark Williams
11/10/2008 06:44AM
Re: Help with slow select due to complex order-by  
2,689
kkmr india
11/11/2008 07:11AM
PRIMARY key not being used as key  
3,812
Jeff Strahl
10/29/2008 11:38AM
Re: PRIMARY key not being used as key  
2,528
KimSeong Loh
11/10/2008 06:20PM
Speed up INSERT/UPDATE Process  
11,509
Irfan Ali
09/26/2008 10:42PM
Re: Speed up INSERT/UPDATE Process  
7,051
Rick James
09/26/2008 10:57PM
Re: Speed up INSERT/UPDATE Process  
7,002
Irfan Ali
09/27/2008 02:32AM
Re: Speed up INSERT/UPDATE Process  
5,596
david yeung
10/22/2008 11:43PM
ORDER BY on SUM() results  
25,106
Lamaru Omar
04/10/2007 08:16AM
Re: ORDER BY on SUM() results  
4,940
hieu ngoc
04/04/2008 02:09AM
Re: ORDER BY on SUM() results  
5,772
KimSeong Loh
07/19/2007 07:07PM
Re: ORDER BY on SUM() results  
8,830
Martijn Dijkstra
07/19/2007 10:17AM
Re: ORDER BY on SUM() results  
5,172
david yeung
10/22/2008 11:37PM
1 second query even as a Heap table  
4,195
Tobias Marx
04/26/2008 05:11AM
Re: 1 second query even as a Heap table  
2,556
Rick James
10/02/2008 08:14PM
Re: 1 second query even as a Heap table  
2,484
david yeung
10/22/2008 11:26PM
InnoDB seemingly fails to use the full resources while inserting  
3,535
Frans Grotepass
10/20/2008 08:40AM
it will be an stupid error but...  
3,914
artica brd
10/17/2008 02:30AM
Resolved  
2,338
artica brd
10/17/2008 04:53AM
MySQL CPU Issue  
3,755
Mathieu Louis
10/17/2008 01:25AM
mySQL QUERY  
3,647
Lauren Halupke
10/14/2008 01:55PM
Optimizer optimizes dependent on data in tables?  
3,750
Daniel Haas
08/18/2008 11:02AM
Re: Optimizer optimizes dependent on data in tables?  
2,515
Rick James
09/26/2008 11:29PM
Re: Optimizer optimizes dependent on data in tables?  
2,506
Rey Wang
10/12/2008 04:16PM
InnoDB + Update Statistics  
3,687
Leopold Vallauri
10/09/2008 03:52AM
Paging on Union queries  
8,329
Tobias Marx
03/24/2008 11:23AM
Re: Paging on Union queries  
3,577
Rick James
09/28/2008 03:51PM
error on optimize table : The table '#sql-1be4_8' is full  
6,825
Delphine PIN
04/10/2008 05:50AM
Re: error on optimize table : The table '#sql-1be4_8' is full  
3,139
Rick James
09/28/2008 03:36PM
optimizing by adding a new field  
4,302
spam Mcbain
04/03/2008 05:32AM
Re: optimizing by adding a new field  
2,542
Rick James
09/28/2008 03:34PM
Re: optimizing by adding a new field  
2,770
spam Mcbain
04/08/2008 02:27AM
Millions of Rows - Several GB - How to Optimize these queries  
9,654
Mike K
02/18/2008 07:46PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
3,753
Rick James
09/28/2008 03:27PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
4,619
Mike K
02/18/2008 08:52PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
4,282
Benoit St-Jean
04/03/2008 07:14AM
Not using index from 'possible_keys'  
7,089
Maciej Nadolski
05/08/2008 05:52AM
Re: Not using index from 'possible_keys'  
3,245
Rick James
09/28/2008 03:13PM
Something is wrong, help me please!!!!  
4,627
hieu ngoc
04/04/2008 12:32AM
Re: Something is wrong, help me please!!!!  
2,582
Lars Johansson
05/17/2008 10:46PM
Re: Something is wrong, help me please!!!!  
2,359
Rick James
09/28/2008 03:08PM
Re: Something is wrong, help me please!!!!  
2,663
KimSeong Loh
04/04/2008 09:16PM
Log Query not using indexes  
6,213
benoit plessis
04/09/2008 10:07AM
Re: Log Query not using indexes  
2,988
Maciej Nadolski
05/11/2008 11:38PM
Re: Log Query not using indexes  
2,587
Rick James
09/27/2008 10:24PM
Re: Log Query not using indexes  
2,897
benoit plessis
09/28/2008 04:49AM
Re: Log Query not using indexes  
2,587
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.