MySQL Forums
Forum List  »  MyISAM

Re: Indexes disabled by default?
Posted by: Peter Wood
Date: January 30, 2006 08:44AM

> Do you start your server with special options?

We don't have any special options passed to the server on execution.

> Do you have entries in .my.cnf?

We do have a my.cnf; also, we are using master-slave replication, and we see this problem with indexes on both the master and the slave.

Here are the contents of the my.cnf file:


~~~~~~~~~~~~~~


[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
thread_concurrency = 4
thread_stack = 2M

datadir=/mysql/data

log-bin=/mysql/bin-log/mysql-bin

max_binlog_size=200M

server-id = 1


[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Options: ReplyQuote


Subject
Views
Written By
Posted
4802
January 27, 2006 10:18AM
2447
January 30, 2006 04:02AM
Re: Indexes disabled by default?
2456
January 30, 2006 08:44AM
2523
January 31, 2006 03:47AM
2885
January 31, 2006 02:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.