myisam Questions
3
Solved
Possible Duplicate:
How can I remove duplicate rows?
Remove duplicates using only a MySQL query?
I have a large table with ~14M entries. The table type is MyISAM ans not InnoDB.
Unf...
2
Solved
My site runs on a VDS-server. I've just found out that my MySQL server doesn't support InnoDB engine, therefore I can't use database transactions in my application.
It makes me think, that some pe...
Schoolmaster asked 28/8, 2012 at 23:33
2
Solved
I have a question of interest:
I have 2 tables in mysql with InnoDb.
table tbl_a has a primary key, named a_id;
table tbl_b has a primary b_id and a foreign key on tbl_a.a_id with "ON DELETE NO AC...
Rig asked 23/8, 2012 at 17:8
1
Solved
Is this "compare and swap" statement always atomic regardless of engine (e.g. InnoDB or MyISAM)? :
UPDATE tbl_name SET locked=1 WHERE id=ID AND locked <> 1;
I ask this because I intend to ...
Stumpf asked 16/7, 2012 at 10:2
1
Solved
I didn't set up my database and noticed that some of my tables are innoDB whereas others are MyISAM. The reason I'm interested in changing them is because Jurg van Vliet (who writes O'Reilly books ...
Weatherby asked 22/7, 2012 at 19:23
1
Solved
I'm storing file system hierarchies of directories and files.
In an innodb table, I store the details of each directory/file and maintain the parent child relationship with a foreign key constrain...
2
Solved
After noticing that our database has become a major bottleneck on our live production systems, I decided to construct a simple benchmark to get to the bottom of the issue.
The benchmark: I time ho...
Fidget asked 5/5, 2012 at 1:44
2
Solved
I am building an app in Symfony2, using Doctrine2 with mysql. I would like to use a fulltext search. I can't find much on how to implement this - right now I'm stuck on how to set the table engine ...
Granite asked 30/8, 2011 at 15:50
1
I am inserting into a simple small table with 5 attributes and 1000 rows.
I observed when the engine is INNODB, each insert is taking 0.03 - 0.05 seconds.
I changed the engine to MYISAM, then the...
Rheumy asked 12/4, 2012 at 5:29
1
I am currently using InnoDB for all my databases in MySQL, however I just noticed that my information_schema database uses MyISAM for tables that are not MEMORY.
I am in the process of investigat...
Concussion asked 24/4, 2012 at 19:30
1
Solved
If MyISAM doesn't have FK integrity, how does a django app that uses MyISAM tables enforce the integrity of the FK constaints?
Gantlet asked 16/4, 2012 at 18:13
1
Solved
The question is rather simple but I couldn't find a precise answer:
In a myisam db, what happens if a php file locks a table (with an atomic operation, say an INSERT) and another php file tries to...
Saponin asked 20/3, 2012 at 11:27
3
Solved
I have a table with 17 million rows. I need to grab 1 column of that table and insert it all into another table. Here's what I did:
INSERT IGNORE INTO table1(name) SELECT name FROM main WHERE ID &...
1
MySQL allows you to specify a different engine for a table from the server default engine. What kind of overhead does that create though? If I wanted to join a table that uses InnoDB with a table t...
2
Solved
I have a MySql MyISAM table with a full text index, like this:
CREATE TABLE `tblsearch` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`brand` varchar(100) DEFAULT NULL,...
Embonpoint asked 6/3, 2012 at 9:6
2
Solved
This is possible a problem what i lost more time to think how to do correct, thinking in the best optimized way to do.
I have a table "Contents", and need to add the option to associate multiple "...
Coorg asked 14/2, 2012 at 18:18
3
Solved
i have an issue with my current database with mysql.
i have over 100 connection waiting on a select record. when i execute:
show processlist;
the select query is a big query and the others are...
2
Solved
My database is currently using the InnoDB engine. Now I want to add the fulltext search feature, which is why I want to convert my tables to MyISAM. But doing so breaks all foreign keys. How can I ...
3
Solved
I know there are a bunch of other questions on this. The problem I'm having is finding an up to date consensus on the matter with regards to the latest versions of the storage engines.
Some...
2
Solved
I was testing transaction support in innoDB tables, and just for the curriosity I tried to run the same transaction on MyIsam table, and surprisingly it worked. I am assuming that on myIsam table q...
1
Solved
I have a MyIsam table about 15Gb large.
I have deleted about a half of the rows from it and the delete query took about 10 hours.
Now I'm afraid to start optimize table, because I don't know how lo...
Toupee asked 21/10, 2011 at 5:31
2
I am attempting my first large scale database project on my own.
I have a myisam mysql db on server 1 with a php app consuming large amount of various data.
I have mysql myisam on server 2 with ph...
Shwalb asked 27/8, 2011 at 20:7
2
Solved
I've searched a bit on this topic and found a few results. However, I'm looking for if anyone knows about or could point me to to some authentic or reputable case studies that detail the benefits(p...
4
I have a large MySQL table (~10 Million Rows, 6.5G) Which i use for read & write. It is MyISAM, and i get a lot of locks due to MyISAM's all table lock on writes.
I decided to try and move to ...
Kapellmeister asked 27/8, 2011 at 21:32
2
Solved
I'm inserting records into a MySQL table and try to understand the differences in time it takes between a MyISAM table and a InnoDB table.
This is the code to create the table:
CREATE TABLE Spect...
Visible asked 17/8, 2011 at 9:14
© 2022 - 2024 — McMap. All rights reserved.