How should my.cnf (For Me) ?

[emresycn]

Processor:	Intel Xeon E3 1225v2
Cores/Threads:	4 cores/ 4 threads
Frequency:	3.2 GHz+
RAM:	16GB DDR3
Disks:	2 x 2 TB SATA
RAID: 	Soft
Network card:	1 Gbps
Bandwidth:	250 Mbps

I have a server in the properties. There is only one site on a server. What should be the best settings for my.cnf. I'm sorry for my bad english. I will be glad if you help me. Good Days.

 

[Harry Tang]

see this: https://help.directadmin.com/item.php?id=44

 

[emresycn]

see this: https://help.directadmin.com/item.php?id=44

Mysql versiyon 5.5.31

Should I use it?

cp -f /usr/share/mysql/my-large.cnf /etc/my.cnf

or

CP /etc/my.cnf /etc/my.cnf.old 
wget -O /etc/my.cnf http://files.directadmin.com/services/all/mysql/my-huge-5.5.cnf

^.^

 

[zEitEr]

Hello,

It's a very bad idea to ask a config for MySQL on forums. You'd better use the default one, as no one here knows anything about your details. Amount of RAM and number of CPU do not give any idea on tables number and their engine, type of load you have there, and what operations are most common: read or write, how good your indexes are, and etc...

 

[Tommyhara]

see this: https://help.directadmin.com/item.php?id=44

This is a common method if you don't know how to have best settings for your MySQL on your hosting server (VPS, dedicated servers)

Processor:	Intel Xeon E3 1225v2
Cores/Threads:	4 cores/ 4 threads
Frequency:	3.2 GHz+
RAM:	16GB DDR3
Disks:	2 x 2 TB SATA
RAID: 	Soft
Network card:	1 Gbps
Bandwidth:	250 Mbps

I have a server in the properties. There is only one site on a server. What should be the best settings for my.cnf. I'm sorry for my bad english. I will be glad if you help me. Good Days.

I would recommend you install mysqltuner to find out best my.cnf settings for your hosting.

Read these guides
http://forumweb.hosting/13508-optimize-mysql-on-vps-with-mysqltuner.html
http://forumweb.hosting/13757-mysql-my-cnf-recommended-settings.html

Hope it helps!