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
4 answers
Update MyISAM tables on live machine (MySQL)
I need a way to update tables on live machine without affecting users experience.
I have few tables on MyISAM engine which are being updated every 15 minutes. Update script just truncates table and inserts data from select sentence. Problem appears…
user1463822
- 837
- 9
- 24
0
votes
3 answers
full text search doesn't find anything
**EDIT**
ok so i found the problam, it was that the min word length for the search was 4, i changed it to 3 but now it only finds the row 1 data and not row 2 data aswell...
-----original question:----
I have a MyISAM table on my phpmyadmin like…
Dan Barzilay
- 4,974
- 5
- 27
- 39
0
votes
3 answers
MyISAM table is using filesort with ORDER BY, why?
Why is mysql using filesort when i order my selected rows with ORDER BY x?
My table looks likes this:
CREATE TABLE `test` (
`sdf` varchar(100) NOT NULL,
`sdf33` varchar(100) NOT NULL,
KEY `sdf_2` (`sdf`),
FULLTEXT KEY `sdf33` (`sdf33`),
…
Marwelln
- 28,492
- 21
- 93
- 117
0
votes
2 answers
Can this mysql/myisam table be optimized?
I run a website where I need to store the information like this:
table: logs
* date (date)
* server_1 (unsigned int)
* server_2 (unsigned int)
* user_id (unsigned int)
* ip (unsigned int)
* service (enum)
* traffic (unsigned bigint)
My…
The Surrican
- 29,118
- 24
- 122
- 168
0
votes
2 answers
how import a mysqldump without ENGINE specified in MyISAM
all my sqldumps are without the "Engine=..." syntax in the CREATE Statements, so
maybe i can somehow add "ENGINE=MyISAM" to the default import?
because on my ubuntu 12.04 server with mysql 5.5 importing a large table is very slow, because it is…
rubo77
- 19,527
- 31
- 134
- 226
0
votes
1 answer
does InnoDB MySQL automatically use row-level locking?
I have a MySQL database that currently uses MyISAM but I am thinking of changing over to InnoDB, because it's quite high traffic and does a lot of writes to the same table, which causes slow loading times for visitors who then have to wait for each…
user1227914
- 3,446
- 10
- 42
- 76
0
votes
1 answer
Myisam table unreadable after sort_buffer_size too small error
I was trying to run OPTIMIZE TABLE on a that's about 200GB 1billion record big, but couple second after the operation, I was giving a sort_buffer_size too small error and now the table showing as 0 row in phpmyadmin, and still have 200gb in size. I…
Gäng Tian
- 1,588
- 2
- 18
- 26
0
votes
1 answer
I have set index then, when i take back up does not display index details
I set index for mysql table, when i take backup using query browser , mysqlworkbench dose not display index details. What is the problem or else any mine mistake.
See mine table. I have set index for "id" column but not display that…
mayasakthi
- 25
- 1
- 7
-1
votes
1 answer
Does changing MYSQL table engine from MYISAM to INNODB can cause a data corruptions?
I have a simple question.
I have a mysql databases. I have 2 tables, that uses MYISAM, I want to change to INNODB, one of the table has 1.000 rows, if I do this this change, is there a risk that it will cause any corruption of my data/rows?
Galbert
- 177
- 1
- 8
-1
votes
2 answers
InnoDB vs MyISAM in a table storing usernames and passwords
I had a table usernames that store user's username and password.
Structure of table usernames is given by:
CREATE TABLE `usernames`
(
`id` INT NOT NULL AUTO_INCREMENT ,
`user_id` INT NOT NULL ,
`username` VARCHAR(50) NOT NULL ,
…
htmler
- 380
- 1
- 4
- 12
-1
votes
1 answer
Why Relational tables via Laravel migrations created with MyISAM which don't support relational features
I noticed, Laravel creates tables via storage engine as MyISAM which does not support relational features.
I have setup the foreign keys via migrations but when I checked in Phpmyadmin, it shows no relational features due to storage engine being…
Sitepose
- 304
- 1
- 13
-1
votes
3 answers
MySql, engine:MyISAM, what index can be used instead of Foreign Key
I am creating a MySQL DB with MyISAM engine. I believe it is not possible to use foreign key with MyISAM. All the tables in DB have primary key, but all of them also need at least 1 FK.
1)Can any of the other options available (apart from PK): such…
-1
votes
1 answer
Phpbb3.1 MyIsam database corrupted
everyone! I'm trying to avoid breaking of my database in the phpbb3.1 forum. It was crushed twice this month.
So I have two questions:
1) Is it safe to convert MyISAM to InnoDB? I mean will extensions work fine? Will forum be workable after…
young B
- 127
- 1
- 11
-1
votes
1 answer
how to perform hourly backup of mysql MyISAM tables
I have a wamp local server with only MyISAM tables, Total size is 350 MB and increases by about 10 MB per day. Would like to have a hourly backup solution. As recently WAMP server crashed and lost data.Should I create a trigger or schedule a task or…
Kanted
- 169
- 1
- 12
-1
votes
1 answer
Puzzled by MySQL information_schema.tables info
For some unknown reason, the info of 'information_schema.tables' is not match to real tables:
First, find table-name from information_schema.tables, there is one result;
Then, select * from table-name, it shows table not exist! /(ㄒoㄒ)/~~
I try to…
Tiger Wang
- 3
- 3