Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save grooverdan/15101063919fdd83c9d08ebd253cd406 to your computer and use it in GitHub Desktop.
Save grooverdan/15101063919fdd83c9d08ebd253cd406 to your computer and use it in GitHub Desktop.
connection node_2;
connection node_1;
CREATE TABLE `legacy_item_requests` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`request` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
SELECT * FROM legacy_item_requests;
id created_at updated_at request
SET profiling = 1;
insert into legacy_item_requests (request) values (1);
set profiling = 0;
SHOW PROFILE FOR QUERY 1;
Status Duration
Starting 0.000327
checking permissions 0.000030
Opening tables 0.000042
After opening tables 0.000039
System lock 0.000014
table lock 0.000016
init for update 0.000028
Update 0.000260
End of update loop 0.000040
Query end 0.000012
Commit 0.001034
innobase_commit_low() 0.000068
Commit 0.000081
closing tables 0.000015
Unlocking tables 0.000028
closing tables 0.000014
Starting cleanup 0.000006
Freeing items 0.000014
Updating status 0.000057
Reset for next command 0.000029
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment