MySQL Forums
Forum List  »  General

Re: Problem with my.cnf file
Posted by: anil alapati
Date: June 28, 2013 12:29PM

here is my my.cnf file shows as follows:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

user=mysql
max_allowed_packet=4M;


old_passwords=0

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

#Allow packets up to 4MB

max_connections=500
default-storage-engine=innodb
log_slow_queries=ON;
long_query_time=2
log-slow-queries=/var/log/mysql/log-slow-queries.log

general_log=1
general_log_file=/var/log/mysqld-general.log

character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
collation_connection utf8_general_ci
collation_database utf8_general_ci
collation_server utf8_general_ci


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

Options: ReplyQuote


Subject
Written By
Posted
June 28, 2013 07:30AM
Re: Problem with my.cnf file
June 28, 2013 12:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.