DataMajor and Memory

DataMajor uses an 'SQL' database (MySQL) behind the scenes. The default setting for this are very conservative to cater for all machines. However, most servers have more than enough memory to allow MySQL to perform much better. The more memory you allocate to MySQL the faster it runs.

How to Fine-Tune MySQL

There is a configuration file /etc/my.cnf, it is a text file and can be edited with any text editor.

It will resemble:

# MySQL Setup File
[client]
socket		= /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port		= 3306
socket		= /tmp/mysql.sock
skip-locking
set-variable	= key_buffer=16K
set-variable	= max_allowed_packet=1M
set-variable	= thread_stack=64K
set-variable	= table_cache=4
set-variable	= sort_buffer=64K
set-variable	= net_buffer_length=2K
server-id	= 1

# Uncomment the following if you want to log updates
#log-bin

By adjusting the setting you can optimise the performance of MySQL on your server. Keep in mind if you only have 64M of RAM in your server don't increase MySQL to 64 or higher - you have left no memory for other tasks!!.

Some of the settings you can use are:

If you make a change you need to tell mysql that there are some new settings, you can do:

• Re-boot (little bit of overkill)

• Signal the sql daemon
  • As root type ps -ef | grep sql
  • Look for the line with mysqld in it, make a note of the 2nd number (PID)
  • Type kill -9 PID

The entries in the above table as the 'common' options for performance, pick one that is close to your requirements, try it.

Veterinary Solutions Technical support: support@vetsolutions.co.uk

Telephone: 0131 556 0555 Fax: 0131 556 3525