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.
Questions tagged [myisam]
1017 questions
0
votes
1 answer
Creating foreign keys using hibernate
I encounter the following problem with Hibernate and foreign keys:
When I first deploy my web application, Hibernate was configured with this parameters (among many others):
databasePlatform set to "generic" (not engine specific) dialect…
ssssteffff
- 964
- 4
- 16
0
votes
1 answer
How to avoid longtime MyISAM recovery after MySQL crash or unexpected shutdown
We are using MySQL 5.x for our system, It generates huge amount of data per day. Yesterday at one our customers place, UPS shutdown and after that Mysql start MyISAM recovery that took about 10 hours. Now my question, is there any way to avoid this…
Farhadix
- 1,395
- 2
- 12
- 25
0
votes
1 answer
Converting MyISAM to InnoDB - what to do with fulltext columns
I am in the process of switching all my database tables to InnoDB so that I can use transactions. I had made certain columns in some tables fulltext with a view to building some search functionality at a later date.
I understand there are serverside…
SwiftD
- 5,769
- 6
- 43
- 67
0
votes
0 answers
Does exporting MyISAM table lock when exporting data?
I am trying to export a huge MyISAM table in a MySQL database into a .SQL file. Will doing so lock the entire table and prevent applications from using it during the export?
If so, is there an alternative?
Spartanblogger
- 271
- 1
- 3
- 9
0
votes
1 answer
MYISAM sharding vs using InnoDB
I have a table with very high insert rate and update rate as well as read rate. On average there are about 100 rows being inserted and updated per second. And there are about 1000 selects per second.
The table has about 100 million tuples. It is a…
Vish
- 4,508
- 10
- 42
- 74
0
votes
3 answers
MySQL query error (using php)
I have problem with this query.
$query = 'CREATE TABLE movie(
movie_id UNSIGNED INTEGER NOT NULL AUTO_INCREMENT,
movie_name VARCHAR(255) NOT NULL,
movie_type TINYINT NOT NULL DEFAULT 0,
movie_year SMALLINT UNSIGNED NOT NULL DEFAULT…
Tom11
- 2,419
- 8
- 30
- 56
0
votes
1 answer
Would MyISAM be better in an almost read-only table?
Basically I have a lang table with the columns pg VARCHAR(20),id VARCHAR(20),en (TEXT),ru (TEXT) for my website's multilingual support and in 99.999% cases data will be read from the table instead of being written. I have heard that MyISAM performs…
AM-
- 871
- 1
- 10
- 20
0
votes
1 answer
mysql myisam update
We use MySQL with MyIsam engine and have a situation where we need to update a huge number of rows (millions) on a daily basis while users can still be accessing the database.
We have users from different timezones from USA, UK, India, China. Data…
Madan Madan
- 674
- 1
- 11
- 28
0
votes
2 answers
Storage engine for discussion board database
Which storage engine should I use for a discussion board (web application) if I want to stay with MySQL? InnoDB or rather MyISAM?
user1598019
0
votes
2 answers
Is MyISAM Table locking in MySQL automatic?
Does MySQL automatically peform read / write table locks on MyIsam tables, or do I have to explicitly lock the tables?
mogronalol
- 2,946
- 8
- 38
- 56
0
votes
2 answers
Mysql / PHP application 99% reads 1% insert/update - What MYSQL Engine To Use?
So I'm developing this tracking application atm, it will run on 2 webservers and it's purpose is to track visitor behaviour.
The data will be collected on Server A which is the master and we decided to use the MYSQL Blackhole engine for that,…
Marc
- 103
- 10
0
votes
1 answer
BigDump Error with MyISAM table
I'm trying to import a a database using BigDump but it is giving me this error:
Error at the line 238: ) ENGINE=MyISAM */;
Query: `username` varchar(64),
`name` varchar(255),
`entityRef` int(11),
`Date` date,
`contactName` varchar(255),
`email`…
imperium2335
- 23,402
- 38
- 111
- 190
0
votes
1 answer
MySql InnoDB - Insertion in "Not Null" column of table
I have a question about InnoDB and MyISAM storage engine of database.
Suppose we have 5 column in a table all column are set to "Not Null".
When I run a query to insert values in only two column of MyISAM database, it wont generate any error,…
Haroon
- 155
- 2
- 10
0
votes
2 answers
Which Storage Engine is best in MySql?
Possible Duplicate:
MyISAM versus InnoDB
Which Storage Engine is best in MySql? InnoDb or MyIsam?
0
votes
1 answer
code changes when migrating from MyISAM to Innodb
I am just wondering do I need to alter "ruby on rails" code when migrating from MyISAM to InnoDB.
I want to migrate to InnoDB and it's known that deadlock is something that may happen working with InnoDB, do I need somehow threat all my inserts and…
com
- 2,606
- 6
- 29
- 44