Sponsored Content
Top Forums UNIX for Advanced & Expert Users How to optimize apache and mysql on my dedicated server? Post 302505552 by chandranjoy on Thursday 17th of March 2011 08:08:54 AM
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 09:36 AM..
 

7 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

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. 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

6. 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

7. 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
MYSQL_INSTALL_DB()														MYSQL_INSTALL_DB()

NAME
mysql_install_db - initialize MySQL data directory SYNOPSIS
mysql_install_db [options] DESCRIPTION
mysql_install_db initializes the MySQL data directory and creates the system tables that it contains, if they do not exist. mysql_install_db is a shell script and is available only on Unix platforms. (As of MySQL 5.6, mysql_install_db is a Perl script and can be used on any system with Perl installed.) To invoke mysql_install_db, use the following syntax: shell> mysql_install_db [options] Because the MySQL server, mysqld, needs to access the data directory when it runs later, you should either run mysql_install_db from the same system account that will be used for running mysqld or run it as root and use the --user option to indicate the user name that mysqld will run as. It might be necessary to specify other options such as --basedir or --datadir if mysql_install_db does not use the correct locations for the installation directory or data directory. For example: shell> scripts/mysql_install_db --user=mysql --basedir=/opt/mysql/mysql --datadir=/opt/mysql/mysql/data mysql_install_db needs to invoke mysqld with the --bootstrap and --skip-grant-tables options. Note If you have set a custom TMPDIR environment variable when performing the installation, and the specified directory is not accessible, mysql_install_db may fail. If so, unset TMPDIR or set TMPDIR to point to the system temporary directory (usually /tmp). mysql_install_db supports the following options, which can be specified on the command line or in the [mysql_install_db] group of an option file. (Options that are common to mysqld can also be specified in the [mysqld] group.) Other options are passed to mysqld. For information about option files, see Section 4.2.3.3, "Using Option Files". mysql_install_db also supports the options for processing option files described at Section 4.2.3.4, "Command-Line Options that Affect Option-File Handling". o --basedir=path The path to the MySQL installation directory. o --datadir=path, --ldata=path The path to the MySQL data directory. o --force Cause mysql_install_db to run even if DNS does not work. Grant table entries that normally use host names will use IP addresses. o --rpm For internal use. This option is used during the MySQL installation process for install operations performed using RPM packages. o --skip-name-resolve Use IP addresses rather than host names when creating grant table entries. This option can be useful if your DNS does not work. o --srcdir=path For internal use. This option specifies the directory under which mysql_install_db looks for support files such as the error message file and the file for populating the help tables. o --user=user_name The system (login) user name to use for running mysqld. Files and directories created by mysqld will be owned by this user. You must be root to use this option. By default, mysqld runs using your current login name and files and directories that it creates will be owned by you. o --verbose Verbose mode. Print more information about what the program does. o --windows For internal use. This option is used for creating Windows distributions. COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved. This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/. SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/. AUTHOR
Oracle Corporation (http://dev.mysql.com/). MYSQL_INSTALL_DB()
All times are GMT -4. The time now is 08:27 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy