MySQL Forums
Forum List  »  MyISAM
Announcements Last Post
•   Announcing July 2024 off-cycle Releases featuring MySQL Server 9.0.1 Innovation, 8.4.2 LTS and 8.0.39 07/24/2024 11:15AM
•   Announcing July 2024 Releases featuring MySQL Server 9.0.0 Innovation, 8.4.1 LTS and 8.0.38 07/02/2024 06:42AM

Advanced Search
New Topic
Pages:
1 2 3 4 5
...
21 »

Subject
Views
Written By
Posted
Sticky:  MySQL 8.0: Still using MyISAM ? It is time to switch to InnoDB ! (1 Posts)  
381
Edwin Desouza
03/07/2023 09:34AM
Sticky:  Migrate MyISAM tables from MySQL 5.7 to 8.0 (1 Posts)  
765
Edwin Desouza
08/02/2021 10:20AM
Sticky:  Meltdown Fix: 40% performance regression for MyISAM; recommend switch to InnoDB (1 Posts)  
1,655
Edwin Desouza
02/13/2018 10:18AM
Sticky:  MySQL: InnoDB -vs- MyISAM (1 Posts)  
6,009
Edwin Desouza
02/18/2016 11:24PM
Sticky:  MySQL 5.6: InnoDB Read-only Performance (1 Posts)  
6,902
Edwin Desouza
07/02/2012 10:58AM
Delete slow as not using index  
420
EDGEFREE DU
02/16/2023 11:30PM
Default storage engine  
485
K B
07/18/2022 06:26AM
Re: Default storage engine  
357
Peter Brawley
07/18/2022 10:14AM
Re: Default storage engine  
319
K B
07/18/2022 11:45PM
Re: Default storage engine  
295
Peter Brawley
07/19/2022 12:30AM
Re: Default storage engine  
343
K B
07/19/2022 01:47AM
Re: Default storage engine  
311
Peter Brawley
07/19/2022 03:18PM
Changing ft_min_word_len without rebuilding old indexes - will that work as described below?  
457
Arkadiusz Miskiewicz
04/12/2022 12:19AM
DATA DIRECTORY and INDEX DIRECTORY  
827
Евгений Б
12/19/2020 05:11PM
Re: DATA DIRECTORY and INDEX DIRECTORY  
512
Peter Brawley
12/19/2020 05:53PM
Re: DATA DIRECTORY and INDEX DIRECTORY  
471
Евгений Б
12/20/2020 06:55AM
MySQL v8 - MYISAM Pack Information  
888
Frank Peacock
09/01/2020 08:04AM
Re: MySQL v8 - MYISAM Pack Information  
532
Frank Peacock
09/02/2020 02:30AM
Re: MySQL v8 - MYISAM Pack Information  
512
Frank Peacock
09/03/2020 02:49AM
MySQL 8 Windows Deletion Performance Improvement?  
1,023
Randy Smith
01/14/2020 03:24PM
Re: MySQL 8 Windows Deletion Performance Improvement?  
567
Peter Brawley
01/14/2020 03:37PM
Re: MySQL 8 Windows Deletion Performance Improvement?  
620
Randy Smith
01/14/2020 03:44PM
Re: MySQL 8 Windows Deletion Performance Improvement?  
686
Randy Smith
01/14/2020 03:58PM
Re: MySQL 8 Windows Deletion Performance Improvement?  
571
Peter Brawley
01/14/2020 11:30PM
Re: MySQL 8 Windows Deletion Performance Improvement?  
651
Randy Smith
01/15/2020 07:13AM
Re: MySQL 8 Windows Deletion Performance Improvement?  
575
Peter Brawley
01/15/2020 11:33AM
Re: MySQL 8 Windows Deletion Performance Improvement?  
623
Randy Smith
01/15/2020 11:44AM
Re: MySQL 8 Windows Deletion Performance Improvement?  
631
Randy Smith
01/15/2020 07:17AM
Deletion Woes  
1,175
Randy Smith
01/15/2020 11:18AM
MyISAM - Incorrect information in file *.frm  
2,025
Boraiah Manjunatha
07/01/2019 02:06PM
Re: MyISAM - Incorrect information in file *.frm  
898
Peter Brawley
07/01/2019 05:12PM
This topic has been moved.:  SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed  
12
sanjb c
06/29/2019 12:13PM
Performance by Selections  
1,290
Greg Mundt
02/19/2019 09:35AM
Re: Performance by Selections  
881
Peter Brawley
02/19/2019 12:02PM
Re: Performance by Selections  
819
Greg Mundt
02/21/2019 06:58AM
Re: Performance by Selections  
716
Peter Brawley
02/21/2019 01:13PM
Re: Performance by Selections  
780
Greg Mundt
02/28/2019 03:56PM
Re: Performance by Selections  
747
Peter Brawley
02/28/2019 05:10PM
Re: Performance by Selections  
756
Greg Mundt
03/04/2019 10:14AM
Re: Performance by Selections  
739
Peter Brawley
03/04/2019 11:08AM
Re: Performance by Selections  
778
Greg Mundt
03/22/2019 06:09AM
Re: Performance by Selections  
710
Peter Brawley
03/22/2019 09:29AM
Database Utilities  
1,147
Scott Krise
03/15/2019 10:58AM
Re: Database Utilities  
708
Peter Brawley
03/15/2019 11:44AM
Re: Database Utilities  
768
Scott Krise
03/15/2019 01:08PM
Re: Database Utilities  
657
Peter Brawley
03/15/2019 01:45PM
Record locking  
1,401
Scott Krise
01/30/2019 10:09AM
Re: Record locking  
767
Peter Brawley
01/30/2019 11:13AM
Re: Record locking  
728
Scott Krise
01/30/2019 12:18PM
Re: Record locking  
711
Peter Brawley
01/30/2019 02:44PM
MyISAM Column / Record Delimiter  
1,432
Alan Halls
12/12/2018 05:25PM
Optimize Table not fixing Blocks/Record  
1,210
Jim Staff
11/30/2018 12:25PM
Mysql order by is very slow from 1,000,000 rows, we have nearly 300,000 search results  
1,343
Ozden Haldun
11/23/2018 07:29AM
Re: Mysql order by is very slow from 1,000,000 rows, we have nearly 300,000 search results  
793
Peter Brawley
11/23/2018 11:50AM
Error : Too many columns  
2,727
Ian Konda
09/19/2018 07:41AM
Re: Error : Too many columns  
1,172
Peter Brawley
09/19/2018 09:14AM
Re: Error : Too many columns  
943
Ian Konda
09/19/2018 09:48AM
Re: Error : Too many columns  
1,207
Peter Brawley
09/19/2018 12:45PM
Cannot open MyISAM backup files with MySQL 8  
1,749
ferit akgul
07/18/2018 02:20PM
Re: Cannot open MyISAM backup files with MySQL 8  
977
Peter Brawley
07/19/2018 10:55AM
Re: Cannot open MyISAM backup files with MySQL 8  
968
ferit akgul
07/19/2018 11:37AM
Re: Cannot open MyISAM backup files with MySQL 8  
902
Peter Brawley
07/20/2018 08:55PM
ONLINE DDL - Incorrect Key  
1,477
G K
07/09/2018 01:14PM
MyISAM multi queries slow performance  
1,332
Kaihao Wang
06/04/2018 05:43PM
Re: MyISAM multi queries slow performance  
792
Peter Brawley
06/04/2018 09:58PM
Write Buffering / Write Cache to reduce SSD / CFast Flash wearing  
1,865
Michael Uray
01/22/2018 06:20AM
Optimum settings for Small DB running on 2G Ram  
1,499
Hans Brost
10/09/2017 12:20PM
Additional Key Caches  
1,366
alan langridge
09/22/2017 10:53AM
We're a Big MyISAM Shop, But...  
1,637
Eric Robinson
05/04/2017 05:46PM
Re: We're a Big MyISAM Shop, But...  
1,154
Benoit St-Jean
05/04/2017 06:04PM
Re: We're a Big MyISAM Shop, But...  
1,115
Eric Robinson
05/04/2017 08:44PM
Re: We're a Big MyISAM Shop, But...  
1,198
Benoit St-Jean
05/04/2017 09:46PM
Re: We're a Big MyISAM Shop, But...  
1,090
Eric Robinson
05/05/2017 11:23AM
Massive MyISAM query  
1,677
Dave S
05/01/2017 05:59PM
Re: Massive MyISAM query  
1,066
Peter Brawley
05/01/2017 06:16PM
Re: Massive MyISAM query  
887
Dave S
05/01/2017 07:52PM
Re: Massive MyISAM query  
968
Peter Brawley
05/01/2017 09:05PM
How Switching To InnoDB Helped Us Bust Through MyISAM Walls  
1,522
Edwin Desouza
02/22/2017 12:05AM
Location search in mysql joining 4 tables  
3,273
Soubhik Chatterjee
01/21/2017 07:27AM
Re: Location search in mysql joining 4 tables  
1,077
Peter Brawley
01/21/2017 04:25PM
Still disable InnoDB in MySQL 5.7  
4,622
Jean-Baptiste SILVY
11/22/2016 12:46AM
Re: Still disable InnoDB in MySQL 5.7  
1,663
Peter Brawley
11/22/2016 02:18PM
Re: Still disable InnoDB in MySQL 5.7  
1,551
Jean-Baptiste SILVY
11/24/2016 10:21PM
Re: Still disable InnoDB in MySQL 5.7  
1,487
Rick James
11/25/2016 08:02PM
MySQL 5.6 Upgrade - Hung On Creating sort index  
3,912
Andrew Klug
10/10/2016 09:52AM
Re: MySQL 5.6 Upgrade - Hung On Creating sort index  
2,283
Peter Brawley
10/10/2016 12:45PM
Re: MySQL 5.6 Upgrade - Hung On Creating sort index  
2,225
Rick James
10/16/2016 04:56PM
Composite index  
2,489
Julian Assange
08/26/2016 05:44PM
Re: Composite index  
1,267
Rick James
08/27/2016 01:55PM
Re: Composite index  
1,311
Julian Assange
08/28/2016 06:18AM
Re: Composite index  
1,524
Rick James
08/29/2016 11:34PM
Re: Composite index  
1,334
Julian Assange
08/30/2016 03:16AM
Re: Composite index  
1,245
Rick James
08/31/2016 04:48PM
Too many key parts specified; max 16 parts allowed.  
5,433
Abhishek Sahu
07/27/2016 05:40AM
Re: Too many key parts specified; max 16 parts allowed.  
3,587
Rick James
07/29/2016 05:10PM
Re: Too many key parts specified; max 16 parts allowed.  
2,692
Abhishek Sahu
07/31/2016 04:35AM
Re: Too many key parts specified; max 16 parts allowed.  
2,143
Rick James
08/01/2016 10:33AM
slow query / table lock  
18,623
Thomas Manninger
06/06/2016 01:55AM
Re: slow query / table lock  
1,429
Thomas Manninger
06/06/2016 02:06AM
Re: slow query / table lock  
1,701
Rick James
06/13/2016 01:55AM
Re: slow query / table lock  
1,324
Rick James
06/13/2016 01:57AM
Backup MySQL MyISAM databases by copying the physical files  
2,702
Timothy Mifsud
04/01/2016 08:58AM
Re: Backup MySQL MyISAM databases by copying the physical files  
1,401
Rick James
04/04/2016 12:07PM
Change from InnoDB to MyISAM storage engine  
2,209
Michael John
03/29/2016 04:01AM
Re: Change from InnoDB to MyISAM storage engine  
1,370
Peter Brawley
03/29/2016 09:20AM
Re: Change from InnoDB to MyISAM storage engine  
1,358
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  
2,775
Андрей Третяк
01/29/2016 09:13AM
Re: Fulltext in MyISAM does not work with cyrillic  
1,490
Rick James
01/30/2016 10:20AM
Re: Fulltext in MyISAM does not work with cyrillic  
1,593
Андрей Третяк
02/01/2016 02:04AM
Re: Fulltext in MyISAM does not work with cyrillic  
1,419
Rick James
02/02/2016 09:33PM
trying to alter table column to geometry but getting errors. please help.  
2,593
Richard Jones
01/26/2016 05:45AM
Re: trying to alter table column to geometry but getting errors. please help.  
1,340
Rick James
01/27/2016 09:50PM
Re: trying to alter table column to geometry but getting errors. please help.  
1,454
Richard Jones
01/28/2016 06:11AM
Re: trying to alter table column to geometry but getting errors. please help.  
1,503
Richard Jones
01/28/2016 06:22AM
Re: trying to alter table column to geometry but getting errors. please help.  
1,337
Rick James
01/29/2016 06:39PM
Re: trying to alter table column to geometry but getting errors. please help.  
1,562
Richard Jones
01/30/2016 03:17PM
information_schema refresh  
4,608
Thol Chidambaram
12/22/2015 05:28PM
Re: information_schema refresh  
1,945
Rick James
12/23/2015 09:50PM
Re: information_schema refresh  
1,843
Peter Brawley
01/29/2016 04:29PM
Cannot display index entries  
2,284
Pavlos Ponos
11/07/2015 11:04AM
Re: Cannot display index entries  
1,298
Peter Brawley
11/07/2015 01:46PM
Re: Cannot display index entries  
1,342
Pavlos Ponos
11/07/2015 01:47PM
Re: Cannot display index entries  
1,427
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  
2,540
loriot alban
08/25/2015 03:41AM
Confusing "Waiting for table level lock"  
4,697
William Oberman
06/27/2015 03:02PM
Re: Confusing "Waiting for table level lock"  
1,968
Rick James
07/02/2015 09:40PM
Tables keep crashing and corrupting  
3,283
Sebastião Burnay
04/28/2015 10:05AM
Re: Tables keep crashing and corrupting  
1,852
Rick James
04/29/2015 06:41PM
Re: Tables keep crashing and corrupting  
1,728
Sebastião Burnay
04/30/2015 03:12AM
Re: Tables keep crashing and corrupting  
1,577
Rick James
05/01/2015 07:42PM
Too many key parts specified; max 16 parts allowed  
9,047
Ahmad Shahzad
04/02/2015 05:47AM
Re: Too many key parts specified; max 16 parts allowed  
5,001
Peter Brawley
04/02/2015 11:06AM
Re: Too many key parts specified; max 16 parts allowed  
3,358
Rick James
04/04/2015 08:37PM
Table keeps crashing. Why?  
3,400
Johannes Ernst
03/24/2015 05:14PM
Re: Table keeps crashing. Why?  
1,858
Rick James
03/27/2015 12:22AM
poor create table performance  
2,827
Ronald Van Iwaarden
03/04/2015 02:29PM
Slow performance when using LIMIT 1000  
3,495
Christian Esborg
02/26/2015 04:32AM
Please don't duplicate-post  
1,716
Peter Brawley
02/26/2015 05:03PM
Option to avoid table rebuild on CREATE INDEX?  
3,120
David Lambert
02/03/2015 05:39PM
Re: Option to avoid table rebuild on CREATE INDEX?  
1,921
Rick James
02/04/2015 07:25PM
Dumping enormous MYISAM table with BLOB based on WHERE clause  
3,063
Ifechukwukwu Okobi
01/29/2015 12:40AM
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause  
1,882
Jonathan Stephens
01/29/2015 06:27AM
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause  
1,747
Ifechukwukwu Okobi
01/29/2015 10:34AM
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause  
1,867
Rick James
01/29/2015 04:53PM
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause  
1,865
Rick James
01/29/2015 04:59PM
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause  
1,920
Ifechukwukwu Okobi
01/30/2015 05:49AM
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause  
1,892
Rick James
01/30/2015 12:01PM
Re: Dumping enormous MYISAM table with BLOB based on WHERE clause  
1,714
Ifechukwukwu Okobi
01/30/2015 05:46AM
Memory Problem with 1 DB. Other DB ok  
3,496
Gabriel Dunn
01/22/2015 11:15PM
Re: Memory Problem with 1 DB. Other DB ok  
1,902
Rick James
01/24/2015 11:25AM
Re: Memory Problem with 1 DB. Other DB ok  
1,923
Gabriel Dunn
01/25/2015 11:26AM
Re: Memory Problem with 1 DB. Other DB ok  
2,109
Gabriel Dunn
01/25/2015 12:06PM
Re: Memory Problem with 1 DB. Other DB ok  
1,823
Gabriel Dunn
01/25/2015 12:09PM
Re: Memory Problem with 1 DB. Other DB ok  
1,835
Rick James
01/26/2015 12:14PM
Re: Memory Problem with 1 DB. Other DB ok  
1,866
Gabriel Dunn
01/26/2015 12:25PM
Re: Memory Problem with 1 DB. Other DB ok  
1,888
Rick James
01/27/2015 09:45PM
Re: Memory Problem with 1 DB. Other DB ok  
1,949
Peter Brawley
01/28/2015 12:46AM
Re: Memory Problem with 1 DB. Other DB ok  
1,803
Gabriel Dunn
01/28/2015 07:48AM
Re: Memory Problem with 1 DB. Other DB ok  
1,912
Gabriel Dunn
01/28/2015 10:39AM
Re: Memory Problem with 1 DB. Other DB ok  
2,131
Rick James
01/28/2015 02:27PM
Re: Memory Problem with 1 DB. Other DB ok  
1,799
Gabriel Dunn
01/28/2015 02:39PM
Re: Memory Problem with 1 DB. Other DB ok  
1,978
Rick James
01/28/2015 03:00PM
Re: Memory Problem with 1 DB. Other DB ok  
1,868
Gabriel Dunn
01/29/2015 06:08PM
Re: Memory Problem with 1 DB. Other DB ok  
1,852
Rick James
01/29/2015 06:10PM
Re: Memory Problem with 1 DB. Other DB ok  
1,932
Gabriel Dunn
01/29/2015 08:49PM
Re: Memory Problem with 1 DB. RESOLUTION  
1,887
Gabriel Dunn
01/29/2015 10:32PM
Re: Memory Problem with 1 DB. Other DB ok - RESOLUTION  
1,861
Gabriel Dunn
01/29/2015 10:33PM
Performance problem migrating from NDB to MyISAM  
3,561
Giuseppe Proietti
01/23/2015 01:45AM
Re: Performance problem migrating from NDB to MyISAM  
1,736
Jonathan Stephens
01/23/2015 04:11AM
Re: Performance problem migrating from NDB to MyISAM  
1,650
Giuseppe Proietti
01/23/2015 11:58PM
Re: Performance problem migrating from NDB to MyISAM  
1,891
Rick James
01/24/2015 11:39AM
Re: Performance problem migrating from NDB to MyISAM  
1,885
Giuseppe Proietti
01/27/2015 11:51AM
Re: Performance problem migrating from NDB to MyISAM  
1,719
Rick James
01/27/2015 10:59PM
Re: Performance problem migrating from NDB to MyISAM  
1,702
Mikael Ronström
01/23/2015 09:23AM
Pages:
1 2 3 4 5
...
21 »

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.