公司一台OA服务器,win 2003下可以识别内存24G,但在使用中发现OA的apache和mysql仅仅使用了不到3G,而mysql又经常报内存溢出的错误,观察系统性能监视器,内存分页数很大,虚拟内存频繁被使用。网上查了些资料,有说32位mysql单进程只能支持3G内存,哪位大大清楚这个问题,或者有大概思路的希望能帮助下,非常感谢。部分信息如下------------------------------------------------------systeminfo:
操作系统: Microsoft(R) Windows(R) Server 2003, Enterprise Edition 5.2.3790 Service Pack 2 Build 3790
初始安装日期: 2011-2-22, 12:58:01
系统型号: DELL PowerEdge R710
处理器: 安装了 12 个处理器。
x86 Family 6 Model 44 Stepping 2 GenuineIntel ~2660 Mhz X12物理内存总量: 24,563 MB
可用的物理内存: 22,732 MB
页面文件: 最大值: 26,301 MB
页面文件: 可用: 24,138 MB
页面文件: 使用中: 2,163 MB网卡: [01]: Broadcom BCM5709C NetXtreme II GigE (NDIS VBD Client)
mysql配置:
[mysql]
default-character-set=gbk[mysqld]
basedir=e:/MYOA/mysql5/
datadir=e:/MYOA/data5/
tmpdir=e:/MYOA/tmp/
default-character-set=gbk
set-variable=max_connections=1000
port=3336set-variable=key_buffer_size=200M
set-variable=max_tmp_tables=328
set-variable=tmp_table_size=2024M
set-variable=max_heap_table_size=2024M
set-variable=max_allowed_packet=20M
set-variable=table_cache=1024
set-variable=sort_buffer_size=40M
set-variable=read_buffer_size=100M
set-variable=read_rnd_buffer_size=16M
set-variable=myisam_sort_buffer_size=64M
set-variable=query_cache_size=200M
set-variable=thread_concurrency=50
set-variable=record_buffer=8M
set-variable=thread_cache=328
set-variable=net_buffer_length=16K
set-variable=wait_timeout=300
set-variable=interactive_timeout=300
set-variable=log-slow-queries=slow.log
set-variable=long_query_time=3
skip-innodb
skip-bdb
skip-name-resolveAPACHE配置:
ServerRoot "E:/MYOA/"
PidFile logs/httpd.pid
Timeout 300
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15<IfModule mpm_winnt.c>
ThreadsPerChild 600
MaxRequestsPerChild 0
</IfModule>LoadModule actions_module modules/mod_actions.so
LoadModule alias_module modules/mod_alias.so
LoadModule asis_module modules/mod_asis.so
LoadModule auth_basic_module modules/mod_auth_basic.so
LoadModule authn_default_module modules/mod_authn_default.so
LoadModule authn_file_module modules/mod_authn_file.so
LoadModule authz_default_module modules/mod_authz_default.so
LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
LoadModule authz_host_module modules/mod_authz_host.so
LoadModule authz_user_module modules/mod_authz_user.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule cgi_module modules/mod_cgi.so
LoadModule dir_module modules/mod_dir.so
LoadModule env_module modules/mod_env.so
LoadModule imagemap_module modules/mod_imagemap.so
LoadModule include_module modules/mod_include.so
LoadModule isapi_module modules/mod_isapi.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule mime_module modules/mod_mime.so
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_http_module modules/mod_proxy_http.so
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule setenvif_module modules/mod_setenvif.so
LoadModule userdir_module modules/mod_userdir.soServerAdmin [email protected] Off
DocumentRoot "E:/MYOA/webroot/"<Directory />
Options FollowSymLinks
AllowOverride None
</Directory><Files ~ "^\.ht">
Order allow,deny
Deny from all
</Files><IfModule mod_mime_magic.c>
MIMEMagicFile conf/magic
</IfModule>LogLevel errorLogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %b" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agentReadmeName README.html
HeaderName HEADER.htmlIndexIgnore .??* *~ *# HEADER* README* RCS CVS *,v *,tAddEncoding x-compress Z
AddEncoding x-gzip gz tgzAddLanguage da .dk
AddLanguage nl .nl
AddLanguage en .en
AddLanguage et .et
AddLanguage fr .fr
AddLanguage de .de
AddLanguage he .he
AddLanguage el .el
AddLanguage it .it
AddLanguage ja .ja
AddLanguage pl .po
AddLanguage ko .ko
AddLanguage pt .pt
AddLanguage nn .nn
AddLanguage no .no
AddLanguage pt-br .pt-br
AddLanguage ltz .ltz
AddLanguage ca .ca
AddLanguage es .es
AddLanguage sv .sv
AddLanguage cz .cz
AddLanguage ru .ru
AddLanguage tw .tw
AddLanguage zh-tw .tw
AddLanguage hr .hrLanguagePriority en da nl et fr de el it ja ko no pl pt pt-br ltz ca es sv twForceLanguagePriority Prefer Fallback
AddDefaultCharset GB2312
AddCharset ISO-8859-1 .iso8859-1 .latin1
AddCharset ISO-8859-2 .iso8859-2 .latin2 .cen
AddCharset ISO-8859-3 .iso8859-3 .latin3
AddCharset ISO-8859-4 .iso8859-4 .latin4
AddCharset ISO-8859-5 .iso8859-5 .latin5 .cyr .iso-ru
AddCharset ISO-8859-6 .iso8859-6 .latin6 .arb
AddCharset ISO-8859-7 .iso8859-7 .latin7 .grk
AddCharset ISO-8859-8 .iso8859-8 .latin8 .heb
AddCharset ISO-8859-9 .iso8859-9 .latin9 .trk
AddCharset ISO-2022-JP .iso2022-jp .jis
AddCharset ISO-2022-KR .iso2022-kr .kis
AddCharset ISO-2022-CN .iso2022-cn .cis
AddCharset Big5 .Big5 .big5
AddCharset WINDOWS-1251 .cp-1251 .win-1251
AddCharset CP866 .cp866
AddCharset KOI8-r .koi8-r .koi8-ru
AddCharset KOI8-ru .koi8-uk .ua
AddCharset ISO-10646-UCS-2 .ucs2
AddCharset ISO-10646-UCS-4 .ucs4
AddCharset UTF-8 .utf8AddCharset GB2312 .gb2312 .gb
AddCharset utf-7 .utf7
AddCharset utf-8 .utf8
AddCharset big5 .big5 .b5
AddCharset EUC-TW .euc-tw
AddCharset EUC-JP .euc-jp
AddCharset EUC-KR .euc-kr
AddCharset shift_jis .sjis
AddHandler type-map varBrowserMatch "Mozilla/2" nokeepalive
BrowserMatch "MSIE 4\.0b2;" nokeepalive downgrade-1.0 force-response-1.0
BrowserMatch "RealPlayer 4\.0" force-response-1.0
BrowserMatch "Java/1\.0" force-response-1.0
BrowserMatch "JDK/1\.0" force-response-1.0BrowserMatch "Microsoft Data Access Internet Publishing Provider" redirect-carefully
BrowserMatch "^WebDrive" redirect-carefully
BrowserMatch "^WebDAVFS/1.[012]" redirect-carefully
BrowserMatch "^gnome-vfs" redirect-carefully<IfModule mod_ssl.c>
Include conf/ssl.conf
</IfModule>#------------------------------------- 手动添加的内容 ------------------------------------------
<Directory ~ "E:/MYOA/webroot/(attachment|images|theme|wav)/">
<Files ~ ".(php|htm|html|jsp|asp)">
Order allow,deny
Deny from all
</Files>
</Directory>PHPIniDir "E:/MYOA/bin/"
LoadModule php5_module E:/MYOA/bin/php5apache2_2.dll AddType application/x-httpd-php .php DirectoryIndex index.php
DirectoryIndex index.html
DirectoryIndex index.htm
DirectoryIndex index.jsp ServerName localhost
Listen 80
PHP部分配置:
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;max_execution_time = 1200 ; Maximum execution time of each script, in seconds
max_input_time = 1200 ; Maximum amount of time each script may spend parsing request data
;max_input_nesting_level = 64 ; Maximum input variable nesting level
memory_limit = 1000M ; Maximum amount of memory a script may consume (128MB)
解决方案 »
- [求助]换了nginx前端 后端 Apache 进不了后台了!
- mysql表读取mysql表的问题
- 求救关于一个sql的问题,合并查询结果
- 请问MySQL Community Server和MySQL Enterprise什么区别
- mysql 5.1.6 免安装怎么样启动数据库?急!
- 找出两个表不一样的记录进行更新
- 刷新几次就出现数据库连接错误。。。
- 问一个数据库SELECT的问题:
- MySQL密码为什么在重启电脑后用不成了?
- 我想将sqlserver2000的程序转到mysql上,要做那些改变?价格呢?
- win2003 mysql服务能正常启动,工具连不上提示10055,重启服务器正常
- 更改两个表的关联值
或换64位的win2003.64位的mysql。
不知道mysql有没有这种配置