Skip to content

Instantly share code, notes, and snippets.

@MOON-CLJ
Last active December 18, 2015 07:29
Show Gist options
  • Save MOON-CLJ/5747014 to your computer and use it in GitHub Desktop.
Save MOON-CLJ/5747014 to your computer and use it in GitHub Desktop.
install tokudb
~/.bashrc
alias gcc='/usr/local/bin/gcc'
export CC=/usr/local/bin/gcc
export CXX=/usr/local/bin/g++
CFLAGS="-O3 -g -fno-exceptions -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing"
CXXFLAGS="-O3 -g -fno-exceptions -fno-rtti -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing"
export CFLAGS CXXFLAGS
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/scws/lib/:/home/arthas/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/sbin
export LIBRARY_PATH=/usr/lib/x86_64-linux-gnu
export PATH=$PATH:/usr/local/tokutek/mysql/bin/
sudo vi support-files/mysql.server
case "$arg" in
--basedir=*) basedir=/usr/local/tokutek/mysql # `echo "$arg" | sed -e 's/^[^=]*=//'`
--datadir=*) datadir=/var/lib/mysql # `echo "$arg" | sed -e 's/^[^=]*=//'`
▸---▸--- datadir_set
$bindir/mysqld_safe --datadir="$datadir" --basedir="$basedir" --pid-file="$mysqld_pid_file_path" $other_args --user=mysql >/dev/null 2>&1 &
sudo cp /usr/local/tokutek/mysql/share/english/errmsg.sys /usr/share/mysql/
my.cnf
datadir = /var/lib/mysql
basedir = /usr/local/tokutek/mysql
user = mysql
#tokudb_cache_size = 18G
#tokudb_commit_sync = 0
#tokudb_pk_insert_mode = 0
#bulk_insert_buffer_size = 256M
sudo scripts/mysql_install_db --datadir=/var/lib/mysql --basedir=/usr/local/tokutek/mysql --user=mysql
python-mysql
python setup.py build
sudo python setup.py install
create database master_timeline CHARACTER SET=utf8;
create table master_timeline_weibo ( _id bigint(17) unsigned not null, user int(11) unsigned not null, retweeted_status bigint(17) unsigned not null, text varchar(560) not null, timestamp int(11) unsigned not null, reposts_count mediumint unsigned not null, source varchar(350), bmiddle_pic varchar(80), geo varchar(100), PRIMARY KEY id_index (_id), clustering key timestamp_index (timestamp), clustering key reposts_count_index (reposts_count), clustering key user_index (user));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment