09 2012 档案

sql2000 CPU负载100%
摘要：sql2000 CPU占用100%查询select * from master..sysprocesses发现有CXPACKET进程占用大量CPU网上找到一个解决办法：关闭sql server的并行机制：sp_configure 'show advanced options',1configure of overridesp_configure 'max degree of parallelism',1configure of override设置这两个选项以后发现CPU的下降的50% 阅读全文

posted @ 2012-09-23 12:34 maolj 阅读(261) 评论(0) 推荐(0)

rails 3.2安装mysql2
摘要：今天在centos上面安装ruby 1.93跟rails 3.2的时候，出现个状况：Could not find gem 'mysql2 (>= 0) ruby' in the gems available on this machine.按照提示gem install mysql2还是报错：*** extconf.rb failed ***Could not create Makefile due to some reason, probably lack ofnecessary libraries and/or headers. Check the mkmf.log 阅读全文

posted @ 2012-09-18 20:31 maolj 阅读(430) 评论(0) 推荐(0)

导航