Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sysbench --db-driver=mysql --mysql-user=root --mysql-password=example --mysql-host=example --mysql-db=takedown --range_size=100 --table_size=10000000 --tables=1 --threads=1 --events=0 --time=60 --rand-type=uniform /usr/share/sysbench/oltp_read_only.lua prepare
- pt-online-schema-change --execute --alter "ADD COLUMN testingcolumn VARCHAR(250) DEFAULT 'this is a test record default value'" h=example.example.example,u=root,p=example,D=takedown,t=sbtest1
- No slaves found. See --recursion-method if host d6c54372-f867-4d9a-92d9-546bde3b7918 has slaves.
- Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
- Operation, tries, wait:
- analyze_table, 10, 1
- copy_rows, 10, 0.25
- create_triggers, 10, 1
- drop_triggers, 10, 1
- swap_tables, 10, 1
- update_foreign_keys, 10, 1
- Altering `takedown`.`sbtest1`...
- Creating new table...
- Created new table takedown._sbtest1_new OK.
- Altering new table...
- Altered `takedown`.`_sbtest1_new` OK.
- 2018-06-14T11:51:50 Creating triggers...
- 2018-06-14T11:51:50 Created triggers OK.
- 2018-06-14T11:51:50 Copying approximately 10000062 rows...
- Copying `takedown`.`sbtest1`: 5% 08:32 remain
- Copying `takedown`.`sbtest1`: 8% 10:18 remain
- Copying `takedown`.`sbtest1`: 12% 10:52 remain
- Copying `takedown`.`sbtest1`: 15% 10:41 remain
- Copying `takedown`.`sbtest1`: 19% 10:13 remain
- Copying `takedown`.`sbtest1`: 22% 10:05 remain
- Copying `takedown`.`sbtest1`: 26% 09:30 remain
- Copying `takedown`.`sbtest1`: 33% 08:07 remain
- Copying `takedown`.`sbtest1`: 39% 06:51 remain
- Copying `takedown`.`sbtest1`: 46% 05:51 remain
- Copying `takedown`.`sbtest1`: 52% 04:57 remain
- Copying `takedown`.`sbtest1`: 59% 04:05 remain
- Copying `takedown`.`sbtest1`: 66% 03:17 remain
- Copying `takedown`.`sbtest1`: 73% 02:31 remain
- Copying `takedown`.`sbtest1`: 80% 01:51 remain
- Copying `takedown`.`sbtest1`: 86% 01:14 remain
- Copying `takedown`.`sbtest1`: 93% 00:38 remain
- Copying `takedown`.`sbtest1`: 99% 00:03 remain
- 2018-06-14T12:00:53 Copied rows OK.
- 2018-06-14T12:00:53 Swapping tables...
- 2018-06-14T12:00:53 Swapped original and new tables OK.
- 2018-06-14T12:00:53 Dropping old table...
- 2018-06-14T12:00:53 Dropped old table `takedown`.`_sbtest1_old` OK.
- 2018-06-14T12:00:53 Dropping triggers...
- 2018-06-14T12:00:53 Dropped triggers OK.
- Successfully altered `takedown`.`sbtest1`.
- E, [2018-06-14T11:46:47.913467 #23669] ERROR -- : Error occurred for cluster example-example: Deadlock found when trying to get lock; try restarting transaction
- E, [2018-06-14T11:52:48.814928 #23669] ERROR -- : Error occurred for cluster example-example: Deadlock found when trying to get lock; try restarting transaction
- E, [2018-06-14T11:53:48.970790 #23669] ERROR -- : Error occurred for cluster example-example: Deadlock found when trying to get lock; try restarting transaction
- (none)> show variables like '%vers%';
- +---------------------------+---------------------------+
- | Variable_name | Value |
- +---------------------------+---------------------------+
- | innodb_version | 5.6.36-82.1 |
- | protocol_version | 10 |
- | slave_type_conversions | |
- | thread_pool_oversubscribe | 3 |
- | version | 10.1.26-MariaDB |
- | version_comment | Source distribution |
- | version_compile_machine | x86_64 |
- | version_compile_os | Linux |
- | version_malloc_library | system |
- | version_ssl_library | OpenSSL 1.0.1f 6 Jan 2014 |
- | wsrep_patch_version | wsrep_25.19 |
- +---------------------------+---------------------------+
- 11 rows in set
- Time: 0.007s
Add Comment
Please, Sign In to add comment