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
4 answers

What's the easiest way to add an index on a live myISAM table?

I have a myISAM table running in production on mySQL, and by doing a few tests, we've found we can tremendously speed up a query by adding a certain compound index. So far so good. However, I am not really about the best way to add this index in a…
Artem
  • 6,420
  • 6
  • 26
  • 26
0
votes
1 answer

MyISAM tables are better then InnoDB tables for full text searching

Between MyISAM and InnoDB tables, which will be better for full text searching?
Md Jobaidur Rahman
  • 67
  • 1
  • 2
  • 9
0
votes
1 answer

Convert table engine MyISAM to INNODB errno: 150

I have this table : CREATE TABLE IF NOT EXISTS `interlocuteur_fonction` ( `id_interlocuteur_fonction` int(11) NOT NULL AUTO_INCREMENT, `id_interlocuteur` int(11) NOT NULL, `id_fonction_interlocuteur` int(11) NOT NULL, `defaut` varchar(1) NOT…
kurtec
  • 128
  • 5
0
votes
1 answer

Using ORMLite with MySQL and MyISAM tables

ORMLite's MySQL driver defaults to using InnoDB tables. The documentation describes how to configure it to use other table types, but does not describe the consequences of doing so. Having had bad experiences with InnoDB recently I'd like to…
Jules
  • 14,841
  • 9
  • 83
  • 130
0
votes
1 answer

SUM with a pivot to calculate overall score

From another question I got this query to get my scores summed up properly: SELECT callSign,event, SUM(score) FROM scores LEFT JOIN candidates ON scores.candidateID=candidates.id WHERE candidateID IN (SELECT id FROM candidates …
h3rrmiller
  • 115
  • 7
0
votes
2 answers

Which tables will be locked with this query?

I am migrating data between two tables using the query below. I had table locking issues, so I am considering changing the table engines from MyISAM to InnoDB. Which tables do I need to do that for? Just the table I am writing to, or both the table…
Chad Johnson
  • 21,215
  • 34
  • 109
  • 207
0
votes
1 answer

I am now having data tables in myisam(mysql). Should I use relation tables of innoDB?

Is a table with columns like tid(int) zid(int) direction(tinyint) type(tinyint) with quite heavy read and write operations, as well as joining to other tables in myisam, better to be engined in myisam or innodb? I was told that innodb had worse…
Abby Chau Yu Hoi
  • 1,378
  • 3
  • 15
  • 37
0
votes
2 answers

MYSQL MyIsaM How to Join 2 statement select + select count

table: postid|userid|post|replyto post sql SELECT * FROM table WHERE postid=12 total replies sql SELECT COUNT(*) AS total FROM table WHERE replyto=12 the expected result is the "post table" + how many replies to the post. replyto field is the target…
mozlima
  • 179
  • 2
  • 8
0
votes
3 answers

Mysql, InnoDB to MyISAM for fulltext index

Actually, I would like to switch the engine of my tables. There are in InnoDB and I want to set them to MyISAM because of this ALTER TABLE `xxx_db`.`yyy` ADD FULLTEXT `ft_modele` ( `anno_modele` ) Error : Documentation #1214 - The used…
Raphaël
  • 1,141
  • 3
  • 18
  • 32
0
votes
1 answer

Effect of KILL QUERY on INSERT and LOAD DATA INFILE statements on a MyISAM table

I have a system which runs quite heavy MySQL queries, and we'd like to provide a way of interrupting the queries through JDBC. Statement.cancel() seems like the way to go, and it effectively sends a KILL QUERY on a separate connection to the…
ahelix
  • 308
  • 1
  • 2
  • 13
0
votes
1 answer

Switching MySQL table from MyISAM to InnoDB - What do I do with the Column Indexes that were FULLTEXT

I am switching some MySQL tables from MyISAM to InnoDB: What should I use in place of FULLTEXT? As InnoDB does not have FULLTEXT. What should I use in FULLTEXT's place, when switching from MyISAM to InnoDB? Thanks all : ) Regards.
user1502852
0
votes
1 answer

MySQL database performance issue. (MyISAM)

Im having online online auction website running live since near about 3 years and still going good. Within 3 years so many auctions has been listed on server and completed too. but now there are a lot of load on server as there are so many completed…
Mahendra
  • 908
  • 1
  • 18
  • 38
0
votes
1 answer

Adding 1 InnoDB table to a DB full of MyISAM tables (effects)

We have a database full of MyISAM tables. The thing is that we need transactions on just 1 table, called payments My question is, will that work? I mean by changing the engine of that table to InnoDB and using transactions on php, will that do the…
Not Amused
  • 942
  • 2
  • 10
  • 28
0
votes
1 answer

MyISAM table keeps crashing. How to go about finding the cause or debugging it?

On one of the site's I manage, I have a table set to MYISAM, and it constantly crashes. Automatic repair fails every time, so I have to go in and run the REPAIR TABLE command. I've looked at possible solutions such as this one: MySQL table is marked…
kennypu
  • 5,950
  • 2
  • 22
  • 28
0
votes
0 answers

MySQL binlog: when does the DELETE gets logged before the INSERT

Some relevant my.cnf settings: binlog-format=ROW init_connect='SET autocommit=1' autocommit=1 innodb_flush_log_at_trx_commit=1 I also have a replication running... Now, most of the time things runs rather well. But sometimes I do get this: Could…
Steven Van Ingelgem
  • 872
  • 2
  • 9
  • 25
1 2 3
…
67 68