摘要: CREATE TABLE aaa ( `id` int(10) NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `cid` int(10) NOT NULL, `resume` text NOT NULL, `releasetime` int(10) NOT NULL, `uid` int(10) NOT NULL, `type` tinyint(1) unsigned NOT NULL DEFAULT '0', `hits` int(10) NOT NULL, `ifshare` tinyint(1) uns.. 阅读全文
posted @ 2012-06-01 16:42 菜鸟MM 阅读(669) 评论(0) 推荐(0) 编辑
摘要: SphinxSphinxSphinxSphinx详细安装配置详细安装配置详细安装配置详细安装配置 项目中需要重新做一个关于商品的全文搜索功能,于是想到了用Sphinx,因为需要中文分词,所以选择了Sphinx for chinese,当然你也可以选择coreseek,建议这两个中选择一个,暂时不要选择原版Sphinx(对中文的支持不是很好).又因为服务器所用 MySQL在当时编译时并没有编译Sphinx扩展,而重新编译MySQL并加入Sphinx暂时又无法实现(项目用到了多台服务器,在不影响现有业务的 情况下不可能去重新编译MySQL的),所以采用的是程序通过API来外部调用Sphinx... 阅读全文
posted @ 2012-06-01 16:41 菜鸟MM 阅读(1059) 评论(0) 推荐(0) 编辑
摘要: DROP TABLE IF EXISTS `lb`.`adrt_counter`;CREATE TABLE `lb`.`adrt_counter` ( `counter_id` int(5) NOT NULL, `max_doc_id` int(20) NOT NULL, `table_name` char(30) NOT NULL, PRIMARY KEY (`counter_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `lb`.`asph_counter`;CREATE TABLE `lb`.`as... 阅读全文
posted @ 2012-06-01 16:40 菜鸟MM 阅读(475) 评论(0) 推荐(0) 编辑
摘要: DROP TABLE IF EXISTS `lb`.`adrt_counter`;CREATE TABLE `lb`.`adrt_counter` ( `counter_id` int(5) NOT NULL, `max_doc_id` int(20) NOT NULL, `table_name` char(30) NOT NULL, PRIMARY KEY (`counter_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `lb`.`asph_counter`;CREATE TABLE `lb`.`as... 阅读全文
posted @ 2012-06-01 16:39 菜鸟MM 阅读(401) 评论(0) 推荐(0) 编辑
摘要: yum install httpd* -yyum install php* -yvim /etc/httpd/conf/httpd.confServerName localhostAddType application/x-httpd-php .phpAddType application/x-httpd-php-source .phpsservice httpd startmkdir -p /var/www/htmlvim index.php<?phpphpinfo();?> 浏览器192.168.10.199/index.phpcp /coreseek-4.0.1-beta/c 阅读全文
posted @ 2012-06-01 16:38 菜鸟MM 阅读(402) 评论(0) 推荐(0) 编辑
摘要: (1)vim /etc/sysconfig/network-scripts/ifcfg-eth0ONBOOT="yes"IPADDR=192.168.10.198BOOTPROTO=noneNETMASK=255.255.255.0TYPE=EthernetGATEWAY=192.168.10.1 (2)service network restartifconfig (3)关闭防火墙service iptables stopvim /etc/sysconfig/selinuxsetenforce 0 (4)光驱挂到本地目录mkdir -p /mnt/cdrommount / 阅读全文
posted @ 2012-06-01 16:37 菜鸟MM 阅读(455) 评论(0) 推荐(0) 编辑
摘要: (一)安装zookeeper(1)tar zxf zookeeper-3.3.3.tar.gz(2)mv zookeeper-3.3.3 /usr/local/zookeeper(3)cd /usr/local/zookeeper/conf/(4)cp zoo_sample.cfg zoo.cfg(5)vim zoo.cfg修改的内容dataDir=/usr/local/zookeeper/zookeeper-datadataLogDir=/usr/local/zookeeper/logsclientPort=2181server.1=master:2888:3888server.2=sla. 阅读全文
posted @ 2012-06-01 16:35 菜鸟MM 阅读(386) 评论(0) 推荐(0) 编辑
摘要: zookeeper的使用 zookeeper启动之后,不需要执行命令,只需查看批准的状况,命令如下:1、ruok - The server will respond with imok if it is running. Otherwise it will not respond at all.2、kill - When issued from the local machine, the server will shut down.3、dump - Lists the outstanding sessions and ephemeral nodes. This only works on.. 阅读全文
posted @ 2012-06-01 16:35 菜鸟MM 阅读(256) 评论(0) 推荐(0) 编辑
摘要: #java -version如有openjdk的东东要删除yum remove java-1.6.0-openjdk然后安装JDK先去下载吧http://www.oracle.com/technetwork/java/javase/downloads/index.html下载下来是个bin可执行文件,首先要赋于执行属性,转为root权限后,#chmod 755 jdk-6u27-linux-x64.bin把它移到要安装的目录,比如usr/local/下,因为安装是安装到当前目录的直接运行#./jdk-6u27-linux-x64.bin按提示完成安装,安装后可把rpm包移除或移到其它软件备份目 阅读全文
posted @ 2012-06-01 16:34 菜鸟MM 阅读(310) 评论(0) 推荐(0) 编辑
摘要: hive安装(1)tar -zxf hive-0.7.1-bin.tar.gz(2)mv hive-0.7.1-bin /usr/local/hive(3)vim hive-config.shexport HADOOP_HOME=/usr/local/hadoop/hadoop-0.20.204.0/export JAVA_HOME=/usr/java/jdk1.6.0_27export HIVE_HOME=/usr/local/hive(4)cd /usr/local/hadoop/hadoop-0.20.204.0(5)bin/hadoop fs -mkdir /tmp(6)bin/h.. 阅读全文
posted @ 2012-06-01 16:33 菜鸟MM 阅读(1464) 评论(0) 推荐(0) 编辑