[mysqld]
pid-file="/var/lib/mysql/c002.pid"
log-error=/var/lib/mysql/c002.dapurhosting.com.err
sql_mode="" 
performance-schema=0
#skip-name-resolve
skip_name_resolve
# 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

##used in replication to give each master and slave a unique identity
server-id=1

##amount of seconds during inactivity that MySQL will wait before it will close a connection on a non-interactive connection. 
wait_timeout=10

##amount of seconds during inactivity that MySQL will wait before it will close a connection on interactive connection, interactive is mysql shell sessions
interactive_timeout=28800

##The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake
connect_timeout=10

##If more than this many successive connection requests from a host are interrupted without a successful connection, the server blocks that host from further connections
max_connect_errors=10

#The maximum number of simultaneous connections permitted to any given MySQL user account
max_user_connections=15

##This value indicates how many maximum concurrent connections mysql server can handle. If mysql reaches to it maximum (max) limit then you can see errors like "too many connections".
max_connections=200

##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=128M

#The minimum size of the buffer that is used for plain index scans, range index scans, and joins that do not use indexes and thus perform full table scans. 
join_buffer_size=1M

##Each session that needs to do a sort allocates a buffer of this size
sort_buffer_size=2M

##Each thread that does a sequential scan allocates a buffer of this size (in bytes) for each table it scans. 
read_buffer_size=131072

#The maximum size of one packet or any generated/intermediate string. 
max_allowed_packet=368435456

##The number of open tables for all threads
table_open_cache=2048 

##which sets the number of threads to hold open in memory to service new connections
thread_cache_size=16

##enables applications to give the threads system a hint about the desired number of threads that should be run at the same time. 
# thread_concurrency=10

##Cache all cacheable query results except for those that begin with SELECT SQL_NO_CACHE.
query_cache_type=1

##Do not cache results that are larger than this number of bytes
query_cache_limit=1M

##The amount of memory allocated for caching query results
query_cache_size=128M

##The number of open tables for all threads
table_open_cache=5120

tmp_table_size=32M
max_heap_table_size=64M

##If a query takes longer than this many seconds, the server increments the Slow_queries status variable
long_query_time=1

##to enable or disable the slow query log
#slow_query_log=1
#slow_query_log_file=/var/log/mysql/mysql-slow.log
#log_error=/var/log/mysql/mysql-error.log
default-storage-engine=MyISAM
innodb_file_per_table=1
open_files_limit=50000