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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
