Skip to content

Instantly share code, notes, and snippets.

@siscia

siscia/test_redisql_instances

Created February 28, 2019 09:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save siscia/aa12e158f5ebdbce39e53528f69adbe8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save siscia/aa12e158f5ebdbce39e53528f69adbe8 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. siscia created this gist Feb 28, 2019.
    61 changes: 61 additions & 0 deletions test_redisql_instances
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,61 @@
    free; for i in {1..11000}; do if [ $(( $i % 1000 )) -eq 0 ]; then echo $i; free; fi; ./redis-cli REDISQL.CREATE_D
    B DB$i > /dev/null; ./redis-cli REDISQL.EXEC DB$i "CREATE TABLE foo(a, b, c); CREATE TABLE bar(a, b, c)" > /dev/null; done


    free;
    for i in {1..11000}; do
    if [ $(( $i % 1000 )) -eq 0 ]; then
    echo $i;
    free;
    fi;
    ./redis-cli REDISQL.CREATE_DB DB$i > /dev/null;
    ./redis-cli REDISQL.EXEC DB$i "CREATE TABLE foo(a, b, c); CREATE TABLE bar(a, b, c)" > /dev/null;
    done

    total used free shared buff/cache available
    Mem: 16296124 2805944 8403924 543908 5086256 12455860
    Swap: 3906556 0 3906556
    1000
    total used free shared buff/cache available
    Mem: 16296124 3068672 8151312 525752 5076140 12205596
    Swap: 3906556 0 3906556
    2000
    total used free shared buff/cache available
    Mem: 16296124 3321480 7869176 544880 5105468 11926768
    Swap: 3906556 0 3906556
    3000
    total used free shared buff/cache available
    Mem: 16296124 3574868 7614968 534256 5106288 11675772
    Swap: 3906556 0 3906556
    4000
    total used free shared buff/cache available
    Mem: 16296124 3833540 7340664 537532 5121920 11405348
    Swap: 3906556 0 3906556
    5000
    total used free shared buff/cache available
    Mem: 16296124 4086556 7077580 536784 5131988 11144744
    Swap: 3906556 0 3906556
    6000
    total used free shared buff/cache available
    Mem: 16296124 4342120 6802328 543580 5151676 10873196
    Swap: 3906556 0 3906556
    7000
    total used free shared buff/cache available
    Mem: 16296124 4600336 6542312 532832 5153476 10617188
    Swap: 3906556 0 3906556
    8000
    total used free shared buff/cache available
    Mem: 16296124 4851204 6285364 526792 5159556 10363584
    Swap: 3906556 0 3906556
    9000
    total used free shared buff/cache available
    Mem: 16296124 5102124 6015596 533224 5178404 10096880
    Swap: 3906556 0 3906556
    10000
    total used free shared buff/cache available
    Mem: 16296124 5355584 5756408 526880 5184132 9841416
    Swap: 3906556 0 3906556
    11000
    total used free shared buff/cache available
    Mem: 16296124 5612236 5481052 533168 5202836 9569632
    Swap: 3906556 0 3906556