Changeset 34

Timestamp:

02/21/06 23:28:19 (7 years ago)

Author:

anarcat

Message:

[project @ alternc: changeset 2003-04-04 05:27:12 by root]
optimisations de mysql pour la dimension d'un serveur (on a au moins
128Mo de RAM ;) )

Original author: root
Date: 2003-04-04 05:27:12

File:

• install/scripts/etc/mysql/my.cnf (modified) (2 diffs)

install/scripts/etc/mysql/my.cnf

@@ -1 +1 @@
 #
 # Fichier de configuration de mysql pour AlternC
-# $Id: my.cnf,v 1.1 2003/04/03 18:45:16 jonathan Exp $
+# $Id: my.cnf,v 1.2 2003/04/04 05:27:12 root Exp $
 
 [client]
-#password       = poipoi
 port            = 3306
 socket          = /var/run/mysqld/mysqld.sock
 
 # Here is entries for some specific programs
-# The following values assume you have at least 32M ram
+# The following values assume you have at least 128M ram
 
 [safe_mysqld]
@@ -28 +27 @@
 #  skip-networking
 skip-innodb
-set-variable    = key_buffer=16M
-set-variable    = max_allowed_packet=1M
-set-variable    = thread_stack=128K
+set-variable    = key_buffer=32M
+set-variable    = max_allowed_packet=4M
+set-variable    = thread_stack=512K
 
 [mysqldump]
 quick
-set-variable    = max_allowed_packet=1M
+set-variable    = max_allowed_packet=4M
 
 [mysql]
-#no-auto-rehash # faster start of mysql but no tab completition
+no-auto-rehash  # faster start of mysql but no tab completition
 
 [isamchk]
-set-variable    = key_buffer=16M
+set-variable    = key_buffer=32M