Skip to content

WarpSQL v8.0.30-GA-R2

Latest
Compare
Choose a tag to compare
@greenlion greenlion released this 11 Apr 20:23

The first GA release of WarpSQL. Supports automatic bitmap indexing, parallel query w/ star schema optimization, and columnar storage. Only utf8mb4 collated utf8_bin is currently supported for WARP tables.

INSTALL INSTRUCTIONS (as root):
download the .tar.gz file into /usr/local
tar Jxovf warpsql-8.0.30-GA.tar.xz
mv mysql-8.0.30 mysql/
useradd mysql
echo "/usr/local/mysql/lib/plugin" > /etc/ld.so.conf.d/warp.conf
ldconfig
-- the following should show no unresolved libraries
ldd mysql/bin/mysqld

mkdir /var/lib/mysql
chown mysql:mysql /var/lib/mysql

-- create an /etc/my.cnf file (to support testing InnoDB and WARP)
[mysqld]
datadir=/var/lib/mysql
innodb_log_file_size=256M
innodb_buffer_pool_size=4G
socket=/tmp/mysql.sock
port=3306
secure_file_priv=""
local_infile=1
user=mysql

[client]
socket=/tmp/mysql.sock

--initialize mysql
mysql/bin/mysqld --initialize-insecure

--start mysqld
mysql/bin/mysqld_safe &

-- confirm WARP engine is enabled
mysql/bin/mysql -uroot -e'SHOW ENGINES'|grep WARP