Hi All, I am running MySQL 3.23.49 on Red Hat Linux 7.3 (installed from rpm included in RH distribution). I am using ext3 file system. In my my.cfg is "skip-locking".
The system is Intel i810, Intel Celeron 433 MHz, 64 MB RAM. It is used only as a database server which is accessable only from our web (apache, php). I would like to do some operation automatickly and periodicly (with a crond): - check all databases / tables - optimize all databases / tables According to documentation (http://www.mysql.com/doc/C/o/Command-line_options.html) I can't use myisamchk, as long as mysqld is running. I have try somethong like this: mysqld stop myisamchk -swr /path/to/datadir/*/*.MYI myisamchk -swm /path/to/datadir/*/*.MYI mysql start But I don't want to stop sql server every time. Could you help me how to solve this issue? Has somebody experience with MySQL on RedHat 7.3 with ext3? Thanks, Jan --------------------------------------------------------------------- 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
