付费求助：更改数据库innodb参数！更改后数据库连接不上

freddy

# Example MySQL config file for very largesystems.

#

# This is for a large system with memory of1G-2G where the system runs mainly

# MySQL.

#

# MySQL programs look for option files in aset of

# locations which depend on the deploymentplatform.

# You can copy this option file to one ofthose

# locations. For information about theselocations, see:

#http://dev.mysql.com/doc/mysql/en/option-files.html

#

# In this file, you can use all longoptions that a program supports.

# If you want to know which options aprogram supports, run the program

# with the "--help" option.

# The following options will be passed toall MySQL clients

[client]

#password       =your_password

port           =3306

socket                =/tmp/mysql.sock

# Here follows entries for some specificprograms

# The MySQL server

[mysqld]

#lum_config_start

wait_timeout=888888

interactive_timeout=888888

max_connections=3000

back_log=50

key_buffer_size=256M

sort_buffer_size=8M

read_buffer_size=4M

join_buffer_size=16M

thread_cache_size=8

query_cache_size=256M

#lum_config_end

port           =3306

socket                =/tmp/mysql.sock

skip-external-locking

max_allowed_packet = 500M

table_open_cache = 2048

read_rnd_buffer_size = 16M

myisam_sort_buffer_size = 128M

# Try number of CPU's*2 forthread_concurrency

thread_concurrency = 8

# Don't listen on a TCP/IP port at all.This can be a security enhancement,

# if all processes that need to connect tomysqld run on the same host.

# All interaction with mysqld must be madevia Unix sockets or named pipes.

# Note that using this option withoutenabling named pipes on Windows

# (via the "enable-named-pipe"option) will render mysqld useless!

#

#skip-networking

# Replication Master Server (default)

# binary logging is required forreplication

log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1

# defaults to 1 if master-host is not set

# but will not function as a master ifomitted

server-id  =1

# Replication Slave (comment out mastersection to use this)

#

# To configure this host as a replicationslave, you can choose between

# two methods :

#

# 1) Use the CHANGE MASTER TO command(fully described in our manual) -

#   the syntax is:

#

#   CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,

#    MASTER_USER=<user>,MASTER_PASSWORD=<password> ;

#

#   where you replace <host>, <user>, <password> by quotedstrings and

#   <port> by the master's port number (3306 by default).

#

#   Example:

#

#   CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,

#   MASTER_USER='joe', MASTER_PASSWORD='secret';

#

# OR

#

# 2) Set the variables below. However, incase you choose this method, then

#   start replication for the first time (even unsuccessfully, for example

#   if you mistyped the password in master-password and the slave fails to

#   connect), the slave will create a master.info file, and any later

#   change in this file to the variables' values below will be ignored and

#   overridden by the content of the master.info file, unless you shutdown

#   the slave server, delete master.info and restart the slaver server.

#   For that reason, you may want to leave the lines below untouched

#   (commented) and instead use CHANGE MASTER TO (see above)

#

# required unique id between 2 and 2^32 - 1

# (and different from the master)

# defaults to 2 if master-host is set

# but will not function as a slave ifomitted

#server-id       = 2

#

# The replication master for this slave -required

#master-host     =  <hostname>

#

# The username the slave will use forauthentication when connecting

# to the master - required

#master-user     =  <username>

#

# The password the slave will authenticatewith when connecting to

# the master - required

#master-password =   <password>

#

# The port the master is listening on.

# optional - defaults to 3306

#master-port     = <port>

#

# binary logging - not required for slaves,but recommended

#log-bin=mysql-bin

#

# binary logging format - mixed recommended

#binlog_format=mixed

# Uncomment the following if you are usingInnoDB tables

innodb_data_home_dir =/usr/local/mysql/data

innodb_data_file_path =ibdata1:2000M;ibdata2:10M:autoextend

innodb_log_group_home_dir= /usr/local/mysql/data

# You can set .._buffer_pool_size up to 50- 80 %

# of RAM but beware of setting memory usagetoo high

innodb_buffer_pool_size =1G

innodb_additional_mem_pool_size= 256M

# Set .._log_file_size to 25 % of bufferpool size

innodb_log_file_size =100M

innodb_log_buffer_size =8M

innodb_flush_log_at_trx_commit= 1

innodb_lock_wait_timeout= 50

[mysqldump]

quick

max_allowed_packet = 256M

[mysql]

no-auto-rehash

# Remove the next comment character if youare not familiar with SQL

#safe-updates

[myisamchk]

read_buffer = 8M

write_buffer = 8M

[mysqlhotcopy]

interactive-timeout

freddy

爱洞特漏

再改回去，或者执行lu-repair -y修复

freddy

爱洞特漏 发表于 2013-4-18 13:28
再改回去，或者执行lu-repair -y修复

老大，能改回去，但是不知道问题出在哪里，改的目的就是要解决目前的需求，但是现在只能改回去，但是需求没解决啊……

freddy

继续求助，付费求助1！！！！

freddy

顶起来！！！！

freddy

继续求顶啊

易旅游-阿文

我也是这样的问题。我顶你！