cat > /etc/sysconfig/mysqld << EOF
# /etc/sysconfig/mysqld
# mysql config file
MYCNF=/etc/mysqld/my.cnf
# (oe) Remove --skip-networking to enable network access from
# non local clients. Access from localhost will still work.
#MYSQLD_OPTIONS="--nice=19 --skip-grant-tables" # --skip-networking
# When I try to remotely connect it would take quite a while to connect.
# I fixed this delay by adding the "skip-name-resolve" to my.ini
# [Warning] 'user' entry 'root@cen05' ignored in --skip-name-resolve mode.
MYSQLD_OPTIONS="" # "--master-connect-retry=10" "--skip-networking"
MYSQLD_PREOPTS="--defaults-file=$MYCNF"
# (oe) set TMPDIR and TMP environment variables
# datadir defined also in my.cnf
# but sometimes mysqldump dies because
# cannot write to files /.tmp dir
datadir=/srv/mysql
TMPDIR="\${datadir}/.tmp"
TMP="\${TMPDIR}"
EOF

#
# mysql config file
#
[client]
socket  = /var/run/mysqld/mysqld.sock
port    = 3306
default-character-set=utf8

[mysql]
# [client] # look like has the same result
# with one little difference
# mysql accept [client]:pager
# mysql* (mysqldump,mysqlshow) DOES NOT accept [client]:pager
#no-auto-rehash # faster start of mysql but no tab completition
pager   = less



[mysqld_safe]
log-error   = /var/log/mysqld/mysqld.log
pid-file    = /var/run/mysqld/mysqld.pid



[mysqld]
# The MySQL server
datadir      = /srv/mysql
socket       = /var/run/mysqld/mysqld.sock
user         = mysql
# (cen06) [Warning] '--default-character-set' is deprecated and will be removed in a future release.
# default-character-set=utf8
character-set-server=utf8
# [Warning] '--skip-locking' is deprecated and will be removed in a future release.
# Please use '--skip-external-locking' instead.
# skip-locking
skip-external-locking
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0


# bind to loopback interface
#bind-address = 127.0.0.1
# bind to all interfaces
bind-address = 0.0.0.0
port         = 3306


# Reduced to 25 as memory will not be enough for 100 connections.
# memory=key_buffer_size+(sort_buffer_size+read_buffer_size)*max_connections
# sort_buffer_size:max=64MB, read_buffer_size:max=64MB
# which is now: 12288 + (64 + 64) * 50 = 18688 MB
# max_connections = approx. MaxClients setting in httpd.conf file
# Default set to 100.
max_connections=25
# It is possible that mysqld could use up to:
# key_buffer_size+(read_buffer_size+sort_buffer_size)*max_connections = 10.250 GB
# bytes of memory
# Hope that's ok; if not, decrease some variables in the equation.


#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# log all queries sended to mysqld
# (cen06) [Warning] '--log' is deprecated and will be removed in a future release. Please use '--general_log'/'--general_log_file' instead.
# cen05: log, cen06: general_log_file
#general_log_file = /var/log/mysqld/queries.log
#log              = /var/log/mysqld/mysqld.log

# log slow queries is a must. Many queries that take more than 2 seconds.
# If so, then your tables need enhancement.
# (cen06) [Warning] '--log_slow_queries' is deprecated and will be removed in a future release.
# cen05: log_slow_queries, cen06: slow_query_log
log_slow_queries = /var/log/mysqld/slow-queries.log
slow_query_log = /var/log/mysqld/slow-queries.log
#long_query_time=2
#log-queries-not-using-indexes


# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
# Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html
old_passwords=1


# increase mysql open file limit, to not often close and open table files
open-files-limit = 65536
table_cache      = 65536


# How many threads the server should cache for reuse. When a client disconnects,
# the client's threads are put in the cache if there are fewer than thread_cache_size threads there.
# Requests for threads are satisfied by reusing threads taken from the cache if possible,
# and only when the cache is empty is a new thread created.
thread_cache_size     =    8

# The maximum size of one packet or any generated/intermediate string.
# The packet message buffer is initialized to net_buffer_length bytes,
# but can grow up to max_allowed_packet bytes when needed.
# This value by default is small, to catch large (possibly incorrect) packets.
max_allowed_packet    =    1M

# Each session that needs to do a sort allocates a buffer of this size.
# sort_buffer_size is not specific to any storage engine and applies in a general manner for optimization.
sort_buffer_size      =    2M

# Each thread that does a sequential scan allocates a buffer of this size (in bytes) for each table it scans.
# If you do many sequential scans, you might want to increase this value, which defaults to 131072.
# The value of this variable should be a multiple of 4KB. If it is set to a value that is not a multiple of 4KB,
# its value will be rounded down to the nearest multiple of 4KB.
read_buffer_size      =    2M

# When reading rows in sorted order following a key-sorting operation,
# the rows are read through this buffer to avoid disk seeks.
# Setting the variable to a large value can improve ORDER BY performance by a lot.
# However, this is a buffer allocated for each client, so you should not set the global variable to a large value.
# Instead, change the session variable only from within those clients that need to run large queries.
read_rnd_buffer_size  =    8M

# Index blocks for MyISAM tables are buffered and are shared by all threads.
# key_buffer_size is the size of the buffer used for index blocks.
# The key buffer is also known as the key cache.
key_buffer_size       =   96M

# The amount of memory allocated for caching query results. The default value is 0, which disables the query cache.
# The permissible values are multiples of 1024; other values are rounded down to the nearest multiple.
# Note that query_cache_size bytes of memory are allocated even if query_cache_type is set to 0.
query_cache_size      =   64M

# MyISAM
# The size of the buffer that is allocated when sorting MyISAM indexes
# during a REPAIR TABLE or when creating indexes with CREATE INDEX or ALTER TABLE.
myisam_sort_buffer_size = 64M

# InnoDB
# If innodb_file_per_table is disabled (the default), InnoDB creates tables in the shared tablespace.
# If innodb_file_per_table is enabled, InnoDB creates each new table using its own .ibd file
# for storing data and indexes, rather than in the shared tablespace.
innodb_file_per_table = 1