Submitted by yejr on 周六, 2007/04/28 - 10:56
原文来自： http://mysqldatabaseadministration.blogspot.com/2007/04/youtube-and-mysq...
Paul Tuckfield of YouTube is giving a keynote. He has been sysadmin for 25 years, Oracle DBA for 15 years and MySQL DBA for 8 months.
For them, MySQL is one (important) piece of scalability. Top reasons for YouTube Scalability includes drinking :).
Top reasons for YouTUbe database scalability include Python, Memcache and MySQL replication. WHat you can do with Python, you can't do with other scripting languages. The fastest query on the database is that is never sent to the database.
Submitted by yejr on 周四, 2007/04/26 - 14:38
原文来自： http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html
One of the great things about MySQL is the superior innovation model that’s used to deliver database server software. Rather than relying solely on internal engineers who create and maintain a piece of software (as in a traditional software company), MySQL partners with the millions of active users across the world who take advantage of the open source model and daily extend the MySQL server to do new and pioneering things. These innovations can then be submitted to MySQL AB, tested, validated, and rolled into the database server so everyone can benefit from the creativity of the very active MySQL community.
Submitted by sapphire on 周四, 2007/04/26 - 09:22
我在一个BBS上看到的贴,觉得很好玩,就转过来了....大家一起分享吧....
1.公司新配给我一个助理.今天,我,助理以及我们老总,去局里开会.会毕,领导要写个注意事项给我们.我和老总当时拿笔都不太方便.我随口问助理..你带笔了吗?
他马上回答:带了
然后,几双眼睛看着他..接下来的十秒钟内..他睁着那双无辜的大眼,看着我们三个.
于是,我打破这个尴尬的僵局..补充一句..借我用用..
又是尴尬的十秒过去了..他才拿过自己的背包里找到一只笔,递给了我.然后我才递给领导..
Submitted by yejr on 周二, 2007/04/17 - 16:37
最近公司网站访问量比以前增加了不少，导致 httpd 负载也响应加大，error log中也多次出现类似下面的错误。
[notice] child pid 11972 exit signal Segmentation fault (11)
*** glibc detected *** free(): invalid pointer: 0x0a7206cc ***
*** glibc detected *** free(): invalid next size (fast): 0x09e87e90 ***
google了一下，发现以前也有人碰到过，通过修改内核参数，加大共享内存即可，于是我也尝试了一下：
web#sysctl -a|grep shm
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 33554432
web#sysctl -w kernel.shmmax = 67108864
然后重启apache，以后就很少报告该错误了。
Submitted by sapphire on 周三, 2007/04/11 - 16:52
测试多多少少影响了一点我的生活。
以前对各种软件啊，什么乱七八糟的都极其不感兴趣。
偏偏，我现在做了软件测试，呵呵，不知道是命运跟我开了这个玩笑还是我鄙视了命运一把。
现在没什么测试任务的时候也喜欢研究下各种平时会用到的软件，比如最平常的输入法啊，以前一直喜欢用紫光的，现在听说sougou的也不错，就下了一个，正在使用中ing。比较喜欢sougou的外观，还有他的设置功能，比较简单易懂。
平时的记账也都由手工记录改为都专用理财软件啦。这个软件的功能还是比较强大的，但是我只用力记录家里每天的流水帐。
Submitted by yejr on 周一, 2007/04/09 - 22:10
总有网友问我，如何通过php调用MySQL的存储过程同时取得返回的结果集呢？确实，MySQL的存储过程大大方便了编程也提高了效率。但是，对于那些还在用php 4 的同学们来说可就麻烦了，因为php 4只能调用存储过程，但却无法直接取得返回结果集；不过，用php 5的mysqli函数就可以做到了。首先，重新编译php 5，增加对mysqli的支持，或者直接下载mysqli的扩展模块，这里不再细说。直接举个例子吧：
1、 创建存储过程，列出 test 库下的所有表：
mysql>DELIMITER //
mysql>CREATE PROCEDURE `yejr`()
->BEGIN
->SHOW TABLES;
->END; //
Query OK, 0 rows affected (0.12 sec)
Submitted by yejr on 周一, 2007/04/09 - 13:15
Milan, Italy -- April 3rd, 2007 -- MySQL AB, developer of the world's most popular open source database, today announced that Dada, a leading international provider of Web and mobile community and entertainment services, has selected MySQL Enterprise Unlimited to power its subscriber database storing the information of over 7 million users.
Dada’s consumer offering is characterized by a rich range of fee-based community and entertainment products and services accessible via the PC and the mobile phone. This offering is available to users in 15 countries throughout the world for a total “addressable market” of over 700 million mobile users on second- and third-generation networks.
Submitted by yejr on 周日, 2007/04/08 - 09:12
先用光盘启动，然后:
yejr$suod su
yejr#/sbin/grub
grub>find /boot/grub/stag1 #显示如(hda0,5)
grub>root (hd0,5)
grub>setup (hd0)
grub>quit
yejr#reboot
一切ok，也用不着chroot。
Submitted by yejr on 周五, 2007/04/06 - 08:45
注：乘客有浓重的地方口音，哪个地方的未知
乘客：人好多啊
乘务员：刚上车的请刷卡，没卡的请买票
乘客：到xxxx
乘务员：有包吗？
乘客：嗯？八毛？
乘务员：有包吗？
乘客：八毛？
乘务员：算了算了，一块钱吧
乘客：什么，快给钱？
乘务员：......
乘务员：给你撕一张一块钱的票吧（把票递过去）
乘客：哦，一块钱啊，嗨....
乘务员：.....
看来普通话的普及很重要啊 :D
页面
最近评论