https://blog.youkuaiyun.com/li_yang98zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/li_yang98/article/details/6384911https://blog.youkuaiyun.com/li_yang98/article/details/6384911li_yang98Mon, 02 May 2011 19:02:00 +0800上一篇 提到了在Ubuntu下搭建Apache+SVN服务，今天写了一个简单的PHP脚本支持用户自行修改SVN密码(假设这个脚本位于/var/www-ssl/svntools/svnpass.php目录下)
 
首先，用户在修改密码之前需要先登录，而登录的验证方法和访问SVN是一样的，在/etc/apache2/mods-available/alias.conf中加入如下配置
Alias /svntools/ "/var/www-ssl/svntools/" <]]>https://blog.youkuaiyun.com/li_yang98/article/details/6384245https://blog.youkuaiyun.com/li_yang98/article/details/6384245li_yang98Mon, 02 May 2011 11:55:00 +0800https://blog.youkuaiyun.com/li_yang98/article/details/6208223https://blog.youkuaiyun.com/li_yang98/article/details/6208223li_yang98Fri, 25 Feb 2011 17:42:00 +0800https://blog.youkuaiyun.com/li_yang98/article/details/6204910https://blog.youkuaiyun.com/li_yang98/article/details/6204910li_yang98Thu, 24 Feb 2011 13:53:00 +0800https://blog.youkuaiyun.com/li_yang98/article/details/6200079https://blog.youkuaiyun.com/li_yang98/article/details/6200079li_yang98Tue, 22 Feb 2011 15:08:00 +0800昨天 比较了一下在某个特定应用中MongoDB和MySQL导入数据的性能，但是MongoDB的测试结果并不能令人满意，今天继续尝试了几种导入数据的方法，希望提升数据导入性能。
 
在昨天的实验中，是以id随机的顺序插入数据的，由于我们在id这个属性上面建立了递增索引，因此首先怀疑的是由于id无序造成后面插入的数据有可能导致前面已经插入的数据移动位置，所以第一个实验把插入顺序改成按id赠序。但结果没有什么变化，插入一百万条数据用了1422秒(比昨天按id随机顺序插入还慢了点，]]>https://blog.youkuaiyun.com/li_yang98/article/details/6198871https://blog.youkuaiyun.com/li_yang98/article/details/6198871li_yang98Tue, 22 Feb 2011 00:03:00 +0800今天通过一个实验比较了一下MongoDB和MySQL的性能，注意这个比较只反映了我们这个应用场景下的情况，并不能代表普遍的情况。
 
我们希望存储一些视频历史上的流量，需要存1年的时间，每天活跃的视频在百万数量级，流量用整型表示就可以了。在我们的应用中，写性能是优先考虑的因素，所以第一步的实验主要比较写入的性能，由于存储的数据是被单一应用(进程)独享的，sqlite也满足我们的应用场景，因此我们同时也测试了sqlite的写入性能。
 
实验环境：
https://blog.youkuaiyun.com/li_yang98/article/details/6181729https://blog.youkuaiyun.com/li_yang98/article/details/6181729li_yang98Sat, 12 Feb 2011 23:02:00 +0800https://blog.youkuaiyun.com/li_yang98/article/details/6173595https://blog.youkuaiyun.com/li_yang98/article/details/6173595li_yang98Mon, 07 Feb 2011 00:19:00 +0800https://blog.youkuaiyun.com/li_yang98/article/details/6173077https://blog.youkuaiyun.com/li_yang98/article/details/6173077li_yang98Sat, 05 Feb 2011 22:57:00 +0800>> from pymongo import * >>> conn = Connection() >>> db = conn['test'] >>> col = db['foo'] >>> col.insert({'a':1}) ObjectId(]]>https://blog.youkuaiyun.com/li_yang98/article/details/6162122https://blog.youkuaiyun.com/li_yang98/article/details/6162122li_yang98Mon, 24 Jan 2011 23:26:00 +0800最近在学习MongoDB，做一些笔记
 
