Hi everyone I am using 3.23.39 and newer on Linux and do:
me> mysqladmin flush-tables me> myisamchk --keys-used=0 -rq /path/to/db/tbl_name before inserting lots of data (15 mio rows) with LOAD DATA INFILE and then re-create the indexes with me> myisamchk -r -q /path/to/db/tbl_name as suggested in the manual. This really speeds up inserts but has some disadvantages: - ordinary users can't use the script, because they have no privileges on the *.MYI file (or I have to add rw system privilege on the index file for 'others' :-(( ) - mysqld must be brought down for running myisamchk or I have to ensure that no one is using the tables while I'm running `myisamchk'. Now new hope is brought by mysqlcheck which is using the mysqld daemon. It should allow ordinary users to run it given they have appropriate mysql privileges and there is no need to shut the server down. BUT mysqlcheck lacks the --keys-used=0 option. WHY? Is there any workaround? I would be happy to stop key generation, do a fast LOAD DATA INFILE and then generate the keys as a normal user without taking the server down or making database directories and index files world writable. Any hints (even RTFM) would be appreciated. Thomas Spahni --------------------------------------------------------------------- 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
