Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 1st February 2012, 01:44
midcarolina midcarolina is offline
Senior Member
 
Join Date: Jul 2011
Posts: 254
Thanks: 1
Thanked 5 Times in 5 Posts
 
Default Best setting for MySql Server

Hi,

I have been having heavy loads on my server. The data transfer rates are high and I had them tested today, and there were definitely peak times, but I have come to determine that (based on several variables) that MySql Server is causing the heavy load. Question:

What are the best settings for mysqld (/etc/my.cnf/) and in php? I have tried low numbers for max_connections and high ones, but I am sure there is a php and memory balance too. Any good ideas?

Thanks in advance.
Reply With Quote
Sponsored Links
Reply

Bookmarks

Tags
load balancing

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
ISPConfig 3.0.3.3 fresh instalation - email tab is empty artur_gib Installation/Configuration 14 28th January 2014 19:02
User unknown in relay recipient table Taxick Installation/Configuration 12 9th April 2013 12:31
php Apps email not going through palkat General 8 21st September 2011 05:35
problem with upgrade to 2.2.34 brianetilley Installation/Configuration 14 11th November 2009 17:22
Problem with keeping Apache alive bobeq Server Operation 3 29th November 2007 16:11


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


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