| 1 |
--echo # |
| 2 |
--echo # Bug#22844987 - SPIN ROUNDS PER WAIT WILL BE NEGATIVE IN INNODB STATUS IF SPIN WAITS > MAX32INT |
| 3 |
--echo # |
| 4 |
|
| 5 |
--replace_regex /\n/<EOL>/ /.*RW-shared spins[[:space:]]*([0-9]+), rounds [[:space:]]*([0-9]+),.*/\2/ |
| 6 |
--let $RW_SHARED_ROUNDS_BEFORE=`SHOW ENGINE INNODB STATUS` |
| 7 |
--replace_regex /InnoDB[[:space:]]*// |
| 8 |
--let $RW_SHARED_ROUNDS_BEFORE_VALUE=`SELECT '$RW_SHARED_ROUNDS_BEFORE'` |
| 9 |
|
| 10 |
CREATE TABLE t (col1 INT); |
| 11 |
INSERT INTO t VALUES (1), (2), (3); |
| 12 |
SELECT * FROM t ORDER BY col1; |
| 13 |
UPDATE t SET col1 = 42 WHERE col1 = 2; |
| 14 |
SELECT * FROM t ORDER BY col1; |
| 15 |
DROP TABLE t; |
| 16 |
|
| 17 |
--replace_regex /\n/<EOL>/ /.*RW-shared spins[[:space:]]*([0-9]+), rounds [[:space:]]*([0-9]+),.*/\2/ |
| 18 |
--let $RW_SHARED_ROUNDS_AFTER=`SHOW ENGINE INNODB STATUS` |
| 19 |
--replace_regex /InnoDB[[:space:]]*// |
| 20 |
--let $RW_SHARED_ROUNDS_AFTER_VALUE=`SELECT '$RW_SHARED_ROUNDS_AFTER'` |
| 21 |
|
| 22 |
if ($RW_SHARED_ROUNDS_AFTER_VALUE < $RW_SHARED_ROUNDS_BEFORE_VALUE) |
| 23 |
{ |
| 24 |
echo SHARED BEFORE: $RW_SHARED_ROUNDS_BEFORE_VALUE, AFTER: $RW_SHARED_ROUNDS_AFTER_VALUE; |
| 25 |
} |