MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   Announcing a new webcast video that completes a deep dive into how to download and use Enterprise Manager for MySQL 04/04/2024 03:01PM

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

Subject
Views
Written By
Posted
varchar index vs. integer index  
13,498
Alex P
03/09/2009 03:27AM
Re: varchar index vs. integer index  
6,358
Rick James
03/10/2009 08:28PM
Performing multiple updates and selects  
4,469
Kristian Schmidt
03/06/2009 05:56AM
Re: Performing multiple updates and selects  
2,651
Rick James
03/07/2009 11:02AM
Re: Performing multiple updates and selects  
2,567
Kristian Schmidt
03/08/2009 08:23AM
Re: Performing multiple updates and selects  
2,503
Rick James
03/08/2009 01:12PM
Re: Performing multiple updates and selects  
2,497
Kristian Schmidt
03/08/2009 03:53PM
Use two indexes (filter "temporary results")  
4,248
Zoltán Lehóczky
12/21/2008 02:06PM
Re: Use two indexes (filter "temporary results")  
2,354
Rick James
03/01/2009 01:18AM
Large range query stops using indexes  
7,850
Solomon Chang
06/11/2007 10:43PM
Re: Large range query stops using indexes  
3,126
Joe Kuan
02/28/2009 04:49AM
Re: Large range query stops using indexes  
3,577
KimSeong Loh
06/12/2007 09:51PM
Re: Large range query stops using indexes  
3,636
Solomon Chang
06/20/2007 11:06AM
Re: Large range query stops using indexes  
3,601
KimSeong Loh
06/21/2007 03:20AM
MySQL Optimizer Code  
4,032
Tobias Zahn
02/22/2009 12:40PM
Re: MySQL Optimizer Code  
2,667
Rick James
02/22/2009 03:20PM
Re: MySQL Optimizer Code  
2,646
Tobias Zahn
02/23/2009 05:15AM
Re: MySQL Optimizer Code  
2,429
Tobias Zahn
02/27/2009 06:40AM
CONCAT IN WHERE  
12,881
Justin Johnson
02/23/2009 09:09PM
Distinct seems to mess up query results  
3,420
Premal Shah
02/18/2009 04:54PM
8 CPU Cores.....only 1 or 2 being used at the same time...  
6,143
Tobias Marx
02/11/2009 02:29PM
Re: 8 CPU Cores.....only 1 or 2 being used at the same time...  
3,359
Rick James
02/13/2009 12:22AM
low priority select  
6,733
Erel Segal
02/02/2009 06:08AM
Re: low priority select  
4,055
KimSeong Loh
02/02/2009 09:19PM
Re: low priority select  
3,334
Rick James
02/02/2009 09:33PM
Re: low priority select  
3,189
Erel Segal
02/04/2009 01:41AM
Script Running for 8 Hours! Need to optimise DESPERATELY!  
3,754
Graham Hemson
01/28/2009 05:27AM
Re: Script Running for 8 Hours! Need to optimise DESPERATELY!  
2,252
Rick James
01/29/2009 10:58PM
Splitting complex SQL select query in to independent sequence of small queries.  
5,932
Prasanth Reddy
01/28/2009 11:10AM
Re: Splitting complex SQL select query in to independent sequence of small queries.  
3,393
Rick James
01/29/2009 12:40AM
Re: Splitting complex SQL select query in to independent sequence of small queries.  
3,006
Vince Gatto
01/28/2009 01:53PM
WHERE clause in View  
16,401
John Kounis
01/24/2009 04:48PM
Re: WHERE clause in View  
4,589
Rick James
01/24/2009 06:55PM
Re: WHERE clause in View  
4,295
John Kounis
01/24/2009 07:08PM
Re: WHERE clause in View  
3,446
Rick James
01/24/2009 10:12PM
Re: WHERE clause in View  
5,377
John Kounis
01/25/2009 01:15PM
Re: WHERE clause in View  
3,212
Rick James
01/25/2009 10:28PM
Re: WHERE clause in View  
3,303
John Kounis
01/26/2009 12:42PM
Re: WHERE clause in View  
3,077
Rick James
01/26/2009 07:13PM
Re: WHERE clause in View  
3,418
John Kounis
01/28/2009 02:11PM
Loose Index  
3,310
Dheleban india
01/22/2009 08:26AM
Re: Loose Index  
2,363
Rick James
01/23/2009 12:47AM
Query Cache Behaviour  
3,247
walter stanish
01/21/2009 10:01PM
Re: Query Cache Behaviour  
2,351
Rick James
01/21/2009 11:47PM
Loads slow when 130+ online  
3,363
Crisy Fallows
01/16/2009 08:58AM
Re: Loads slow when 130+ online  
2,427
Rick James
01/19/2009 09:47PM
Re: Loads slow when 130+ online  
2,308
Crisy Fallows
01/21/2009 07:59PM
Re: Loads slow when 130+ online  
2,257
Rick James
01/21/2009 11:32PM
Optimizing ORDER BY in "complex" query  
3,460
Julien Genestoux
01/09/2009 06:36PM
Re: Optimizing ORDER BY in "complex" query  
2,328
Rick James
01/19/2009 10:03PM
Re: Optimizing ORDER BY in "complex" query  
2,285
Ryan Lowe
01/10/2009 04:38PM
Optimizer??  
3,178
James Brown
01/14/2009 08:57AM
Re: Optimizer??  
2,071
Rick James
01/19/2009 09:54PM
still stuck on Using temporary; Using filesort  
8,037
Johannes Fosseus
11/21/2008 03:34AM
Re: still stuck on Using temporary; Using filesort  
3,498
Zoltán Lehóczky
12/21/2008 01:43PM
How to optimize a range  
9,035
David Spindler
08/02/2006 07:56AM
Re: How to optimize a range  
8,923
Björn Steinbrink
07/18/2007 04:52PM
Re: How to optimize a range  
3,510
keith cascio
12/13/2008 09:32PM
Re: How to optimize a range  
4,059
Niko Viitala
07/13/2007 03:30AM
Re: How to optimize a range  
4,198
Toa Sty
08/04/2006 09:00AM
Optimizing for e-commerce  
3,050
karl lillrud
12/13/2008 09:22PM
why is MySQL not using an available index?  
7,509
Raymond Davis
12/20/2007 01:11PM
Re: why is MySQL not using an available index?  
4,858
KimSeong Loh
12/25/2007 11:48PM
Re: why is MySQL not using an available index?  
3,495
Ted Smith
12/04/2008 03:10PM
Need Suggestion for Large Database  
3,590
Kausik Sarkar
10/02/2008 01:54PM
Re: Need Suggestion for Large Database  
2,294
Ted Smith
12/04/2008 02:51PM
Re: Need Suggestion for Large Database  
2,513
Rick James
10/02/2008 08:13PM
Re: Need Suggestion for Large Database  
2,432
david yeung
10/22/2008 11:23PM
THERE IS NO OPTIMIZER IN MYSQL!!!!  
3,020
Ted Smith
12/04/2008 02:50PM
MySql Optimizer really sucks sometimes :D  
3,762
Thibault Delor
11/25/2008 10:45AM
Re: MySql Optimizer really sucks sometimes :D  
2,495
KimSeong Loh
11/25/2008 11:46PM
Re: MySql Optimizer really sucks sometimes :D  
2,519
Thibault Delor
11/29/2008 05:31AM
INDEXES on JOINS - example + question  
5,136
Firstname lastname
11/27/2008 02:37PM
Re: INDEXES on JOINS - example + question  
2,779
KimSeong Loh
11/28/2008 01:21AM
Re: INDEXES on JOINS - example + question  
2,528
Firstname lastname
11/28/2008 04:01AM
query takes a long time with large database  
5,368
Harish Balakrishnan Marar
11/25/2008 03:02AM
Re: query takes a long time with large database  
2,473
KimSeong Loh
11/25/2008 11:49PM
Dependent subquery oddness  
4,170
Matt C
09/05/2008 02:23PM
Re: Dependent subquery oddness  
2,716
Vasile Ceteras
11/24/2008 08:37AM
two tabel join result in: Using where; Using temporary; Using filesort  
6,740
Johannes Fosseus
11/20/2008 04:33PM
Re: two tabel join result in: Using where; Using temporary; Using filesort  
3,104
KimSeong Loh
11/20/2008 06:09PM
Re: two tabel join result in: Using where; Using temporary; Using filesort  
2,806
Johannes Fosseus
11/21/2008 01:12AM
Why isn't table using an index?  
3,096
Christie Sorenson
11/17/2008 03:46PM
Filesort & limit: poor optimization?  
3,392
Olaf van der Spek
11/17/2008 08:18AM
Why is this query table scanning?  
3,438
alan langridge
11/11/2008 10:54AM
Re: Why is this query table scanning?  
2,129
KimSeong Loh
11/13/2008 08:22PM
MySQL 5 using too many resources  
5,091
john marshall
11/12/2008 03:18AM
Re: MySQL 5 using too many resources  
2,916
john marshall
11/13/2008 08:17AM
Re: MySQL 5 using too many resources  
2,826
john marshall
11/12/2008 05:42AM
Help with slow select due to complex order-by  
4,836
Mark Williams
11/10/2008 06:44AM
Re: Help with slow select due to complex order-by  
2,564
kkmr india
11/11/2008 07:11AM
PRIMARY key not being used as key  
3,565
Jeff Strahl
10/29/2008 11:38AM
Re: PRIMARY key not being used as key  
2,404
KimSeong Loh
11/10/2008 06:20PM
Speed up INSERT/UPDATE Process  
11,242
Irfan Ali
09/26/2008 10:42PM
Re: Speed up INSERT/UPDATE Process  
6,939
Rick James
09/26/2008 10:57PM
Re: Speed up INSERT/UPDATE Process  
6,889
Irfan Ali
09/27/2008 02:32AM
Re: Speed up INSERT/UPDATE Process  
5,470
david yeung
10/22/2008 11:43PM
ORDER BY on SUM() results  
24,693
Lamaru Omar
04/10/2007 08:16AM
Re: ORDER BY on SUM() results  
4,793
hieu ngoc
04/04/2008 02:09AM
Re: ORDER BY on SUM() results  
5,639
KimSeong Loh
07/19/2007 07:07PM
Re: ORDER BY on SUM() results  
8,713
Martijn Dijkstra
07/19/2007 10:17AM
Re: ORDER BY on SUM() results  
5,044
david yeung
10/22/2008 11:37PM
1 second query even as a Heap table  
3,944
Tobias Marx
04/26/2008 05:11AM
Re: 1 second query even as a Heap table  
2,434
Rick James
10/02/2008 08:14PM
Re: 1 second query even as a Heap table  
2,386
david yeung
10/22/2008 11:26PM
InnoDB seemingly fails to use the full resources while inserting  
3,271
Frans Grotepass
10/20/2008 08:40AM
it will be an stupid error but...  
3,668
artica brd
10/17/2008 02:30AM
Resolved  
2,207
artica brd
10/17/2008 04:53AM
MySQL CPU Issue  
3,558
Mathieu Louis
10/17/2008 01:25AM
mySQL QUERY  
3,412
Lauren Halupke
10/14/2008 01:55PM
Optimizer optimizes dependent on data in tables?  
3,482
Daniel Haas
08/18/2008 11:02AM
Re: Optimizer optimizes dependent on data in tables?  
2,408
Rick James
09/26/2008 11:29PM
Re: Optimizer optimizes dependent on data in tables?  
2,391
Rey Wang
10/12/2008 04:16PM
InnoDB + Update Statistics  
3,451
Leopold Vallauri
10/09/2008 03:52AM
Paging on Union queries  
7,758
Tobias Marx
03/24/2008 11:23AM
Re: Paging on Union queries  
3,327
Rick James
09/28/2008 03:51PM
error on optimize table : The table '#sql-1be4_8' is full  
6,526
Delphine PIN
04/10/2008 05:50AM
Re: error on optimize table : The table '#sql-1be4_8' is full  
3,005
Rick James
09/28/2008 03:36PM
optimizing by adding a new field  
4,059
spam Mcbain
04/03/2008 05:32AM
Re: optimizing by adding a new field  
2,427
Rick James
09/28/2008 03:34PM
Re: optimizing by adding a new field  
2,633
spam Mcbain
04/08/2008 02:27AM
Millions of Rows - Several GB - How to Optimize these queries  
9,406
Mike K
02/18/2008 07:46PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
3,638
Rick James
09/28/2008 03:27PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
4,475
Mike K
02/18/2008 08:52PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
4,178
Benoit St-Jean
04/03/2008 07:14AM
Not using index from 'possible_keys'  
6,850
Maciej Nadolski
05/08/2008 05:52AM
Re: Not using index from 'possible_keys'  
3,124
Rick James
09/28/2008 03:13PM
Something is wrong, help me please!!!!  
4,393
hieu ngoc
04/04/2008 12:32AM
Re: Something is wrong, help me please!!!!  
2,460
Lars Johansson
05/17/2008 10:46PM
Re: Something is wrong, help me please!!!!  
2,226
Rick James
09/28/2008 03:08PM
Re: Something is wrong, help me please!!!!  
2,532
KimSeong Loh
04/04/2008 09:16PM
Log Query not using indexes  
5,879
benoit plessis
04/09/2008 10:07AM
Re: Log Query not using indexes  
2,881
Maciej Nadolski
05/11/2008 11:38PM
Re: Log Query not using indexes  
2,443
Rick James
09/27/2008 10:24PM
Re: Log Query not using indexes  
2,733
benoit plessis
09/28/2008 04:49AM
Re: Log Query not using indexes  
2,460
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.