How to optimize apache and mysql on my dedicated server?


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users How to optimize apache and mysql on my dedicated server?
# 1  
Old 03-17-2011
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.

Code:
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

Last edited by pludi; 03-17-2011 at 10:36 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Add new smtp to my dedicated server

Hi there, I have a dedicated server that sends mail with own smtp (obviously). On this server I have a web platform for music artists that allows entries for each enrollment and sends confirmation e-mails and so on ... Now I have purchased a service smtp (like those of smtp.com) because I... (3 Replies)
Discussion started by: colorsthink
3 Replies

2. Ubuntu

Vmware Citrix Xenn virtualization on dedicated server

hi, I am newbie and I think I am trying to bit off more than I could chew in this field. I would like to know if virtualization with Vmware Citrix on a dedicated server under ubuntu 64bit is simple. I looked up in the board with keyword "virtualization, vmware, dedicated" but replied threads are... (2 Replies)
Discussion started by: baris35
2 Replies

3. UNIX and Linux Applications

MySQL - optimize using other storage volume

So, I need to optimize a very large MySQL table. This process creates a TMD that seems to approach the size of the original MYD. The problem is that we don't have that much space left on the volume that the MySQL files are on. Is there a way to get the system to use another storage volume on a... (1 Reply)
Discussion started by: treesloth
1 Replies

4. Emergency UNIX and Linux Support

New centos dedicated server - cant get mysql working

Hi all, I installed centos 5, with LAMP. httpd is working fine, ssh, ftp all working ok. But, when I try to use mysql its not, when I give the command mysql I get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (4 Replies)
Discussion started by: lawstudent
4 Replies

5. Linux

ipcheck problem in my dedicated server

Dear Friends, We have a 4 dedicated servers. All are working but the thing is one server is not working. when i go to network tools and after i enter my host domain i cant able to ping. it is showing host not found. But remaining servers are working. I terminate my account and re-again create... (4 Replies)
Discussion started by: mastansaheb
4 Replies

6. Emergency UNIX and Linux Support

Dedicated Server - Linux Mirror

Hi guys. I am gonna buy a dedicated server and make it a public mirror for some distributions. but how much RAM, Hard Disk, Band Width, ... will suffice? It will be a mirror for CentOS and Ubuntu both. (3 Replies)
Discussion started by: majid.merkava
3 Replies

7. IP Networking

Dedicated Server Move

I just moved a dedicated server, which included moving to a new subnet, and new IP address. Now my server is not reconnecting - I've tried ifconfig, altering the etc/hosts file with the new ip address, with no luck. (5 Replies)
Discussion started by: esmerika
5 Replies
Login or Register to Ask a Question

Featured Tech Videos