MySQL Forums
Forum List  »  Performance

Re: How To Use More Resources
Posted by: Rick James
Date: January 07, 2015 07:14PM

There could be any of a number of things to tune/modify/etc.

Please provide
SHOW CREATE TABLE
The update statement
How much RAM you have
SHOW VARIABLES;
SHOW GLOBAL STATUS;

And explain why you are UPDATEing 30% of a table. This is usually an indicator of a problem in the schema design. How often do you need to do it?

Options: ReplyQuote


Subject
Views
Written By
Posted
1747
January 07, 2015 11:12AM
Re: How To Use More Resources
746
January 07, 2015 07:14PM
1133
January 07, 2015 09:14PM
1088
January 07, 2015 11:21PM
702
January 07, 2015 11:42PM
784
January 08, 2015 05:48PM
845
January 09, 2015 02:39PM


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.