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
Priority: Minor
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
