MySQL Forums
Forum List  »  Optimizer & Parser

Re: my.cnf optimization please help
Posted by: Rick James
Date: October 29, 2013 07:10PM

Will you be using InnoDB?

SHOW VARIABLES;
SHOW GLOBAL STATUS;

What queries are running "slow"?

(my.cnf is only a small piece of the puzzle.)

Do you do theupdate / insert / delete one at a time? Or in batches? (Batches of 100 tends to be 10 times as fast.

Options: ReplyQuote


Subject
Views
Written By
Posted
3954
October 28, 2013 03:39AM
Re: my.cnf optimization please help
1373
October 29, 2013 07:10PM


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.