首页新闻找找看学习计划

windows2003 64 位 mysql 服务自动关闭

0
悬赏园豆:20 [待解决问题]

情况如下 :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

< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册