|
Sticky:
MySQL 5.6: InnoDB Read-only Performance (1 Posts)
|
1,668 |
Edwin Desouza
|
07/02/2012 10:58AM
|
|
Sticky:
Upgrading from MyISAM to InnoDB (1 Posts)
|
4,107 |
Edwin DeSouza
|
11/16/2010 11:20AM
|
|
Mysql group by returns wrong result
|
220 |
Pradeep mar
|
03/04/2013 01:01AM
|
|
Re: Mysql group by returns wrong result
|
121 |
Rick James
|
03/04/2013 09:19PM
|
|
Re: Mysql group by returns wrong result
|
122 |
Pradeep kumar
|
03/08/2013 01:15AM
|
|
Re: Mysql group by returns wrong result
|
112 |
Rick James
|
03/10/2013 07:28PM
|
|
Re: Mysql group by returns wrong result
|
105 |
Pradeep kumar
|
03/14/2013 04:38AM
|
|
Re: Mysql group by returns wrong result
|
135 |
Pradeep kumar
|
03/26/2013 12:25AM
|
|
why bigger index of ascii than utf8?
|
206 |
武士 小浜
|
03/20/2013 09:01PM
|
|
Re: why bigger index of ascii than utf8?
|
108 |
Rick James
|
03/23/2013 06:33PM
|
|
Re: why bigger index of ascii than utf8?
|
97 |
武士 小浜
|
03/24/2013 12:29AM
|
|
After creating a big amount of temporary tables I get this message: Can't create table 'table_name' (errno: 22) the binary log entry just before getting the error : DROP /*!40005 TEMPORARY */ TABLE IF EXISTS...
|
257 |
jani killer
|
02/21/2013 06:46AM
|
|
Re: After creating a big amount of temporary tables I get this message: Can't create table 'table_name' (errno: 22) the binary log entry just before getting the error : DROP /*!40005 TEMPORARY */ TABLE IF EXISTS...
|
131 |
Rick James
|
02/23/2013 07:01PM
|
|
MyISAM index issue
|
254 |
Wayne Clancy
|
02/11/2013 10:48AM
|
|
Re: MyISAM index issue
|
148 |
Rick James
|
02/12/2013 10:08AM
|
|
issue with myisam
|
237 |
miky heky
|
02/09/2013 12:12AM
|
|
Re: issue with myisam
|
139 |
Rick James
|
02/09/2013 09:48PM
|
|
LOCK replication safe?
|
255 |
Brad Proctor
|
02/08/2013 01:09PM
|
|
Re: LOCK replication safe?
|
145 |
Rick James
|
02/09/2013 12:55PM
|
|
5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
417 |
Ben Wallach
|
01/23/2013 06:44PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
249 |
Scott Nemes
|
01/24/2013 10:59AM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
231 |
Ben Wallach
|
01/24/2013 12:16PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
219 |
Scott Nemes
|
01/24/2013 01:41PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
216 |
Ben Wallach
|
01/24/2013 02:29PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
204 |
Scott Nemes
|
01/24/2013 03:14PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
217 |
Ben Wallach
|
01/24/2013 03:36PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
228 |
Scott Nemes
|
01/24/2013 03:44PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
192 |
Ben Wallach
|
01/25/2013 09:28AM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
206 |
Scott Nemes
|
01/25/2013 09:51AM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
223 |
Rick James
|
01/26/2013 12:40AM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
207 |
Ben Wallach
|
01/26/2013 09:57AM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
213 |
Rick James
|
01/26/2013 01:35PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
203 |
Scott Nemes
|
01/26/2013 02:25PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
217 |
Ben Wallach
|
01/26/2013 03:36PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
211 |
Rick James
|
01/26/2013 06:02PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
209 |
Ben Wallach
|
01/26/2013 07:18PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
214 |
Rick James
|
01/26/2013 09:33PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
210 |
Ben Wallach
|
01/27/2013 11:01AM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
225 |
Scott Nemes
|
01/27/2013 12:44PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
240 |
Ben Wallach
|
01/27/2013 03:40PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
204 |
Ben Wallach
|
01/28/2013 11:13AM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
230 |
Ben Wallach
|
02/01/2013 03:35PM
|
|
Re: 5.1 to 5.5 upgrade causes significant write slowdown (MyISAM + indexes)
|
207 |
Scott Nemes
|
02/01/2013 03:37PM
|
|
convert myisam to innodb - table status
|
592 |
Greg K
|
12/03/2012 06:09AM
|
|
Re: convert myisam to innodb - table status
|
277 |
Rick James
|
12/05/2012 12:26AM
|
|
Re: convert myisam to innodb - table status
|
221 |
Greg K.
|
01/10/2013 01:24AM
|
|
Re: convert myisam to innodb - table status
|
252 |
Rick James
|
01/13/2013 12:00AM
|
|
Waiting for table metadata lock
|
621 |
Jon Ribbens
|
01/06/2013 10:24AM
|
|
Re: Waiting for table metadata lock
|
364 |
Rick James
|
01/07/2013 11:03PM
|
|
Re: Waiting for table metadata lock
|
488 |
Jon Ribbens
|
01/08/2013 05:15AM
|
|
Concurrency probloem of MyIsam.
|
341 |
landtunes nomatter
|
01/01/2013 10:08PM
|
|
Re: Concurrency probloem of MyIsam.
|
173 |
Rick James
|
01/05/2013 03:23PM
|
|
Rebuilding Index
|
384 |
Charles Siu
|
12/11/2012 10:26PM
|
|
Re: Rebuilding Index
|
195 |
Rick James
|
12/20/2012 02:48PM
|
|
Help to optimize query
|
550 |
Daniel Morais
|
11/27/2012 12:27PM
|
|
Re: Help to optimize query
|
252 |
Rick James
|
12/02/2012 09:23AM
|
|
Unknown MyISAM file
|
389 |
Tom Cleaveland
|
11/21/2012 08:52AM
|
|
Re: Unknown MyISAM file
|
217 |
Tom Cleaveland
|
11/21/2012 09:43AM
|
|
Enable Keys use keycache with "errorno 0" - 800Million Rows in one partition - 5 index
|
583 |
Emmanuel Vincent
|
10/31/2012 08:27AM
|
|
Re: Enable Keys use keycache with "errorno 0" - 800Million Rows in one partition - 5 index
|
329 |
Rick James
|
11/01/2012 10:55PM
|
|
Re: Enable Keys use keycache with "errorno 0" - 800Million Rows in one partition - 5 index
|
345 |
Emmanuel Vincent
|
11/02/2012 05:20AM
|
|
Re: Enable Keys use keycache with "errorno 0" - 800Million Rows in one partition - 5 index
|
263 |
Emmanuel Vincent
|
11/07/2012 03:17AM
|
|
Working with short words in full text search
|
393 |
Thato Mantai
|
10/26/2012 12:03PM
|
|
Re: Working with short words in full text search
|
284 |
Rick James
|
10/27/2012 12:08PM
|
|
Re: Working with short words in full text search
|
238 |
Thato Mantai
|
11/06/2012 03:00PM
|
|
Index Keys of the table
|
434 |
fei lee
|
10/28/2012 11:01PM
|
|
Re: Index Keys of the table
|
295 |
Rick James
|
10/30/2012 11:59AM
|
|
Re: Index Keys of the table
|
263 |
fei lee
|
11/01/2012 08:05PM
|
|
Re: Index Keys of the table
|
263 |
Rick James
|
11/02/2012 08:21PM
|
|
Re: Index Keys of the table
|
253 |
fei lee
|
11/04/2012 08:54PM
|
|
order by rand() Query takes too long (writes to disk)
|
497 |
Bernd Meier
|
10/28/2012 02:01PM
|
|
Re: order by rand() Query takes too long (writes to disk)
|
336 |
Rick James
|
10/30/2012 12:22PM
|
|
Help understanding the relationship between threads and opened tables for MyISAM
|
501 |
Michael Finch
|
10/09/2012 06:36PM
|
|
Re: Help understanding the relationship between threads and opened tables for MyISAM
|
263 |
Rick James
|
10/10/2012 08:02PM
|
|
Add multiple interrior ring to mysql spatial extention
|
520 |
Hendra Darwintha
|
09/15/2012 07:45AM
|
|
Re: Add multiple interrior ring to mysql spatial extention
|
301 |
Aftab Khan
|
09/20/2012 02:05AM
|
|
MySQL Full Text Search not returing all records
|
456 |
Brett Atkin
|
09/16/2012 09:02PM
|
|
Re: MySQL Full Text Search not returing all records
|
282 |
Rick James
|
09/17/2012 07:40PM
|
|
Re: MySQL Full Text Search not returing all records
|
326 |
Brett Atkin
|
09/18/2012 07:39AM
|
|
query scanning all rows
|
548 |
jay oberoi
|
09/12/2012 01:20PM
|
|
Re: query scanning all rows
|
304 |
Rick James
|
09/15/2012 12:44PM
|
|
fulltext boolean search not returning a particular row
|
533 |
Sascha Monteiro
|
08/31/2012 10:03PM
|
|
Re: fulltext boolean search not returning a particular row
|
342 |
Rick James
|
09/01/2012 06:14PM
|
|
Re: fulltext boolean search not returning a particular row
|
343 |
Sascha Monteiro
|
09/01/2012 09:44PM
|
|
Re: fulltext boolean search not returning a particular row
|
382 |
Rick James
|
09/02/2012 06:01PM
|
|
Almost whole table in single index: is there a better way?
|
609 |
Andy Deakin
|
08/25/2012 07:33AM
|
|
Re: Almost whole table in single index: is there a better way?
|
391 |
Aftab Khan
|
08/27/2012 09:18AM
|
|
Re: Almost whole table in single index: is there a better way?
|
367 |
Andy Deakin
|
08/27/2012 10:18AM
|
|
Re: Almost whole table in single index: is there a better way?
|
373 |
Aftab Khan
|
08/27/2012 11:02AM
|
|
Re: Almost whole table in single index: is there a better way?
|
427 |
Andy Deakin
|
08/27/2012 11:16AM
|
|
Re: Almost whole table in single index: is there a better way?
|
381 |
Aftab Khan
|
08/27/2012 11:42AM
|
|
Re: Almost whole table in single index: is there a better way?
|
344 |
Andy Deakin
|
08/27/2012 12:29PM
|
|
Re: Almost whole table in single index: is there a better way?
|
378 |
Rick James
|
08/28/2012 08:43AM
|
|
Re: Almost whole table in single index: is there a better way?
|
338 |
Andy Deakin
|
08/28/2012 10:08AM
|
|
Re: Almost whole table in single index: is there a better way?
|
353 |
Aftab Khan
|
08/28/2012 10:52AM
|
|
Re: Almost whole table in single index: is there a better way?
|
391 |
Rick James
|
08/28/2012 11:20PM
|
|
Re: Almost whole table in single index: is there a better way?
|
409 |
Aftab Khan
|
08/27/2012 10:53AM
|
|
5% of spare memory key buffer big enough?
|
637 |
Josh Irish
|
08/15/2012 03:53AM
|
|
Re: 5% of spare memory key buffer big enough?
|
444 |
Aftab Khan
|
08/17/2012 11:09AM
|
|
Re: 5% of spare memory key buffer big enough?
|
391 |
Rick James
|
08/19/2012 01:41PM
|
|
Two instances better - or mix MyISAM and InnoDB?
|
677 |
|
08/07/2012 05:31PM
|
|
Re: Two instances better - or mix MyISAM and InnoDB?
|
445 |
Rick James
|
08/08/2012 11:14PM
|
|
Re: Two instances better - or mix MyISAM and InnoDB?
|
431 |
Aftab Khan
|
08/11/2012 04:37AM
|
|
Re: Two instances better - or mix MyISAM and InnoDB?
|
426 |
|
08/15/2012 10:09AM
|
|
Re: Two instances better - or mix MyISAM and InnoDB?
|
390 |
Rick James
|
08/18/2012 10:15PM
|
|
A Question on MyISAM table locking on joins.
|
674 |
John Snow
|
08/01/2012 09:14AM
|
|
Re: A Question on MyISAM table locking on joins.
|
426 |
Rick James
|
08/03/2012 12:38AM
|
|
Error "Duplicate entry for key 1", but there don't seem to be any duplicates...
|
1,009 |
Kenn Baker
|
08/02/2012 04:50AM
|
|
Re: Error "Duplicate entry for key 1", but there don't seem to be any duplicates...
|
497 |
Kenn Baker
|
08/02/2012 11:06PM
|
|
How to index a 1.5 billion rows
|
832 |
Vladimir Pivovar
|
07/10/2012 02:46AM
|
|
Re: How to index a 1.5 billion rows
|
528 |
Rick James
|
07/11/2012 05:56AM
|
|
Re: How to index a 1.5 billion rows
|
483 |
Vladimir Pivovar
|
07/17/2012 12:57AM
|
|
Re: How to index a 1.5 billion rows
|
457 |
Aftab Khan
|
07/29/2012 04:42AM
|
|
Re: How to index a 1.5 billion rows
|
409 |
Rick James
|
07/17/2012 10:06PM
|
|
Re: How to index a 1.5 billion rows
|
428 |
Vladimir Pivovar
|
07/18/2012 10:18AM
|
|
Re: How to index a 1.5 billion rows
|
457 |
Rick James
|
07/19/2012 09:46PM
|
|
Calculate bytes stored per row for dynamic format
|
812 |
Myra Lords
|
07/03/2012 12:29PM
|
|
Re: Calculate bytes stored per row for dynamic format
|
453 |
Rick James
|
07/04/2012 09:28AM
|
|
Re: Calculate bytes stored per row for dynamic format
|
478 |
Myra Lords
|
07/04/2012 09:44AM
|
|
Re: Calculate bytes stored per row for dynamic format
|
424 |
Rick James
|
07/05/2012 06:00AM
|
|
Re: Calculate bytes stored per row for dynamic format
|
465 |
Myra Lords
|
07/13/2012 05:11AM
|
|
Re: Calculate bytes stored per row for dynamic format
|
394 |
Rick James
|
07/17/2012 07:44PM
|
|
Improve performance of a query with join and order by
|
664 |
Mario Rossi
|
07/16/2012 03:25AM
|
|
Re: Improve performance of a query with join and order by
|
383 |
Rick James
|
07/16/2012 11:08PM
|
|
Es posible recuperar datos de una tabla
|
605 |
Mauricio Zambrana
|
07/12/2012 01:30PM
|
|
is it posible to create table with symbols + or - ???
|
676 |
InterSky :)
|
07/08/2012 03:12PM
|
|
large file operations exhaust memory
|
876 |
Tomas Singliar
|
07/02/2012 09:52AM
|
|
Re: large file operations exhaust memory
|
502 |
Rick James
|
07/03/2012 12:47PM
|
|
Re: large file operations exhaust memory
|
444 |
Tomas Singliar
|
07/04/2012 02:20AM
|
|
5.5 running tiny queries much slower than 5.0
|
887 |
Andrew Leonard
|
06/27/2012 01:18PM
|
|
Re: 5.5 running tiny queries much slower than 5.0
|
507 |
Andrew Leonard
|
06/28/2012 10:08AM
|
|
Re: 5.5 running tiny queries much slower than 5.0
|
501 |
Rick James
|
07/01/2012 01:41PM
|
|
Re: 5.5 running tiny queries much slower than 5.0
|
490 |
Andrew Leonard
|
07/02/2012 01:12PM
|
|
Re: 5.5 running tiny queries much slower than 5.0
|
513 |
Rick James
|
07/03/2012 12:32PM
|
|
concurrent inserts not working
|
709 |
ashish behl
|
06/29/2012 05:23AM
|
|
MyISAM table repair problem
|
673 |
santosh kumar
|
06/22/2012 12:33AM
|
|
search inclose in double quote
|
716 |
jean Clariond
|
06/06/2012 04:27AM
|
|
Re: search inclose in double quote
|
453 |
jean Clariond
|
06/15/2012 09:00AM
|
|
Re: search inclose in double quote
|
417 |
Rick James
|
06/12/2012 09:43PM
|
|
Re: search inclose in double quote
|
440 |
jean Clariond
|
06/15/2012 09:14AM
|
|
Re: search inclose in double quote
|
518 |
Rick James
|
06/16/2012 03:59PM
|
|
Queries on MyISAM
|
845 |
m newbie
|
06/04/2012 02:42PM
|
|
Re: Queries on MyISAM
|
524 |
Rick James
|
06/10/2012 10:57PM
|
|
improve the chances crash recovery for MyISAM
|
785 |
Mubarak Abdallah
|
06/06/2012 08:10PM
|
|
Re: improve the chances crash recovery for MyISAM
|
453 |
Rick James
|
06/10/2012 10:51PM
|
|
Fulltext search problem!
|
1,007 |
mahmud mofrad
|
05/26/2012 02:35AM
|
|
Re: Fulltext search problem!
|
457 |
Rick James
|
05/26/2012 10:10PM
|
|
Re: Fulltext search problem!
|
503 |
mahmud mofrad
|
05/27/2012 12:07AM
|
|
Deleted table file behavior!
|
1,006 |
Eliezer Figueroa
|
05/01/2012 11:17PM
|
|
Re: Deleted table file behavior!
|
467 |
Rick James
|
05/02/2012 07:35PM
|
|
Re: Deleted table file behavior!
|
477 |
Eliezer Figueroa
|
05/02/2012 10:25PM
|
|
Re: Deleted table file behavior!
|
553 |
Rick James
|
05/03/2012 07:06PM
|
|
Re: Deleted table file behavior!
|
472 |
Eliezer Figueroa
|
05/03/2012 10:00PM
|
|
Optimize Table Taking Forever
|
1,082 |
Thomas Cleveland
|
04/27/2012 03:03AM
|
|
Re: Optimize Table Taking Forever
|
1,141 |
Thomas Cleveland
|
04/28/2012 04:17PM
|
|
Re: Optimize Table Taking Forever
|
910 |
Rick James
|
04/30/2012 12:32AM
|
|
Re: Optimize Table Taking Forever
|
861 |
Thomas Cleveland
|
04/30/2012 03:52AM
|
|
Re: Optimize Table Taking Forever
|
785 |
Rick James
|
05/01/2012 10:14AM
|
|
Re: Optimize Table Taking Forever
|
1,026 |
Thomas Cleveland
|
04/30/2012 10:12AM
|
|
Binary log Synchronization
|
786 |
Aftab Khan
|
04/18/2012 03:14AM
|
|
problem union and order by
|
955 |
Uwe Geercken
|
04/13/2012 01:07AM
|
|
Re: problem union and order by
|
583 |
Uwe Geercken
|
04/13/2012 01:36AM
|
|
Problem: INSERT DELAYED works like normal INSERT
|
1,261 |
Benland Benland
|
03/27/2012 06:15AM
|
|
Re: Problem: INSERT DELAYED works like normal INSERT
|
562 |
Rick James
|
03/29/2012 09:49PM
|
|
Re: Problem: INSERT DELAYED works like normal INSERT
|
569 |
Benland Benland
|
03/30/2012 10:08AM
|
|
Re: Problem: INSERT DELAYED works like normal INSERT
|
728 |
Rick James
|
03/31/2012 12:59PM
|
|
Re: Problem: INSERT DELAYED works like normal INSERT
|
702 |
Rick James
|
04/01/2012 07:31AM
|
|
Got error 64 when reading table '/tmp/#sql_5389_0'
|
1,044 |
Geoff Rowland
|
03/08/2012 10:19AM
|
|
Re: Got error 64 when reading table '/tmp/#sql_5389_0'
|
545 |
Rick James
|
03/10/2012 06:29PM
|
|
Result Set Differentiation..!!
|
1,002 |
Saurabh Arora
|
03/02/2012 04:49AM
|
|
Re: Result Set Differentiation..!!
|
575 |
Rick James
|
03/04/2012 06:58PM
|
|
Re: Result Set Differentiation..!!
|
590 |
Saurabh Arora
|
03/05/2012 12:26AM
|
|
restore myisam table Field List state
|
1,372 |
athiq rahman
|
02/16/2012 02:29PM
|
|
Re: restore myisam table Field List state
|
628 |
Rick James
|
02/17/2012 09:37PM
|
|
size of TMD relative to MYD and MYI
|
1,551 |
athiq rahman
|
02/12/2012 04:31AM
|
|
Re: size of TMD relative to MYD and MYI
|
990 |
Rick James
|
02/14/2012 11:43AM
|
|
Re: size of TMD relative to MYD and MYI
|
995 |
athiq rahman
|
02/14/2012 02:44PM
|
|
Re: size of TMD relative to MYD and MYI
|
683 |
Rick James
|
02/15/2012 11:17PM
|
|
Re: size of TMD relative to MYD and MYI
|
672 |
athiq rahman
|
02/16/2012 06:52AM
|
|
How to improve the join performance on 15 tables
|
1,202 |
SivaKumar A
|
02/02/2012 06:34PM
|
|
Re: How to improve the join performance on 15 tables
|
653 |
Rick James
|
02/03/2012 08:22PM
|