Hi there,
We have a 250 GB database on Ubuntu 14 on a XFS partition (in a RAID 6
using LVM).
There are major slowdowns and connection issues. For example, selecting
from OUser "select from OUser" takes 14 seconds.
Adding a LIMIT 1 takes 118 seconds. I ran it twice to show that after
running it once, it still takes 18 seconds:
orientdb {db=pumpup}> select from OUser limit 1
----+----+------+-----+-------------------------------------------------------------------------+------+-----
# |@RID|@CLASS|name |password
|status|roles
----+----+------+-----+-------------------------------------------------------------------------+------+-----
0 |#5:0|OUser |admin|{SHA-256}XXXXXXXX|ACTIVE|[1]
----+----+------+-----+-------------------------------------------------------------------------+------+-----
1 item(s) found. Query executed in 118.849 sec(s).
orientdb {db=pumpup}> select from OUser limit 1
----+----+------+-----+-------------------------------------------------------------------------+------+-----
# |@RID|@CLASS|name |password
|status|roles
----+----+------+-----+-------------------------------------------------------------------------+------+-----
0 |#5:0|OUser |admin|{SHA-256}XXXXXXXXX|ACTIVE|[1]
----+----+------+-----+-------------------------------------------------------------------------+------+-----
1 item(s) found. Query executed in 22.369 sec(s).
There are frequent connection issues:
OrientDB console v.2.0-SNAPSHOT (build UNKNOWN@r; 2014-12-04 22:29:22-0500)
www.orientechnologies.com
Type 'help' to display all the supported commands.
Installing extensions for GREMLIN language v.2.6.0
orientdb> connect remote:localhost/db root XXXX
Connecting to database [remote:localhost/db] with user 'root'...
2015-01-08 05:52:21:287 WARNING Caught I/O errors from Not connected (local
socket=?), trying to reconnect (error: java.io.IOException: Channel is
closed) [OStorageRemote]
Error: com.orientechnologies.orient.core.exception.OStorageException:
Cannot create a connection to remote server address(es): [127.0.0.1:2424]
orientdb> connect remote:localhost/db root XXXX
Disconnecting from the database [null]...OK
Connecting to database [remote:localhost/db] with user 'root'...
Error: com.orientechnologies.orient.core.exception.OStorageException:
Cannot create a connection to remote server address(es): [127.0.0.1:2424]
orientdb> connect remote:localhost/db root XXXX
Disconnecting from the database [null]...OK
Connecting to database [remote:localhost/db] with user 'root'...OK
orientdb {db=db}>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
