Date: Sat, 7 Nov 2015 09:28:22 +0000 (UTC) From: Kurt Jaeger <pi@FreeBSD.org> To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r400974 - head/databases/cego Message-ID: <201511070928.tA79SMg9076499@repo.freebsd.org>
next in thread | raw e-mail | index | archive | help
Author: pi Date: Sat Nov 7 09:28:21 2015 New Revision: 400974 URL: https://svnweb.freebsd.org/changeset/ports/400974 Log: databases/cego: 2.26.7 -> 2.26.9 - Version passed concurrent load test with 10 million concurrent operations ( random insert, update and delete on one table with 2 processes ) - Fix in CegoFileHandler::allocatePage, In case of page exceed with appendMode = true, a second try is done with appendMode = false - Small fix in CegoObjectManager::reorgObject, ref page id information for append mode is set to new last page id - Small fix in CegoSelect::filterRefs, allow expressions with constant values ( getAttrRefList= 0 ) in aggregation - Locking improvements for delete and update operations. All delete operations are done now via transactions ( introduced CegoTableManager::deleteDataTableAtomic ). This allows to use a shared lock as the table lock for using the table (CegoDistManager::deleteLocalDataTable and CegoDistManager::updateLocalDataTable ) As a result, a table can be accessed in parallel during a ( long running ) delete operation on the table( e.g. delete from table). E.g. select count(*) from table will not block anymore, rather indicates the remaining number of tuples in the table. This modification is still under investigation and must verfied ( also in combination with btree/index objects on the table ) - Fix in CegoBTreeManager::deleteBTree, the relevance value was not calculated correctly Fix in CegoQuery, cache invalidation is done before query operations. Otherwise, if the query is aborted, an exception is thrown and the cache is not cleaned - Small modifications on cgblow load simulation client - Changed locking for delete an update operations to exclusive due to concurrency prpblems with btree operations - Added page locking to AVLIndexManager and AVLIndexCursor - Improvements for locking done. Since locking is done on page level, Insert and delete operations can be done now in parallel . For this locking had to be introduced in CegoBtreeManager::insertBTree and CegoBTreeManager::deleteBTree Further performance path for grouping queries in CegoGroupSpace. Since the current grouping key is stored now in the class variable _groupSchema, some expensive list copy operations could be avoided. This improves performance for about 4%. Submitted by: Bjoern Lemke <lemke@lemke-it.com> Modified: head/databases/cego/Makefile head/databases/cego/distinfo head/databases/cego/pkg-plist Modified: head/databases/cego/Makefile ============================================================================== --- head/databases/cego/Makefile Sat Nov 7 07:35:37 2015 (r400973) +++ head/databases/cego/Makefile Sat Nov 7 09:28:21 2015 (r400974) @@ -1,7 +1,7 @@ # $FreeBSD$ PORTNAME= cego -PORTVERSION= 2.26.7 +PORTVERSION= 2.26.9 CATEGORIES= databases MASTER_SITES= http://www.lemke-it.com/ Modified: head/databases/cego/distinfo ============================================================================== --- head/databases/cego/distinfo Sat Nov 7 07:35:37 2015 (r400973) +++ head/databases/cego/distinfo Sat Nov 7 09:28:21 2015 (r400974) @@ -1,2 +1,2 @@ -SHA256 (cego-2.26.7.tar.gz) = 9843a5f00cdc0b806a1e2fc65b8124b36b88d6a2a9cdb3fcc405603d5dcf272b -SIZE (cego-2.26.7.tar.gz) = 1226686 +SHA256 (cego-2.26.9.tar.gz) = 31f38e21226ff20cd5fc81db7568297a6e8364f652e0c6276c19931aaeab7ef7 +SIZE (cego-2.26.9.tar.gz) = 1227953 Modified: head/databases/cego/pkg-plist ============================================================================== --- head/databases/cego/pkg-plist Sat Nov 7 07:35:37 2015 (r400973) +++ head/databases/cego/pkg-plist Sat Nov 7 09:28:21 2015 (r400974) @@ -137,5 +137,6 @@ lib/libcgwrap.so.2.0.0 %%DATADIR%%/cgbackup %%DATADIR%%/cgmkdb %%DATADIR%%/cgrecover +%%DATADIR%%/cgsimload %%DATADIR%%/startdb %%DATADIR%%/stopdb
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201511070928.tA79SMg9076499>