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

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

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