RE: MySQL 3.23.39 released
hi! Steven == Steven Roussey [EMAIL PROTECTED] writes: Steven Now I have a question: Does this also apply to automatic repair inside Steven mysqld? I'd finally use the feature if its true... If you just run CHECK TABLE, it will repair the open count (it should always have done that). myisamchk --fast --force is equal to: run CHECK TABLE on all tables Run REPAIR TABLE on tables which was not marked as ok. Steven I was refering to --myisam-recover=FORCE Steven As I remember, it would repair tables that had a open count 0 (at least Steven back when I first tried using it). I checked this and at least now it only repairs the table if a check table finds something wrong. Regards, Monty - 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
RE: MySQL 3.23.39 released
Steven Now I have a question: Does this also apply to automatic repair inside Steven mysqld? I'd finally use the feature if its true... If you just run CHECK TABLE, it will repair the open count (it should always have done that). myisamchk --fast --force is equal to: run CHECK TABLE on all tables Run REPAIR TABLE on tables which was not marked as ok. I was refering to --myisam-recover=FORCE As I remember, it would repair tables that had a open count 0 (at least back when I first tried using it). Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - 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
Re: MySQL 3.23.39 released
Hi! Steven == Steven Roussey [EMAIL PROTECTED] writes: Steven Changes in release 3.23.39 Steven -- Steven* Fixed problem with shutdown when `INSERT DELAYED' was waiting for Steven a `LOCK TABLE'. Steven* Running `myisamchk --fast --force' will no longer repair tables Steven that only had the open count wrong. Steven -- Steven THANK YOU! You don't know what it was for the first item to require a forced Steven shutdown that made myisamchk take a huge amount of time. Although we have Steven not had the need for a `myisamchk --fast --force' in a while, I tell you if Steven you had a big fulltext index, you would avoid it like the plague. Steven Now I have a question: Does this also apply to automatic repair inside Steven mysqld? I'd finally use the feature if its true... If you just run CHECK TABLE, it will repair the open count (it should always have done that). myisamchk --fast --force is equal to: run CHECK TABLE on all tables Run REPAIR TABLE on tables which was not marked as ok. Regards, Monty - 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
Re: MySQL 3.23.39 released
Changes in release 3.23.39 -- * Fixed problem with shutdown when `INSERT DELAYED' was waiting for a `LOCK TABLE'. * Running `myisamchk --fast --force' will no longer repair tables that only had the open count wrong. -- THANK YOU! You don't know what it was for the first item to require a forced shutdown that made myisamchk take a huge amount of time. Although we have not had the need for a `myisamchk --fast --force' in a while, I tell you if you had a big fulltext index, you would avoid it like the plague. Now I have a question: Does this also apply to automatic repair inside mysqld? I'd finally use the feature if its true... Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - 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
MySQL 3.23.39 released
Hi! This release fixes a couple of bugs in InnoDB tables and a couple of other minor bugs. If you are not using InnoDB tables, you probably don't need to upgrade. Changes in release 3.23.39 -- * If one dropped and added an `AUTO_INCREMENT' column, the `AUTO_INCREMENT' sequence wasn't reset. * `CREATE .. SELECT' now creates not unique indexes delayed. * Fixed problem where `LOCK TABLES table_name READ' followed by `FLUSH TABLES' put a exclusive lock on the table. * `REAL' @variables with was represented with 2 digits when converted to strings. * Fixed problem that client 'hung' when `LOAD TABLE FROM MASTER' failed. * Running `myisamchk --fast --force' will no longer repair tables that only had the open count wrong. * Added functions to handle symbolic links to make life easier in 4.0. * We are now using the `-lcma' thread library on HP-UX 10.20 to get *MySQL* more stable on HP-UX. * Fixed problem with `IF()' and number of decimals in the result. * Fixed date-part extraction functions to work with dates where day and/or month is 0. * Extended argument length in option files from 256 to 512 chars. * Fixed problem with shutdown when `INSERT DELAYED' was waiting for a `LOCK TABLE'. * Fixed coredump bug in InnoDB when tablespace was full. * Fixed problem with `MERGE' tables and big tables ( 4G) when using `ORDER BY' Regards, Monty - 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