zodb / relstorage / 602
96%
master: 92%

LAST BUILD BRANCH: 4.1.1
DEFAULT BRANCH: master
Ran
Jobs 15
Files 73
Run time 13min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst
602

push

travis-ci

jamadden 
Use InnoDB temp tables

And truncate them.

For most things this seems to speed up writes by around 10% due to the
way the temp tables are allocated.

Tested on both 5.5 and 5.7.

I think the dropping was an attempt to make the tables statement-level
replication compatible, but since they weren't transactianal I don't
think that worked. They were also variable sized so I don't think there
ware any speed benefits.

Benchmarks from 5.5:

zodbshootout -c 2 shootout.conf -n 100 --test-reps 200 -r 1 -s 256

** concurrency=2 **
"Transaction",               mysql_hf
"Add 100 Objects",               6493
"Update 100 Objects",            9636
"Read 100 Warm Objects",         9797
"Read 100 Cold Objects",         9336
"Read 100 Hot Objects",         37407
"Read 100 Steamin' Objects",   921761

** concurrency=6 **
"Transaction",               mysql_hf
"Add 100 Objects",              10574
"Update 100 Objects",           15492
"Read 100 Warm Objects",        19290
"Read 100 Cold Objects",        17051
"Read 100 Hot Objects",         72304
"Read 100 Steamin' Objects",  1590488

** concurrency=2 **
"Transaction",               mysql_hf
"Add 100 Objects",               7079
"Update 100 Objects",            9782
"Read 100 Warm Objects",         8726
"Read 100 Cold Objects",         9834
"Read 100 Hot Objects",         40004
"Read 100 Steamin' Objects",   937232

c=6
** concurrency=6 **
"Transaction",               mysql_hf
"Add 100 Objects",              10612
"Update 100 Objects",           15789
"Read 100 Warm Objects",        17501
"Read 100 Cold Objects",        16556
"Read 100 Hot Objects",         71868
"Read 100 Steamin' Objects",  1549534

zodbshootout -c 2 shootout.conf -n 100 --test-reps 200 -r 1 -s 96

** concurrency=2 **
"Transaction",               mysql_hf
"Add 100 Objects",              15547
"Update 100 Objects",           14337
"Read 100 Warm Objects",        12357
"Read 100 Cold Objects",        13686
"Read 100 Hot Objects",         54559
"Read 100 ... (continued)

3 of 3 new or added lines in 1 file covered. (100.0%)

5214 of 5446 relevant lines covered (95.74%)

10.34 hits per line

Uncovered Existing Lines

Lines Coverage ∆ File
1
91.67
 -8.33% relstorage/__init__.py
1
94.57
 0.0% relstorage/adapters/mysql/mover.py
3
89.53
 -3.49% relstorage/adapters/connmanager.py
27
92.06
 0.18% relstorage/storage.py
Jobs
ID Job ID Ran Files Coverage
1 602.1 (ENV=cmysqlconnector RS_MY_DRIVER="C MySQL Connector/Python") 73
85.64
 Travis Job 602.1
2 602.2 (ENV=mysqlconnector) 73
85.53
 Travis Job 602.2
3 602.3 (ENV=mysqlconnector) 0
Travis Job 602.3
4 602.4 (ENV=mysql) 73
85.31
 Travis Job 602.4
5 602.5 (ENV=mysql) 73
85.35
 Travis Job 602.5
6 602.6 (ENV=mysql) 73
85.33
 Travis Job 602.6
7 602.7 (ENV=mysql) 0
Travis Job 602.7
8 602.8 (ENV=pymysql) 73
85.11
 Travis Job 602.8
9 602.9 (ENV=pymysql) 73
85.11
 Travis Job 602.9
10 602.10 (ENV=umysqldb) 73
85.9
 Travis Job 602.10
11 602.11 (ENV=postgres) 73
86.76
 Travis Job 602.11
12 602.12 (ENV=postgres) 0
Travis Job 602.12
13 602.13 (ENV=postgres) 73
86.78
 Travis Job 602.13
14 602.14 (ENV=pypostgres) 73
88.45
 Travis Job 602.14
15 602.15 (ENV=pypostgres) 73
88.4
 Travis Job 602.15
Source Files on build 602
Coverage ∆ File Lines Relevant Covered Missed Hits/Line