MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing January 2025 Releases featuring MySQL Server 9.2.0 Innovation, 8.4.4 LTS and 8.0.41 01/22/2025 08:08AM

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

Subject
Views
Written By
Posted
varchar index vs. integer index  
13,705
Alex P
03/09/2009 03:27AM
Re: varchar index vs. integer index  
6,465
Rick James
03/10/2009 08:28PM
Performing multiple updates and selects  
4,622
Kristian Schmidt
03/06/2009 05:56AM
Re: Performing multiple updates and selects  
2,713
Rick James
03/07/2009 11:02AM
Re: Performing multiple updates and selects  
2,634
Kristian Schmidt
03/08/2009 08:23AM
Re: Performing multiple updates and selects  
2,571
Rick James
03/08/2009 01:12PM
Re: Performing multiple updates and selects  
2,559
Kristian Schmidt
03/08/2009 03:53PM
Use two indexes (filter "temporary results")  
4,362
Zoltán Lehóczky
12/21/2008 02:06PM
Re: Use two indexes (filter "temporary results")  
2,404
Rick James
03/01/2009 01:18AM
Large range query stops using indexes  
8,071
Solomon Chang
06/11/2007 10:43PM
Re: Large range query stops using indexes  
3,201
Joe Kuan
02/28/2009 04:49AM
Re: Large range query stops using indexes  
3,663
KimSeong Loh
06/12/2007 09:51PM
Re: Large range query stops using indexes  
3,718
Solomon Chang
06/20/2007 11:06AM
Re: Large range query stops using indexes  
3,673
KimSeong Loh
06/21/2007 03:20AM
MySQL Optimizer Code  
4,121
Tobias Zahn
02/22/2009 12:40PM
Re: MySQL Optimizer Code  
2,716
Rick James
02/22/2009 03:20PM
Re: MySQL Optimizer Code  
2,708
Tobias Zahn
02/23/2009 05:15AM
Re: MySQL Optimizer Code  
2,481
Tobias Zahn
02/27/2009 06:40AM
CONCAT IN WHERE  
12,986
Justin Johnson
02/23/2009 09:09PM
Distinct seems to mess up query results  
3,520
Premal Shah
02/18/2009 04:54PM
8 CPU Cores.....only 1 or 2 being used at the same time...  
6,310
Tobias Marx
02/11/2009 02:29PM
Re: 8 CPU Cores.....only 1 or 2 being used at the same time...  
3,430
Rick James
02/13/2009 12:22AM
low priority select  
6,834
Erel Segal
02/02/2009 06:08AM
Re: low priority select  
4,126
KimSeong Loh
02/02/2009 09:19PM
Re: low priority select  
3,386
Rick James
02/02/2009 09:33PM
Re: low priority select  
3,246
Erel Segal
02/04/2009 01:41AM
Script Running for 8 Hours! Need to optimise DESPERATELY!  
3,880
Graham Hemson
01/28/2009 05:27AM
Re: Script Running for 8 Hours! Need to optimise DESPERATELY!  
2,312
Rick James
01/29/2009 10:58PM
Splitting complex SQL select query in to independent sequence of small queries.  
6,293
Prasanth Reddy
01/28/2009 11:10AM
Re: Splitting complex SQL select query in to independent sequence of small queries.  
3,491
Rick James
01/29/2009 12:40AM
Re: Splitting complex SQL select query in to independent sequence of small queries.  
3,117
Vince Gatto
01/28/2009 01:53PM
WHERE clause in View  
16,758
John Kounis
01/24/2009 04:48PM
Re: WHERE clause in View  
4,735
Rick James
01/24/2009 06:55PM
Re: WHERE clause in View  
4,392
John Kounis
01/24/2009 07:08PM
Re: WHERE clause in View  
3,523
Rick James
01/24/2009 10:12PM
Re: WHERE clause in View  
5,470
John Kounis
01/25/2009 01:15PM
Re: WHERE clause in View  
3,322
Rick James
01/25/2009 10:28PM
Re: WHERE clause in View  
3,407
John Kounis
01/26/2009 12:42PM
Re: WHERE clause in View  
3,182
Rick James
01/26/2009 07:13PM
Re: WHERE clause in View  
3,504
John Kounis
01/28/2009 02:11PM
Loose Index  
3,411
Dheleban india
01/22/2009 08:26AM
Re: Loose Index  
2,407
Rick James
01/23/2009 12:47AM
Query Cache Behaviour  
3,337
walter stanish
01/21/2009 10:01PM
Re: Query Cache Behaviour  
2,418
Rick James
01/21/2009 11:47PM
Loads slow when 130+ online  
3,479
Crisy Fallows
01/16/2009 08:58AM
Re: Loads slow when 130+ online  
2,482
Rick James
01/19/2009 09:47PM
Re: Loads slow when 130+ online  
2,368
Crisy Fallows
01/21/2009 07:59PM
Re: Loads slow when 130+ online  
2,323
Rick James
01/21/2009 11:32PM
Optimizing ORDER BY in "complex" query  
3,558
Julien Genestoux
01/09/2009 06:36PM
Re: Optimizing ORDER BY in "complex" query  
2,385
Rick James
01/19/2009 10:03PM
Re: Optimizing ORDER BY in "complex" query  
2,363
Ryan Lowe
01/10/2009 04:38PM
Optimizer??  
3,275
James Brown
01/14/2009 08:57AM
Re: Optimizer??  
2,132
Rick James
01/19/2009 09:54PM
still stuck on Using temporary; Using filesort  
8,134
Johannes Fosseus
11/21/2008 03:34AM
Re: still stuck on Using temporary; Using filesort  
3,549
Zoltán Lehóczky
12/21/2008 01:43PM
How to optimize a range  
9,149
David Spindler
08/02/2006 07:56AM
Re: How to optimize a range  
9,003
Björn Steinbrink
07/18/2007 04:52PM
Re: How to optimize a range  
3,564
keith cascio
12/13/2008 09:32PM
Re: How to optimize a range  
4,124
Niko Viitala
07/13/2007 03:30AM
Re: How to optimize a range  
4,255
Toa Sty
08/04/2006 09:00AM
Optimizing for e-commerce  
3,130
karl lillrud
12/13/2008 09:22PM
why is MySQL not using an available index?  
7,592
Raymond Davis
12/20/2007 01:11PM
Re: why is MySQL not using an available index?  
4,904
KimSeong Loh
12/25/2007 11:48PM
Re: why is MySQL not using an available index?  
3,548
Ted Smith
12/04/2008 03:10PM
Need Suggestion for Large Database  
3,698
Kausik Sarkar
10/02/2008 01:54PM
Re: Need Suggestion for Large Database  
2,347
Ted Smith
12/04/2008 02:51PM
Re: Need Suggestion for Large Database  
2,568
Rick James
10/02/2008 08:13PM
Re: Need Suggestion for Large Database  
2,481
david yeung
10/22/2008 11:23PM
THERE IS NO OPTIMIZER IN MYSQL!!!!  
3,096
Ted Smith
12/04/2008 02:50PM
MySql Optimizer really sucks sometimes :D  
3,856
Thibault Delor
11/25/2008 10:45AM
Re: MySql Optimizer really sucks sometimes :D  
2,554
KimSeong Loh
11/25/2008 11:46PM
Re: MySql Optimizer really sucks sometimes :D  
2,576
Thibault Delor
11/29/2008 05:31AM
INDEXES on JOINS - example + question  
5,236
Firstname lastname
11/27/2008 02:37PM
Re: INDEXES on JOINS - example + question  
2,820
KimSeong Loh
11/28/2008 01:21AM
Re: INDEXES on JOINS - example + question  
2,572
Firstname lastname
11/28/2008 04:01AM
query takes a long time with large database  
5,444
Harish Balakrishnan Marar
11/25/2008 03:02AM
Re: query takes a long time with large database  
2,525
KimSeong Loh
11/25/2008 11:49PM
Dependent subquery oddness  
4,273
Matt C
09/05/2008 02:23PM
Re: Dependent subquery oddness  
2,771
Vasile Ceteras
11/24/2008 08:37AM
two tabel join result in: Using where; Using temporary; Using filesort  
6,839
Johannes Fosseus
11/20/2008 04:33PM
Re: two tabel join result in: Using where; Using temporary; Using filesort  
3,144
KimSeong Loh
11/20/2008 06:09PM
Re: two tabel join result in: Using where; Using temporary; Using filesort  
2,855
Johannes Fosseus
11/21/2008 01:12AM
Why isn't table using an index?  
3,159
Christie Sorenson
11/17/2008 03:46PM
Filesort & limit: poor optimization?  
3,461
Olaf van der Spek
11/17/2008 08:18AM
Why is this query table scanning?  
3,528
alan langridge
11/11/2008 10:54AM
Re: Why is this query table scanning?  
2,173
KimSeong Loh
11/13/2008 08:22PM
MySQL 5 using too many resources  
5,189
john marshall
11/12/2008 03:18AM
Re: MySQL 5 using too many resources  
2,967
john marshall
11/13/2008 08:17AM
Re: MySQL 5 using too many resources  
2,880
john marshall
11/12/2008 05:42AM
Help with slow select due to complex order-by  
4,939
Mark Williams
11/10/2008 06:44AM
Re: Help with slow select due to complex order-by  
2,619
kkmr india
11/11/2008 07:11AM
PRIMARY key not being used as key  
3,650
Jeff Strahl
10/29/2008 11:38AM
Re: PRIMARY key not being used as key  
2,448
KimSeong Loh
11/10/2008 06:20PM
Speed up INSERT/UPDATE Process  
11,320
Irfan Ali
09/26/2008 10:42PM
Re: Speed up INSERT/UPDATE Process  
6,980
Rick James
09/26/2008 10:57PM
Re: Speed up INSERT/UPDATE Process  
6,933
Irfan Ali
09/27/2008 02:32AM
Re: Speed up INSERT/UPDATE Process  
5,520
david yeung
10/22/2008 11:43PM
ORDER BY on SUM() results  
24,870
Lamaru Omar
04/10/2007 08:16AM
Re: ORDER BY on SUM() results  
4,846
hieu ngoc
04/04/2008 02:09AM
Re: ORDER BY on SUM() results  
5,686
KimSeong Loh
07/19/2007 07:07PM
Re: ORDER BY on SUM() results  
8,760
Martijn Dijkstra
07/19/2007 10:17AM
Re: ORDER BY on SUM() results  
5,089
david yeung
10/22/2008 11:37PM
1 second query even as a Heap table  
4,021
Tobias Marx
04/26/2008 05:11AM
Re: 1 second query even as a Heap table  
2,474
Rick James
10/02/2008 08:14PM
Re: 1 second query even as a Heap table  
2,422
david yeung
10/22/2008 11:26PM
InnoDB seemingly fails to use the full resources while inserting  
3,355
Frans Grotepass
10/20/2008 08:40AM
it will be an stupid error but...  
3,751
artica brd
10/17/2008 02:30AM
Resolved  
2,253
artica brd
10/17/2008 04:53AM
MySQL CPU Issue  
3,628
Mathieu Louis
10/17/2008 01:25AM
mySQL QUERY  
3,491
Lauren Halupke
10/14/2008 01:55PM
Optimizer optimizes dependent on data in tables?  
3,558
Daniel Haas
08/18/2008 11:02AM
Re: Optimizer optimizes dependent on data in tables?  
2,446
Rick James
09/26/2008 11:29PM
Re: Optimizer optimizes dependent on data in tables?  
2,422
Rey Wang
10/12/2008 04:16PM
InnoDB + Update Statistics  
3,530
Leopold Vallauri
10/09/2008 03:52AM
Paging on Union queries  
7,999
Tobias Marx
03/24/2008 11:23AM
Re: Paging on Union queries  
3,421
Rick James
09/28/2008 03:51PM
error on optimize table : The table '#sql-1be4_8' is full  
6,641
Delphine PIN
04/10/2008 05:50AM
Re: error on optimize table : The table '#sql-1be4_8' is full  
3,059
Rick James
09/28/2008 03:36PM
optimizing by adding a new field  
4,129
spam Mcbain
04/03/2008 05:32AM
Re: optimizing by adding a new field  
2,466
Rick James
09/28/2008 03:34PM
Re: optimizing by adding a new field  
2,675
spam Mcbain
04/08/2008 02:27AM
Millions of Rows - Several GB - How to Optimize these queries  
9,489
Mike K
02/18/2008 07:46PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
3,678
Rick James
09/28/2008 03:27PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
4,518
Mike K
02/18/2008 08:52PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
4,220
Benoit St-Jean
04/03/2008 07:14AM
Not using index from 'possible_keys'  
6,947
Maciej Nadolski
05/08/2008 05:52AM
Re: Not using index from 'possible_keys'  
3,158
Rick James
09/28/2008 03:13PM
Something is wrong, help me please!!!!  
4,479
hieu ngoc
04/04/2008 12:32AM
Re: Something is wrong, help me please!!!!  
2,506
Lars Johansson
05/17/2008 10:46PM
Re: Something is wrong, help me please!!!!  
2,269
Rick James
09/28/2008 03:08PM
Re: Something is wrong, help me please!!!!  
2,580
KimSeong Loh
04/04/2008 09:16PM
Log Query not using indexes  
5,956
benoit plessis
04/09/2008 10:07AM
Re: Log Query not using indexes  
2,921
Maciej Nadolski
05/11/2008 11:38PM
Re: Log Query not using indexes  
2,501
Rick James
09/27/2008 10:24PM
Re: Log Query not using indexes  
2,796
benoit plessis
09/28/2008 04:49AM
Re: Log Query not using indexes  
2,510
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.