[mysqld] # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 # FIXME! bdb maybe work on x86/Linux and amd64/Linux #skip-bdb #bind-address = 127.0.0.1 chroot=/var/lib/mysql datadir=/db bdb-logdir=/log #log=/log/queries pid-file=/mysqld.pid skip-locking skip-networking socket=/mysql.sock tmpdir=/tmp user=mysql ## http://paragasu.wordpress.com/2008/12/02/very-low-memory-mysql-5-mycnf-configuration/ # Set internal buffers, caches and stacks very low key_buffer = 16K max_allowed_packet = 800K table_cache = 1 sort_buffer_size = 16K read_buffer_size = 16K read_rnd_buffer_size = 1K net_buffer_length = 1K thread_stack = 16K # Skip Berkley and Inno DB types skip-bdb skip-innodb skip-networking server-id = 1 # Set the query cache low query_cache_limit = 1048576 query_cache_size = 1048576 query_cache_type = 1 # Set various memory limits very low, disable memory-hogging extras [mysqldump] quick max_allowed_packet = 16K [mysql] no-auto-rehash [isamchk] key_buffer = 16K sort_buffer_size = 16K [myisamchk] key_buffer = 16K sort_buffer_size = 16K [mysqlhotcopy] interactive-timeout