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
InnoDB VS Myisam Regarding Logs Data & Logs Retrieval on every minute
Well, I know already that:
1. InnoDB is faster for data insertion but slower on data retrieval.
2. MyISAM is faster for data retrieval but slower for data insertion.
My situation is a bit different, and I just cant figure out what settings are good…
MrBlackJack
- 11
- 1
0
votes
1 answer
MyISAM char(7) field has index with long key length
i have a date dimension table with a char(7) field called year_month_number with an index on it as follows:
ALTER TABLE `dim_date` add INDEX `year_month_number` (`year_month_number` ASC);
it has data in it like '2013-06' or '2013-07'.
im having…
marengaz
- 1,639
- 18
- 28
0
votes
0 answers
MySQL select by primary key against 100M of records within 30ms
I have no expirience with MySQL and database performance tuning in general.
Wondering whether it is possible to perform a large number of selects against 100 millions of records by primary key within 30ms per request in average.
Some details:
PK is…
edio
- 652
- 1
- 8
- 21
0
votes
1 answer
Improve DATETIME grouping queries performance
This is my first attempt at reaching out for help on StackOverflow :)
I have the following table:
CREATE TABLE `tinfinite_visits` (
`visit_id` int(255) NOT NULL AUTO_INCREMENT,
`identity_id` int(255) NOT NULL,
`ip` varchar(39) NOT NULL,
…
Emilian Manolache
- 414
- 3
- 8
0
votes
1 answer
mysql foreign key not violated
I am using mysql.
When I add a foreign key to a table it is done without any errors.
When the table structure is described i see MUL under the key field like I see the the PRI for the columns set as the primary key.
But when I try to violate the…
0
votes
2 answers
Incorrect data in MyISAM database due to concurrency
Problem
I have a webpage that does the following (the code is much simplified to show only relevant code.
mysql_query("insert into table1 (field1) values ('value')");
$last_id = mysql_insert_id();
$result = mysql_query("select * from table1 t inner…
Lorenz Meyer
- 19,166
- 22
- 75
- 121
0
votes
3 answers
Multiple SELECT subqueries to the same table into one
There's a table message and a table sender, and I want to retrieve all "message information" associated to a specific id, along with the sender name and email. I have this query:
SELECT
a.id,
a.subject,
a.body,
a.sender_id,
(
…
federico-t
- 12,014
- 19
- 67
- 111
0
votes
2 answers
Can I reduce ibdata1 file size by converting table to MyISam?
I have a table called path. It takes up about 99% of a 13G ibdata1. It was previously an INNODB table, but I converted it to MYISAM.
If I run optimize table on the new path table, will it free up my ibdata1 file? Or does this never reduce in size…
David542
- 104,438
- 178
- 489
- 842
0
votes
2 answers
MySQL select query returns 250K+ results, delete query only deletes one?
I don't understand this. I've dropped the table and recreated it multiple times, and it's the same every time. When I run this query:
SELECT * FROM `squares` WHERE MBRContains(PolyFromText('Polygon((-34 166, -34 171, -41 171, -41 166, -34 166))'),…
marked-down
- 9,958
- 22
- 87
- 150
0
votes
0 answers
InnoDB row size limitation and handling table splitting in cakePHP
I have made a mistake when designing my DB. I have created a table with more than 40 text cells. Now I have a nearly finished application (cakePHP) and I recognized that InnoDB tables have these limitations the first time while testing with larger…
Steffen
- 1
0
votes
1 answer
Indexing column with REPLACE function in mySQL
May be a silly question to ask.
I need to use this a lot in both join and where:
REPLACE(table_a.column_1, '-', '') = REPLACE(table_b.column_2, '-', '')
since bit data inconsistency from other companies' system
Is that possible or any other…
Richard Fu
- 616
- 10
- 27
0
votes
3 answers
Can i use some tables with InnoDB engine and some with MyIsam on my MySQL database?
I read that Innodb is better to use on a table that get a lot's of insert records simultaneously. My application gets about 50 records per seconds. So for these tables should I use Innodb, right?
In the other hand i have some tables that are only…
yves
- 250
- 1
- 2
- 18
0
votes
1 answer
Converting from myisam to innodb
I am looking to convert my myisam mysql database to an innodb. I seem to keep coming up with conflicting ideas on how to do this or even if I should! What are your thoughts?
Lizard
- 43,732
- 39
- 106
- 167
0
votes
1 answer
MyISAM and InnoDB Table locking issue when queried together
I'm working on fixing up a messed up database. I have several MyISAM and InnoDB tables in this DB. I need to write a query that uses the following 3 tables:
table_a => InnoDB
table_b => InnoDB
table_c => MyISAM
The query takes about a minute to run…
usumoio
- 3,500
- 6
- 31
- 57
0
votes
1 answer
Using a Mysql Trigger to break down a URL Field and store it's parts in a MyISAM Table
I have a MySQL MyISAM table that stores a URL in a url field. The URL is always just the scheme, subdomain, and host ( eg. http://www.site.com or https://site2.edu ).
I need to store the Domain, the Subdomain, and the Scheme in their own fields so…
T. Brian Jones
- 13,002
- 25
- 78
- 117