[mysqld]
log-error=/var/lib/mysql/cs317.bluehost.com.err
log_timestamps=SYSTEM
tmpdir=/var/mysqltmp
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
log_warnings=2

query_cache_size=0M
key_buffer_size=8M
sort_buffer_size=256k
read_buffer_size=256k
tmp_table_size=256M
max_heap_table_size=256M
table_definition_cache=8192
thread_cache_size=64
table_open_cache=20000
open_files_limit=50000
max_connections=150
extra_max_connections=5
join_buffer_size=128k

default-storage-engine=innodb
userstat=on

skip-partition
ft_min_word_len=3

ssl-cert=/var/cpanel/ssl/mysql/mysql.crt
ssl-key=/var/cpanel/ssl/mysql/mysql.key

old_passwords=0
datadir=/var/lib/mysql
skip-external-locking
query_cache_type=0
max_user_connections=25

collation_server=utf8_unicode_ci
character_set_server=utf8

delayed_insert_timeout=40

interactive_timeout=10
wait_timeout=3600
connect_timeout=20
max_connect_errors=100
max_allowed_packet=256M
read_rnd_buffer_size=2M
myisam_sort_buffer_size=32M
server-id=1

innodb_file_per_table=1
innodb_strict_mode=0
innodb_fast_shutdown=0
innodb_log_file_size=134217728
innodb_log_files_in_group=2
innodb_flush_method=O_DIRECT
innodb_stats_on_metadata=0
innodb_buffer_pool_size=4096M
innodb_temp_data_file_path=ibtmp1:12M:autoextend:max:10G
innodb_flush_log_at_trx_commit=2
innodb_open_files=300
[mysql.server]
user=mysql

[mysqldump]
quick
max_allowed_packet=256M

[mysql]
no-auto-rehash
max_allowed_packet=256M