MySQL Forums
Forum List  »  General

Re: Optimize table statement
Posted by: abilash vs
Date: September 23, 2010 12:10AM

Hi Rick,

Thanks .I just managed to get a rough number ,there could be close to 4k to 5K record deletions each day.

I was doing a small POC on this wherein I was running OPTIMIZE weekly once(the results of which I shared to u before) and if at all I change the frequency to once in a month ,can there be any difference ? If there is no point in doing it ,then I can drop this idea totally.

I also request you to help me by giving some ideas on the below ,

1)Is there a specific percentage that needs to be calculated based on server memory while deciding the values for 'innodb_buffer_pool_size'and 'key_buffer_size'and 'innodb_additional_mem_pool_size.'

2)As my servers are up and running in production,can you suggest me some important mysql paramaters that need to be monitored from tuning/optimization perspective.

Thanks in advance!!

Cheers,
Abilash

Options: ReplyQuote


Subject
Written By
Posted
September 09, 2010 01:30AM
September 10, 2010 02:28PM
September 11, 2010 10:15AM
September 21, 2010 06:44AM
September 21, 2010 03:41PM
September 22, 2010 06:58AM
September 22, 2010 07:35PM
Re: Optimize table statement
September 23, 2010 12:10AM
September 23, 2010 08:48AM
October 08, 2010 01:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.