MySQL论坛

 找回密码
 注册
搜索
热搜: 活动 交友 discuz
查看: 1876|回复: 2

[其他] windows2003 64 位 mysql 服务自动关闭

[复制链接]

该用户从未签到

发表于 2013-4-3 09:22:54 | 显示全部楼层 |阅读模式
情况如下 :windows2003 64 位 如果机器上不安装vpn  正常运行 但是如果安装的话 mysql
服务假启动  过一会就自动关闭了  找了几天了 找不到答案 求关注
mysql 错误日志
130402  2:55:41 [Note] mysqlguarantee: Shutdown complete
130402  2:58:38  InnoDB: Error: cannot allocate 1073758208 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 7538476 bytes. Operating system errno: 8 InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. InnoDB: Note that in most 32-bit computers the process InnoDB: memory space is limited to 2 GB or 4 GB. InnoDB: We keep retrying the allocation for 60 seconds... InnoDB: Fatal error: cannot allocate the memory for the buffer pool 130402  2:59:38 [ERROR] Default storage engine (InnoDB) is not available 130402  2:59:38 [ERROR] Aborting
130402  2:59:38 [Note] mysqlguarantee: Shutdown complete
my.ini 配置文件如下
[client]
port=3308
[mysql]
default-character-set=gbk
[mysqld]
skip-name-resolve

# The TCP/IP Port the MySQL Server will listen on port=3308
#Path to installation directory. All paths are usually resolved relative to this. basedir=C:\Guarantee\mysql-5.0.20a-win32
#Path to the database root
datadir=C:\Guarantee\mysql-5.0.20a-win32\data
back_log=500
# The default character set that will be used when a new schema or table is # created and no character set is defined default-character-set=gbk
# The default storage engine that will be used when create new tables when default-storage-engine=INNODB
# Set the SQL mode to strict sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
# The maximum amount of concurrent sessions the MySQL server will # allow. One of these connections will be reserved for a user with # SUPER privileges to allow the administrator to login even if the # connection limit has been reached. max_connections=500 max_connect_errors = 500
query_cache_size=0
table_cache=512
tmp_table_size=101M

thread_cache_size=20
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=202M
key_buffer_size=172M
read_buffer_size=64K read_rnd_buffer_size=256K
sort_buffer_size=256K


innodb_additional_mem_pool_size=7M
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=4M
innodb_buffer_pool_size=1G
innodb_log_file_size=256M
innodb_thread_concurrency=8

该用户从未签到

 楼主| 发表于 2013-4-3 09:23:28 | 显示全部楼层
自己顶  找了好久 也找不到解决方案  求关注
回复 支持 反对

使用道具 举报

该用户从未签到

发表于 2013-4-12 12:57:19 | 显示全部楼层
你的my.ini文件谁帮你配置的?
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|小黑屋|手机版|Archiver|中文MySQL ( 京ICP 备06008873号 )

GMT+8, 2017-4-24 21:40 , Processed in 0.092842 second(s), 25 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表