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,257 times on 229 sites in last 3 months
Started 2 days, 7 hours ago (2009-11-27 05:19:00)
by Krzysztof Retel
Hi All, I was looking around the forum to find out which backup method MySQL Community recommends for the MyISAM DB. We have two DBs (A and B), where one (A) is design to have heavy inserts where each insert fires a trigger to populate data across to some tables in other DB. The second DB (B) has a heavy usage for CRUD operations. Requirements: 1. Do not lock neither of ...
Started 2 weeks, 2 days ago (2009-11-13 07:18:00)
by Antnee
I know this is a question that comes up a lot, but I have a question pertaining to my specific database usage, if you don't mind? At present we use all MyISAM tables and every query comes via a web-server (PHP mysql commands). However, since the system was originally developed, the number of JOINs that we use has vastly increased. They're effectively being used as FKs in a number of tables, ...
Started 3 weeks, 6 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 month 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 month 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 1 month, 1 week 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 3 days, 3 hours ago (2009-11-26 08:50:00)
by dcz
phpBB SEO Related Topics Title : phpBB SEO Related Topics Author : dcz / http://www.phpbb-seo.com Description : Adds related topic link list in topic view. The mod supports Mysql FullTex (mysql >=4.1 using Myisam, auto detected) and SQL Like matching for others, and has common words filtering abilities. With the Ultimate SEO URL mod, it has its own section in the ACP ...
Started 4 days, 8 hours ago (2009-11-25 04:40:00)
by feld
Currently all the tables are in latin1_german1_ci for example : Code: ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=35 They plan to make in multilingual . im thinking about altering the tables to utf8_unicode_ci, assuming it will support all unicode characters. will this damage the existing data?.
Started 5 days, 8 hours ago (2009-11-24 04:31:00)
by Tero Pitkänen
Hi, I have managed to drop one of my mysql databases. (database engine MyISAM) Me and my buddy have been working about a week or so to recover the lost data. We were able to recover myi and frm files, but we haven't found solution to recover any myd files. Is it possible to carve the filesystem for those MYD files? Or is it impossible? (We don't have proper backup for ...
Started 3 days, 13 hours ago (2009-11-25 23:28:00)
by Rick James
A FOREIGN KEY gives you two things: * Protection from certain coding mistakes -- presumably you have fixed all of them by now, so you don't need PKs for that. * CASCADING DELETEs, etc. Triggers might work -- if your provider allows triggers. Probably better to code them yourself. You knew what had to be done when you added the CASCADE clause; now you simply have to do it in code. You ...
Started 3 days, 13 hours ago (2009-11-25 23:35:00)
by Rick James
Please provide SHOW CREATE TABLE -- need to see certain other details. How much RAM do you have available? (Thinking about key_buffer_size) What percentage of records are "new" versus duplicates?
Started 6 hours, 37 minutes ago (2009-11-29 06:07:00)
by nomankhn
Quote: Originally Posted by Miraenda If you might be running out of memory, your key_buffer_size is too large. That's a lot of memory you are giving the key buffer (512M). I'd suggest just changing that value rather than revising all of your values as was suggested lol Possibly, just change the key_buffer_size to 80M or 100M in your...
Started 3 days, 21 hours ago (2009-11-25 15:12:00)
by ice_rr
Veritabanı Kod: -- -- Tablo yapısı: `anket` -- CREATE TABLE IF NOT EXISTS `anket` ( `id` int(3) NOT NULL AUTO_INCREMENT, `kurum` varchar(40) CHARACTER SET latin5 NOT NULL, `gorev` varchar(40) CHARACTER SET latin5 NOT NULL, `cinsiyet` varchar(40) CHARACTER SET latin5 NOT NULL, `tarih` varchar(40) CHARACTER SET latin5 NOT NULL, `eposta` varchar(40) CHARACTER SET latin5 NOT NULL,...
Started 1 week ago (2009-11-22 06:14:00)
by co.ador
so it's ok if I leave like that? Quote: CREATE TABLE IF NOT EXISTS `restaurants_foodtypes` ( `restaurants_id` int(1) NOT NULL, `foodtypes_id` int(1) NOT NULL, PRIMARY KEY (`restaurants_id`,`foodtypes_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; I using phpmyadmin and mysql. What would be the way to struture the way you have done it...