I'm pleased to announce the release of Spider storage engine
version 2.5(beta) and Vertical Partitioning storage engine
version 0.5(alpha).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
Vertical Partitioning is a Storage Engine for vertical
partitioning for a table.
http://launchpad.net/vpformysql
The main changes in this version are following.
- The standalone compilation with Vertical Partitioning storage
engine is now available.
- Vertical Partitioning can be used for multi-step
partitioning.
Example:
create table a(a int primary
key)engine=myisam;
create table b(a int primary
key)engine=vp comment 'tnl "a"';
create table c(a …
I'm pleased to announce the release of Spider storage engine
version 2.4(beta) and Vertical Partitioning storage engine
version 0.4(alpha).
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
Vertical Partitioning is a Storage Engine for vertical
partitioning for a table.
http://launchpad.net/vpformysql
The main changes in this version are following.
- "Engine-condition-pushdown" is available on Vertical
Partitioning with Spider.
Please see "99_change_logs.txt" in the download documents for
checking other changes.
Thanks to Gennady for bug report.
Enjoy!
I'm pleased to announce the release of Vertical Partitioning
storage engine version 0.3.
http://launchpad.net/vpformysql
The main changes in this version are following.
- Add table parameter "choose_table_mode_for_lock".
- Add server parameter "vp_choose_table_mode_for_lock".
These parameters are used for avoiding deadlock by
fixing lock order to table list order.
Please see "99_change_logs.txt" in the download documents for
checking other changes.
Enjoy!
I'm pleased to announce the release of Vertical Partitioning
storage engine version 0.2.
http://launchpad.net/vpformysql
The main changes in this version are following.
- Support MySQL's table partitioning.
MySQL's table partitioning that is only introduced
last release is now supported.
note: After this version, you need to apply a patch
for installing Vertical Partitioning storage engine.
- After this version, the primary key part of InnoDB's secondary
index is effectively used.
You can use the primary key columns with InnoDB's
secondary index by using following statements.
create table tbl_b(
…
I'm pleased to announce a release of a new storage engine
"Vertical Partitioning storage engine".
http://launchpad.net/vpformysql
You can use relation tables of one to one like one table by using
Vertical Partitioning storage engine.
It is near by a view of joined relation tables of one to one but
different point is following.
- It can insert.
- It can do partition pruning.(Not use partitions that are no
necessity)
Vertical Partitioning storage engine can use following
purposes.
(Vertical Partitioning table is called "parent table", integrated
tables are called "child table")
1.A MySQL's InnoDB table that has the big record size is very
slow if a select statement needs table scanning with a lot of
records.
Vertical Partitioning is good for resolving this
performance problem.
…