Quote:
Originally Posted by eyanu
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