LinuxQuestions.org
Help answer threads with 0 replies.
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 11-15-2012, 10:51 PM   #1
ravindert
Member
 
Registered: Oct 2011
Posts: 68

Rep: Reputation: Disabled
Minimum Hardware requirement for MYSQL DB


Hi,

Currently i have installed the rsyslog configured with the mysql database on Centos and below is the configuration detail of the server .

But after mysql reach the 4 GB in size the loganalyzer (web utility to check the log) behaving very slow and performance of the server suddenly slow down.
So can you please let me know the what is the minimum requirement (RAM) to run the 100GB mysql database .


[root@adc3sv04 ~]# cat /proc/cpuinfo |grep processor|wc -l
4
[root@adc3sv04 ~]# free -m
total used free shared buffers cached
Mem: 3949 3915 33 0 427 1415
-/+ buffers/cache: 2072 1876
Swap: 7993 0 7993
[root@adc3sv04 ~]#

Thanks
Ravinder
 
Old 11-17-2012, 04:01 AM   #2
eyanu
Member
 
Registered: Jul 2012
Location: kampala,Uganda
Distribution: backtrack
Posts: 87

Rep: Reputation: Disabled
The need in RAM depends on the database schema, quantity of data, number of connection, etc. With your mysql running low, you should start by optimizing it, post your my.cnf here.
 
Old 11-18-2012, 07:02 PM   #3
ravindert
Member
 
Registered: Oct 2011
Posts: 68

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by eyanu View Post
The need in RAM depends on the database schema, quantity of data, number of connection, etc. With your mysql running low, you should start by optimizing it, post your my.cnf here.


Hi Eyanu,

Thanks for the reply.

Currently there are hundreds of thousands of logs are coming to the mysql database of the network firewalls and database is increasing with the rate of 3 GB per day . So can you please suggest accordingly what should be the size of the RAM of the ram and configuration of the my.cnf which can help in increase of the performance of the database.

Below is the current configuration of the my.cnf.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid



Thanks

Last edited by ravindert; 11-18-2012 at 07:40 PM.
 
Old 11-19-2012, 12:40 AM   #4
eyanu
Member
 
Registered: Jul 2012
Location: kampala,Uganda
Distribution: backtrack
Posts: 87

Rep: Reputation: Disabled
Please start by googling on how to optimize mysql, and also install mytop and post here it's results
 
  


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
what is the minimum hardware requirement to port linux kernel to an embedded systems vivignesh Linux - Embedded & Single-board computer 1 09-28-2010 02:57 AM
what is minimum memory requirement for fedora 12? oob4uleap Linux - Newbie 7 11-24-2009 02:42 PM
Minimum memory requirement ? m.parthiban Fedora 6 03-26-2006 09:23 AM
Minimum Hardware Requirement for Fedora 4 manas484 Linux - Hardware 1 01-06-2006 05:21 AM
RH8 Minimum requirement c0c0deuz Linux - Distributions 2 11-04-2002 09:10 PM


All times are GMT -5. The time now is 06:48 AM.

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