I compare WARP to InnoDB using the rather large data ontime flight data set from the BTS. leapdb.com/blog/warp-vs-i… #MySQL #WarpSQL

Parallel query finally works: > select count(*),c2 From test.tx group by c2; ... 2 rows in set (9.87 sec) > set warp_rewriter_parallel_query=ON; Query OK, 0 rows affected (0.00 sec) > select count(*),c2 From test.tx group by c2; ... 2 rows in set (3.64 sec) #MySQL #WarpSQL

#WarpSQL update - I had to make some changes to the WARP parallel query rewrite plugin to update to MySQL 8.0.22 - I am still debugging problems with parallel query plugin after the update to 8.0.22. I'll work on it more later this week.

I have been doing a lot of consulting for a large customer which has taken away most of my time to work on WarpSQL, but I am still working on it, it is making progress, and a new version will be out with an initial version of parallel query when it is ready. #mysql #warpsql

Making good progress on WarpSQL parallel query. I have some test code in a postparse rewrite plugin, and I have 'async' (part of swanhart-tools) set up for parallel workers, and it works without modification on MySQL 8.0. #MySQL #WarpSQL

Today @justin_swanhart released the first beta version of #WarpSQL, a #MySQL fork whose main feature is the WARP engine. #Vettabase published a Docker image to allow you to quickly test it. The image is alpha quality, do not use in production. hub.docker.com/r/vettadock/wa…

Next blog post are SSB SF1 and SF10 results of WARP vs InnoDB vs (maybe) RocksDB. I never have much luck with RocksDB. #MySQL #WarpSQL #MariaDB

Squashed the transactions branch into 8.0 (master) WarpSQL beta 2 - support MVCC, transactions, row level locking, statement rollback, improve ECP 8ece380 33 seconds ago FINALLY! #MySQL #WarpSQL

I like to fix bugs when I find them, but I also want to get beta 2 out the door, and I think that this one is rare enough to push to beta 3 even though it is a wrong result bug. github.com/greenlion/warp… #MySQL #WarpSQL

Now I am getting somewhere... SSB Q1.1 SF1: InnoDB w/ key on dim filter and fact table cold=0.21sec hot=0.20sec WARP w/ automatic indexing and join pushdown cold=0.10sec hot=0.04sec #MySQL #WarpSQL

SQL injection in the MySQL server! (of the proxy kind) via @planetmysql bit.ly/2arRvfS #warpsql #proxy