[MDEV-7698] Spiral patches Created: 2015-03-11  Updated: 2017-11-27  Resolved: 2017-11-27

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Fix Version/s: 10.3.3

Type: Epic Priority: Major
Reporter: Sergey Vojtovich Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None

Attachments: File 10.2-server-with-connect-string-patch.diff     File partition_mrr_test.tgz     File spider_test_for_10.2.tgz    
Issue Links:
Duplicate
duplicates MDEV-12332 MariaDB spider performance Closed
Epic Name: Spiral patches

 Description   

Review and apply patches suggested by Kentoku.



 Comments   
Comment by Eric Herman [ 2015-10-14 ]

-------- Forwarded Message --------
Subject: Re: Patched MariaDB 10.1.8 with Spider
Date: Wed, 14 Oct 2015 17:37:46 +0900
From: kentoku <kentokushiba@gmail.com>
To: Michael Widenius <monty@askmonty.org>, Sergey Vojtovich <svoj@mariadb.org>
CC: sergey@mariadb.com, eric.herman@booking.com, Stephane Varoqui <Stephane@mariadb.com>, Kayoko Goto <kayoko.goto@spiral-arms.com>

Hi Monty, Sergey,

I just uploaded patch files on the server. Please download from this
URL and check it.
http://spiderformysql.com/downloads/spider-3.2/patch_mariadb-10.1.8.tgz

See you soon!

Thanks,
Kentoku

2015-10-14 12:34 GMT+09:00 kentoku <kentokushiba@gmail.com>:
> Hi Monty, Sergey,
>
> I just finished creating patched MariaDB 10.1.8 with Spider and VP.
> Please download from this URL and continue reviewing.
> http://spiderformysql.com/downloads/spider-3.2/mariadb-10.1.8-spider-3.2-vp-1.1.tgz
>
> mysql-test is available by using the following commands.
>
> ./mtr --suite=spider
> ./mtr --suite=spider/bg
> ./mtr --suite=spider/handler
> ./mtr --suite=vp
> ./mtr --suite=vp/spider
>
> "spider", "spider/bg", "spider/handler" tests are passed, but "vp" and
> "vp/spider" tests are still failing the following tests. I'll check it
> later.
> geometry
> geometry_part
>
> Additionally, some patches are changed for MariaDB 10.1 and some
> patches are added. I'll send it soon.
>
> Thanks,
> Kentoku

Comment by Eric Herman [ 2015-10-14 ]

Spider Hacking 2015 Dev Meeting Amsterdam:

https://docs.google.com/a/skysql.com/document/d/1RihIJjeDGzuFZSu5GDjPviu378W0IysDcMRrkogRT5k/edit?usp=sharing

Comment by Kentoku Shiba (Inactive) [ 2016-05-07 ]

The latest patch files for MariaDB 10.2.0 are here. Please check it.
http://spiderformysql.com/downloads/spider-3.3/patch_mariadb-10.2.0.tgz

Comment by Kentoku Shiba (Inactive) [ 2016-05-08 ]

Prioritize the list of patches in dependency order
priority. patch numbers
01. 001
02. 002
03. 003,019,021,048,054,055,056,060
04. 004
05. 005,013,034,041,061(change of mysqld.cc)
06. 006,008,010,011,061(change of sql_delete.cc and sql_update.cc)
07. 007,038
08. 012
09. 014,015,023,033,035,037,040,042(change of ha_partition.cc and multi_range_read.cc),044,045,049,050,051,053,059
10. 020
11. 022
12. 024
13. 026,031,058
14. 027
15. 030
16. 039,047
17. 046
18. 052
19. 057

Comment by Kentoku Shiba (Inactive) [ 2016-11-23 ]

Here is spider tests for MariaDB 10.2.
spider_test_for_10.2.tgz

Comment by Kentoku Shiba (Inactive) [ 2016-11-30 ]

Here is recreated patch for connect string.
10.2-server-with-connect-string-patch.diff

Comment by Kentoku Shiba (Inactive) [ 2016-12-06 ]

Here is the latest code that applied patches.
http://spiderformysql.com/downloads/spider-3.3/mariadb-10.2.0-spider-3.3-vp-1.1.tgz

Comment by Kentoku Shiba (Inactive) [ 2016-12-06 ]

Here is the test for partition_mrr patches.
partition_mrr_test.tgz

Comment by Michael Widenius [ 2017-07-05 ]

Stage 9: 014,015,023,033,035,037,040,042(change of ha_partition.cc and multi_range_read.cc),044,045,049,050,051,053,059 now pushed to 10.2-spider

Generated at Thu Feb 08 07:21:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.