How to speed up ANALYZE TABLE? - Kevin A. Burton - com.mysql.lists.mysql

2 messages in com.mysql.lists.mysqlHow to speed up ANALYZE TABLE?

From	Sent On	Attachments
Kevin A. Burton	26 Dec 2004 22:17
Sasha Pachev	30 Dec 2004 15:15

Subject:	How to speed up ANALYZE TABLE?
From:	Kevin A. Burton (bur...@newsmonster.org)
Date:	12/26/2004 10:17:57 PM
List:	com.mysql.lists.mysql

The ANALYZE TABLE entry in the manual doesn't say anything about performance optimization.

How do I get optimum performance out of ANALYZE TABLE?

Can I just set the same variables as I would with REPAIR TABLE?

key_buffer_size sort_buffer_size myisam_sort_buffer_size

Also... Does A.T. always need to read ALL rows from the table? I assume so.

Also... why does it require *any* type of lock? For large tables the chance
that data would be modified during the ANALYZE to cause the results to be wildly
innacurate are rare. It seems possible to just let ANALYZE run without any
locks and just let the data be off by a few K rows.

Which seems MUCH better than NEVER running them.

Kevin

Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an invite! Also see irc.freenode.net #rojo if you want to chat.

Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html

If you're interested in RSS, Weblogs, Social Networking, etc... then you should work for Rojo! If you recommend someone and we hire them you'll get a free iPod!