- 博客(17)
- 资源 (8)
- 收藏
- 关注
原创 如何快速的阅读一本书的精华
网络时代的新办法: 在Goolge中输入: 书名 “笔记” 尤其适合只想了解下书中干活的情况。 例如:C陷阱与缺陷 “笔记”
2009-11-25 18:10:00 636
原创 JOIN 还是 IN ; 一条还是多条
Join Decomposition Many high-performance web sites use join decomposition. You can decompose a join by running multiple single-table queries instead of a multitable join, and then per- forming t
2009-11-25 15:43:00 478
原创 快速的表复制
mysql> CREATE TABLE innodb_table LIKE myisam_table; mysql> ALTER TABLE innodb_table ENGINE=InnoDB; mysql> INSERT INTO innodb_table SELECT * FROM myisam_table;
2009-11-25 14:29:00 376
原创 MyISAM比InnoDB快是误传
It’s an excellent idea to run a realistic load simulation on a test server and then literally pull the power plug. The firsthand experience of recovering from a crash is priceless. It saves nasty
2009-11-25 14:20:00 453
原创 MySQL的内存表的局限性
Although Memory tables are very fast, they often don’t work well as a general- purpose replacement for disk-based tables. They use table-level locking, which gives low write concurrency, and they
2009-11-25 13:57:00 516
原创 InnoDB的Primary Key不易过大
InnoDB tables are built on a clustered index, which we will cover in detail in Chapter 3. InnoDB’s index structures are very different from those of most other MySQL storage engines. As a result,
2009-11-25 13:50:00 474
原创 MySQL最多能装多少记录
Scalability and Limits: Support for large databases. We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 200,000 tables and ab
2009-11-25 12:30:00 903
原创 [转载]如何使用python在2M内存中排序一百万个32位整数
有人开玩笑地问我 如何使用python在2M内存中排序一百万个32位整数.为了应付这个挑战,我学习了一下缓冲I/O. 很 明显,这是一个开玩笑的问题.假设是二进制编码,单单是数据就已经占了4M!唯一的解释就是: 给定一个包含一百万个32位整数的文件,你如何使用最少内存去排序好它们?这可能需要使用某种合并排序的方式,把数据分块在内存排序,并保存到临时文件中 去,最后把临时文件合并获得最终结果.
2009-11-23 11:32:00 746
原创 用unix命令进行简单的统计(Top N)
统计日志文件test.txt中出现频度最高的前三行。 $ cat test.txt a b a b b b c c d d d d d e e e d a $ cat test.txt | sort | uniq -c | sort -nr | head -n3 6
2009-11-17 20:20:00 482
原创 如何用好Google
有两点心得: 1. 通配符* ,有时不知道如何表达一句英语才算地道,就可以用这个技巧,比如:"I was * to do",丢到Google里,就可以找到很多相关的句式。 2. 不要主观过滤。有时我们搜索一个关键词,然后凭自己的感觉随意点开几个,往往发现不是我们想要的。但是真真有键值的东西往往在我们忽略的那几个link。所以,最好的办法是打开搜索结果第一页的所有link,然后再一一过滤,这样做
2009-11-12 09:42:00 525
原创 MySQL的查询优化很傻
select id from message where author_id in (select followed_id from Relation where follower_id=1) order by id desc 和 分别执行 $userlist = select followed_id from Relation where follower_id=1 再 sele
2009-11-05 17:11:00 445
原创 figlet 一个生成ASCII艺术之的玩意儿
C:/Documents and Settings/Administrator>figlet LOVE _ _____ _______ | | / _ / / / / ____| | | | | | / / / /| _| | |__| |_| |/ V / | |___ |_____/___/ /_/ |_____| f
2009-11-05 17:03:00 605
QRe 正则表达式测试工具
2008-01-05
小孙Java反编译专家2.0
2007-08-16
IceSword终结者
2007-04-16
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人