|
Sticky:
MySQL: InnoDB -vs- MyISAM (1 Posts)
|
977 |
Edwin Desouza
|
02/18/2016 11:24PM
|
|
Sticky:
MySQL 5.6: InnoDB Read-only Performance (1 Posts)
|
5,362 |
Edwin Desouza
|
07/02/2012 10:58AM
|
|
How Switching To InnoDB Helped Us Bust Through MyISAM Walls
|
44 |
Edwin Desouza
|
02/22/2017 12:05AM
|
|
Location search in mysql joining 4 tables
|
212 |
Soubhik Chatterjee
|
01/21/2017 07:27AM
|
|
Re: Location search in mysql joining 4 tables
|
65 |
Peter Brawley
|
01/21/2017 04:25PM
|
|
Still disable InnoDB in MySQL 5.7
|
370 |
Jean-Baptiste SILVY
|
11/22/2016 12:46AM
|
|
Re: Still disable InnoDB in MySQL 5.7
|
159 |
Peter Brawley
|
11/22/2016 02:18PM
|
|
Re: Still disable InnoDB in MySQL 5.7
|
165 |
Jean-Baptiste SILVY
|
11/24/2016 10:21PM
|
|
Re: Still disable InnoDB in MySQL 5.7
|
210 |
Rick James
|
11/25/2016 08:02PM
|
|
MySQL 5.6 Upgrade - Hung On Creating sort index
|
496 |
Andrew Klug
|
10/10/2016 09:52AM
|
|
Re: MySQL 5.6 Upgrade - Hung On Creating sort index
|
336 |
Peter Brawley
|
10/10/2016 12:45PM
|
|
Re: MySQL 5.6 Upgrade - Hung On Creating sort index
|
323 |
Rick James
|
10/16/2016 04:56PM
|
|
Composite index
|
515 |
Julian Assange
|
08/26/2016 05:44PM
|
|
Re: Composite index
|
217 |
Rick James
|
08/27/2016 01:55PM
|
|
Re: Composite index
|
225 |
Julian Assange
|
08/28/2016 06:18AM
|
|
Re: Composite index
|
300 |
Rick James
|
08/29/2016 11:34PM
|
|
Re: Composite index
|
245 |
Julian Assange
|
08/30/2016 03:16AM
|
|
Re: Composite index
|
204 |
Rick James
|
08/31/2016 04:48PM
|
|
Too many key parts specified; max 16 parts allowed.
|
630 |
Abhishek Sahu
|
07/27/2016 05:40AM
|
|
Re: Too many key parts specified; max 16 parts allowed.
|
393 |
Rick James
|
07/29/2016 05:10PM
|
|
Re: Too many key parts specified; max 16 parts allowed.
|
344 |
Abhishek Sahu
|
07/31/2016 04:35AM
|
|
Re: Too many key parts specified; max 16 parts allowed.
|
316 |
Rick James
|
08/01/2016 10:33AM
|
|
slow query / table lock
|
553 |
Thomas Manninger
|
06/06/2016 01:55AM
|
|
Re: slow query / table lock
|
266 |
Thomas Manninger
|
06/06/2016 02:06AM
|
|
Re: slow query / table lock
|
255 |
Rick James
|
06/13/2016 01:55AM
|
|
Re: slow query / table lock
|
272 |
Rick James
|
06/13/2016 01:57AM
|
|
Backup MySQL MyISAM databases by copying the physical files
|
825 |
Timothy Mifsud
|
04/01/2016 08:58AM
|
|
Re: Backup MySQL MyISAM databases by copying the physical files
|
436 |
Rick James
|
04/04/2016 12:07PM
|
|
Change from InnoDB to MyISAM storage engine
|
699 |
Michael John
|
03/29/2016 04:01AM
|
|
Re: Change from InnoDB to MyISAM storage engine
|
345 |
Peter Brawley
|
03/29/2016 09:20AM
|
|
Re: Change from InnoDB to MyISAM storage engine
|
393 |
Michael John
|
03/30/2016 07:40AM
|
|
This topic has been moved.:
Load Data Vertical Raw using MySQL command
|
58 |
Ferdie Palero
|
03/29/2016 09:24AM
|
|
Fulltext in MyISAM does not work with cyrillic
|
719 |
Андрей Третяк
|
01/29/2016 09:13AM
|
|
Re: Fulltext in MyISAM does not work with cyrillic
|
414 |
Rick James
|
01/30/2016 10:20AM
|
|
Re: Fulltext in MyISAM does not work with cyrillic
|
392 |
Андрей Третяк
|
02/01/2016 02:04AM
|
|
Re: Fulltext in MyISAM does not work with cyrillic
|
368 |
Rick James
|
02/02/2016 09:33PM
|
|
trying to alter table column to geometry but getting errors. please help.
|
800 |
Richard Jones
|
01/26/2016 05:45AM
|
|
Re: trying to alter table column to geometry but getting errors. please help.
|
406 |
Rick James
|
01/27/2016 09:50PM
|
|
Re: trying to alter table column to geometry but getting errors. please help.
|
399 |
Richard Jones
|
01/28/2016 06:11AM
|
|
Re: trying to alter table column to geometry but getting errors. please help.
|
371 |
Richard Jones
|
01/28/2016 06:22AM
|
|
Re: trying to alter table column to geometry but getting errors. please help.
|
389 |
Rick James
|
01/29/2016 06:39PM
|
|
Re: trying to alter table column to geometry but getting errors. please help.
|
379 |
Richard Jones
|
01/30/2016 03:17PM
|
|
information_schema refresh
|
966 |
Thol Chidambaram
|
12/22/2015 05:28PM
|
|
Re: information_schema refresh
|
464 |
Rick James
|
12/23/2015 09:50PM
|
|
Re: information_schema refresh
|
511 |
Peter Brawley
|
01/29/2016 04:29PM
|
|
Cannot display index entries
|
852 |
Pavlos Ponos
|
11/07/2015 11:04AM
|
|
Re: Cannot display index entries
|
415 |
Peter Brawley
|
11/07/2015 01:46PM
|
|
Re: Cannot display index entries
|
445 |
Pavlos Ponos
|
11/07/2015 01:47PM
|
|
Re: Cannot display index entries
|
412 |
Rick James
|
11/30/2015 08:15PM
|
|
This topic has been moved.:
error 2003
|
17 |
theo tek
|
09/26/2015 11:17PM
|
|
Export geants database
|
1,215 |
loriot alban
|
08/25/2015 03:41AM
|
|
Confusing "Waiting for table level lock"
|
1,268 |
William Oberman
|
06/27/2015 03:02PM
|
|
Re: Confusing "Waiting for table level lock"
|
635 |
Rick James
|
07/02/2015 09:40PM
|
|
Tables keep crashing and corrupting
|
1,517 |
Sebastião Burnay
|
04/28/2015 10:05AM
|
|
Re: Tables keep crashing and corrupting
|
737 |
Rick James
|
04/29/2015 06:41PM
|
|
Re: Tables keep crashing and corrupting
|
727 |
Sebastião Burnay
|
04/30/2015 03:12AM
|
|
Re: Tables keep crashing and corrupting
|
643 |
Rick James
|
05/01/2015 07:42PM
|
|
Too many key parts specified; max 16 parts allowed
|
2,228 |
Ahmad Shahzad
|
04/02/2015 05:47AM
|
|
Re: Too many key parts specified; max 16 parts allowed
|
1,212 |
Peter Brawley
|
04/02/2015 11:06AM
|
|
Re: Too many key parts specified; max 16 parts allowed
|
1,073 |
Rick James
|
04/04/2015 08:37PM
|
|
Table keeps crashing. Why?
|
1,343 |
Johannes Ernst
|
03/24/2015 05:14PM
|
|
Re: Table keeps crashing. Why?
|
732 |
Rick James
|
03/27/2015 12:22AM
|
|
poor create table performance
|
1,307 |
Ronald Van Iwaarden
|
03/04/2015 02:29PM
|
|
Slow performance when using LIMIT 1000
|
1,479 |
Christian Esborg
|
02/26/2015 04:32AM
|
|
Please don't duplicate-post
|
770 |
Peter Brawley
|
02/26/2015 05:03PM
|
|
Option to avoid table rebuild on CREATE INDEX?
|
1,464 |
David Lambert
|
02/03/2015 05:39PM
|
|
Re: Option to avoid table rebuild on CREATE INDEX?
|
799 |
Rick James
|
02/04/2015 07:25PM
|
|
Dumping enormous MYISAM table with BLOB based on WHERE clause
|
1,468 |
Ifechukwukwu Okobi
|
01/29/2015 12:40AM
|
|
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause
|
788 |
Jonathan Stephens
|
01/29/2015 06:27AM
|
|
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause
|
774 |
Ifechukwukwu Okobi
|
01/29/2015 10:34AM
|
|
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause
|
782 |
Rick James
|
01/29/2015 04:53PM
|
|
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause
|
803 |
Rick James
|
01/29/2015 04:59PM
|
|
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause
|
812 |
Ifechukwukwu Okobi
|
01/30/2015 05:49AM
|
|
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause
|
809 |
Rick James
|
01/30/2015 12:01PM
|
|
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause
|
728 |
Ifechukwukwu Okobi
|
01/30/2015 05:46AM
|
|
Memory Problem with 1 DB. Other DB ok
|
1,647 |
Gabriel Dunn
|
01/22/2015 11:15PM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
783 |
Rick James
|
01/24/2015 11:25AM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
788 |
Gabriel Dunn
|
01/25/2015 11:26AM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
851 |
Gabriel Dunn
|
01/25/2015 12:06PM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
755 |
Gabriel Dunn
|
01/25/2015 12:09PM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
729 |
Rick James
|
01/26/2015 12:14PM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
833 |
Gabriel Dunn
|
01/26/2015 12:25PM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
735 |
Rick James
|
01/27/2015 09:45PM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
813 |
Peter Brawley
|
01/28/2015 12:46AM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
800 |
Gabriel Dunn
|
01/28/2015 07:48AM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
775 |
Gabriel Dunn
|
01/28/2015 10:39AM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
726 |
Rick James
|
01/28/2015 02:27PM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
724 |
Gabriel Dunn
|
01/28/2015 02:39PM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
851 |
Rick James
|
01/28/2015 03:00PM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
716 |
Gabriel Dunn
|
01/29/2015 06:08PM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
758 |
Rick James
|
01/29/2015 06:10PM
|
|
Re: Memory Problem with 1 DB. Other DB ok
|
812 |
Gabriel Dunn
|
01/29/2015 08:49PM
|
|
Re: Memory Problem with 1 DB. RESOLUTION
|
768 |
Gabriel Dunn
|
01/29/2015 10:32PM
|
|
Re: Memory Problem with 1 DB. Other DB ok - RESOLUTION
|
786 |
Gabriel Dunn
|
01/29/2015 10:33PM
|
|
Performance problem migrating from NDB to MyISAM
|
1,909 |
Giuseppe Proietti
|
01/23/2015 01:45AM
|
|
Re: Performance problem migrating from NDB to MyISAM
|
728 |
Jonathan Stephens
|
01/23/2015 04:11AM
|
|
Re: Performance problem migrating from NDB to MyISAM
|
705 |
Giuseppe Proietti
|
01/23/2015 11:58PM
|
|
Re: Performance problem migrating from NDB to MyISAM
|
771 |
Rick James
|
01/24/2015 11:39AM
|
|
Re: Performance problem migrating from NDB to MyISAM
|
745 |
Giuseppe Proietti
|
01/27/2015 11:51AM
|
|
Re: Performance problem migrating from NDB to MyISAM
|
700 |
Rick James
|
01/27/2015 10:59PM
|
|
Re: Performance problem migrating from NDB to MyISAM
|
713 |
Mikael Ronström
|
01/23/2015 09:23AM
|
|
Converting Heap to MyISAM issue
|
1,944 |
Matija Milkovic
|
01/11/2015 05:33PM
|
|
Re: Converting Heap to MyISAM issue
|
936 |
Rick James
|
01/13/2015 10:22AM
|
|
Re: Converting Heap to MyISAM issue
|
1,215 |
Rick James
|
01/13/2015 12:29PM
|
|
Query performance
|
1,608 |
Maurizio Mariani
|
11/21/2014 09:08AM
|
|
Re: Query performance
|
797 |
Rick James
|
11/22/2014 11:13AM
|
|
recuperar tablas MyISAM
|
1,985 |
fede rojas
|
11/19/2014 01:34PM
|
|
Unable to analyse thread level information in MySQL server
|
2,170 |
Afaque Ahmad Siddiqui
|
10/17/2014 04:14AM
|
|
Re: Unable to analyse thread level information in MySQL server
|
1,002 |
Rick James
|
10/20/2014 11:23AM
|
|
Re: Unable to analyse thread level information in MySQL server
|
940 |
Afaque Ahmad Siddiqui
|
11/03/2014 09:50PM
|
|
Re: Unable to analyse thread level information in MySQL server
|
860 |
Rick James
|
11/06/2014 08:25PM
|
|
Re: Unable to analyse thread level information in MySQL server
|
952 |
Rick James
|
11/06/2014 08:35PM
|
|
MySQL threads level sequence diagram at OS level
|
1,923 |
Afaque Ahmad Siddiqui
|
11/03/2014 10:01PM
|
|
Re: MySQL threads level sequence diagram at OS level
|
1,148 |
Rick James
|
11/06/2014 08:05PM
|
|
Position-weighted full text ranking
|
1,756 |
Paul Hudson
|
08/01/2014 10:00AM
|
|
Re: Position-weighted full text ranking
|
959 |
Rick James
|
08/02/2014 12:51PM
|
|
Using DISABLE KEYS on production tables
|
1,741 |
Dave Scofield
|
09/13/2014 09:54AM
|
|
Re: Using DISABLE KEYS on production tables
|
927 |
Rick James
|
09/15/2014 11:23AM
|
|
Re: Using DISABLE KEYS on production tables
|
951 |
Dave Scofield
|
09/15/2014 03:07PM
|
|
Re: Using DISABLE KEYS on production tables
|
922 |
Rick James
|
09/16/2014 03:32PM
|
|
Re: Using DISABLE KEYS on production tables
|
905 |
Dave Scofield
|
09/16/2014 04:20PM
|
|
FullText problem 'start with' or 'end with'
|
1,760 |
giulio fitini
|
09/08/2014 09:35AM
|
|
Re: FullText problem 'start with' or 'end with'
|
962 |
Rick James
|
09/10/2014 06:40PM
|
|
Re: FullText problem 'start with' or 'end with'
|
864 |
giulio fitini
|
09/11/2014 01:34AM
|
|
Table kept crashing
|
1,550 |
Shane Alcock
|
08/27/2014 01:56AM
|
|
Re: Table kept crashing
|
1,003 |
Rick James
|
08/29/2014 09:40PM
|
|
How to improve the performance of read ?
|
2,031 |
zjizhi zeng
|
08/02/2014 08:01AM
|
|
Re: How to improve the performance of read ?
|
952 |
Rick James
|
08/03/2014 09:27AM
|
|
Create indexes on everything?
|
1,777 |
fintan guihen
|
07/29/2014 02:46AM
|
|
Re: Create indexes on everything?
|
962 |
Rick James
|
07/30/2014 10:22PM
|
|
MyISAM key buffer cache emptying
|
1,703 |
Sebastien Cantos
|
07/24/2014 02:21AM
|
|
Re: MyISAM key buffer cache emptying
|
868 |
Rick James
|
07/26/2014 03:22PM
|
|
Re: MyISAM key buffer cache emptying
|
1,286 |
Sebastien Cantos
|
07/29/2014 03:43AM
|
|
'create table ... select' creates text column where varchar would suffice
|
2,082 |
A. Valkenberg
|
06/11/2014 01:33AM
|
|
Mysql not allowing change of engine
|
1,818 |
Jorge Hernandez
|
05/30/2014 08:17AM
|
|
Re: Mysql not allowing change of engine
|
1,109 |
Rick James
|
05/31/2014 07:54AM
|
|
Re: Mysql not allowing change of engine
|
968 |
Jorge Hernandez
|
06/02/2014 03:17PM
|
|
Re: Mysql not allowing change of engine
|
935 |
Rick James
|
06/04/2014 04:16PM
|
|
MYISAM INDEX KEY Question
|
2,026 |
lee fei
|
05/27/2014 02:49AM
|
|
Re: MYISAM INDEX KEY Question
|
1,089 |
Rick James
|
05/28/2014 12:48AM
|
|
Re: MYISAM INDEX KEY Question
|
993 |
lee fei
|
05/29/2014 01:57AM
|
|
Re: MYISAM INDEX KEY Question
|
1,013 |
Rick James
|
05/29/2014 10:44PM
|
|
Reading Data from .MYD file
|
2,442 |
Alain Forget
|
04/29/2014 07:44AM
|
|
How to enable index fast in MyISAM table
|
2,342 |
Gejun Shen
|
03/04/2014 07:26PM
|
|
Re: How to enable index fast in MyISAM table
|
1,240 |
Rick James
|
03/08/2014 12:42PM
|
|
Re: How to enable index fast in MyISAM table
|
1,388 |
Gejun Shen
|
03/13/2014 10:49PM
|
|
Re: How to enable index fast in MyISAM table
|
1,224 |
Rick James
|
03/14/2014 06:32PM
|
|
Re: How to enable index fast in MyISAM table
|
1,125 |
Gejun Shen
|
03/17/2014 01:38AM
|
|
Re: How to enable index fast in MyISAM table
|
1,120 |
Rick James
|
03/20/2014 06:33PM
|
|
Re: How to enable index fast in MyISAM table
|
1,242 |
Gejun Shen
|
03/22/2014 07:23PM
|
|
Re: How to enable index fast in MyISAM table
|
1,198 |
Rick James
|
03/23/2014 02:36PM
|
|
Re: How to enable index fast in MyISAM table
|
1,128 |
Gejun Shen
|
03/24/2014 12:16AM
|
|
Re: How to enable index fast in MyISAM table
|
1,171 |
Rick James
|
03/24/2014 10:49PM
|
|
Re: How to enable index fast in MyISAM table
|
1,187 |
Gejun Shen
|
03/25/2014 08:39PM
|
|
Re: How to enable index fast in MyISAM table
|
1,369 |
Rick James
|
03/26/2014 11:55AM
|
|
slow query on myisam table
|
2,626 |
Jan Kowalski
|
03/04/2014 06:48AM
|
|
Re: slow query on myisam table
|
1,139 |
Rick James
|
03/08/2014 12:32PM
|
|
Re: slow query on myisam table
|
1,088 |
Jan Kowalski
|
03/10/2014 05:23AM
|
|
Re: slow query on myisam table
|
1,109 |
Rick James
|
03/13/2014 08:29PM
|
|
Alt index search on partitioned table
|
2,063 |
CHap Harrison
|
02/20/2014 02:46PM
|
|
Re: Alt index search on partitioned table
|
1,114 |
Rick James
|
02/24/2014 05:49PM
|
|
Recovery of ISAM Table deletes all rows of that table
|
1,954 |
Ioannis Ntelakis
|
02/21/2014 09:53AM
|
|
Re: Recovery of ISAM Table deletes all rows of that table
|
1,083 |
Rick James
|
02/24/2014 05:33PM
|
|
Is there any legal case where a clean shutdown leaves crashed MyISAM tables?
|
2,151 |
Saverio Miroddi
|
02/12/2014 05:03AM
|
|
Re: Is there any legal case where a clean shutdown leaves crashed MyISAM tables?
|
1,106 |
Rick James
|
02/13/2014 11:18PM
|
|
Re: Is there any legal case where a clean shutdown leaves crashed MyISAM tables?
|
1,084 |
Saverio M
|
02/19/2014 08:44AM
|
|
How does mysql work ?
|
2,482 |
Jason Carroll
|
02/11/2014 02:36PM
|
|
Re: How does mysql work ?
|
1,286 |
Rick James
|
02/12/2014 11:46AM
|
|
Re: How does mysql work ?
|
1,109 |
Jason Carroll
|
02/12/2014 02:02PM
|
|
Re: How does mysql work ?
|
1,107 |
Rick James
|
02/13/2014 10:03PM
|
|
index auto_increment
|
2,658 |
massimo tecnico
|
02/07/2014 11:45AM
|
|
Re: index auto_increment
|
1,287 |
Rick James
|
02/10/2014 03:48PM
|
|
Re: index auto_increment
|
1,407 |
massimo tecnico
|
02/11/2014 07:37AM
|
|
Importing database from 5.4.12 (windows) to 5.5.35 (linux), error 1214
|
2,378 |
S.G.H. Schepens
|
02/07/2014 10:03AM
|
|
Re: Importing database from 5.4.12 (windows) to 5.5.35 (linux), error 1214
|
1,186 |
Rick James
|
02/10/2014 05:55PM
|