.73]# cp /usr/share/doc/mysql-server-
5.1.73/my-large.cnf /etc/my.cnf
cp: overwrite `/etc/my.cnf‘? y
[root@localhost mysql-server-
5.1.73]# vim /etc/my.cnf
# Example MySQL config
file for large systems.
#
# This
is for a large system
with memory =
512M where the system runs mainly
# MySQL.
#
# MySQL programs look
for option files
in a set
of
# locations which depend
on the deployment platform.
# You can copy this option
file to one
of those
# locations.
For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
#
In this
file, you can
use all long options that a program supports.
#
If you want
to know which options a program supports, run the program
#
with the
"--help" option.
# The following options will be passed
to all MySQL clients
[client]
#password = your_password
port =
3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries
for some specific programs
# The MySQL server
[mysqld]
port =
3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size =
256M
max_allowed_packet =
1M
table_open_cache =
256
sort_buffer_size =
1M
read_buffer_size =
1M
read_rnd_buffer_size =
4M
myisam_sort_buffer_size =
64M
thread_cache_size =
8
query_cache_size=
16M
# Try number
of CPU
‘s*
2 for thread_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
to mysqld run
on the same host.
#
All interaction
with mysqld must be made via Unix sockets
or named pipes.
# Note that using this option without enabling named pipes
on Windows
# (via the
"enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
# Replication Master Server (
default)
# binary logging
is required
for replication
log-bin=mysql-bin
# binary logging format - mixed recommended
binlog_format=mixed
# 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
if omitted
server-id =
1
# Replication Slave (comment
out master section
to use this)
#
#
To configure this host as a replication slave, 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 quoted strings
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,
in case 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
if omitted
#server-id =
2
#
# The replication master
for this slave - required
#master-host = <hostname>
#
# The username the slave will
use for authentication
when connecting
#
to the master - required
#master-user = <username>
#
# The password the slave will authenticate
with 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
# Uncomment the following
if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql
#innodb_data_file_path = ibdata1:
10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql
# You can set .._buffer_pool_size up
to 50 -
80 %
#
of RAM but beware
of setting memory usage too high
#innodb_buffer_pool_size =
256M
#innodb_additional_mem_pool_size =
20M
# Example MySQL config
file for large systems.
#
# This
is for a large system
with memory =
512M where the system runs mainly
# MySQL.
#
# MySQL programs look
for option files
in a set
of
# locations which depend
on the deployment platform.
# You can copy this option
file to one
of those
# locations.
For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
#
In this
file, you can
use all long options that a program supports.
#
If you want
to know which options a program supports, run the program
#
with the
"--help" option.
# The following options will be passed
to all MySQL clients
[client]
#password = your_password
port =
3306
# This
is for a large system
with memory =
512M where the system runs mainly
# MySQL.
#
# MySQL programs look
for option files
in a set
of
# locations which depend
on the deployment platform.
# You can copy this option
file to one
of those
# locations.
For information about these locations, see:
# http://dev.mysql.com/doc/mysql/en/option-files.html
#
#
In this
file, you can
use all long options that a program supports.
#
If you want
to know which options a program supports, run the program
#
with the
"--help" option.
# The following options will be passed
to all MySQL clients
[client]
default-
character-set=utf8
#password = your_password
port =
3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries
for some specific programs
# The MySQL server
[mysqld]
lower_case_table_names=
1
port =
3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size =
256M
max_allowed_packet =
1M
table_open_cache =
256
sort_buffer_size =
1M
read_buffer_size =
1M
read_rnd_buffer_size =
4M
myisam_sort_buffer_size =
64M
thread_cache_size =
8
query_cache_size=
16M
# Try number
of CPU
‘s*
2 for thread_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
to mysqld run
on the same host.
#
All interaction
with mysqld must be made via Unix sockets
or named pipes.
# Note that using this option without enabling named pipes
on Windows
# (via the
"enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
# Replication Master Server (
default)
# binary logging
is required
for replication
log-bin=mysql-bin
# binary logging format - mixed recommended
binlog_format=mixed
# 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
if omitted
server-id =
1
# Replication Slave (comment
out master section
to use this)
#
#
To configure this host as a replication slave, 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 quoted strings
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,
in case 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
if omitted
#server-id =
2
#
# The replication master
for this slave - required
#master-host = <hostname>
#
# The username the slave will
use for authentication
when connecting
#
to the master - required
#master-user = <username>
#
# The password the slave will authenticate
with 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
# Uncomment the following
if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql
#innodb_data_file_path = ibdata1:
10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql
# You can set .._buffer_pool_size up
to 50 -
80 %
#
of RAM but beware
of setting memory usage too high
#innodb_buffer_pool_size =
256M
#innodb_additional_mem_pool_size =
20M
socket = /var/lib/mysql/mysql.sock
# Here follows entries
for some specific programs
# The MySQL server
[mysqld]
lower_case_table_names=
1
port =
3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size =
256M
max_allowed_packet =
1M
table_open_cache =
256
sort_buffer_size =
1M
read_buffer_size =
1M
read_rnd_buffer_size =
4M
myisam_sort_buffer_size =
64M
thread_cache_size =
8
query_cache_size=
16M
# Try number
of CPU
‘s*
2 for thread_concurrency
thread_concurrency =
8
default-
character-set=utf8
# Don
‘t listen
on a TCP/IP
port at
all. This can be a security enhancement,
"/etc/my.cnf" 148L,
4740C written
[root@localhost mysql-server-
5.1.73]# serv
servertool service
[root@localhost mysql-server-
5.1.73]# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
Linux mysql设置表名不区分大小写，设置编码
标签：
