#
# This is a MySQL example config file for systems with 4GB of memory
# running mostly MySQL using InnoDB only tables and performing complex
# queries with few connections.
# 
# You can copy this file to /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options 
# (/var/lib/mysql for this installation) or to
# ~/.my.cnf to set user-specific options.
#
# 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.
#
# More detailed information about the individual options can also be
# found in the manual.
#

#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
#password	= [your_password]
port		= 3306
socket		= /var/lib/mysql/mysql.sock

# *** Application-specific options follow here ***

#
# The MySQL server
#
[mysqld]

# generic configuration options
port		= 3306
socket		= /var/lib/mysql/mysql.sock


back_log = 50

#skip-networking
#skip-grant-tables 

max_connections = 500

#max_connect_errors = 10 
table_cache = 2048  

#external-locking


max_allowed_packet = 16M

net_buffer_length=1048576 
event-scheduler=1
skip-name-resolve

binlog_cache_size = 1M

max_heap_table_size = 64M

sort_buffer_size = 8M

join_buffer_size = 8M

thread_cache_size = 8

thread_concurrency = 8

query_cache_size = 0  

query_cache_limit = 2M

ft_min_word_len = 4

#memlock

default_table_type = INNODB  

thread_stack = 256K  

# Set the default transaction isolation level. Levels available are:
# READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE
transaction_isolation = REPEATABLE-READ

tmp_table_size = 64M

###### Log File Section######
##### I have placed all the log files related variables here

#log-output=TABLE 

log-error=/var/lib/mysqllog/error/lppu.err 

pid-file=/var/lib/mysqllog/error/pidoflppu.pid

log-bin=/var/lib/mysqllog/bin/updates
binlog_format=MIXED 

#log_slave_updates


#general_log  


log_warnings

#slow_query_log   

long_query_time = 2

log_long_format

# The directory used by MySQL for storing temporary files. For example,
#tmpdir = /tmp

###### Finished Logging Information #######



#*** MyISAM Specific options

key_buffer_size = 32M

read_buffer_size = 2M

read_rnd_buffer_size = 16M

bulk_insert_buffer_size = 64M

myisam_sort_buffer_size = 128M

myisam_max_sort_file_size = 10G
myisam_max_extra_sort_file_size = 10G

myisam_repair_threads = 1

myisam_recover


# *** INNODB Specific options ***

#skip-innodb

innodb_additional_mem_pool_size = 16M

innodb_buffer_pool_size = 2G


innodb_data_file_path = ibdata1:50M:autoextend  

innodb_file_per_table=1  

innodb_open_files=600 

#innodb_data_home_dir = <directory>

innodb_file_io_threads = 4

#innodb_force_recovery=1

innodb_thread_concurrency = 16

innodb_flush_log_at_trx_commit = 1

#innodb_fast_shutdown

innodb_log_buffer_size = 8M

innodb_log_file_size = 256M


innodb_log_files_in_group = 3


#innodb_log_group_home_dir


innodb_max_dirty_pages_pct = 90


#innodb_flush_method=O_DSYNC


innodb_lock_wait_timeout = 120


[mysqldump]
# Do not buffer the whole result set in memory before writing it to
# file. Required for dumping very large tables
quick

max_allowed_packet = 16M
net_buffer_length=1048576

[mysql]
no-auto-rehash

# Only allow UPDATEs and DELETEs that use keys.
#safe-updates

[isamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M

[myisamchk]
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M

[mysqlhotcopy]
interactive-timeout

[mysqld_safe]
# Increase the amount of open files allowed per process. Warning: Make
# sure you have set the global system limit high enough! The high value
# is required for a large number of opened tables
open-files-limit = 8192