my.cnf Best configuration

seifhatem · Mar 16, 2014

Hello,
I have a dedicated server with

Code:

64 GB Ram
8 Threads processor (3.7 GHz)

I have a CMS website based on a MySQL DB:

Code:

650 MB
150 tables (MyISAM)
The most altered table is a table with 900,000 rows others are just for configuration or logging with max of 3000 rows

Can you please tell me the best configuration I can set for my.cnf for the best performance

Thanks in advance

cPanelMichael · Mar 17, 2014

Hello

Please see the following thread for help with providing information that will allow other users to offer feedback:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.

Thread starter	Similar threads	Forum	Replies	Date
	Best performance my.cnf and EA4 Config	Workarounds and Optimization	4	Sep 9, 2017
N	my.cnf best settings	Workarounds and Optimization	3	Jan 5, 2015
G	Best my.cnf for my servers!	Workarounds and Optimization	3	May 8, 2014
M	Best my.cnf configuration	Workarounds and Optimization	2	Jan 22, 2014
M	Best optimization for my.cnf	Workarounds and Optimization	5	Apr 12, 2012