From: Date: February 26 2008 2:58am
Subject: Setting Variables
List-Archive: http://lists.mysql.com/mysql/211503
Message-Id: <006501c8781b$237c06c0$0315a8c0@endie>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

Dear all..

Does anyone know how to set variables in MySQL
ideal for the performance so the machine can run maximum
which variable i should be notice?
what is the value of each variable?
how can i calculate to get the value? is there the formula?

for example:
max_allowed_packet =?
max_binlog_size=?
read_buffer_size=?
etc.

mysql version : v 5.1.22 InnoDB
RAM 1GB
OS : FreeBSD

Thx before