you can go to http://www.tmtm.org/en/ruby/mysql/ to download the tar file, and run the command below # ruby ./install.rb to install the mysql.rb -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Shawn Cheatham
2008-Dec-11 01:27 UTC
Re: mysql.rb driver has been removed from Rails 2.2 ?
Weng Edgar wrote:> you can go to http://www.tmtm.org/en/ruby/mysql/ to download the tar > file, and run the command below > > # ruby ./install.rb > > to install the mysql.rbJust learning so hang with me. I downloaded, unzipped and in terminal ran # ruby ./install.rb which returned a new command line. Is there a specific location the folder should sit in before the install command is entered or a directory I should be in first? Thanks in advance -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
You get around this by actually installing the MySQL gem with C bindings. The one you guys are talking about is the pure Ruby one. The pure-MySQL library is terrible for performance and can cause some seriously flaky stuff. There are a number of posts on tis list that discuss the installation of that library. If you''re getting the error relating to /usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle then you have a half-installed mysql driver and I bet you''re on a Mac. The solution that worked for me was to do this: http://www.napcsweb.com/blog/2007/06/01/mysql-gem-on-osx/ I hope that helps! On Wed, Dec 10, 2008 at 7:27 PM, Shawn Cheatham <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > Weng Edgar wrote: >> you can go to http://www.tmtm.org/en/ruby/mysql/ to download the tar >> file, and run the command below >> >> # ruby ./install.rb >> >> to install the mysql.rb > > Just learning so hang with me. I downloaded, unzipped and in terminal > ran # ruby ./install.rb which returned a new command line. Is there a > specific location the folder should sit in before the install command is > entered or a directory I should be in first? > > Thanks in advance > -- > Posted via http://www.ruby-forum.com/. > > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Shawn Cheatham
2008-Dec-11 23:48 UTC
Re: mysql.rb driver has been removed from Rails 2.2 ?
Thanks for the help - after a bit of onsite help I was able to complete the install. Still some quirks to be worked out but that''s the point...to tinker. Thanks again Brian Hogan wrote:> You get around this by actually installing the MySQL gem with C > bindings. The one you guys are talking about is the pure Ruby one. > > The pure-MySQL library is terrible for performance and can cause some > seriously flaky stuff. There are a number of posts on tis list that > discuss the installation of that library. > > If you''re getting the error relating to > > /usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle > > then you have a half-installed mysql driver and I bet you''re on a Mac. > > The solution that worked for me was to do this: > > http://www.napcsweb.com/blog/2007/06/01/mysql-gem-on-osx/ > > I hope that helps! > > On Wed, Dec 10, 2008 at 7:27 PM, Shawn Cheatham-- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
I have installed rails 2.2.2 (had 2.0.1) and the mysql performance is very bad compared to earlier I takes me 10 minutes to load data into a mysql database. With 2.0.1 it took less than 4 minutes The amount of save and creating operations is indicated of that the log file is about 2.7 MB I have tried to install mysql gem as proposed. I first uninstalled mysql by sudo gem uninstall mysql I then installed it again with sudo env ARCHFLAGS="-arch i386" gem install mysql -- --with-mysql- dir=/usr/local/mysql --with-mysql-lib=/usr/local/mysql/lib --with- mysql-include=/usr/local/mysql/include but there is now change in performance I have Mysql 5.051, gem 1.3.1 ruby 1.8.6 rails 2.2.2 Appriciate any helps!!!!! On 12 Dec 2008, 00:48, Shawn Cheatham <rails-mailing-l...@andreas- s.net> wrote:> Thanks for the help - after a bit of onsite help I was able to complete > the install. Still some quirks to be worked out but that''s the > point...to tinker. > > Thanks again > > > > Brian Hogan wrote: > > You get around this by actually installing the MySQL gem with C > > bindings. The one you guys are talking about is the pure Ruby one. > > > The pure-MySQL library is terrible forperformanceand can cause some > > seriously flaky stuff. There are a number of posts on tis list that > > discuss the installation of that library. > > > If you''re getting the error relating to > > > /usr/local/lib/ruby/gems/1.8/gems/mysql-2.7/lib/mysql.bundle > > > then you have a half-installed mysql driver and I bet you''re on a Mac. > > > The solution that worked for me was to do this: > > >http://www.napcsweb.com/blog/2007/06/01/mysql-gem-on-osx/ > > > I hope that helps! > > > On Wed, Dec 10, 2008 at 7:27 PM, Shawn Cheatham > > -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
This way has worked everytime for me. Make sure the path is correct in your environment. sudo gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---