search for: myisam

I tried adding a FULLTEXT search index to a table of mine in MySQL, only to discover that the InnoDB table format doesn''t seem to support this feature. Switching to the MyISAM table type seemed to work, but I seem to have some recollection that ActiveRecord transactions aren''t fully atomic on MyISAM tables. Is this true or am I just remembering wrong? If so, does anyone have any suggestions for doing fulltext searches in rails? I found a couple of links on th...

i''m using a table, that uses fulltext search and therefore the table type MyISAM everything works fine in production mode, but tests fail with ActiveRecord::StatementInvalid: Mysql::Error: The used table type doesn''t support FULLTEXT indexes when looking in the test db it''s clear, that it''s using InnoDB, but even manually changing the table type doe...

...sql and index.cache errors what am I missing ? only noticed this one so far ------------------ # grep "Too many open files" /var/log/dovecot.log Jan 02 15:22:16 auth-worker(1411): Warning: mysql: Query failed, retrying: Got error 24 "Too many open files" from storage engine MyISAM Jan 02 15:22:16 auth-worker(1411): Error: sql(bb at tld.com.au,183.88.2.248,<VzebccNhtPO3WAL4>): User query failed: Got error 24 "Too many open files" from storage engine MyISAM lots of this one ---------------------------- Jan 16 09:08:36 imap(postmaster at sbt.net.au): Error: mma...

Hi, I am a RoR newbie and I''ve been experimenting with different databases (mySQL, PostgreSQL, etc.) and different table types (MyISAM vs. InnoDB). Is there a preferred database/table type for RoR development. I like how MySQL''s InnoDB tables enforce referential integrity, but these tables require a lot more storage space then MyISAM tables. For everyone with a lot of RoR experience, what database setup do you prefe...

Hi, I have been using myisam tables in mysql with rails because my client will soon want fulltext searchable content, however when I migrated my development db from schema.rb all of the tables generated were innodb. I understand that I can override this, but also like the transactions and foreign keys of innodb. So 2 questions...

Hi All, In my companies environment, we have multiple sites in multiple geographic locations, sometimes with high latency between the sites. I''m trying to come up with a solution that could provide puppet infrastructure to all sites nodes. ----a few assumptions--- - puppet manifest / configuration is fetched from a centralized version control system. - store db is needed (ssh keys,

I''ve been creating my tables using the command line approach Dave advocates in AWD. I just noticed that they''re being created as MyISAM-type tables. I remember reading (but not where) that I should be creating these as InnoDB-type tables. So, two questions... 1) Is the table type important? (a "why" component to the answer would be nice too ;-) ) 2) If so, is there a way to specify the table type using the command l...

