Mysql Optimization Parameters (cPanel)

[mysqld]
key-buffer-size=512M
local-infile=0
symbolic-links=0
max-allowed-packet = 128M
wait-timeout=20
connect-timeout=10
max-connections = 500
max-user-connections=150
tmp-table-size = 64M
max-heap-table-size=64M
query_cache_limit=2M
query-cache-size=64M
query-cache-type=1
thread-cache-size=50
open-files-limit=4096
table-definition-cache=4096
table-open-cache=4096
sort-buffer-size=256K
read-buffer-size=2M
read-rnd-buffer-size=8M
myisam-sort-buffer-size=64M
innodb-flush-method=O_DIRECT
innodb-log-files-in-group=2
innodb-flush-log-at-trx-commit=1
innodb-file-per-table=1
innodb-buffer-pool-size=10G


max_allowed_packet=268435456
open_files_limit=10000
[mysqld_safe]
open-files-limit=8192

[mysqldump]
quick
max-allowed-packet=16M

[myisamchk]
key-buffer=384M
sort-buffer=384M