X   Сообщение сайта
(Сообщение закроется через 3 секунды)



 

Здравствуйте, гость (

| Вход | Регистрация )

Открыть тему
Тема закрыта
> Оптимизация разгрузка БД
blood_ghost
blood_ghost
Topic Starter сообщение 15.3.2019, 21:51; Ответить: blood_ghost
Сообщение #1


Всем привет не знаю туда ли пишу.
Нужна помощь в оптимизации базы данных. Нужна помощь в снижении нагрузки на БД.

вот лог от провайдера

Развернуть/Свернуть


# A software update is available:
# * The current version for Percona::Toolkit is 3.0.5

Reading from STDIN ...

# 40.8s user time, 3.7s system time, 31.59M rss, 111.55M vsz
# Current date: Wed Nov 7 23:19:25 2018
# Hostname: sirius.beget.ru
# Files: STDIN
# Overall: 4.72k total, 38 unique, 0.37 QPS, 0.71x concurrency ___________
# Time range: 2018-11-07T19:48:01 to 2018-11-07T23:19:14
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 8962s 100ms 14s 2s 11s 4s 100ms
# Lock time 0 0 0 0 0 0 0
# Query size 704.70k 36 380 153.01 346.17 103.22 97.36
# id 145.82G 31.48M 31.75M 31.66M 31.49M 113.70k 31.49M

# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== =============== ===== ====== ===== =============
# 1 0xB8322890B1EB6660 4585.3908 51.2% 529 8.6680 1.46 SELECT wp_posts wp_term_relationships
# 2 0xDEFFA9D48665E302 2066.6301 23.1% 236 8.7569 1.04 SELECT wp_posts wp_term_relationships
# 3 0xCCE67731826095F5 1832.5373 20.4% 223 8.2177 1.58 SELECT wp_posts wp_term_relationships
# 4 0x7D18C5C503757896 154.2686 1.7% 1423 0.1084 0.06 SELECT wp_postmeta
# MISC 0xMISC 322.8045 3.6% 2305 0.1400 0.0 <34 ITEMS>

# Query 1: 0.04 QPS, 0.36x concurrency, ID 0xB8322890B1EB6660 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 1.46
# Time range: 2018-11-07T19:48:01 to 2018-11-07T23:19:12
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 11 529
# Exec time 51 4585s 101ms 14s 9s 13s 4s 10s
# Lock time 0 0 0 0 0 0 0 0
# Query size 23 168.95k 322 332 327.04 329.68 5 313.99
# id 11 16.36G 31.48M 31.75M 31.66M 31.49M 94.24k 31.49M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ######
# 1s #####################################################
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_posts'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_posts`\G
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_term_relationships'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_term_relationships`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (1,4,5,6,7,8)
) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 5\G

# Query 2: 0.02 QPS, 0.16x concurrency, ID 0xDEFFA9D48665E302 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 1.04
# Time range: 2018-11-07T19:48:35 to 2018-11-07T23:18:50
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 5 236
# Exec time 23 2067s 100ms 12s 9s 11s 3s 10s
# Lock time 0 0 0 0 0 0 0 0
# Query size 10 72.83k 316 316 316 316 0 316
# id 5 7.30G 31.48M 31.75M 31.67M 31.49M 99.74k 31.49M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ###
# 1s #################################################
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_posts'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_posts`\G
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_term_relationships'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_term_relationships`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (4,5,6,7,8)
) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY RAND() LIMIT 0, 12\G

# Query 3: 0.02 QPS, 0.15x concurrency, ID 0xCCE67731826095F5 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 1.58
# Time range: 2018-11-07T19:48:13 to 2018-11-07T23:18:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 223
# Exec time 20 1833s 201ms 12s 8s 11s 4s 10s
# Lock time 0 0 0 0 0 0 0 0
# Query size 10 76.83k 350 355 352.79 346.17 0 346.17
# id 4 6.90G 31.48M 31.75M 31.67M 31.49M 141.25k 31.49M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ##############
# 1s ############################################
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_posts'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_posts`\G
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_term_relationships'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_term_relationships`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID NOT IN (30559) AND (
wp_term_relationships.term_taxonomy_id IN (8)
) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 3\G

# Query 4: 0.11 QPS, 0.01x concurrency, ID 0x7D18C5C503757896 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.06
# Time range: 2018-11-07T19:48:13 to 2018-11-07T23:19:14
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 30 1423
# Exec time 1 154s 100ms 1s 108ms 100ms 82ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 20 141.21k 95 165 101.62 136.99 12.52 97.36
# id 30 44.00G 31.48M 31.75M 31.66M 31.49M 114.81k 31.49M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_postmeta'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_postmeta`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (96686) ORDER BY meta_id ASC\G

# A software update is available:
# * The current version for Percona::Toolkit is 3.0.5

Reading from STDIN ...

