similar to: Max Filesize MySQL CentOS 3

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

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

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

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

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 really: 1. are transactions in activerecord dependent on innodb or do

Hi everybody I am totally new to rails and I am trying to start a tiny project to get familiar with rails. But I already got my first problem and I would be happy if somebody could point me in the best and cleanest direction. I am trying to develop a small gallery app. Since I would like to add more features in future I am trying to design a clean OO architecture of my models: The base object

En r?ponse ? Ingo Ralf Blum <ingoralfblum@gmx.de>: > Hi, > > > I saw on the website that the ACM was a work in progress, but have > seen no > other > > mention anywhere else. So if someone is working on that I'm ready to > help, > > otherwise I'm ready to start it. > > I just read on the FLAC main website, that the MediaXW project contains

That would explain it. The commit messages were quite long (especially the second one) and a commit with a smaller message has shown up. Thanks for letting me know. I'll try to keep them a bit more reasonable in future. > -----Original Message----- > From: NAKAMURA Takumi [mailto:geek4civic at gmail.com] > Sent: 15 November 2013 16:28 > To: Daniel Sanders > Cc: LLVM Developers

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? Thank you. Juan

Hey Rails People, I''m doing my first Rails app and I''m having a newbie problem with the count method.... Mysql::Error: #42S02Unknown table ''jobs_sectors'' in where clause: SELECT COUNT(*) FROM jobs WHERE (jobs_sectors.sector_id = 1 ) Extracted source (around line #4): 1: <div class="sectors"> 2: <ul> 3: <% for sector in @sectors

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

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 does not help,

Hi all, I am starting out learning Ruby on Rails (coming from a PHP background) and I have a question about proper database design. Let me give you a quick example of what I want to do: Database: CREATE TABLE `users` ( `id` int(11) NOT NULL auto_increment, `login` varchar(40) default NULL, `email` varchar(100) default NULL, `crypted_password` varchar(40) default NULL, `salt`

I have a model named User. When running this application from the console I can call User.find_by_id(nil) and it returns nil. When running this application during testing or through WEBrick or Mongrel calling User.find_by_id(nil) returns the newest record in the database. But it only does this the first time you call it with nil. The second time you call User.find_by_id(nil) it returns nil.

Ah, ...no. please don't hesitate to write logs ;) It must be the subject in the buildbot, not in developer guys. Galina, I'll write up later, how to tweak this issue. It is not resolved in released versions, though. The easiest way is to tweak svnpoller. 2013/11/16 Daniel Sanders <Daniel.Sanders at imgtec.com>: > That would explain it. The commit messages were quite long

I''m new to rails and ruby, and after trying to get this to work correctly for hours, I thought I''d give this forum an try. I''ve setup a trivial project just to mess around with Rails database naming conventions and associations. I''ve got a table called Pets, and a table called Types. Pets contains a list of pets, Parky the cat, Daisy the dog, etc, And Types

Hi, is this the best forum to answer this question? Is there any better source for information or another mailinglist to address this question to? Cheers, Mariano ---------- Forwarded message ---------- From: Mariano Kamp <mariano.kamp@gmail.com> Date: Jan 8, 2006 6:24 PM Subject: Migration doesn''t seem to preserve create_table options in schema To: rails@lists.rubyonrails.org

I'm having problems compiling cdr_addon_mysql with MySQL 3.23.58 I get the following errors: cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o cdr_addon_mysql.o cdr_addon_mysql.c cdr_addon_mysql.c:50: warning: parameter names (without types) in function declaration cdr_addon_mysql.c:50: warning: data definition has no type or storage class cdr_addon_mysql.c: In function

I get the following error on trying to install mysql rpms please any idea what might be wrong and how to work around it? [root at localhost linux 23-02-2007]# rpm -i --nodeps mysql-5.0.27-1.el4.centos.i386.rpm warning: mysql-5.0.27-1.el4.centos.i386.rpm: V3 DSA signature: NOKEY, key ID 443e1821 file /etc/my.cnf from install of mysql-5.0.27-1.el4.centos conflicts with file from package