Justin Swanhart

icon indicating a website link http://shardquery.wordpress.com icon indicating an email [email protected]

icon company WarpSQL icon location Johnstown, PA icon location I work on making databases faster. Work includes Flexviews, Shard-Query, WarpSQL, and PHP-SQL-Parser.

Results 34 comments of Justin Swanhart

support special $COLUMN columns to tables

To support CDC without a daemon plugin, also make available $trxid and $operation columns which expose the internal transaction id row values and deletion/insertion markers.

Add recognition of SQL parameters

Will do ASAP.

Add WarpSQL SHIM plugin support back into the server

The rewrite plugins in MySQL 8 are good enough for now.

use smallest column for count(*)

minor issue - moving out of beta 2 - revisit later

PRIMARY KEY and UNIQUE KEY indexes do not enforce uniqueness

Fixed in ca4e43ae13237ac263f7e88be826c4bdff805669

PRIMARY KEY and UNIQUE KEY indexes do not enforce uniqueness

Removed PRIMARY and UNIQUE indexes in beta 2. Revisit this later.

significant disk usage by ps_history tables

I had not considered InnoDB compression on the tables, but this is a great idea.

significant disk usage by ps_history tables

I should probably make the storage engine configurable, as tokudb or rockdb are also great for compression.

Flexviews: UTIL_API/refresh Documentation Problem

Thanks. I'll fix when possible.

Can't use a separate schema for aggregate tables

All shards (including coord shards) have to have the schema loaded, even just empty tables will work. I'll think about support for coord shards without schema though.