MySQL Forums :: Performance :: Basic Standards of Mysql server variable setting


Advanced Search

Basic Standards of Mysql server variable setting
Posted by: Zafar Malik ()
Date: May 07, 2012 10:02AM

Dear Rick James/any one,

Is there any basic standards to set server variables.

For example-
Using Mysql5.5 version on 64 bit linux server
Disk space is 500 GB (can assume avg. data size will be 350 GB)
RAM is 24 GB
select queries - 80 to 90%
Insert queries - approx 5 to 6%
Update queries - approx 4 to 5%
max users can be - 1000

Please help me how I can allocate memory in different important server variables so that can get maximum performance and can avoid slowness in production.

Thanks,
Zafar

Options: ReplyQuote


Subject Views Written By Posted
Basic Standards of Mysql server variable setting 1763 Zafar Malik 05/07/2012 10:02AM
Re: Basic Standards of Mysql server variable setting 827 Rick James 05/08/2012 08:44AM
Re: Basic Standards of Mysql server variable setting 717 Zafar Malik 05/21/2012 11:42AM
Re: Basic Standards of Mysql server variable setting 584 Zafar Malik 05/21/2012 11:48AM
Re: Basic Standards of Mysql server variable setting 1000 Rick James 05/22/2012 09:18AM


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.