安装：
1. 下载
    有32位和64位两个版本，32位版本存储的数据量有2GB的限制，建议选择64位版本。最新的release版本号是1.6.5
    wget http://fastdl.mongodb.org/linux/mongodb-linux-x86_64-1.6.5.tgz
2. 解压
    tar -xzvf mongodb-linux-x86_64-1.6.5]]>https://blog.youkuaiyun.com/li_yang98/article/details/6116072https://blog.youkuaiyun.com/li_yang98/article/details/6116072li_yang98Tue, 04 Jan 2011 17:47:00 +0800最近在调试程序的时候接触到了strace这个工具。strace 是一个十分强大的调试/分析/诊断工具，这里 有一篇详细的介绍。
 
今天在配置lighty + web.py的时候遇到了问题，按照http://webpy.org/cookbook/fastcgi-lighttpd/ 进行配置后lighty无法正常启动，从lighty的error log看是加载处理fcgi的python模块时出了问题，但是不知道具体原因。尝试了几次以后决定用strace试一试:
]]>https://blog.youkuaiyun.com/li_yang98/article/details/6102354https://blog.youkuaiyun.com/li_yang98/article/details/6102354li_yang98Tue, 28 Dec 2010 12:09:00 +0800https://blog.youkuaiyun.com/li_yang98/article/details/5895234https://blog.youkuaiyun.com/li_yang98/article/details/5895234li_yang98Sun, 19 Sep 2010 18:06:00 +0800https://blog.youkuaiyun.com/li_yang98/article/details/5890988https://blog.youkuaiyun.com/li_yang98/article/details/5890988li_yang98Fri, 17 Sep 2010 15:15:00 +0800https://blog.youkuaiyun.com/li_yang98/article/details/5871663https://blog.youkuaiyun.com/li_yang98/article/details/5871663li_yang98Wed, 08 Sep 2010 19:16:00 +0800GDB下用p看一个字符串的时候默认显示是截断的，可以通过set print element 0命令显示完整的字符串。
 
(gdb) p this->content_->rd_ptr()
$1 = 0x1e30a20 "/r/nhttps://blog.youkuaiyun.com/li_yang98/article/details/5870817https://blog.youkuaiyun.com/li_yang98/article/details/5870817li_yang98Wed, 08 Sep 2010 14:09:00 +080064MB，会返回失败。http://code.google.com/intl/zh-CN/apis/protocolbuffers/docs/reference/cpp/google.protobuf.io.coded_stream.html#CodedInputStream.SetTotalBytesLimit.details这里给出了解释，主要是出于安全因素的考虑。可以通过SetTotalBytesLi]]>https://blog.youkuaiyun.com/li_yang98/article/details/5866250https://blog.youkuaiyun.com/li_yang98/article/details/5866250li_yang98Mon, 06 Sep 2010 14:30:00 +0800DATETIME -> Timestamp: UNIX_TIMESTAMP(...)
Timestamp -> DATETIME: FROM_UNIXTIME(...)
 
mysql> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()));
+--------------------------------------+
| FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())) |<]]>https://blog.youkuaiyun.com/li_yang98/article/details/3891407https://blog.youkuaiyun.com/li_yang98/article/details/3891407li_yang98Sun, 15 Feb 2009 01:30:00 +0800https://blog.youkuaiyun.com/li_yang98/article/details/3270766https://blog.youkuaiyun.com/li_yang98/article/details/3270766li_yang98Tue, 11 Nov 2008 01:06:00 +0800https://blog.youkuaiyun.com/li_yang98/article/details/3261211https://blog.youkuaiyun.com/li_yang98/article/details/3261211li_yang98Sun, 09 Nov 2008 18:15:00 +0800 /dev/null 2>&1如何打开core dump呢？最简单的方法是用户在自己的~/.bash_profile中加入ulimit -S -]]>