[ https://forge.continuent.org/jira/browse/SEQUOIA-1140?page=all ]
Emmanuel Cecchet resolved SEQUOIA-1140:
---------------------------------------
Resolution: Not an issue
This is a group communication configuration problem.
Use the mailing list for support not JIRA
> Insert performance very bad with RAIDb-1
> ----------------------------------------
>
> Key: SEQUOIA-1140
> URL: https://forge.continuent.org/jira/browse/SEQUOIA-1140
> Project: Sequoia
> Type: Improvement
> Versions: sequoia 2.10.10
> Environment: 2 nodes - Linux
> 2 controlers Sequoia 2.10.10
> 2 BDD mysql on the same node that Sequoia
> 2 ReceveryLog mysql on the same node that Sequoia
> Config RAIDb-1
> Appia default config
> Network with Go full duplex router between controlers
> Reporter: Philippe APVY
> Assignee: Emmanuel Cecchet
> Priority: Minor
>
> Original Estimate: 4 days
> Remaining: 4 days
>
> Hello
> With this config, the insert performance are very bad. On the whole an insert
> take 3 times that an insert directly in base.
> Table in BDD: create table benchSequoia01 (col1 int, col2 int, col3
> varchar(16))
> Requet insert: insert into benchSequoia01 values (val1,val2,'AAA')
> 1000 insert give this time on different configuration:
> 1 BDD - 1 controler - SingleDB - NO recoverylog
> Boucle d'insert (1000)
> [813 ms]
> 1 BDD - 1 controler - SingleDB - RecoveryLog
> Boucle d'insert (1000)
> [800 ms]
> 1 BDD - 1 controler - RAIDb-1 - RecoveryLog - Distribution no enable in
> xml file
> Boucle d'insert (1000)
> [1122 ms]
> 1 BDD - 1 controler - RAIDb-1 - Recovery - Distribution enable in xml
> file
> Boucle d'insert (1000)
> [1644 ms]
> 2 BDD - 2 controlers - RAIDb-1 - 2 RecoveryLog - Distribution enable in
> xml file
> Boucle d'insert (1000)
> [2746ms]
> The network traffic is very important just for a small insert. 4Mo in point
> between les 2 controllers.
> Please excuse me for my very bad Inglish.
> Thanks for your help
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
