Re: [URGENT] Mysql crash every 2-3days

[BENJAMIN LINIER]

Hello,

Yes, all crashed tables are MyISAM.(How did you see that ? ;) )


Do you recommand to convert tables to InnoDB using ALTAIR TABLE method ?
(It's a very solicited database.)

Peter Brawley Wrote:
-------------------------------------------------------
> To switch to InnoDB, you'd need to reconfigure
> my.ini.

What are the specific changes in my.cnf for InnoDB ? This is my current configuration: (For a 8GB server)


[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /cluster/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
log-error=/log/mysql-err.log

#
#Fine Tuning
#
key_buffer = 384M
max_allowed_packet = 384M
thread_stack = 384K
thread_cache_size = 384
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
interactive_timeout=60
wait_timeout=60

#
#Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M


[mysqldump]
quick
quote-names
max_allowed_packet = 16M


[isamchk]
key_buffer = 16M




Thanks for your help