Discussion about optimise MySQL_程序员之家(Tuning MySQL)

开发技术指南» 文章正文

引言： Discussion about optimise MySQL

摘要：狂晕！谁知道“\”的资料 (6)shell环境变量 cdpath 用于cd命令的查找路径 home /etc/passwd文件中列出的用户主目录 ifs internal field separator,默认为空格，tab及换行符 mail /var/mail/$username mail等程序使用 path ps1，ps2 默认提示符($)及换行提示符(>) term 终端类型，常用的有v......

·一个关于perl的判断语句的练习 »显示摘要«

摘要：把if语句看了看,做了一个练习 ^_^ 一个猜随机数的小脚本! (附测试结果) 点击查看文件==>lx.txt......

Tuning MySQL

discussion about optimise mysql to handle a high traffic website.

【程序编程相关:锁定控制台的一个脚本】

【推荐阅读:stty技巧小全】

【扩展信息:如何为普通用户分配特权】

tim

cto, digital content solutions

mysql settings, many concurrent users.

i run a site for a client that has over 3000 users that log in for about 5-7 hours

per day each. so, at peak times, we have to handle about 2000 concurrent users.

when configured correctly, php and mysql can handle this load wonderfully on fairly

cheap intel architecture. first off, hardware.

1) it is better to have 2 separate servers for apache/php and mysql with the linux of your choice.

2) try not to run too much else on either box; leave the resources for apache/php and mysql.

here are the specs on each box in my config:

1) apache/php: pentium 3, 600 mhz, 512 megs ram.

2) mysql: dual pentium 3, 750 mhz (1500 mhz total), 2 gigs ram.

tuning mysql

discussion about optimise mysql to handle a high traffic website.

tim

cto, digital content solutions

mysql settings, many concurrent users.

i run a site for a client that has over 3000 users that log in for about 5-7 hours

... 下一页

·用perl写的一个脚本 »显示摘要«

摘要：今天看论坛上有人问问题,我尝试用perl写了一个perl script ^_^ 感觉perl真的很有趣 :-)由于代码无法正确显示,点击此文件即可查看......

» 本期热门文章：

· 热门栏目：

» 相关精选文章

» 其它相关：