# MySQL (default setup). Versions 4.1 and 5.0 are recommended.
# 此处省略一些注释。
development:
adapter: mysql
database: demo_development
username: root
password:
host: localhost
# Warning: The database defined as 'test' will be erased and
# re-generated from your development database when you run 'rake'.
# Do not set this db to the same as development or production.
test:
adapter: mysql
database: demo_test
username: root
password:
host: localhost
production:
adapter: mysql
database: demo_production
username: root
password:
host: localhost
先安装rubyinstaller,下载并解压DevKit,注意,这两个版本要对应,网页上有说明(http://rubyinstaller.org/downloads/),解压DevKit后,打开目录,运行devkitvars.bat(是不是必须的不确定)。打开cmd,进入DevKit的解压目录
ruby dk.rb
---
Configures an MSYS/MinGW based Development Kit (DevKit) for
each of the Ruby installations on your Windows system. The
DevKit enables you to build many of the available native
RubyGems that don't yet have a binary gem.
Usage: ruby dk.rb COMMAND [options]
where COMMAND is one of:
init prepare DevKit for installation
review review DevKit install plan
install install required DevKit executables
and 'install' [options] are:
-f, --force overwrite existing helper scripts
-------------
ruby dk.rb init
---
Initialization complete! Please review and modify the auto-generated
'config.yml' file to ensure it contains the root directories to all
of the installed Rubies you want enhanced by the DevKit.
--------------------------------
ruby dk.rb install
---
Invalid configuration or no Rubies listed. Please fix 'config.yml'
and rerun 'ruby dk.rb install'
如果出现的是这个,则需要修改config.yml
加入
- C:\Ruby200-x64
---
[INFO] Updating convenience notice gem override for 'C:/Ruby200-x64'
[INFO] Installing 'C:/Ruby200-x64/lib/ruby/site_ruby/devkit.rb'
这是对的
---------------------
gem install ruby-debug-ide
---
Temporarily enhancing PATH to include DevKit...
Building native extensions. This could take a while...
Successfully installed ruby-debug-ide-0.4.17
Parsing documentation for ruby-debug-ide-0.4.17
Installing ri documentation for ruby-debug-ide-0.4.17
1 gem installed
在使用Cookie.find等操作的时候,就会连接到database.yml中monitor_spider配置的数据库上操作。以前一直都这么用,没发现什么不妥。最近一个项目,由于启动的进程比较多,老是碰到数据库连接池链接获取超时的错误。通过MySQL Client用命令:show processlist发现数据库连接数量一直居高不下,轻轻松松就上2k+的连接。通过读Rails框架的connection_pool.rb文件代码,发现在各模型中用establish_connection连接数据库会造成很大的问题。文件中类ConnectionHandler的establish_connection方法代码如下:Ruby代码 def establish_connection(name, spec) @connection_pools[name] = ConnectionAdapters::ConnectionPool.new(spec) end def establish_connection(name, spec)
@connection_pools[name] = ConnectionAdapters::ConnectionPool.new(spec)