Stack Overflow
Stack Overflow

Questions tagged [myisam]

MyISAM is a non-transactional storage engine for MySQL. It provides high-speed storage and retrieval, as well as fulltext searching capabilities. Also, it is the default storage engine type for versions prior to 5.5.

1017 questions
0
votes
1 answer

phpmyadmin change table engine when exporting in SQL formt

I have a db schema with 10 tables in mysql. some of table has innodb engine, and some of table with myisam. However, when using phpmyadmin exporting the schema in SQL format, it converts all tables engine to mysiam. So why phpmyadmin automatically…
bourneli
  • 2,172
  • 4
  • 24
  • 40
0
votes
2 answers

MyISAM index slows down using LOAD DATA INFILE

I'm building a table that will be used for READ ONLY which is why I decided to go with MyISAM instead of InnoDB (but i'm open to suggestions). However, this table needs to be extremely large. Although each row is about 12-14 bytes, the table itself…
nick
  • 2,743
  • 4
  • 31
  • 39
0
votes
2 answers

MySQL: index diffrences between innoDB and MyISAM

What are the main differences between index in innoDB and MyISAM?
Philippe Blayo
  • 10,610
  • 14
  • 48
  • 65
0
votes
1 answer

Concise FULLTEXT Search

I've been trying to find some help on using MySQL's FULLTEXT search. I realise that this has been discussed to death, but I can't quite understand how to get a concise set of results. I have a MyISAM table of say 500,000 products with a FULLTEXT…
Alexander Holsgrove
  • 1,795
  • 3
  • 25
  • 54
0
votes
2 answers

improve mysql load data

Is there any mysql parameter to improve the speed of "LOAD DATA INFILE " ? I am using 1 MyISAM and 1 TokuDB table. The data is saved as Tab separated text file.
shantanuo
  • 31,689
  • 78
  • 245
  • 403
0
votes
4 answers

rsync and MyISAM tables

I'm trying to use rsync to backup MySQL data. The tables use the MyISAM storage engine. My expectation was that after the first rsync, subsequent rsyncs would be very fast. It turns out, if the table data was changed at all, the operation slows…
CocaLeaf
  • 321
  • 2
  • 9
0
votes
0 answers

MySQL: 25M records (rows) A simple COUNT(column) takes 70s and then quits

I have a rather large table (1,8GB, 25M records), with indexes on every important column (those I use WHERE or other selectors with). The engine is MyISAM, I've heard people recommend switching to InnoDB but many others said MyISAM is faster with…
James Stone
  • 487
  • 7
  • 16
0
votes
1 answer

Can't change storage engine to myisam, unknown storage engine 'InnoDB'

I'm trying to use mysqldump to dump a database, but I'm getting an error: mysqldump: Couldn't execute 'show create table wp_commentmeta': Unknown storage engine 'InnoDB' (1286) No worries; I'll just go into MySQL and change the storage engine for…
Ben McCormack
  • 32,086
  • 48
  • 148
  • 223
0
votes
1 answer

deleted row reappears

I have a c program running on ubuntu connecting to mysql (5.0.51a-3ubuntu5.4-log). The programs main task is to process records from a small (<5000 rows) myisam table. If the row is processed successfully it is deleted. If not it is retried at a…
user141249
0
votes
2 answers

Minimum set of files needed to recover a MySQL table (MyISAM and InnoDB)

When recovering a MyISAM table the only file that is strictly needed is the data file (tablename.MYD) - the rest of the files (the index file tablename.MYI and tablename.frm) can be recreated from the data file using REPAIR TABLE. Assume I'm using…
knorv
  • 49,059
  • 74
  • 210
  • 294
0
votes
1 answer

Resolve MySQL error when changing engine from MyISAM to InnoDB

My database experienced some corruption last week, and the technicians from the web hosting company changed all my tables to MyISAM and performed repair on those tables. However, my application requires InnoDB tables. I've tried the method mentioned…
segfault
  • 5,759
  • 9
  • 45
  • 66
0
votes
2 answers

How to get rid of the 1GB overhead of MyISAM table without locking too much the system

I had some maintenance task completed on one of the tables, and now it has 1GB of overhead. Since the table operations run for hours (delete 40% of records, took 4 hours) I do not want to lock the database with the OPTIMIZE table command for hours,…
Pentium10
  • 204,586
  • 122
  • 423
  • 502
0
votes
1 answer

PHP: convert mysql code so it will work with innodb?

I have migrated from myisam to innodb and i had to remove fulltext indexes from tables. now some parts of my script doesn't work, how can i convert the below code so it will work with innodb? $posts_fields = "SELECT SQL_CALC_FOUND_ROWS id, autor, "…
Crazy_Bash
  • 1,755
  • 10
  • 26
  • 38
0
votes
2 answers

MyISAM slows down whilst working with database

I am running around 50,000 queries on a MyISAM DB however the longer the query runs the slower it becomes. For example, at the beginning 20 rows can be done in a second and by the end it is doing 5 rows a second. Is this happening because MyISAM…
Ben Jackson
  • 1,427
  • 3
  • 14
  • 24
0
votes
2 answers

MySQL table lock, or other possible solutions?

I have a security problem. I think to lock a table would be a solution, only I don't know how to properly do it in MySQL, PHP, and don't have enough time to search Google and documentations anymore. So, the task: Make a database and write a php code…
ZeeCoder
  • 1,001
  • 9
  • 17
1 2 3
…
67 68