LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 03-17-2011, 08:06 AM   #1
chandranjoy
LQ Newbie
 
Registered: Jun 2010
Posts: 8

Rep: Reputation: 0
How to optimize apache and mysql on my dedicated server?


Hi,
Any one please suggest me the best mysql apache settings for the given below scenario.

My Server config:
Intel(R) Xeon(R) CPU E5504 @ 2.00GHz
8GB RAM
300GB HDD

Website:
It's a famous wordpress blog
Mysql DB size: 235MB

Expectations:
Server should be handle 600+ concurrent connections.

OS: Ubuntu 10.04.2 LTS
Arc: 64Bit
Mysql Version: 5.1.41
Apache version: Apache/2.2.14

Now I have optimized the apache and mysql(using with mysqltuner,mysqlreport) but mysql always using more cpu.

top - 12:50:47 up 33 days, 23:26, 1 user, load average: 4.48, 3.79, 2.97
Tasks: 281 total, 2 running, 279 sleeping, 0 stopped, 0 zombie
Cpu(s): 6.2%us, 1.4%sy, 0.0%ni, 91.4%id, 0.9%wa, 0.0%hi, 0.1%si, 0.0%st
Mem: 8181836k total, 7335392k used, 846444k free, 22908k buffers
Swap: 11595768k total, 636300k used, 10959468k free, 1060196k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
14276 mysql 20 0 1727m 283m 3192 S 340 3.5 842:12.36 /usr/sbin/mysqld --pid-file=/var/run/mysqld/mysqld.pid

Thanks,
Jay
 
  


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
Dedicated Server mysql issues NewtonIX Slackware 1 03-13-2007 05:10 PM
Parsing PHP Scripts using Apache in SuSe 9.3 (without a dedicated server) elliotfuller SUSE / openSUSE 7 07-27-2005 12:40 PM
how do i Know Apache PHP MYSQL Installed on my Dedicated Server? phpsharma Linux - Newbie 3 04-18-2005 06:40 PM
Trying to start mysql on freebsd 4.8 dedicated server NoS Sr50 *BSD 1 12-08-2004 12:46 AM
optimize every mysql database at once? JustinHoMi Programming 0 02-07-2002 01:05 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 05:25 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
Open Source Consulting | Domain Registration