Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 28th April 2012, 22:42
fatbear fatbear is offline
Join Date: Jul 2010
Location: Raleigh, NC US
Posts: 42
Thanks: 4
Thanked 9 Times in 4 Posts
Default MySQL - The Perfect Server - MySQL

Hi all,

I'm new to the developer group and I'm starting to install ISPConfig this weekend. One of the first things I want is to ensure that the MySQL is tuned appropriately. Please find attached the my.cnf file (inside my.zip) that I've used for some time. Note that I specify innodb as the default storage engine.

I'm looking for a critical analysis of this my.cnf file. What would you change to make this appropriate for a "The Perfect Server - MySQL" article that I'm considering to write?

I hope you enjoy looking at the my.cnf file!
Attached Files
File Type: zip my.zip (1.4 KB, 65 views)
Steve Amerige, Fat Bear Incorporated
Server Leasing | Web Software Development | User Experience & Graphic Design
Managed Services, Website, Java, and Source-Code Hosting
Did my post help you? Click the Thanks button!

Last edited by fatbear; 28th April 2012 at 23:51.
Reply With Quote
Sponsored Links
Old 30th April 2012, 10:40
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts

The optimal mysql settings depend on the hardware of the server and the actual load. It can e.g. be better to disable innodb instead of making it the default if your server has very low ram like 1GB in a vserver as the setup has mostly reads in the db and transactions are not used. To write a perfect mysql setup guide, it might be good to define server classes like 2, 4, 8 and 16GB RAM and make individual settings for them.

My recommendation is to use mysqltuner to find the optimal settings for a specific system:

Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending email issue lezelf Installation/Configuration 15 9th August 2011 12:20
Not working emails (DNS and postfix problem?) shekiman Installation/Configuration 9 1st March 2011 17:25
Virtual Users+Postfix+Courier+CentOS problem telnet localhost 25 stinson HOWTO-Related Questions 11 5th February 2011 14:57
Problem with keeping Apache alive bobeq Server Operation 3 29th November 2007 17:11
Problems with Postfix Mysql Courier PatrickAdrichem Installation/Configuration 3 13th April 2007 16:44

All times are GMT +2. The time now is 03:03.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.