MySQL Forums
Forum List  »  Falcon

Re: Warming up issue of record cache?
Posted by: Yuan WANG
Date: April 10, 2008 01:05AM

Hakan

Thank you for your quick response. I tested the performance when setting record cache/page cache to 400M/100M and 100M/400M respectively. Here are the results.


== Record cache 400M / Page cache 100M ==
Log of vmstat is:

$ vmstat 60
procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
0 0 13944 849160 166612 2154560 0 0 77 54 0 0 0 0 99 0
6 7 13944 687560 166624 2154548 0 0 4047 6 1278 24194 16 12 32 40
5 9 13944 647576 166632 2154568 0 0 4719 7 1445 39474 28 22 4 47
4 8 13944 611788 166644 2154560 0 0 4596 3 1418 41155 30 23 3 44
1 9 13944 579296 166656 2154584 0 0 4486 6 1386 42829 32 24 3 41
4 7 13944 549720 166660 2154584 0 0 4342 2 1351 44753 35 25 2 38
3 7 13944 523676 166672 2154584 0 0 4157 3 1306 46808 37 27 2 35
11 3 13944 499788 166684 2154584 0 0 3920 7 1246 49150 39 28 2 31
11 4 13944 478224 166692 2154588 0 0 3649 6 1181 51452 42 30 2 26
11 3 13944 459116 166704 2154588 0 0 3368 6 1107 53299 44 32 2 22
6 6 13944 442064 166708 2154588 0 0 3059 4 1033 55096 46 33 2 18

Performance report by sysbench is:

OLTP test statistics:
queries performed:
read: 11101349
write: 0
other: 0
total: 11101349
transactions: 11101349 (18502.17 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 11101349 (18502.17 per sec.)
other operations: 0 (0.00 per sec.)

== Record cache 100M / Page cache 400M ==
Log of vmstat:

$ vmstat 60
procs -----------memory---------- ---swap-- -----io---- -system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
0 0 13944 818688 167524 2154668 0 0 77 54 0 1 0 0 99 0
9 2 13944 569612 167536 2154668 0 0 2892 7 992 33151 27 20 29 23
10 0 13944 486440 167544 2154668 0 0 484 7 391 59741 56 41 2 1
10 0 13944 472992 167556 2154660 0 0 199 3 316 60042 56 42 2 0
10 1 13944 464348 167560 2154668 0 0 121 7 300 59159 56 41 3 0
10 0 13944 458412 167572 2154668 0 0 90 5 292 59981 56 42 2 0
11 0 13944 454196 167584 2154668 0 0 70 3 286 59984 55 42 2 0
10 0 13944 450504 167592 2154668 0 0 51 6 287 60301 56 42 2 0
10 0 13944 447588 167604 2154668 0 0 46 2 278 59120 55 41 3 0
10 1 13944 444412 167616 2154668 0 0 40 7 279 60440 56 43 2 0
14 0 13944 442884 167620 2154668 0 0 32 3 278 59161 56 41 3 0

Performance report by sysbench is:

OLTP test statistics:
queries performed:
read: 16212516
write: 0
other: 0
total: 16212516
transactions: 16212516 (27020.84 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 16212516 (27020.84 per sec.)
other operations: 0 (0.00 per sec.)


The command of sysbench used for the test is shown as folloows. Both tests runs for 10 minutes.

./sysbench --max-time=600 --num-threads=10 --max-requests=0 --test=oltp --oltp-test-mode=simple --oltp-table-size=5000000 --mysql-host=xxx --mysql-port=xxx --mysql-user=xxx --mysql-db=xxx --mysql-table-engine=falcon --mysql-engine-trx=yes run

The size of the database is 448M:

$ ls -lh falcon_user.fts
-rw-rw---- 1 ddb netease 448M 2008-04-10 14:40 falcon_user.fts

You can see, when page cache is set to 400M, the system warmed up very fast in 1 minute. But when record cache is set to 400M and page size set to 100M, the system warmed up really slowly. And the performance is much better when we have a larger page cache.

Options: ReplyQuote


Subject
Written By
Posted
Re: Warming up issue of record cache?
April 10, 2008 01:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.