cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "shawndu (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-4418) Add new file Column family Type
Date Sat, 07 Jul 2012 04:42:35 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-4418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13408571#comment-13408571
] 

shawndu edited comment on CASSANDRA-4418 at 7/7/12 4:41 AM:
------------------------------------------------------------

I know cassandra is a nosql engine. but some features in traditional sql based database engine
like trigger really are very useful. it is in roadmap?
for the above case, I think if cassandra let user to define some callbacks when mutations,it
will be much powerful. 
                
      was (Author: shawndu):
    I know cassandra is a nosql engine. but some features in traditional sql based database
engine like trigger really are very useful. It don't know it is in roadmap?
for the above case, I think if cassandra let user to define some callbacks when mutations.
it will be much powerful. 
                  
> Add new file Column family Type
> -------------------------------
>
>                 Key: CASSANDRA-4418
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4418
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Core
>    Affects Versions: 1.1.2
>         Environment: All
>            Reporter: shawndu
>
> Now I think cassandra's main problems is the compaction.
> Our use case is:
> we insert many big column value data in cassandra. column value maybe more than 10k.for
cassandra write is quiet fast. it will cause cassandra flush memtbale data into sstable.but
these data may be deleted soon. so issues come: compaction.
> I don't know the root cause. but I know the result. in this case, compaction will make
server become slow and also very high CPU and at a dangerous state. for we have other much
important process running.
> I think we need a new File Column Family type. It is:
> a Column value is not a byte array but a file name. the real value is in the file.
> there are some benefits:
> 0 when column is inserted, just create the file.
> 1 when column value is update. just replace the file.
> 2 when column is deleted, just delete the file.
> 3 this will save much time when compaction.
> I don't know it is a good, but in my view, it is simple and can real fix the compaction
problems.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message