n*d
2 楼
我有一个很强的服务器,Dual-Quad-Core CPU, 32GB内存。里面run的是Vista 64Bit.
但是对一个很大的数据库(4GB)运行MySQL的查询时,还是十分十分的慢,我也加过
Index等,还是没有效果,一查,发现CPU基本没有用 Mysqld进程只用了1%不到的CPU,
内存也没有好好用,一共只用了几百MB。
怎么设置一下能让系统资源多分配给MySQL啊?
但是对一个很大的数据库(4GB)运行MySQL的查询时,还是十分十分的慢,我也加过
Index等,还是没有效果,一查,发现CPU基本没有用 Mysqld进程只用了1%不到的CPU,
内存也没有好好用,一共只用了几百MB。
怎么设置一下能让系统资源多分配给MySQL啊?
s*l
3 楼
建议你到Hifi版去问问
http://www.mitbbs.com/bbsdoc/HiFi.html
【在 G*******n 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 原来一直用的sony888 今天给压碎了..
: ex300 500如何 ?
http://www.mitbbs.com/bbsdoc/HiFi.html
【在 G*******n 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 原来一直用的sony888 今天给压碎了..
: ex300 500如何 ?
w*r
4 楼
check out here. usually it is your buffer size is not set for large table
full scan. Also, it sounds to me that the IO wait is very long on your DB. I
am not quite sure where to look. Usually, I will search some information
about reading block size / table block size and read cache policy.
http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
full scan. Also, it sounds to me that the IO wait is very long on your DB. I
am not quite sure where to look. Usually, I will search some information
about reading block size / table block size and read cache policy.
http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
G*n
5 楼
谢谢啊~~
溜错版了
溜错版了
n*d
7 楼
Thanks very much. This link is really helpful!
相关阅读
Why did BM/BF not mark #344(by pigbaby)?第三课 对象、属性、事件、方法PL/SQL, stored p, trigger etc..How to extract data from web如何建基于WWW的BBS?Re: 请教C++制作数据库的问题(continue)how to do a case insensitive comparisonIs there any small free database support Java ?请教C++制作数据库的问题any good textbook about DBMS?what about oracle,repository&service?Is that possible for Applet to access the Oracle?申请Database版的板斧Enterprise Application Integration(EAI)A questionBCP的问题COMPUTER SCIENCE POSITIONS关于数据库有什么可学的呢?[转载] How to build a Web based check out system?Comparing different commercial available DBMS?