{"action":"created","issue":{"url":"https://api.github.com/repos/akiradeveloper/dm-writeboost/issues/146","repository_url":"https://api.github.com/repos/akiradeveloper/dm-writeboost","labels_url":"https://api.github.com/repos/akiradeveloper/dm-writeboost/issues/146/labels{/name}","comments_url":"https://api.github.com/repos/akiradeveloper/dm-writeboost/issues/146/comments","events_url":"https://api.github.com/repos/akiradeveloper/dm-writeboost/issues/146/events","html_url":"https://github.com/akiradeveloper/dm-writeboost/issues/146","id":172617514,"number":146,"title":"Question regarding writeboost and MYSQL","user":{"login":"joeey1984ad","id":12181529,"avatar_url":"https://avatars.githubusercontent.com/u/12181529?v=3","gravatar_id":"","url":"https://api.github.com/users/joeey1984ad","html_url":"https://github.com/joeey1984ad","followers_url":"https://api.github.com/users/joeey1984ad/followers","following_url":"https://api.github.com/users/joeey1984ad/following{/other_user}","gists_url":"https://api.github.com/users/joeey1984ad/gists{/gist_id}","starred_url":"https://api.github.com/users/joeey1984ad/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/joeey1984ad/subscriptions","organizations_url":"https://api.github.com/users/joeey1984ad/orgs","repos_url":"https://api.github.com/users/joeey1984ad/repos","events_url":"https://api.github.com/users/joeey1984ad/events{/privacy}","received_events_url":"https://api.github.com/users/joeey1984ad/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":31,"created_at":"2016-08-23T05:49:39Z","updated_at":"2016-08-23T11:47:42Z","closed_at":null,"body":"Hello, I was testing writeboost  with Percona 5.5 and sysbenck 0.4. The performance is great up until around 10GB DATA. The performance quicly diminishes to a very low TPS. I repeated same test with LVM-Cache and Bcache but TPS drops down 'steadily' Not 'quicly'. Is this due the block size ( and if so can it be changed? ) or is  this a normal behavior?\r\n\r\nBTW. My Buffer Pool is quite high 56GB. My Cache SSD is 430GB.\r\n\r\nI created a 400GB DATA with sysbench 0.4 like so,\r\n\r\nsysbench --test=oltp --oltp-table-size=5990000000 --mysql-db=test1 --db-driver=mysql --mysql-user=root --mysql-password=  prepare\r\n\r\nTest is a complex R/W. \r\nResults:\r\n\r\nTest1. All 400GB DATA (5990000000 Rows) \r\n\r\nsysbench --test=oltp --db-driver=mysql --oltp-test-mode=complex --oltp-table-size=350000  00  --mysql-db=test1 --mysql-user=root --mysql-password= --max-time=60 --oltp-read-only=off --max-requests=0 --num-threa  ds=56 run\r\nsysbench 0.4.12:  multi-threaded system evaluation benchmark\r\n\r\nOLTP test statistics:\r\n    queries performed:\r\n        read:                            17080\r\n        write:                           6100\r\n        other:                           2440\r\n        total:                           25620\r\n    transactions:                        1220   (15.53 per sec.)\r\n    deadlocks:                           0      (0.00 per sec.)\r\n    read/write requests:                 23180  (808.07 per sec.)\r\n    other operations:                    2440   (85.06 per sec.)\r\n\r\n------------------------------------------------------------------------\r\nTest2. around 80Gb DATA (350000000 Rows) with the same 400GB table \r\n\r\n sysbench --test=oltp --db-driver=mysql --oltp-test-mode=complex --oltp-table-size=350000000  --mysql-db=test1 --mysql-user=root --mysql-password= --max-time=20 --oltp-read-only=off --max-requests=0 --num-threads=56 run\r\nsysbench 0.4.12:  multi-threaded system evaluation benchmark\r\n\r\n\r\nOLTP test statistics:\r\n    queries performed:\r\n        read:                            9198\r\n        write:                           3285\r\n        other:                           1314\r\n        total:                           13797\r\n    transactions:                        657    (30.93 per sec.)\r\n    deadlocks:                           0      (0.00 per sec.)\r\n    read/write requests:                 12483  (587.66 per sec.)\r\n    other operations:                    1314   (61.86 per sec.)\r\n\r\n-------------------------------------------------------------------------\r\nTeest3. Around 1GB DATA (5000000 Rows) with the same 400GB table \r\n\r\nsysbench --test=oltp --db-driver=mysql --oltp-test-mode=complex --oltp-table-size=5000000  --mysql-db=test1 --mysql-user=root --mysql-password= --max-time=60 --oltp-read-only=off --max-requests=0 --num-threads=56 run\r\n\r\nOLTP test statistics:\r\n    queries performed:\r\n        read:                            1128106\r\n        write:                           402895\r\n        other:                           161158\r\n        total:                           1692159\r\n    transactions:                        80579  (4027.58 per sec.)\r\n    deadlocks:                             0      (0.00 per sec.)\r\n    read/write requests:                 1531001 (76523.94 per sec.)\r\n    other operations:                     161158 (8055.15 per sec.)\r\n\r\n\r\nThe results with LVM-Cache and Bcache With same hardware and Mysql configuration is pporximately \r\nTest1, 1700-2000 TPS\r\nTest2, 2200-2800 TPS\r\nTest3, 4400-4500 TPS\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/akiradeveloper/dm-writeboost/issues/comments/241706345","html_url":"https://github.com/akiradeveloper/dm-writeboost/issues/146#issuecomment-241706345","issue_url":"https://api.github.com/repos/akiradeveloper/dm-writeboost/issues/146","id":241706345,"user":{"login":"akiradeveloper","id":785824,"avatar_url":"https://avatars.githubusercontent.com/u/785824?v=3","gravatar_id":"","url":"https://api.github.com/users/akiradeveloper","html_url":"https://github.com/akiradeveloper","followers_url":"https://api.github.com/users/akiradeveloper/followers","following_url":"https://api.github.com/users/akiradeveloper/following{/other_user}","gists_url":"https://api.github.com/users/akiradeveloper/gists{/gist_id}","starred_url":"https://api.github.com/users/akiradeveloper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/akiradeveloper/subscriptions","organizations_url":"https://api.github.com/users/akiradeveloper/orgs","repos_url":"https://api.github.com/users/akiradeveloper/repos","events_url":"https://api.github.com/users/akiradeveloper/events{/privacy}","received_events_url":"https://api.github.com/users/akiradeveloper/received_events","type":"User","site_admin":false},"created_at":"2016-08-23T11:47:42Z","updated_at":"2016-08-23T11:47:42Z","body":"@joeey1984ad  so it's a good chance to analyze why writeboost slows down. btw, give me the `dmsetup status` which may tells me the reason."}}
{"actor":{"display_login":"akiradeveloper"}}