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