Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # MySQL Performance documentation for Node:
- db-mysql-hackathon0a.42.wixprod.net
- Generated by WIX MySQL DATA team v1.0.0
- ## Table with no Primary key
- |TABLE_SCHEMA|TABLE_NAME|
- | --- | --- |
- |hackathon_db25|consumed_messages
- |hackathon_db25|produced_messages
- |hackathon_db26|migration_version
- |instance_info|instance_info
- ## Unused Indexes
- |object_schema|NumUnusedIndexes|
- | --- | --- |
- |hackathon_db26|team_id_idx
- |hackathon_db26|room_id_idx
- |hackathon_db26|fulltext
- |hackathon_db26|fulltext
- |hackathon_db26|floor_id_idx
- |hackathon_db26|fulltext
- |hackathon_db6|name_text_idx
- |hackathon_db6|cat_aliases_fulltext_idx
- |hackathon_db6|name_fulltext_idx
- |hackathon_db6|instance_id
- |hackathon_db6|service_type_id_idx
- |hackathon_db6|geometry_idx
- |hackathon_db6|service_by_creation_time
- |hackathon_db6|service_instance_tenant_version_idx
- |hackathon_db6|services_events_by_time
- |hackathon_db6|bids_tenant_tenant_version_idx
- |hackathon_db6|bids_events_by_time
- |hackathon_db6|bids_tenant_id_idx
- |hackathon_db6|bids_requesting_service_id_idx
- |hackathon_db6|bids_requested_service_type_id_idx
- |hackathon_db6|geometry_idx
- |hackathon_db6|bids_by_creation_time
- ## statement_performance_analyzer
- |db|query|full_scan|exec_counts|max_latency|avg_latency|rows_sent_avgs|rows_examined_avgs|last_seen_|digest|
- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
- |hackathon_db16|INSERT INTO `track` VALUES (...) /* , ... */ ||1|511.81 ms|511.81 ms|0|0|2019-04-11 09:31:44|cadeb8b0a4bd74fd448bf1cf324f26ce
- |hackathon_db16|ALTER TABLE `users` ADD COLUMN ... x` INTEGER NOT NULL DEFAULT ? ||2|43.56 ms|21.86 ms|0|0|2019-04-13 17:39:09|c7480d4358e77cb8ba044f26618126f0
- |hackathon_db16|INSERT INTO `track_ganres` VALUES (...) /* , ... */ ||1|23.83 s|23.83 s|0|0|2019-04-11 09:32:09|3ed4655facd1182798d350a2eb5edbf4
- |hackathon_db6|CREATE TABLE `catalog_services ... EFAULT CHARACTER SET = `utf8` ||3|73.33 ms|68.80 ms|0|0|2019-04-13 21:00:58|b8f6601beb9abd677ce727d01f3c9a37
- |hackathon_db6|CREATE TABLE `service_bids` ( ... EFAULT CHARACTER SET = `utf8` ||3|18.46 ms|17.10 ms|0|0|2019-04-13 21:00:58|8b9270ed746347e93f6d352f94a5bd95
- |hackathon_db6|CREATE TABLE `catalog_services ... EFAULT CHARACTER SET = `utf8` ||1|65.98 ms|65.98 ms|0|0|2019-04-14 08:37:20|507b0c9068d6fabfdefc758c2c131c68
- |hackathon_db6|CREATE TABLE `service_bids` ( ... EFAULT CHARACTER SET = `utf8` ||1|17.84 ms|17.84 ms|0|0|2019-04-14 08:37:20|269bfdbeeba53f6514f680574eb715ce
- |hackathon_db25|CREATE TABLE `produced_message ... LESS THAN ( `TO_DAYS` (?) ) ) ||1|93.89 ms|93.89 ms|0|0|2019-04-11 14:41:14|eadd1cf6d0cb2a577773433317f750f8
- |hackathon_db25|CREATE TABLE `consumed_message ... LESS THAN ( `TO_DAYS` (?) ) ) ||1|90.79 ms|90.79 ms|0|0|2019-04-11 15:24:12|f40efa04383c3ae6f19384721775d42e
- |hackathon_db6|CREATE TABLE `service_bids` ( ... EFAULT CHARACTER SET = `utf8` ||1|16.74 ms|16.74 ms|0|0|2019-04-14 15:21:38|1575b6b937a6e0e9ae8ba8f706b650d4
- |hackathon_db6|ALTER TABLE `catalog_services` ... ( `category_id` , `aliases` ) ||1|62.00 ms|62.00 ms|0|0|2019-04-14 16:37:06|204cddb4c08b6103d4ab72f8dd6d449e
- |hackathon_db6|ALTER TABLE `catalog_services` ... name_fulltext_idx` ( `name` ) ||1|55.97 ms|55.97 ms|0|0|2019-04-14 16:37:06|77c1612cf8e509c7c9bf5b6d0b7c4ad4
- |hackathon_db26|CREATE FULLTEXT INDEX `fulltext` ON `people` ( `search` ) ||1|72.80 ms|72.80 ms|0|0|2019-04-12 12:27:45|a4e90e0a4f366cbc60862eddc6546813
- |hackathon_db26|CREATE FULLTEXT INDEX `fulltext` ON `rooms` ( `search` ) ||1|71.88 ms|71.88 ms|0|0|2019-04-12 12:27:45|efd7cd38d5ea33620fc720c34b0fafaf
- |hackathon_db26|CREATE FULLTEXT INDEX `fulltext` ON `teams` ( `search` ) ||1|71.13 ms|71.13 ms|0|0|2019-04-12 12:27:45|9cdbe55f8da40654b5a9ca14287c4a56
- |hackathon_db16|INSERT INTO `album` VALUES (...) /* , ... */ ||1|646.51 ms|646.51 ms|0|0|2019-04-11 09:31:37|fe00bfda03d394f22692377969c727e8
- |hackathon_db16|INSERT INTO `album_ganres` VALUES (...) /* , ... */ ||1|204.31 ms|204.31 ms|0|0|2019-04-11 09:31:39|55ef28bebfa054625a4746e9f1b7b2c4
- |hackathon_db16|INSERT INTO `family_ganres` VALUES (...) /* , ... */ ||1|17.18 ms|17.18 ms|0|0|2019-04-11 09:31:40|843c86c7418023b7bcf9718bb097275a
- |hackathon_db16|SELECT COUNT ( `track_id` ) AS ... iked` != - ? AND `u_id` = ? ) |*|200|183.75 ms|70.58 ms|1|8381|2019-04-14 17:09:52|579fe31324ebc8247f43f4662c7d91d2
- |hackathon_db16|SELECT `track_id` AS `trackId` ... AND `u_id` = ? ) LIMIT ?, ... |*|198|93.59 ms|33.11 ms|1|4144|2019-04-14 17:09:52|613095a00302ea18921ae6e013b3c5f5
- |sys|SELECT COUNT (?) AS `cnt` , `r ... _by_digest` GROUP BY `avg_us` |*|8|116.26 ms|75.62 ms|21|8554|2019-04-14 13:05:13|c98129e1a0b983f2d50cbb70da172a78
- |hackathon_db25|SELECT * FROM `produced_messages` WHERE `topic` = ? |*|253|2.54 s|2.18 s|40|4014949|2019-04-14 17:06:51|386356f797a39dee3923a94b3ca9062b
- |hackathon_db25|SELECT * FROM `consumed_messages` WHERE `topic` = ? |*|253|2.66 s|2.21 s|350|3846178|2019-04-14 17:06:53|9655bf6974aa1e3cf09de7973a8d25b5
- |hackathon_db25|SELECT * FROM `produced_messages` WHERE `message_id` = ? |*|4|2.16 s|2.16 s|0|4018700|2019-04-14 16:31:06|f2d2e0da417290596a81cc8fa6f13d2a
- |hackathon_db25|SELECT * FROM `produced_messages` WHERE `topic` = ? LIMIT ? |*|3|2.18 s|2.13 s|3|3936356|2019-04-14 17:08:38|b00c453e190f31412fac0c72009f2fb2
- |hackathon_db25|SELECT DISTINCTROW `topic` FROM `produced_messages` |*|1|10.59 s|10.59 s|37|4032957|2019-04-14 17:07:38|b58600d33d937c12e4f8dd80961db9cc
- ## statement_performance_analyzer
- |db|query|full_scan|exec_counts|max_latency|avg_latency|rows_sent_avgs|rows_examined_avgs|last_seen_|digest|
- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
- |hackathon_db16|INSERT INTO `track` VALUES (...) /* , ... */ ||1|511.81 ms|511.81 ms|0|0|2019-04-11 09:31:44|cadeb8b0a4bd74fd448bf1cf324f26ce
- |hackathon_db16|ALTER TABLE `users` ADD COLUMN ... x` INTEGER NOT NULL DEFAULT ? ||2|43.56 ms|21.86 ms|0|0|2019-04-13 17:39:09|c7480d4358e77cb8ba044f26618126f0
- |hackathon_db16|INSERT INTO `track_ganres` VALUES (...) /* , ... */ ||1|23.83 s|23.83 s|0|0|2019-04-11 09:32:09|3ed4655facd1182798d350a2eb5edbf4
- |hackathon_db6|CREATE TABLE `catalog_services ... EFAULT CHARACTER SET = `utf8` ||3|73.33 ms|68.80 ms|0|0|2019-04-13 21:00:58|b8f6601beb9abd677ce727d01f3c9a37
- |hackathon_db6|CREATE TABLE `service_bids` ( ... EFAULT CHARACTER SET = `utf8` ||3|18.46 ms|17.10 ms|0|0|2019-04-13 21:00:58|8b9270ed746347e93f6d352f94a5bd95
- |hackathon_db6|CREATE TABLE `catalog_services ... EFAULT CHARACTER SET = `utf8` ||1|65.98 ms|65.98 ms|0|0|2019-04-14 08:37:20|507b0c9068d6fabfdefc758c2c131c68
- |hackathon_db6|CREATE TABLE `service_bids` ( ... EFAULT CHARACTER SET = `utf8` ||1|17.84 ms|17.84 ms|0|0|2019-04-14 08:37:20|269bfdbeeba53f6514f680574eb715ce
- |hackathon_db25|CREATE TABLE `produced_message ... LESS THAN ( `TO_DAYS` (?) ) ) ||1|93.89 ms|93.89 ms|0|0|2019-04-11 14:41:14|eadd1cf6d0cb2a577773433317f750f8
- |hackathon_db25|CREATE TABLE `consumed_message ... LESS THAN ( `TO_DAYS` (?) ) ) ||1|90.79 ms|90.79 ms|0|0|2019-04-11 15:24:12|f40efa04383c3ae6f19384721775d42e
- |hackathon_db6|CREATE TABLE `service_bids` ( ... EFAULT CHARACTER SET = `utf8` ||1|16.74 ms|16.74 ms|0|0|2019-04-14 15:21:38|1575b6b937a6e0e9ae8ba8f706b650d4
- |hackathon_db6|ALTER TABLE `catalog_services` ... ( `category_id` , `aliases` ) ||1|62.00 ms|62.00 ms|0|0|2019-04-14 16:37:06|204cddb4c08b6103d4ab72f8dd6d449e
- |hackathon_db6|ALTER TABLE `catalog_services` ... name_fulltext_idx` ( `name` ) ||1|55.97 ms|55.97 ms|0|0|2019-04-14 16:37:06|77c1612cf8e509c7c9bf5b6d0b7c4ad4
- |hackathon_db26|CREATE FULLTEXT INDEX `fulltext` ON `people` ( `search` ) ||1|72.80 ms|72.80 ms|0|0|2019-04-12 12:27:45|a4e90e0a4f366cbc60862eddc6546813
- |hackathon_db26|CREATE FULLTEXT INDEX `fulltext` ON `rooms` ( `search` ) ||1|71.88 ms|71.88 ms|0|0|2019-04-12 12:27:45|efd7cd38d5ea33620fc720c34b0fafaf
- |hackathon_db26|CREATE FULLTEXT INDEX `fulltext` ON `teams` ( `search` ) ||1|71.13 ms|71.13 ms|0|0|2019-04-12 12:27:45|9cdbe55f8da40654b5a9ca14287c4a56
- |hackathon_db16|INSERT INTO `album` VALUES (...) /* , ... */ ||1|646.51 ms|646.51 ms|0|0|2019-04-11 09:31:37|fe00bfda03d394f22692377969c727e8
- |hackathon_db16|INSERT INTO `album_ganres` VALUES (...) /* , ... */ ||1|204.31 ms|204.31 ms|0|0|2019-04-11 09:31:39|55ef28bebfa054625a4746e9f1b7b2c4
- |hackathon_db16|INSERT INTO `family_ganres` VALUES (...) /* , ... */ ||1|17.18 ms|17.18 ms|0|0|2019-04-11 09:31:40|843c86c7418023b7bcf9718bb097275a
- |hackathon_db16|SELECT COUNT ( `track_id` ) AS ... iked` != - ? AND `u_id` = ? ) |*|200|183.75 ms|70.58 ms|1|8381|2019-04-14 17:09:52|579fe31324ebc8247f43f4662c7d91d2
- |hackathon_db16|SELECT `track_id` AS `trackId` ... AND `u_id` = ? ) LIMIT ?, ... |*|198|93.59 ms|33.11 ms|1|4144|2019-04-14 17:09:52|613095a00302ea18921ae6e013b3c5f5
- |sys|SELECT COUNT (?) AS `cnt` , `r ... _by_digest` GROUP BY `avg_us` |*|8|116.26 ms|75.62 ms|21|8554|2019-04-14 13:05:13|c98129e1a0b983f2d50cbb70da172a78
- |hackathon_db25|SELECT * FROM `produced_messages` WHERE `topic` = ? |*|253|2.54 s|2.18 s|40|4014949|2019-04-14 17:06:51|386356f797a39dee3923a94b3ca9062b
- |hackathon_db25|SELECT * FROM `consumed_messages` WHERE `topic` = ? |*|253|2.66 s|2.21 s|350|3846178|2019-04-14 17:06:53|9655bf6974aa1e3cf09de7973a8d25b5
- |hackathon_db25|SELECT * FROM `produced_messages` WHERE `message_id` = ? |*|4|2.16 s|2.16 s|0|4018700|2019-04-14 16:31:06|f2d2e0da417290596a81cc8fa6f13d2a
- |hackathon_db25|SELECT * FROM `produced_messages` WHERE `topic` = ? LIMIT ? |*|3|2.18 s|2.13 s|3|3936356|2019-04-14 17:08:38|b00c453e190f31412fac0c72009f2fb2
- |hackathon_db25|SELECT DISTINCTROW `topic` FROM `produced_messages` |*|1|10.59 s|10.59 s|37|4032957|2019-04-14 17:07:38|b58600d33d937c12e4f8dd80961db9cc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement