MySQL Forums
Forum List  »  Optimizer & Parser

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

Subject
Views
Written By
Posted
varchar index vs. integer index  
13,794
Alex P
03/09/2009 03:27AM
Re: varchar index vs. integer index  
6,498
Rick James
03/10/2009 08:28PM
Performing multiple updates and selects  
4,674
Kristian Schmidt
03/06/2009 05:56AM
Re: Performing multiple updates and selects  
2,748
Rick James
03/07/2009 11:02AM
Re: Performing multiple updates and selects  
2,660
Kristian Schmidt
03/08/2009 08:23AM
Re: Performing multiple updates and selects  
2,595
Rick James
03/08/2009 01:12PM
Re: Performing multiple updates and selects  
2,581
Kristian Schmidt
03/08/2009 03:53PM
Use two indexes (filter "temporary results")  
4,411
Zoltán Lehóczky
12/21/2008 02:06PM
Re: Use two indexes (filter "temporary results")  
2,430
Rick James
03/01/2009 01:18AM
Large range query stops using indexes  
8,166
Solomon Chang
06/11/2007 10:43PM
Re: Large range query stops using indexes  
3,244
Joe Kuan
02/28/2009 04:49AM
Re: Large range query stops using indexes  
3,693
KimSeong Loh
06/12/2007 09:51PM
Re: Large range query stops using indexes  
3,743
Solomon Chang
06/20/2007 11:06AM
Re: Large range query stops using indexes  
3,693
KimSeong Loh
06/21/2007 03:20AM
MySQL Optimizer Code  
4,168
Tobias Zahn
02/22/2009 12:40PM
Re: MySQL Optimizer Code  
2,741
Rick James
02/22/2009 03:20PM
Re: MySQL Optimizer Code  
2,729
Tobias Zahn
02/23/2009 05:15AM
Re: MySQL Optimizer Code  
2,500
Tobias Zahn
02/27/2009 06:40AM
CONCAT IN WHERE  
13,034
Justin Johnson
02/23/2009 09:09PM
Distinct seems to mess up query results  
3,561
Premal Shah
02/18/2009 04:54PM
8 CPU Cores.....only 1 or 2 being used at the same time...  
6,360
Tobias Marx
02/11/2009 02:29PM
Re: 8 CPU Cores.....only 1 or 2 being used at the same time...  
3,444
Rick James
02/13/2009 12:22AM
low priority select  
6,873
Erel Segal
02/02/2009 06:08AM
Re: low priority select  
4,150
KimSeong Loh
02/02/2009 09:19PM
Re: low priority select  
3,410
Rick James
02/02/2009 09:33PM
Re: low priority select  
3,269
Erel Segal
02/04/2009 01:41AM
Script Running for 8 Hours! Need to optimise DESPERATELY!  
3,911
Graham Hemson
01/28/2009 05:27AM
Re: Script Running for 8 Hours! Need to optimise DESPERATELY!  
2,326
Rick James
01/29/2009 10:58PM
Splitting complex SQL select query in to independent sequence of small queries.  
6,363
Prasanth Reddy
01/28/2009 11:10AM
Re: Splitting complex SQL select query in to independent sequence of small queries.  
3,519
Rick James
01/29/2009 12:40AM
Re: Splitting complex SQL select query in to independent sequence of small queries.  
3,145
Vince Gatto
01/28/2009 01:53PM
WHERE clause in View  
16,943
John Kounis
01/24/2009 04:48PM
Re: WHERE clause in View  
4,790
Rick James
01/24/2009 06:55PM
Re: WHERE clause in View  
4,430
John Kounis
01/24/2009 07:08PM
Re: WHERE clause in View  
3,549
Rick James
01/24/2009 10:12PM
Re: WHERE clause in View  
5,502
John Kounis
01/25/2009 01:15PM
Re: WHERE clause in View  
3,352
Rick James
01/25/2009 10:28PM
Re: WHERE clause in View  
3,442
John Kounis
01/26/2009 12:42PM
Re: WHERE clause in View  
3,212
Rick James
01/26/2009 07:13PM
Re: WHERE clause in View  
3,541
John Kounis
01/28/2009 02:11PM
Loose Index  
3,445
Dheleban india
01/22/2009 08:26AM
Re: Loose Index  
2,425
Rick James
01/23/2009 12:47AM
Query Cache Behaviour  
3,372
walter stanish
01/21/2009 10:01PM
Re: Query Cache Behaviour  
2,444
Rick James
01/21/2009 11:47PM
Loads slow when 130+ online  
3,509
Crisy Fallows
01/16/2009 08:58AM
Re: Loads slow when 130+ online  
2,500
Rick James
01/19/2009 09:47PM
Re: Loads slow when 130+ online  
2,385
Crisy Fallows
01/21/2009 07:59PM
Re: Loads slow when 130+ online  
2,340
Rick James
01/21/2009 11:32PM
Optimizing ORDER BY in "complex" query  
3,603
Julien Genestoux
01/09/2009 06:36PM
Re: Optimizing ORDER BY in "complex" query  
2,398
Rick James
01/19/2009 10:03PM
Re: Optimizing ORDER BY in "complex" query  
2,376
Ryan Lowe
01/10/2009 04:38PM
Optimizer??  
3,312
James Brown
01/14/2009 08:57AM
Re: Optimizer??  
2,151
Rick James
01/19/2009 09:54PM
still stuck on Using temporary; Using filesort  
8,189
Johannes Fosseus
11/21/2008 03:34AM
Re: still stuck on Using temporary; Using filesort  
3,565
Zoltán Lehóczky
12/21/2008 01:43PM
How to optimize a range  
9,215
David Spindler
08/02/2006 07:56AM
Re: How to optimize a range  
9,026
Björn Steinbrink
07/18/2007 04:52PM
Re: How to optimize a range  
3,591
keith cascio
12/13/2008 09:32PM
Re: How to optimize a range  
4,145
Niko Viitala
07/13/2007 03:30AM
Re: How to optimize a range  
4,275
Toa Sty
08/04/2006 09:00AM
Optimizing for e-commerce  
3,159
karl lillrud
12/13/2008 09:22PM
why is MySQL not using an available index?  
7,623
Raymond Davis
12/20/2007 01:11PM
Re: why is MySQL not using an available index?  
4,918
KimSeong Loh
12/25/2007 11:48PM
Re: why is MySQL not using an available index?  
3,559
Ted Smith
12/04/2008 03:10PM
Need Suggestion for Large Database  
3,724
Kausik Sarkar
10/02/2008 01:54PM
Re: Need Suggestion for Large Database  
2,360
Ted Smith
12/04/2008 02:51PM
Re: Need Suggestion for Large Database  
2,579
Rick James
10/02/2008 08:13PM
Re: Need Suggestion for Large Database  
2,490
david yeung
10/22/2008 11:23PM
THERE IS NO OPTIMIZER IN MYSQL!!!!  
3,122
Ted Smith
12/04/2008 02:50PM
MySql Optimizer really sucks sometimes :D  
3,889
Thibault Delor
11/25/2008 10:45AM
Re: MySql Optimizer really sucks sometimes :D  
2,568
KimSeong Loh
11/25/2008 11:46PM
Re: MySql Optimizer really sucks sometimes :D  
2,588
Thibault Delor
11/29/2008 05:31AM
INDEXES on JOINS - example + question  
5,278
Firstname lastname
11/27/2008 02:37PM
Re: INDEXES on JOINS - example + question  
2,842
KimSeong Loh
11/28/2008 01:21AM
Re: INDEXES on JOINS - example + question  
2,587
Firstname lastname
11/28/2008 04:01AM
query takes a long time with large database  
5,479
Harish Balakrishnan Marar
11/25/2008 03:02AM
Re: query takes a long time with large database  
2,540
KimSeong Loh
11/25/2008 11:49PM
Dependent subquery oddness  
4,311
Matt C
09/05/2008 02:23PM
Re: Dependent subquery oddness  
2,788
Vasile Ceteras
11/24/2008 08:37AM
two tabel join result in: Using where; Using temporary; Using filesort  
6,866
Johannes Fosseus
11/20/2008 04:33PM
Re: two tabel join result in: Using where; Using temporary; Using filesort  
3,158
KimSeong Loh
11/20/2008 06:09PM
Re: two tabel join result in: Using where; Using temporary; Using filesort  
2,870
Johannes Fosseus
11/21/2008 01:12AM
Why isn't table using an index?  
3,189
Christie Sorenson
11/17/2008 03:46PM
Filesort & limit: poor optimization?  
3,491
Olaf van der Spek
11/17/2008 08:18AM
Why is this query table scanning?  
3,563
alan langridge
11/11/2008 10:54AM
Re: Why is this query table scanning?  
2,190
KimSeong Loh
11/13/2008 08:22PM
MySQL 5 using too many resources  
5,218
john marshall
11/12/2008 03:18AM
Re: MySQL 5 using too many resources  
2,982
john marshall
11/13/2008 08:17AM
Re: MySQL 5 using too many resources  
2,901
john marshall
11/12/2008 05:42AM
Help with slow select due to complex order-by  
4,969
Mark Williams
11/10/2008 06:44AM
Re: Help with slow select due to complex order-by  
2,635
kkmr india
11/11/2008 07:11AM
PRIMARY key not being used as key  
3,685
Jeff Strahl
10/29/2008 11:38AM
Re: PRIMARY key not being used as key  
2,463
KimSeong Loh
11/10/2008 06:20PM
Speed up INSERT/UPDATE Process  
11,355
Irfan Ali
09/26/2008 10:42PM
Re: Speed up INSERT/UPDATE Process  
6,997
Rick James
09/26/2008 10:57PM
Re: Speed up INSERT/UPDATE Process  
6,948
Irfan Ali
09/27/2008 02:32AM
Re: Speed up INSERT/UPDATE Process  
5,541
david yeung
10/22/2008 11:43PM
ORDER BY on SUM() results  
24,935
Lamaru Omar
04/10/2007 08:16AM
Re: ORDER BY on SUM() results  
4,866
hieu ngoc
04/04/2008 02:09AM
Re: ORDER BY on SUM() results  
5,703
KimSeong Loh
07/19/2007 07:07PM
Re: ORDER BY on SUM() results  
8,778
Martijn Dijkstra
07/19/2007 10:17AM
Re: ORDER BY on SUM() results  
5,107
david yeung
10/22/2008 11:37PM
1 second query even as a Heap table  
4,065
Tobias Marx
04/26/2008 05:11AM
Re: 1 second query even as a Heap table  
2,495
Rick James
10/02/2008 08:14PM
Re: 1 second query even as a Heap table  
2,440
david yeung
10/22/2008 11:26PM
InnoDB seemingly fails to use the full resources while inserting  
3,394
Frans Grotepass
10/20/2008 08:40AM
it will be an stupid error but...  
3,791
artica brd
10/17/2008 02:30AM
Resolved  
2,271
artica brd
10/17/2008 04:53AM
MySQL CPU Issue  
3,655
Mathieu Louis
10/17/2008 01:25AM
mySQL QUERY  
3,528
Lauren Halupke
10/14/2008 01:55PM
Optimizer optimizes dependent on data in tables?  
3,602
Daniel Haas
08/18/2008 11:02AM
Re: Optimizer optimizes dependent on data in tables?  
2,466
Rick James
09/26/2008 11:29PM
Re: Optimizer optimizes dependent on data in tables?  
2,440
Rey Wang
10/12/2008 04:16PM
InnoDB + Update Statistics  
3,577
Leopold Vallauri
10/09/2008 03:52AM
Paging on Union queries  
8,111
Tobias Marx
03/24/2008 11:23AM
Re: Paging on Union queries  
3,476
Rick James
09/28/2008 03:51PM
error on optimize table : The table '#sql-1be4_8' is full  
6,681
Delphine PIN
04/10/2008 05:50AM
Re: error on optimize table : The table '#sql-1be4_8' is full  
3,076
Rick James
09/28/2008 03:36PM
optimizing by adding a new field  
4,178
spam Mcbain
04/03/2008 05:32AM
Re: optimizing by adding a new field  
2,484
Rick James
09/28/2008 03:34PM
Re: optimizing by adding a new field  
2,696
spam Mcbain
04/08/2008 02:27AM
Millions of Rows - Several GB - How to Optimize these queries  
9,529
Mike K
02/18/2008 07:46PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
3,701
Rick James
09/28/2008 03:27PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
4,550
Mike K
02/18/2008 08:52PM
Re: Millions of Rows - Several GB - How to Optimize these queries  
4,238
Benoit St-Jean
04/03/2008 07:14AM
Not using index from 'possible_keys'  
6,977
Maciej Nadolski
05/08/2008 05:52AM
Re: Not using index from 'possible_keys'  
3,188
Rick James
09/28/2008 03:13PM
Something is wrong, help me please!!!!  
4,511
hieu ngoc
04/04/2008 12:32AM
Re: Something is wrong, help me please!!!!  
2,521
Lars Johansson
05/17/2008 10:46PM
Re: Something is wrong, help me please!!!!  
2,292
Rick James
09/28/2008 03:08PM
Re: Something is wrong, help me please!!!!  
2,602
KimSeong Loh
04/04/2008 09:16PM
Log Query not using indexes  
6,018
benoit plessis
04/09/2008 10:07AM
Re: Log Query not using indexes  
2,939
Maciej Nadolski
05/11/2008 11:38PM
Re: Log Query not using indexes  
2,524
Rick James
09/27/2008 10:24PM
Re: Log Query not using indexes  
2,827
benoit plessis
09/28/2008 04:49AM
Re: Log Query not using indexes  
2,529
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.