External database set up notes

When using onCourse with MySql, Oracle or MSSQL Server some particular tuning is advised.

MySQL

ish recommend the following attributes to be entered into your MySQL my.cnf



default-storage-engine          = innodb


	
#Increase the below two if lots of temp tables are been written to disk.

tmp_table_size          = 512M

max_heap_table_size     = 512M


	
#allows attachments larger than 1meg (default)

max_allowed_packet=5M

Oracle

No specific notes at this time.

Microsoft SQL Server

No specific notes at this time.