My.cnf

RT Users
1

Anyone care to share their /etc/my.cnf files? I’m trying to figure
out a few settings on mine, like the size limit for a record.

						Thanks in advance,
						Jaime
2

Here’s mine:

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld_safe]
err-log = /var/log/mysql/mysql.err
socket = /var/run/mysqld/mysqld.sock

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306

log = /var/log/mysql/mysql.log
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-locking

skip-networking
key_buffer = 16M

Set max_allowed_packet to allow max. attachment size of 10MB

max_allowed_packet = 10M
thread_stack = 128K

query_cache_limit = 1048576
query_cache_size = 26214400
query_cache_type = 1

default-table-type=innodb

[mysqldump]
quick
max_allowed_packet = 1M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16MOn Thu, 10 Feb 2005, Jaime Kikpole wrote:

Anyone care to share their /etc/my.cnf files? I’m trying to figure
out a few settings on mine, like the size limit for a record.

  					Thanks in advance,
  					Jaime

The rt-users Archives

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact training@bestpractical.com
for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com