myisam Questions
2
Solved
How to force django to use MYISAM storage engine when creating database using syncdb command? This page does not help much to shed light in this issue.
MYISAM is the perfect choice since the datab...
Famished asked 16/12, 2014 at 3:11
4
Is there a way I can convert a full populated MyISAM database to InnoDB (in a way that will create all foreign key constraints, the same way it would be if I ran the syncdb command from the beginni...
12
Solved
What are the differences between MyISAM and Inno DB types in MySql?
3
So how can one specify the storage engine to use for a given entity in Doctrine 2?
I'm creating a table that needs a full text index and only the MyISAM storage engine supports full text indexing...
Schwann asked 23/9, 2011 at 1:1
2
Solved
On my site I have a visitor's table with 10 million rows.
Every request to the site inserts row to the table, in case the table is locked (usually in optimize query) visitors can't get into the si...
2
My question is a follow up to this answer. I want to find out how to perform a select statement without locking a table with MyISAM engine.
The answer states the following if you have InnoDB but ...
6
i have a question: i have built a big application with Yii and InnoDB and came to the problem, that the insert/update durate really really long time, here is my php report:
INNODB:
admin User upda...
5
I'm designing an internal web application that uses MySQL as its backend database. The integrity of the data is crucial, so I am using the innoDB engine for its foreign key constraint features.
I ...
Monohydroxy asked 14/4, 2010 at 15:25
4
Solved
I have a MySQL 1.5 GB MyISAM-table (1.0 GB data, 0.5 GB indexes) in production which I'm about to convert into InnoDB.
Since the table is used in production I'd like to make the downtime as short ...
Mallon asked 17/1, 2010 at 17:10
3
Solved
I'm currently doing research on the best ways to provide an advanced search for my php project.
I have narrowed it down to using FULLTEXT search rather than using LIKE to find matching strings in ...
Assuasive asked 5/1, 2012 at 22:4
1
Solved
Is it a good practice to set up a database with some InnoDB and some MyISAM tables depending on their use? I would set InnoDB only for those involved in transactions and MyISAM for everything else....
6
Solved
Sometimes I got asked on some interviews: what benefits does InnoDB have against MyISAM and when MyISAM is better than InnoDB? It's all clear about the first part of question: InnoDB is transaction...
4
Solved
We're running a social networking site that logs every member's action (including visiting other member's pages); this involves a lot of writes to the db. These actions are stored in a MyISAM table...
3
Solved
Sure, for a transactional database InnoDB is a slam dunk. MyISAM doesn't support transactions or row-level locking.
But what if I want to do big nasty batch queries that touch hundreds of millions...
Lizethlizette asked 8/5, 2011 at 1:33
1
Solved
My DB design includes multiple MYISAM tables with measurements collected online,
Each row record contains auto-incremented id, some data and an integer representing unixtime.
I am designing an ag...
Dowable asked 12/12, 2012 at 11:53
1
Solved
I am trying to understand how MyISAM physically store its records and how it maintains its structure after record insertion and record deletion. I have read the following link:
MyISAM Dynamic Dat...
Catchweight asked 23/5, 2013 at 10:49
2
Solved
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 stora...
2
Solved
I understand that this question has been asked before, but most of the time it is asked in relation to a specific database or table. I cannot find an answer on this site that describes the tw...
1
Solved
I have these small tables, item and category:
CREATE TABLE `item` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
`category_id` mediumint(8) unsigned NOT NUL...
3
Solved
I have a mysql table with over 30 million records that was originally being stored with myisam. Here is a description of the table:
I would run the following query against this table which would...
1
I have a MySQL database (version 5.5.28) with a table like this:
products (InnoDB)
-------------------------------------------------
search_id title description
1 Levi Blue Jeans Some cool jeans
...
2
Solved
I am using mysql and mysql workbench. I created 5 tables with innodb engine. I checked their engine and it was innodb before I insert data into them. I inserted data from 5 MyISAM tables and now my...
3
Solved
By mistake I ran the update query. This update made my table all rows values as o.
Is it possible to rollback the table values?
2
Solved
I need to add a new column to a table in MySQL DB (MyISAM table) that contains more than 20 Million rows.
The process of adding the column must be in run-time, I mean that the app will still be ru...
Shushan asked 2/12, 2012 at 9:53
1
Solved
I've installed MySQL 5.5 recently. I'm using InnoDB as the engine for all my databases. I noticed that the mysql database default and all of it's tables (user, db, etc...) are MyISAM. Is there any ...
© 2022 - 2024 — McMap. All rights reserved.