# 37s user time, 3.8s system time, 30.92M rss, 110.85M vsz
# Current date: Tue Feb 19 16:06:26 2019
# Hostname: sirius.beget.ru
# Files: STDIN
# Overall: 147 total, 16 unique, 0.01 QPS, 0.00x concurrency _____________
# Time range: 2019-02-19T12:09:40 to 2019-02-19T15:51:19
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 18s 100ms 1s 123ms 198ms 106ms 100ms
# Lock time 0 0 0 0 0 0 0
# Query size 29.82k 25 353 207.76 346.17 128.33 313.99
# id 7.02G 48.80M 49.13M 48.92M 48.85M 169.42k 48.85M

# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============= ===== ====== ===== ===============
# 1 0xB8322890B1EB6660 4.5342 25.0% 41 0.1106 0.01 SELECT wp_posts wp_term_relationships
# 2 0x9FE96489A777ECF1 3.5218 19.4% 33 0.1067 0.01 SHOW DATABASES
# 3 0xDEFFA9D48665E302 2.8113 15.5% 16 0.1757 0.26 SELECT wp_posts wp_term_relationships
# 4 0x677B9CAE22F23CF7 2.4117 13.3% 15 0.1608 0.31 SELECT wp_posts
# 5 0xCCE67731826095F5 1.1101 6.1% 9 0.1233 0.01 SELECT wp_posts wp_term_relationships
# 6 0xB20CD8AD00C4242A 1.1061 6.1% 7 0.1580 0.01 SELECT wp_posts wp_term_relationships
# 7 0x7FCEAD054C629A84 0.6027 3.3% 6 0.1005 0.00 SHOW OPEN TABLES
# 8 0x7EDD67F850C9495A 0.5023 2.8% 5 0.1005 0.00 SELECT wp_posts
# 9 0xFCE5A41B9E0C2B28 0.3032 1.7% 3 0.1011 0.00 SELECT wp_posts
# 10 0x30DA85C940E0D491 0.3029 1.7% 3 0.1010 0.00 SELECT wp_posts
# 11 0x7D18C5C503757896 0.3024 1.7% 3 0.1008 0.00 SELECT wp_postmeta
# MISC 0xMISC 0.6040 3.3% 6 0.1007 0.0 <5 ITEMS>

# Query 1: 0.00 QPS, 0.00x concurrency, ID 0xB8322890B1EB6660 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2019-02-19T12:13:09 to 2019-02-19T15:51:18
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 27 41
# Exec time 25 5s 100ms 202ms 111ms 198ms 29ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 43 13.09k 322 332 326.93 329.68 5 313.99
# id 27 1.96G 48.80M 49.13M 48.97M 48.85M 166.94k 48.85M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_posts'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_posts`\G
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_term_relationships'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_term_relationships`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (8)
) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 3\G

# Query 2: 0.05 QPS, 0.01x concurrency, ID 0x9FE96489A777ECF1 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2019-02-19T12:09:40 to 2019-02-19T12:19:55
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 22 33
# Exec time 19 4s 100ms 201ms 107ms 100ms 23ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 3 1.03k 25 40 31.82 38.53 5.91 31.70
# id 22 1.57G 48.80M 48.81M 48.80M 46.53M 0 46.53M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
SHOW DATABASES LIKE 'performance_schema'\G

# Query 3: 0.00 QPS, 0.00x concurrency, ID 0xDEFFA9D48665E302 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.26
# Time range: 2019-02-19T12:13:10 to 2019-02-19T15:51:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 10 16
# Exec time 15 3s 100ms 1s 176ms 198ms 215ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 16 4.94k 316 316 316 316 0 316
# id 10 783.69M 48.80M 49.13M 48.98M 48.85M 166.94k 48.85M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ####
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_posts'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_posts`\G
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_term_relationships'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_term_relationships`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (4,5,6,7,8)
) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY RAND() LIMIT 0, 12\G

# Query 4: 0.00 QPS, 0.00x concurrency, ID 0x677B9CAE22F23CF7 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.31
# Time range: 2019-02-19T12:13:10 to 2019-02-19T15:51:18
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 10 15
# Exec time 13 2s 100ms 1s 161ms 100ms 222ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 8 2.47k 168 169 168.60 166.51 0 166.51
# id 10 734.86M 48.80M 49.13M 48.99M 48.85M 166.94k 48.85M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s ####
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_posts'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_posts`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.comment_count DESC LIMIT 0, 3\G

# Query 5: 0.00 QPS, 0.00x concurrency, ID 0xCCE67731826095F5 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2019-02-19T14:16:19 to 2019-02-19T15:21:03
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 6 9
# Exec time 6 1s 100ms 202ms 123ms 198ms 41ms 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 10 3.10k 352 353 352.56 346.17 0 346.17
# id 6 441.21M 48.98M 49.08M 49.02M 48.85M 0 48.85M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_posts'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_posts`\G
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_term_relationships'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_term_relationships`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID NOT IN (8829) AND (
wp_term_relationships.term_taxonomy_id IN (8)
) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 3\G

