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

unused data in mysql myisam storage engine

I am trying to understand how MyISAM physically store its records. In MyISAM Storage engine Variable-sized record there is some unused data after each record. how many bytes is reserved as unused data? is there any specific algorithm which MyISAM is…
ali akhbarizadeh
  • 51
  • 7
0
votes
2 answers

Referential integrity for mysql

I am currently maintaining a rather large office web-application. I recently became aware that via various developer-tools within web-browsers that values of select-boxes can easily be modified by a user (among other things). On the server side I do…
Patrick
  • 383
  • 1
  • 2
  • 19
0
votes
1 answer

Converting a program that was set to use MyISAM to INNODB instead

I have a database program that was written a few years back using MYISAM tables in a MYSQL database. It is a pretty simple structure but I wasn't the one who set it up. All the current releases of MYSQL are all set for INNODB and I just wondered…
questorfla
  • 25
  • 6
0
votes
2 answers

SQL combining LIKE and AND gives me wrong result

SELECT * FROM table WHERE column LIKE '%whatever%' AND id='1' OR id='2' OR id='3' When using the code above, I get back three rows and not the one with column LIKE '%whatever%' I find it strange, and can not understand why. How could I rewrite my…
Joel
  • 61
  • 3
  • 11
0
votes
1 answer

Are multiple-table DELETE statements bad practice? Why?

I'm working with a MySQL database that uses the MyISAM storage engine. I make use of the multiple-table delete syntax. So far, I've only used it when I need to delete from multiple child tables at once. But I was considering using it to delete from…
toxalot
  • 11,260
  • 6
  • 35
  • 58
0
votes
1 answer

Grails Multiple DataSources with Innodb and MyIASM

Grails 2.2.0 MySQL 5.5.x Part of our application requires a Data Warehouse which we want to place in its own database using the MyISAM engine. The transactional parts of our app will remain InnoDB. For that, we're using the…
Gregg
  • 34,973
  • 19
  • 109
  • 214
0
votes
1 answer

Slow MYSQL Insert to DB MyISAM

I have a file (insert.sql) which has 250k rows like these with no key, no index : INSERT `project_383`.`entity_metrics_build_1` VALUES ('d402afeb4630267f383b99875f37162d', 'ClMaxCycl', '-1'); INSERT `project_383`.`entity_metrics_build_1` VALUES…
TrangVu
  • 43
  • 7
0
votes
1 answer

Small system using MySQL 5.5.4 with MyIsam tables, everything works, is there a good reason for InnoDB?

Considering the headaches of changing something that is working perfectly "as-is" and will never need to do more than it does now, is there any overwhelming reason to convert the MyIsam tables over to InnoDB just to upgrade the MySQL engine? This…
questorfla
  • 25
  • 6
0
votes
2 answers

Constraint like check constraints, not null constraints on MyISAM Storage Engines in MySQL

Can we use constraint like check constraints, not null constraints on MyISAM Storage Engines in MySQL?
Rachel
  • 100,387
  • 116
  • 269
  • 365
0
votes
1 answer

searching MySQL for most phrase occurrence

I am trying to search an entire table and return the most occurring phrases (up to three words) within a long string. I believe I could use fulltext search, but I am not matching against anything... table I like Iron Man 3 so much Iron Man 3 sucked…
user2359318
  • 83
  • 1
  • 1
  • 5
0
votes
2 answers

How to find MySQL temporary table storage engine

Hi I am working with Temporary table and I would like to know the temporary table storage Engine (InnoDB, MyISAM .... ) I am using the following code to find out but it is not showing me the storage Engine. $engine="SELECT ENGINE FROM…
DonOfDen
  • 3,968
  • 11
  • 62
  • 112
0
votes
0 answers

Got error 127 when reading table and Table is marked as crashed and should be repaired

Getting Error Table is marked as crashed and should be repaired Table is using MyIsam engine. 130429 3:11:27 [Warning] IP address '221.174.22.58' could not be resolved: The requested name is valid, but no data of the requested type was found.…
vikas
  • 2,780
  • 4
  • 27
  • 37
0
votes
1 answer

Speeding up multi-table joins with MySQL

I have 3 tables in which I'm trying to preform joins on, and inserting the resulting data into another table. The query is taking anywhere between 15-30 mins depending on the dataset. The tables I'm selecting from and joining on are at least 25k…
Dan Ramos
  • 1,092
  • 2
  • 19
  • 35
0
votes
1 answer

mysql my.cnf config for 6gb ram

I have dedicated server (Intel Quad Core Xeon E5645 VT, 6 GB RAM). But i have problems with mysql. My site have 40-60k unical users every day. I need to config my.cnf for best performance. My currently config: key_buffer =…
Zulfugar Ismayilzadeh
  • 2,643
  • 3
  • 16
  • 26
0
votes
0 answers

Initiate truncate, then write

If I initiate a TRUNCATE on a table, what happens to INSERTs executed against that table? Are they queued until the TRUNCATE completes, or are they simply discarded? I know this condition is quite rare but it's possible. I'm using PDO transactions…
Bojangles
  • 99,427
  • 50
  • 170
  • 208
1 2 3
…
67 68