[Deploying Sakai] my.cnf advised settings

Wolfgang Rohregger Wolfgang.Rohregger at mci.edu
Tue Jul 26 05:08:11 PDT 2011


what about the buffer size? When dumping Sakai databases with database storage of uploaded files enabled, dumping the mysql tables will fail over TCP/IP connections when the buffer is set too small.

 max_allowed_packet      = 16M

+1 to the character set settings.

And for security reasons:

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            =



Von: production-bounces at collab.sakaiproject.org [production-bounces at collab.sakaiproject.org] im Auftrag von Jean-Francois Leveque [jean-francois.leveque at upmc.fr]
Gesendet: Dienstag, 26. Juli 2011 12:36
An: sakai-dev Developers; production at collab.sakaiproject.org
Betreff: [Deploying Sakai] my.cnf advised settings

Hi all,

under 5.2 Create a my.cnf/my.ini configuration file, there is "a
minimalist MySQL 5.1 configuration file for a development laptop
/etc/my.cnf" that only has:
> [mysqld]
> default-storage-engine=InnoDB
> lower_case_table_names=1

Is there another mention of /etc/my.cnf elsewhere in the 2.8 documentation ?

I think it would be worth adding:
> character_set_client=utf8
> character_set_server=utf8

What do you think ?


production mailing list
production at collab.sakaiproject.org

TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

More information about the production mailing list