# Query 6: 0.00 QPS, 0.00x concurrency, ID 0xB20CD8AD00C4242A at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2019-02-19T12:13:10 to 2019-02-19T15:51:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 7
# Exec time 6 1s 100ms 201ms 158ms 198ms 49ms 198ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 7 2.27k 332 332 332 332 0 332
# id 4 342.39M 48.80M 49.13M 48.91M 48.85M 166.94k 46.53M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_posts'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_posts`\G
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_term_relationships'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_term_relationships`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (4,5,6,7,8)
) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 8\G

# Query 7: 0.01 QPS, 0.00x concurrency, ID 0x7FCEAD054C629A84 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2019-02-19T12:10:30 to 2019-02-19T12:19:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 6
# Exec time 3 603ms 100ms 100ms 100ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 1 306 51 51 51 51 0 51
# id 4 292.81M 48.80M 48.81M 48.80M 46.53M 0 46.53M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'tyttui_ntc'\G
# SHOW CREATE TABLE `tyttui_ntc`.`tyttui_ntc`\G
SHOW OPEN TABLES FROM `tyttui_ntc` WHERE In_use > 0\G

# Query 8: 0.00 QPS, 0.00x concurrency, ID 0x7EDD67F850C9495A at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2019-02-19T12:13:09 to 2019-02-19T15:51:18
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 3 5
# Exec time 2 502ms 100ms 100ms 100ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 2 905 181 181 181 181 0 181
# id 3 244.75M 48.80M 49.13M 48.95M 48.85M 166.94k 48.85M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_posts'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_posts`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 1\G

# Query 9: 0.00 QPS, 0.00x concurrency, ID 0xFCE5A41B9E0C2B28 at byte 0 __
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2019-02-19T12:13:10 to 2019-02-19T12:28:43
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 3
# Exec time 1 303ms 101ms 101ms 101ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 2 642 214 214 214 214 0 214
# id 2 146.44M 48.80M 48.82M 48.81M 46.53M 0 46.53M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_posts'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_posts`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID NOT IN (95758) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 3\G

# Query 10: 0.00 QPS, 0.00x concurrency, ID 0x30DA85C940E0D491 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2019-02-19T12:13:10 to 2019-02-19T14:16:20
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 3
# Exec time 1 303ms 101ms 101ms 101ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 0 139 46 47 46.33 46.83 0.50 44.60
# id 2 146.59M 48.80M 48.98M 48.86M 48.85M 90.43k 46.53M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_posts'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_posts`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM wp_posts WHERE ID = 1856 LIMIT 1\G

# Query 11: 0.00 QPS, 0.00x concurrency, ID 0x7D18C5C503757896 at byte 0 _
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2019-02-19T12:21:37 to 2019-02-19T14:47:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 3
# Exec time 1 302ms 100ms 101ms 101ms 100ms 0 100ms
# Lock time 0 0 0 0 0 0 0 0
# Query size 0 297 99 99 99 99 0 99
# id 2 146.76M 48.81M 49.03M 48.92M 48.85M 109.90k 48.85M
# String:
# Databases tyttui_ntc
# Hosts localhost
# Users tyttui_ntc
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tyttui_ntc` LIKE 'wp_postmeta'\G
# SHOW CREATE TABLE `tyttui_ntc`.`wp_postmeta`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (76317) ORDER BY meta_id ASC\G



Замечание модератора:
Эта тема была закрыта автоматически ввиду отсутствия активности в ней на протяжении 100+ дней.
Если Вы считаете ее актуальной и хотите оставить сообщение, то воспользуйтесь кнопкой
или обратитесь к любому из модераторов.
0
Вернуться в начало страницы
 
Ответить с цитированием данного сообщения
Открыть тему
Тема закрыта
1 чел. читают эту тему (гостей: 1, скрытых пользователей: 0)
Пользователей: 0


Свернуть

> Похожие темы

  Тема Ответов Автор Просмотров Последний ответ
Горячая тема (нет новых ответов) Оптимизация сайтов, продвижение, наращивание ссылок
Большой опыт работы, отзывы
304 tario777 203587 13.3.2024, 14:01
автор: tario777
Горячая тема (нет новых ответов) Тема имеет прикрепленные файлыВерстка/Натяжка/Оптимизация/Увеличение функционала шаблонов на WP
Разработка на профессиональном уровне
144 Gerga 92197 11.3.2024, 19:59
автор: anchous
Открытая тема (нет новых ответов) Оптимизация сайтов, продвижение, наращивание ссылок. Большой опыт работы
2 BurzhuyXXi 1991 25.2.2023, 14:37
автор: BurzhuyXXi
Открытая тема (нет новых ответов) Тема имеет прикрепленные файлыГрамотная внутренняя оптимизация сайтов (SEO - Seach Engines Optimization) + Накрутка ПФ
Работу выполняю качественно и с любовью (Недорого + Скидки)
11 WebSniper 6928 1.2.2023, 13:58
автор: маяк
Горячая тема (нет новых ответов) WordPress: ускорение, защита, оптимизация
35 wp01 20065 9.11.2022, 14:24
автор: wp01


 



RSS Текстовая версия Сейчас: 26.4.2024, 10:22
Дизайн