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.
Reply
 
Thread Tools Display Modes
  #1  
Old 28th April 2012, 21:42
fatbear fatbear is offline
Member
 
Join Date: Jul 2010
Location: Raleigh, NC US
Posts: 41
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, 62 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 22:51.
Reply With Quote
Sponsored Links
  #2  
Old 30th April 2012, 09:40
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,413
Thanks: 834
Thanked 5,498 Times in 4,328 Posts
 
Default

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:

http://www.faqforge.com/linux/optimi...th-mysqltuner/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

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 11:20
Not working emails (DNS and postfix problem?) shekiman Installation/Configuration 9 1st March 2011 16:25
Virtual Users+Postfix+Courier+CentOS problem telnet localhost 25 stinson HOWTO-Related Questions 11 5th February 2011 13:57
Problem with keeping Apache alive bobeq Server Operation 3 29th November 2007 16:11
Problems with Postfix Mysql Courier PatrickAdrichem Installation/Configuration 3 13th April 2007 15:44


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


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