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.
Thread Tools Display Modes
Old 6th November 2009, 07:10
longvnit longvnit is offline
Junior Member
Join Date: Mar 2009
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Question Optimization MySQL for Server

My server have CPU dual core 1.6 Ghz and 1GB RAM
I installed only Centos 5.3 And MySQL 5, Apache & PHP latest version.
I run only 1 website which have ~ 2000 visitor / day.

When I start your server i used command: free -m , i saw your server used < 200 MB RAM , but after server uptime in 3 days , i saw your server used > 800 MB RAM

I think I have a problem with MySQL ,

This is my my.conf

PHP Code:
=32M ## 32MB for every 1GB of RAM
=64M ## 64MB for every 1GB of RAM
=1M ## 1MB for every 1GB of RAM
read_buffer_size=1M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=1M  ## 1MB for every 1GB of RAM
thread_concurrency=## Number of CPUs x 2






#top -c
PHP Code:
 1960 mysql     16   0  226m  37m 4344 S  0.0  2.5   0
:05.59 /usr/libexec/mysqld 
Please help me ! Thanks

Last edited by longvnit; 6th November 2009 at 07:13.
Reply With Quote
Sponsored Links
Old 6th November 2009, 09:44
Ben Ben is offline
Join Date: Jul 2006
Posts: 1,029
Thanks: 7
Thanked 62 Times in 56 Posts

Well in my opinion a really cool tool that helps you with optimizing mysql is the mysql tuning primter script: http://www.day32.com/MySQL/ (first entry on the page).
It indicates which switches have a non optimal value and why. But it gives you at least (if not trusting the suggested values) a hint at which config switches you should take a look at, and read what the mysql doc (dev.mysql.com) says.

Reply With Quote


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
Add ons for ISPConfig 3 virtue Installation/Configuration 24 16th October 2009 18:30
Problem installing MySQL on suse 10.3 Txchaser Installation/Configuration 20 18th April 2008 02:05
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 13:17
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04

All times are GMT +2. The time now is 05:52.

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