LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-17-2012, 12:52 PM   #1
programer
Member
 
Registered: Mar 2012
Location: India
Distribution: Linux mint 14, Ubuntu 12.10
Posts: 46

Rep: Reputation: Disabled
My SQL and Apache optimisation


I would like to optimise Apache and MySQL but when i am trying to do the requirement is to open hte .cnf file in an editor, can i use VI editor for the same, is there any source that explains about how to use a vi editor? Is there any other editor which is simple rather than using vi editor? or its the only method to edit any .cnf file?

Also I came to know that there are standard template for the .cnf files of Apache and MySQL and if that is added to the original .cnf file it will be optimised, can anyone direct me to that particular link if any?

Last edited by programer; 03-17-2012 at 01:03 PM.
 
Old 03-17-2012, 07:06 PM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,921

Rep: Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690
Quote:
Originally Posted by programer View Post
I would like to optimise Apache and MySQL but when i am trying to do the requirement is to open hte .cnf file in an editor, can i use VI editor for the same, is there any source that explains about how to use a vi editor? Is there any other editor which is simple rather than using vi editor? or its the only method to edit any .cnf file?
ANY editor can be used to edit a file. If you need help using VI, try Google. There are lots of guides, and vi even has built-in help.
Quote:
Also I came to know that there are standard template for the .cnf files of Apache and MySQL and if that is added to the original .cnf file it will be optimised, can anyone direct me to that particular link if any?
No, since there is no way to know what you mean by optimized. Each installation/configuration is different, and it's up to the administrator to know how to analyze the installation, and tune it. Optimizing a 1GB database with 100,000 records, and one web server is far different than a 1TB database with 20,000,000 records, hooked to a web-server farm behind it, serving 10,000 users a day.
 
Old 03-18-2012, 12:55 PM   #3
programer
Member
 
Registered: Mar 2012
Location: India
Distribution: Linux mint 14, Ubuntu 12.10
Posts: 46

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by TB0ne View Post
ANY editor can be used to edit a file. If you need help using VI, try Google. There are lots of guides, and vi even has built-in help.

No, since there is no way to know what you mean by optimized. Each installation/configuration is different, and it's up to the administrator to know how to analyze the installation, and tune it. Optimizing a 1GB database with 100,000 records, and one web server is far different than a 1TB database with 20,000,000 records, hooked to a web-server farm behind it, serving 10,000 users a day.
My sites will never have more than 3000 visitors a day and it may be wordpress of Joomla based site,for this should i require optimisation?
 
Old 03-18-2012, 05:04 PM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,921

Rep: Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690Reputation: 3690
Quote:
Originally Posted by programer View Post
My sites will never have more than 3000 visitors a day and it may be wordpress of Joomla based site,for this should i require optimisation?
No idea. Again, we don't have the necessary information to tell you anything. A handy tip is: if the site is running slow, you need to tune/optimize it. Otherwise, why waste time?

Gather meaningful statistics, get user feedback, and watch how things go. If you're having slow page loads, the database isn't refreshing quickly enough, or WHATEVER your site does it does slowly, then you'll have a baseline to compare it to. Figure out the problem from there, and resolve it.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
I'm about done with Red Hat...Apache, SQL, Xinetd Galaxy_Stranger Red Hat 3 11-21-2006 04:37 PM
pre configured linux install with apache, sql, and php? mydssbin Linux - Newbie 1 01-20-2006 08:02 PM
My SQL + APACHE on Seprate servers westlm01 Programming 2 12-19-2005 12:48 PM
Do I need to recompile Apache sqL computerdaves Fedora 11 02-07-2005 02:41 AM


All times are GMT -5. The time now is 07:34 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration