Re: Why INSERT performance has not increase in sub-table?
Posted by:
Rick James
Date: November 03, 2014 09:31AM
SHOW VARIABLES LIKE 'innodb%';
SHOW VARIABLES LIKE 'autocommit';
There are at least 3 variables in the "default" config that are not tuned for a stress test like you are doing. Let's see your values, then discuss them.
Will you really have 50 users pounding on the table(s)? That is often unrealistic. Will you INSERT one row a time? That is significantly less efficient than 100 at a time.
Etc.
As for your question about one table vs many, that will come out in further discussion.
Subject
Views
Written By
Posted
2551
November 03, 2014 03:02AM
809
November 03, 2014 09:07AM
Re: Why INSERT performance has not increase in sub-table?
886
November 03, 2014 09:31AM
825
November 03, 2014 11:56AM
971
November 03, 2014 01:12PM
820
November 03, 2014 09:43PM
956
November 04, 2014 08:57AM
776
November 05, 2014 04:39AM
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.