Gowtham Jayaram <[EMAIL PROTECTED]> wrote:
>
> - Are there any benchmarks that provide information
> on time taken to run 'CHECK TABLE' and/or 'REPAIR
> TABLE' on tables of different sizes ?
You can run your own benchmarks and find out the statistics you need.
>
> - What are the factors that effect the time taken to
> run 'CHECK TABLE' and/or 'REPAIR TABLE' on a table
> other than its size?
MySQL server parameters, number of indexes, hardware, disk throughput ..
>
> - Are there any pointers to optimize the performance
> of these commands ?
Read about myisam_sort_buffer_size, myisam_max_extra_sort_file_size,
myisam_repair_threads, myisam_max_sort_file_size options:
http://www.mysql.com/doc/en/SHOW_VARIABLES.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
