RE: analyze table issue

Nevermind, it just finished... holy uggh! Steven Staples > -Original Message- > From: Steven Staples [mailto:sstap...@mnsi.net] > Sent: June 18, 2010 2:31 PM > To: mysql@lists.mysql.com > Subject: analyze table issue > > Ok, I know I am an idiot sometimes, and I

analyze table issue

Ok, I know I am an idiot sometimes, and I think this falls into that category. I use SQLYog as my MySQL front end editor. I was looking to do some things, and was going to run a check table command, and clicked the "analyze" button, and didn't realize that all the tables in the database were sel

analyze table

Hi All, We have proc which create around 7 table, inserts data , creates indexes and then run analyze table command. The analyze table command on 7 tables are taking around 18 hrs. They are myisam table. The db server has 8 cpu, 16gb RAM, with both innodb and myisam. Is there a way we can

Analyze Table

Howdy all, Quick question about Analyze table. I just deleted 3+ million records from a table that gets a lot of insert activity throughout the day. It seems like now would be a good time to run optimize table and/or analyze table. I saw in the docs that analyze table puts a read lock on the

Re: How to speed up ANALYZE TABLE?

Kevin A. Burton wrote: 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

How to speed up ANALYZE TABLE?

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

Re: Do Analyze Table before Optimize Table or the other way around??

"Scott Fletcher" <[EMAIL PROTECTED]> wrote: > I wanna know is do I do the Analyze the table before the Optimize the > table or should I do it the other way around??? If you need to defragment the table, you can just run OPTIMIZE TABLE. -- For technical support contracts, goto https://order

Do Analyze Table before Optimize Table or the other way around??

I wanna know is do I do the Analyze the table before the Optimize the table or should I do it the other way around??? Thanks, FletchSOD

Re: Can we remove the results of "Analyze Table"?

Hi! On Aug 29, Kevin Fries wrote: > Can we 'unanalyze' a table? I'd like to remove the statistical > information from my analyzed table, for testing purposes. yes, but it is not easy. You cannot mark the table as "unanalyzed" - so you need to rebuild it somehow. REPAIR TABLE table_name EXTENDED

Re: Can we remove the results of "Analyze Table"?

"Kevin Fries" <[EMAIL PROTECTED]> wrote: > > Can we 'unanalyze' a table? I'd like to remove the statistical > information from my analyzed table, for testing purposes. > You can't. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.

Can we remove the results of "Analyze Table"?

Can we 'unanalyze' a table? I'd like to remove the statistical information from my analyzed table, for testing purposes. Thanks Kevin

question about ANALYZE TABLE

i noticed this on the mysql website: I found that when EXPLAIN gives unexpected results (like using another index than the one you created especially for this goal), first running ANALYZE TABLE on the involved tables helped a lot. I put an ANALYZE TABLE for 10 or so "key" tab

OPTIMIZE TABLE / ANALYZE TABLE behaviour ?

Hi, I notice a strange behaviour with OPTIMIZE TABLE and ANALYZE TABLE (on MyISAM table) : Before analysing my table, mysql show me : mysql> show index from forumcontpresence