Hello,
We are using mySQL on over 6 servers here, we have been doing so for over 2 years, and
we are constaly facing problems with corrupted tables, especially on two of our
busiest servers.
Tables seem to corrupt out of the blue and we have to shut them down ( the servers )
occassionaly to fix all tables and then bring them up again.
This is really not something we want to do, bringing down a server that is, so we were
wondering if we are doing something wrong. There must be other users of mySQL using it
for far most difficult tasks who maybe faced the same problems once but managed to
solve them.
We are using mySQL 3.23.41. Tables corruptions occur regardless the server's
configuration ( even on a system with PIII@1MhzX2 with 1.5G RAM we get those problems
) so maybe there is something wrong with the startup options we are using for mySQLd.
This is how we start mySQLd.
--skip-locking -O back_log=1024 -O table_cache=280 -O max_connections=2048 -O
wait_timeout=30 -O interactive_timeout=30 -O long_query_time=2
--log-slow-queries=slow.log --big-tables
Please reply to [EMAIL PROTECTED] Thank you in advance,
Mark Papadakis
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
