In need of a little help...

MrTall

• September 08, 2013 18:04

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

• 

  MrTall

  • September 08, 2013 23:13

  For a little bit more detail, this is the MySQL tuner output: >> MySQLTuner 1.2.0 - Major Hayden >> Bug reports, feature requests, and downloads at

  0
• 

  cPanelMichael

  • September 09, 2013 15:12

  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
• 

  MrTall

  • September 09, 2013 18:36

  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.