Topic profile page for MyISAM.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: MyISAM.
Topic "Myisam" was discussed 2,107 times on 208 sites in last 3 months
Started 1 week, 2 days ago (2009-11-02 09:13:00)
by Mark Smeed
Hey all, I am a newbie to Clustering and I have been trying to find out if I can overcome a little problem I have. When some of our clients create tables on our cluster environment they specify the engine as MyIsam. Obviously this means that the table does not get replicated on all of the nodes. Is there a way of forcing MySQL to always use the engine NDB even if the engine is specified ...
Started 1 week, 6 days ago (2009-10-28 22:38:00)
by DEinspanjer
I'm querying one MySQL database that uses InnoDB tables, and I'm ETLing the data into my data warehouse database that is using MyISAM. I need the read consistent view that InnoDB provides in a transaction, so I've enabled the option to make the transformation database transactional, but that surfaces a problem: When the transformation successfully finishes processing data, it tries...
Started 1 week, 6 days ago (2009-10-28 22:38:00)
by DEinspanjer Senior Member
I'm querying one MySQL database that uses InnoDB tables, and I'm ETLing the data into my data warehouse database that is using MyISAM. I need the read consistent view that InnoDB provides in a transaction, so I've enabled the option to make the transformation database transactional, but that surfaces a problem: When the transformation successfully finishes processing data, it tries...
Started 3 weeks ago (2009-10-21 02:22:00)
by Arin Ben-Aharon
Recently I have conducted a small benchmark that its goal was to test MyISAM select performance using different platforms ( with no special configuration, well almost) I have tested MySQL 5.1.39 on solaris 10u7 using UFS file system and performed another test using ZFS file system. I used sysbench to execute benchmarks ( all the tests used select distribution of 10% from the data in 70%...
Started 1 month ago (2009-10-08 05:09:00)
by Trupti Kulkarni
Hello all, I'm going to write my first trigger, and wanted to know if triggers work for tables whose engine is MyISAM. Some of the tables in my database have MyISAM and some have InnoDB engine. The version of MySQL I'm using is '5.1.33-community-log'. Thanks for your time. - Trupti
Started 3 days, 2 hours ago (2009-11-08 09:42:00)
by akari11
Fun Facts SQL Database For Sale Descriptions SQL File 1,489 Inserts Fun Facts Sample: CREATE TABLE `fact` ( `Fact` varchar(255) NOT NULL default '', PRIMARY KEY (`Fact`) ) TYPE=MyISAM; INSERT INTO `fact` VALUES (' A dime has 118 ridges around the edge, a quarter has 119.'); INSERT INTO `fact` VALUES (' A one ounce milk chocolate bar has 6 mg of...
Started 1 week ago (2009-11-03 15:20:00)
by nutkenz
If I'm not mistaken, InnoDB supports transactions, right? Though, how would changes to MyISAM tables intermixed with changes to InnoDB tables in a single transaction be handled through Doctrine? For example, suppose we have two tables: BANK1_CLIENTS (InnoDB) id balance BANK2_CLIENTS (MyISAM) id balance BEGIN -- start transaction UPDATE bank1_clients SET balance = balance - 400 WHERE id=4 ...
Started 1 week, 1 day ago (2009-11-02 12:45:00)
by Sherif Elian
Dear All i have a problem with the Mysql cluster, i have a database created 2 times , 1 with Engine=MYISAM and the other with Engine=NDBCluster after some benchmarking , i found that the MYISAM version is much faster than the NDBCluster one. i tried many query on different tables , i also used 2 setup's (1 datanodes and 2 datanodes) and i tried almost all the performance fixes...
Started 1 week ago (2009-11-04 06:34:00)
by Sarvesh Kumar
Hi, We are using MySQL Server 5.0.41 community version with InnoDB and MyISAM table engine in our production database which is on Linux 32 bit system with 8 GB RAM. We are observing the mysql error log frequently and found that after every 1-2 month it through the OUT OF MEMORY exception and the buffer get choked. It got fix as we have restarted the mysql service each time and the ...