In need of a little help...
Hello all, first of all I would like to acknowledge this isn't really anything to do with WHM or cPanel and it's regarding the my.conf file. Recently I tried making a backup of my sql database to find the download very slow and making a error on my site indicating too many sql connections.
My site is a phpbb forum and is on a dedicated server with the following spec:
Intel Xeon E3110, 3.0GHz Dual-Core
RAM: 8GB
HDD: 1 x 500GB SATA HDDs
Operating System: Linux - CentOS 6.0 (64bit)
(there's only one web site being hosted on the server which is a phpbb forum)
I downloaded the my.conf file to find it's contents very basic (2 lines basic):
[mysqld]
innodb_file_per_table=1
This leads me onto configuring the file and my knowledge in this area is next to none! I've had a look at example configurations and I understand the settings to add are really based on the servers capability.
I know this is a bit cheeky, but is there any out there that might be able to point me towards an idiot proof guide or assist with a configuration?
Also, do the edit have to be made through SSH or can I adjust via sftp and notepad++ and then restart mysql through WHM?
Really appreciate any help with this, I know there are a few similar threads of this subject around the forum looking for help but I'm hoping someone will take pitty on me! :)
Thanks for any help! :D
---Edit, please find added in a mystl tuner report:
>> MySQLTuner 1.2.0 - Major Hayden
>> Bug reports, feature requests, and downloads at -
Hello :) The following thread should also be useful in helping you to provide the users here with additional information about your MySQL statistics: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you. 0 -
Hello Thanks for the reply, I'll have a look at the other stats page to see if I can add more info here. Hoping to find someone here who is able to help as I'm keen on getting it right first time :) 0
Please sign in to leave a comment.
Comments
3 comments