Page Comparison

...

      uPortal relies on database transactional support, which in MySQL is dependent upon the underlying storage engine (per-table).
     The default (MyISAM) is not transaction safe. The most common transactional table type on MySQL is InnoDB. Configure InnoDB as the default by adding the following line under the [mysqld] directive:

[mysqld]
default-storage-engine=innodb

...

      MySQL table names are case-sensitive depending on the filesystem of the server. (e.g. insensitive in Windows & Mac HFS+, while case sensitive in Unix.)
      The SQL used in uPortal may not always be in the same case so the following line of code must be added to the my.cnf file:

[mysqld]
lower_case_table_names=1

...

You can also set all of the memory, table, and connection limits as well as a host of other options.

# Example settings used for uPortal at Manchester
max_connections = 1500
table_cache = 512
query_cache_size = 128M
set-variable = innodb_buffer_pool_size=128M
set-variable = innodb_log_file_size=256M
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_log_buffer_size=4M
innodb_flush_log_at_trx_commit=1

...