myisam Questions
6
Solved
Database is MySQL with MyISAM engine.
Table definition:
CREATE TABLE IF NOT EXISTS matches (
id int(11) NOT NULL AUTO_INCREMENT,
game int(11) NOT NULL,
user int(11) NOT NULL,
opponent int(11)...
Golub asked 20/5, 2011 at 12:26
3
I wonder if I convert some tables from MyISAM to InnoDB, will it cause any corruptions of data?
I am in need to convert some tables to InnoDB so I can use transaction, but they are holding very im...
1
Solved
When it comes to MySQL and PHPMyAdmin, I'm not a novice, but I'm closer to novice than expert. Hopefully what I ask for is doable, and that someone will provide me with a simple, cut-n-paste SQL qu...
Anchoress asked 11/6, 2011 at 19:12
6
Possible Duplicate:
MyISAM versus InnoDB
Ok I read this information of Wikipedia and InnoDB seems better. Here is my question would it be OK to use InnoDB instead of MyISAM for select...
1
Solved
What are key differences and what is a use case for both of them? Thanks!
2
We have a set of tables which contain the meta level data like organizations, organization users, organization departments etc. All these table are going to be read heavy with very few write operat...
4
Solved
I have MySQL MyISAM table:
Table friends(id, friend_id):
1, 5
5, 1
2, 6
6, 2
3, 7
How to delete reverse records? If for record values «1, 5» exist record with values «5, 1» i need to delete ...
Diffident asked 25/3, 2011 at 22:26
1
Solved
I'm switching a large table to InnoDB from myISAM. There has been a lot of discussion regarding why switching makes sense, but not much about HOW to do it while making sure the table performs well....
2
Solved
I've got a MySQL table that stores urls as unique keys. I'm starting to get collisions on my keys because it seems the keys themselves are only the first 64 bytes (or characters if you prefer, its ...
Danford asked 7/3, 2011 at 19:11
3
Solved
In MySQL, there is no way to specify a storage engine for a certain database, only for single tables. However, you can specify a storage engine to be used during one session with:
SET storage_engi...
Kokanee asked 23/12, 2010 at 2:46
2
Solved
Since foreign keys are not supported by partitioned mySQL databases for the moment, I would like to hear some pro's and con's for a read-heavy application that will handle around 1-400 000 rows per...
Islean asked 24/3, 2010 at 23:31
3
Solved
I have a lot of RAM (1 gb) on my server, and I have a table (100 mb) that I would like to increase the speed of. Is it possible to keep the entire table in memory (while keeping it MYISAM)? Would t...
4
Solved
Possible Duplicate:
Should I always prefer MySQL InnoDB over MyISAM?
Under what conditions should InnoDB be used over MyISAM ? I've seen some MySQL optimization tests where MyISAM pro...
2
Solved
How many records can a MySQL MyISAM table store? How many InnoDB can?
1
Solved
Pretty straightforward question.
I use InnoDB for everything else, for a couple of reasons. Is it a performance hit over MyISAM for a 'high-traffic' table?
1
Solved
Assume a database consisting of 1 GB of data and 1 GB of index data.
To minimize disk IO and hence maximize performance I want to allocate memory to MySQL so that the entire dataset including inde...
Hendricks asked 7/2, 2010 at 18:21
2
Solved
I have a database with about 30 tables and 5 tables of them is write-intensive.
I'm considering
Convert 5 write-intensive tables to use InnoDB engine and keep the rest on MyISAM engine
Convert a...
3
Solved
Obviously both have their benefits. MyISAM is fast but may get currupted easily, InnoDB is slow but is more stable thanks to transactions and foreign keys. So it could be good to mix both engines i...
Sudoriferous asked 28/12, 2009 at 16:26
6
Solved
Someone just told me that InnoDB is much better than MyISAM. So when I create a table, should I always try to use InnoDB Engine instead of MyISAM? Or do both have it's big benefits?
Demp asked 28/12, 2009 at 16:6
1
Solved
Does a MySQL MyISAM table gets locked when records are deleted from it?
1
Solved
I did a wipe and restore.
I backedup my current innodb tables. (mysqldump)
I loaded it into the database.
For some reason...the tables are now all myisam instead of innodb...weird!
I try to do:
...
2
This question is like a continuation of my previous question:
Am I right that InnoDb is better for frequent concurrent updates and inserts than MyISAM?
But this time I have concrete questions.
We ...
What asked 13/11, 2009 at 15:11
2
Solved
We have a websites with hundreds of visitors every day and tens of thousands queries a day.
So, some tables in the database are updated very rarely, some tables are updated few times a minute and s...
1
Solved
In phpMyAdmin v2.8.2.4 for MyISAM tables, the "Relation View" appears under the Structure tab. It shows a list of Internal Relations. But what do these do, given that MyISAM does not support foreig...
Tichon asked 12/11, 2009 at 12:3
6
Solved
© 2022 - 2024 — McMap. All rights reserved.