I have a new managed dedicated server. 

 

Running the latest IPS4 

 

2 x 2.4GHz Hexa-Core E5-2620 v3 Haswell

64 GB DDR4

800 GB SSD

CentOS 6.7 x86_64

 

MySQL version 5.5.42-cll

PHP version 5.4.42.

 

 

My current my.cnf in the /etc dir

[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=10000
local-infile=0

 

 

 

Any suggestions on optimizing MySQL? Any help is much appreciated.

Edited August 18, 20159 yr by phuddle

How can we help you with only that information?

How can we help you with only that information?

Sorry, you can tell I am fairly ignorant of what you need to be able to give advice. 

Can you run mysqltuner and post here the result?