...NULL auto_increment, `user_id` int(11) NOT NULL default ''0'', `created_on` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `updated_on` timestamp NOT NULL default ''0000-00-00 00:00:00'', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `galleries`; CREATE TABLE `galleries` ( `id` int(11) NOT NULL auto_increment, `node_id` int(11) NOT NULL default ''0'', `user_id` int(11) NOT NULL default ''0'', `title` varchar(255) NOT NULL default ''...

Hi, Strange behavior here. On my dev machine code works, but on the production machine I get the dreaded: SQLite3::BusyException: database is locked INSERT INTO "comments" [...] What kind of bug could yield such behavior? It''s impossible the database times out, there are no concurrent requests coming in, and the db is only 150kB. Is there a possible race condition? Caching

...t but should there be more references to the join between jobs and jobs_sectors? Thanks for you time, Tim DDL as promised..... CREATE TABLE `jobs_sectors` ( `job_id` mediumint(9) NOT NULL default ''0'', `sector_id` mediumint(9) NOT NULL default ''0'' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `jobs` ( `id` int(10) unsigned NOT NULL auto_increment, `title` varchar(254) NOT NULL default '''', `description` text NOT NULL, `start_sallary` float NOT NULL default ''0'', `end_sallery` float NOT NULL default '...

...`id` int(11) NOT NULL auto_increment, `message` text NOT NULL, `date` datetime NOT NULL default ''0000-00-00 00:00:00'', `sender_id` int(11) NOT NULL default ''0'', `receiver_id` int(11) NOT NULL default ''0'', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; (I''m using acts_as_authenticated for my user management.) Whenever a message is sent, I want both the sender_id and the receiver_id to point to the user_id. I guess I am wanting to know what is the best way to go about setting up the model file when you have two...

...eeder) > > That said, I wish every guys would not be made afraid of commit message... > > Galina, FYI, it's the place to check length; master/buildbot/db/base.py > > CREATE TABLE `changes` ( > (snip) > `comments` varchar(1024) NOT NULL, > (snip) > ) ENGINE=MyISAM AUTO_INCREMENT=25011 DEFAULT CHARSET=utf8; > > ...I don't know why this is created as myisam and the column "comments" > would be not "text" but varchar... > > 2013/11/15 Daniel Sanders <Daniel.Sanders at imgtec.com>: > > Hi, > > > >...

Dear R Developers, In the same way that MySQL/MariaDB's Engine InnoDB or MyISAM/Aria have the innodb_buffer_pool_size or the key_buffer_size for setting the maximum amount of RAM which can be used by a Server Instance: ?Would it be possible to create an R Configuration Variable which fixes the maximum amount of RAM memory to be used as Commit / Dynamic Memory Allocation? Tha...

...wish every guys would not be made afraid of commit message... >> >> Galina, FYI, it's the place to check length; master/buildbot/db/base.py >> >> CREATE TABLE `changes` ( >> (snip) >> `comments` varchar(1024) NOT NULL, >> (snip) >> ) ENGINE=MyISAM AUTO_INCREMENT=25011 DEFAULT CHARSET=utf8; >> >> ...I don't know why this is created as myisam and the column "comments" >> would be not "text" but varchar... >> >> 2013/11/15 Daniel Sanders <Daniel.Sanders at imgtec.com>: >> > Hi...

...06 6:24 PM Subject: Migration doesn''t seem to preserve create_table options in schema To: rails@lists.rubyonrails.org Hi, I have the following migration (abbreviated): class Initial < ActiveRecord::Migration def self.up create_table :messages, :options => ''ENGINE=MyISAM'', :force => true do |t| t.column :id, :integer, :null => false t.column :external_id, :string, :null => false t.column :recipients_count, :integer, :default => 0 end end def self.down drop_table :messages end end When runnin...

...s done not in the buildmaster, but on the commit feeder) That said, I wish every guys would not be made afraid of commit message... Galina, FYI, it's the place to check length; master/buildbot/db/base.py CREATE TABLE `changes` ( (snip) `comments` varchar(1024) NOT NULL, (snip) ) ENGINE=MyISAM AUTO_INCREMENT=25011 DEFAULT CHARSET=utf8; ...I don't know why this is created as myisam and the column "comments" would be not "text" but varchar... 2013/11/15 Daniel Sanders <Daniel.Sanders at imgtec.com>: > Hi, > > > > Neither of my commits so far t...

...of pets, Parky the cat, Daisy the dog, etc, And Types contains a list of different pet types, dog - cat - fish - bird - etc. Pets table CREATE TABLE `pets` ( `id` int(11) NOT NULL auto_increment, `name` varchar(20) default NULL, `pet_id` int(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Types table CREATE TABLE `types` ( `id` int(11) NOT NULL auto_increment, `pettype` varchar(11) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 What I want to do is to associate the pet_id from Pets with the id from types, and can do that in...

Hi, Neither of my commits so far today have shown up in the buildbot console view. They aren't showing up in the list of changes reported by the changesource either. For example: http://lab.llvm.org:8011/changes/45724 shows r194805, then http://lab.llvm.org:8011/changes/45725 shows r194807. My commit is the r194806 that should be between them. Similarly change 45728 is r194810, and change

...e! Here is the sql to create the database with some simple information CREATE TABLE `child` ( `item_number` varchar(16) NOT NULL default '''', `first_name` varchar(8) NOT NULL default '''', `last_name` varchar(8) NOT NULL default '''' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `child` -- INSERT INTO `child` VALUES (''2005121212121201'', ''charlie'', ''bowman''); -- -------------------------------------------------------- -- -- Table structure for table `parent` -- CR...

Anybody offhand know the maximum filesize for a MySQL table? CentOS 3.6 Linux native ext3 filesystem MySQL version 3.23.58 TIA John Hinton