1#!/usr/bin/env sysbench 2-- Copyright (C) 2006-2017 Alexey Kopytov <akopytov@gmail.com> 3 4-- This program is free software; you can redistribute it and/or modify 5-- it under the terms of the GNU General Public License as published by 6-- the Free Software Foundation; either version 2 of the License, or 7-- (at your option) any later version. 8 9-- This program is distributed in the hope that it will be useful, 10-- but WITHOUT ANY WARRANTY; without even the implied warranty of 11-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 12-- GNU General Public License for more details. 13 14-- You should have received a copy of the GNU General Public License 15-- along with this program; if not, write to the Free Software 16-- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA 17 18-- ---------------------------------------------------------------------- 19-- Read-Only OLTP benchmark 20-- ---------------------------------------------------------------------- 21 22require("oltp_common") 23 24function prepare_statements() 25 prepare_point_selects() 26 27 if not sysbench.opt.skip_trx then 28 prepare_begin() 29 prepare_commit() 30 end 31 32 if sysbench.opt.range_selects then 33 prepare_simple_ranges() 34 prepare_sum_ranges() 35 prepare_order_ranges() 36 prepare_distinct_ranges() 37 end 38end 39 40function event() 41 if not sysbench.opt.skip_trx then 42 begin() 43 end 44 45 execute_point_selects() 46 47 if sysbench.opt.range_selects then 48 execute_simple_ranges() 49 execute_sum_ranges() 50 execute_order_ranges() 51 execute_distinct_ranges() 52 end 53 54 if not sysbench.opt.skip_trx then 55 commit() 56 end 57end 58