Last active
December 18, 2015 07:29
-
-
Save MOON-CLJ/5747014 to your computer and use it in GitHub Desktop.
install tokudb
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
~/.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