<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[xto的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/xto</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; xto]]></copyright><item><title><![CDATA[python myql类库MySQLdb在数据过量情况下巨慢无比的原因分析]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403941</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403941</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 12:26:00 +0800</pubDate><description><![CDATA[2009年 9月27日晚上快下班时分，有群里面的朋友说python的MySQLdb在检索百万数据量的时候巨慢无比，要达到20分钟左右。由于自己的一些项目也用到了MySQLdb，所以特别注意了一下，于是翻阅了源代码。而后经过大半天对其源码的分析，初步得出一些结论。MySQLdb的性能影响主要是由于_mysql.c代码页中的self->use以及个别函数中的use参数=1或者0时引起的。由于在函数]]></description><category></category></item><item><title><![CDATA[lighttpd fastcgi配置例子和一些备份脚本]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403916</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403916</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 12:14:00 +0800</pubDate><description><![CDATA[global{server.modules +=("mod_fastcgi")}$SERVER["socket"]=="222.73.42.76:81"{#$HTTP["host"]=="db.huiin.com"{        server.name="huiin.com"        server.document-root="/var/www/phpmyadmin"        fas]]></description><category></category></item><item><title><![CDATA[一段debian 下面Iptables脚本控制ip访问的例子。]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403909</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403909</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 12:09:00 +0800</pubDate><description><![CDATA[写了好久了。自己都快忘记了顺便记在这里      1 iptables -F      2 iptables -N FIREWALL      3 iptables -F FIREWALL      4 iptables -A INPUT -j FIREWALL      5 iptables -A FORWARD -j FIREWALL      6 #pop3      7 #ipta]]></description><category></category></item><item><title><![CDATA[python reportlab 相对较为可用的正式报表]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403903</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403903</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 12:06:00 +0800</pubDate><description><![CDATA[#coding=utf-8#from reportlab.lib import *from reportlab.platypus import *from reportlab.lib.styles import *   from reportlab.rl_config import *   from reportlab.lib.units import *from reportlab.lib.pa]]></description><category></category></item><item><title><![CDATA[python reportlab调用操作分页报表]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403902</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403902</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 12:05:00 +0800</pubDate><description><![CDATA[#coding=utf-8def init_config():    import reportlab.rl_config    reportlab.rl_config.warnOnMissingFontGlyphs = 0    from reportlab.pdfbase import pdfmetrics    from reportlab.pdfbase.ttfonts import TT]]></description><category></category></item><item><title><![CDATA[一个基于python写的ms sql和postgresql互相转化表结构以及操作的用例]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403887</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403887</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 12:01:00 +0800</pubDate><description><![CDATA[#coding=utf-8#import _mssqlimport psycopg2,pymssqlimport typesTableSpace=ABS.class SyncDataBase():    def __init__(self):        self.pgconn=psycopg2.connect("dbname=absob host=192.168.1.32 user=pos]]></description><category></category></item><item><title><![CDATA[python DBUtils数据连接池与ms sql配合用法]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403877</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403877</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:59:00 +0800</pubDate><description><![CDATA[#coding=utf-8import os,psycopg2import _mssqlimport pymssqlfrom DBUtils.PooledDB import PooledDBhosts="192.168.1.32"users="test"passwords="12345"dbnames="testdb"ms_hosts="192.168.1.20"ms_users="sa"ms_p]]></description><category></category></item><item><title><![CDATA[python 利用win32com操作excel]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403863</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403863</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:56:00 +0800</pubDate><description><![CDATA[#coding=cp936import win32comfrom adoconstants import *from win32com.client import Dispatch,constantsimport osimport pythoncomclass TranslateExcel:    @staticmethod    def ImportMssqlToExcel(ip,dbname,]]></description><category></category></item><item><title><![CDATA[MongoDB数据库操作和程序基础文档]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403855</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403855</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:52:00 +0800</pubDate><description><![CDATA[数据库常用操作命令Bin/mongod run 启动数据库服务端。bin/mongod.exe --dbpath d:/data/mongo 启动数据库服务端并且将数据库目录设定在该地址下。run 直接启动。例：./mongod run--dbpath 指定特定存储目录启动，若目录不存在则创建。例：./mongod --dbpath /var/data/mongo--port 指定端口]]></description><category></category></item><item><title><![CDATA[lighttp服务器在linux2.6内核的优化]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403814</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403814</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:42:00 +0800</pubDate><description><![CDATA[一，基础配置纯静态优化. 目前服务器平台主要基于debian和ubuntu系统。 #基于linux-sysepoll优化 server.event-handler="linux-sysepoll" server.max-fds默认是1024 修改 server.max-fds,大流量网站推荐2048. 2 stat() 缓存stat() 这样的系统调用,开销也是相当明显的.缓存能够节约时间和环]]></description><category></category></item><item><title><![CDATA[Postgresql8.3数据库在linux编译安装说明]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403789</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403789</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:35:00 +0800</pubDate><description><![CDATA[有些部分是我自己写的，有些摘抄的，感谢开源社区的支持一，编译安装软件包：sudo apt-get install binutils cpp fetchmail flex gcc libarchive-zip-perl libc6-dev libcompress-zlib-perl libdb4.3-dev libpcre3 libpopt-dev lynx m4 make ncft]]></description><category></category></item><item><title><![CDATA[PostgreSQL系统配置优化]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403782</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403782</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:34:00 +0800</pubDate><description><![CDATA[PG的配置文件是数据库目录下的postgresql.conf文件，8.0以后的版本可支持K，M，G这样的参数，只要修改相应参数后重新启动PG服务就OK了。shared_buffers：这是最重要的参数，postgresql通过shared_buffers和内核和磁盘打交道，因此应该尽量大，让更多的数据缓存在shared_buffers中。通常设置为实际RAM的10％是合理的，比如50000(4]]></description><category></category></item><item><title><![CDATA[【SQL Server 数据库导入导出部分】 ]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403756</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403756</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:29:00 +0800</pubDate><description><![CDATA[1、在查询分析器下查询Excel文档 SELECT * FROM OpenDataSource(Microsoft.Jet.OLEDB.4.0,Data Source="c:/测试.xls"; User ID=Admin;Password=;Extended properties=Excel 8.0)...Sheet1$ 2、从数据库中导出数据并存到文件中 EXEC master..xp_]]></description><category></category></item><item><title><![CDATA[postgresql 表分区的测试用例]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403738</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403738</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:26:00 +0800</pubDate><description><![CDATA[----大数据数据表分区做法CREATE TABLE bcompany_01(CHECK(cpy_idCREATE TABLE bcompany_02(CHECK(cpy_id500000) ) INHERITS (bcompany);CREATE TABLE bcompany_03(CHECK(cpy_id1000000) ) INHERITS (bcompany);CREATE T]]></description><category></category></item><item><title><![CDATA[postgresql的一些常规的sql测试用例]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403710</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403710</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:17:00 +0800</pubDate><description><![CDATA[这是以前工作中测试用例。准备离职了，顺便贴到这里来 几个存储过程和方法： SELECT convert_from(aaaa,utf-8)CREATE OR REPLACE FUNCTION ABS.PRC_ENCODE_UTF8(PARAMS VARCHAR) RETURNS SETOF recordAS $$    declare sql varchar;    r ]]></description><category></category></item><item><title><![CDATA[postgresql源代码分析]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403701</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403701</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:16:00 +0800</pubDate><description><![CDATA[从Linux下拷回通过编译的源代码后，在硬盘上展开，例如我展开后将所有的源代码放到D:/Postgresql/source目录下。然后建立一个目录D:/Postgresql/insight,打开sourceinsight后在这个目录下创建一个project，将D:/Postgresql/source/backend目录下的所有文件加入该项目然后找到D:/Postgresql/source/doc/]]></description><category></category></item><item><title><![CDATA[postgresql代码研究的主要目录分类描述]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403693</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403693</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:14:00 +0800</pubDate><description><![CDATA[后台代码主要集中在 backend下面各个目录 access 物理表 index的实现 bootstrap 初始化模块 catalog 数据字典模块， commands ddl命令实现 executor 执行器 lib 辅助模块，双向list libpq 前后台通信 main main入口 Makefile nls.mk nodes query结构采用nodes表示，辅助模块 optimizer ]]></description><category></category></item><item><title><![CDATA[python 写的一个Ice服务端在linux下面的守护进程程序]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403676</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403676</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:10:00 +0800</pubDate><description><![CDATA[framework基本都是开发的远程调用方法DBUtils.PooledDB 是一个python的mysql数据连接池。后期都改为SQLAlchemy的连接池了 #coding=utf-8import sys,Ice,loggingfrom framework.ProspectEvent import *from framework.ProductEvent import ]]></description><category></category></item><item><title><![CDATA[python写的一个omniORB的调用用例]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403644</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403644</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 11:03:00 +0800</pubDate><description><![CDATA[当初项目选型时，在Ice,Net Remoting,omniORB徘徊许久，最终还是选用了Ice。这是omniORB的一个简单用例。idl接口描述module messenger{  interface SecretMessage  {    string get_message();  };};服务端实现：#coding=utf-8import messenger, me]]></description><category></category></item><item><title><![CDATA[一些摘抄的c#常用正则表达]]></title><link>https://blog.youkuaiyun.com/xto/article/details/5403589</link><guid>https://blog.youkuaiyun.com/xto/article/details/5403589</guid><author>xto</author><pubDate>Mon, 22 Mar 2010 10:55:00 +0800</pubDate><description><![CDATA[using System; 　　namespace Regexlib { 　　/// /// Class1 的摘要说明。 　　public class Regexlib { 　　public Regexlib() { 　　// // TODO: 在此处添加构造函数逻辑 // 　　} 　　//搜索输入字符串并返回所有 href="..."值 　　string DumpHrefs(String inp]]></description><category></category></item></channel></rss>