个人中心
文章发布
退出
作者热门文章
- html - 出于某种原因，IE8 对我的 Sass 文件中继承的 html5 CSS 不友好？
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景？
25
4
谁能帮忙解释一下以下日志:
MariaDB [(none)]> show full processlist;
+--------+----------------+-----------------+---------------------+---------+-----
| 3 | user-rw | localhost | bets-stage | Sleep | 51 | | NULL | 0.000 |
| 11 | user-rw | localhost | bets-stage | Sleep | 39 | | NULL | 0.000 |
| 13 | db1029865-news | localhost | db1029865-sportnews | Query | 30 | Writing to net | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 17 | db1029865-news | localhost | db1029865-sportnews | Query | 20 | Writing to net | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 34 | db1029865-news | localhost | db1029865-sportnews | Query | 3 | Sorting result | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 37 | db1029865-news | localhost | db1029865-sportnews | Sleep | 31 | | NULL | 0.000 |
| 39 | user-rw | localhost | bets-stage | Sleep | 77 | | NULL | 0.000 |
| 40 | db1029865-news | localhost | db1029865-sportnews | Query | 16 | Writing to net | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 41 | user-rw | localhost | bets-stage | Sleep | 43 | | NULL | 0.000 |
| 49 | db1029865-news | localhost | db1029865-sportnews | Query | 24 | Writing to net | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 52 | db1029865-news | localhost | db1029865-sportnews | Sleep | 36 | | NULL | 0.000 |
| 53 | db1029865-news | localhost | db1029865-sportnews | Query | 26 | Writing to net | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 54 | db1029865-news | localhost | db1029865-sportnews | Query | 1 | Copying to tmp table | SELECT `post`.*, `post`.`team1_seourl` AS `team1seourl`, `post`.`team1_seourl` AS `teamseourl`, `post`.`team2_seourl` AS `team2seourl`, IF(`temp_tn1uid`.`value` > 0, `post`.`team1_uid`, NULL) AS `tn1uid`, IF(`temp_tn2uid`.`value` > 0, `post`.`team2_uid`, NULL) AS `tn2uid` FROM (SELECT `post`.*, `post_j`.`title`, `post_j`.`teaser` FROM (SELECT `post`.* FROM `sportnews_cache_post_team` AS `post` FORCE INDEX(`sort_index`) JOIN (SELECT `cache_uid` FROM `sportnews_cache_post_team` AS `post` WHERE (`post`.`team1_uid` = 4894 OR `post`.`team2_uid` = 4894) GROUP BY `post`.`uid` ORDER BY `post`.`cache_uid` LIMIT 40 OFFSET 0) AS `post_j` ON `post`.`cache_uid` = `post_j`.`cache_uid`) AS `post` JOIN `sportnews_post` AS `post_j` ON `post_j`.`uid` = `post`.`uid`) AS `post` LEFT JOIN (SELECT `uid`, COUNT(*) AS `value` FROM `sportnews_cache_post_team` AS `post` FORCE INDEX(`sort_index`) WHERE `post`.`team1_uid` = 4894 GROUP BY `post`.`uid`) AS `temp_tn1uid` ON `temp_tn1uid`.`uid` = `post`.`uid` LEFT JOIN (SELECT `uid`, COUNT(*) AS `value` FROM `sportnews_cache_post_team` AS `post` FORCE INDEX(`sort_index`) WHERE `post`.`team2_uid` = 4894 GROUP BY `post`.`uid`) AS `temp_tn2uid` ON `temp_tn2uid`.`uid` = `post`.`uid` | 0.000 |
| 57 | db1029865-news | localhost | db1029865-sportnews | Sleep | 22 | | NULL | 0.000 |
| 75 | user-rw | localhost | bets-stage | Sleep | 32 | | NULL | 0.000 |
| 77 | db1029865-news | localhost | db1029865-sportnews | Sleep | 6 | | NULL | 0.000 |
| 78 | db1029865-news | localhost | db1029865-sportnews | Sleep | 15 | | NULL | 0.000 |
| 79 | db1029865-news | localhost | db1029865-sportnews | Sleep | 3 | | NULL | 0.000 |
| 88 | db1029865-news | localhost | db1029865-sportnews | Query | 18 | Writing to net | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 99 | db1029865-news | localhost | db1029865-sportnews | Sleep | 39 | | NULL | 0.000 |
| 100 | db1029865-news | localhost | db1029865-sportnews | Query | 1 | Sorting result | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 110 | db1029865-news | localhost | db1029865-sportnews | Query | 32 | Writing to net | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 117 | db1029865-news | localhost | db1029865-sportnews | Sleep | 9 | | NULL | 0.000 |
| 119 | user-rw | localhost | bets-stage | Sleep | 70 | | NULL | 0.000 |
| 137 | user-rw | localhost | bets-stage | Sleep | 34 | | NULL | 0.000 |
| 138 | db1029865-news | localhost | db1029865-sportnews | Query | 28 | Sending data | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 160 | user-rw | localhost | bets-stage | Sleep | 40 | | NULL | 0.000 |
| 162 | user-rw | localhost | bets-stage | Sleep | 27 | | NULL | 0.000 |
| 189 | user-rw | localhost | bets-stage | Sleep | 19 | | NULL | 0.000 |
| 208 | user-rw | localhost | bets-stage | Sleep | 56 | | NULL | 0.000 |
| 218 | db1029865-news | localhost | db1029865-sportnews | Query | 22 | Writing to net | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 219 | user-rw | localhost | bets-stage | Sleep | 3 | | NULL | 0.000 |
| 274 | user-rw | localhost | bets-stage | Sleep | 20 | | NULL | 0.000 |
| 301 | user-rw | localhost | bets-stage | Sleep | 30 | | NULL | 0.000 |
| 302 | user-rw | localhost | bets-stage | Sleep | 2 | | NULL | 0.000 |
| 356 | user-rw | localhost | bets-stage | Sleep | 36 | | NULL | 0.000 |
| 435 | user-rw | localhost | bets-stage | Sleep | 55 | | NULL | 0.000 |
| 511 | user-rw | localhost | bets-stage | Sleep | 59 | | NULL | 0.000 |
| 2007 | user-rw | localhost | bets-stage | Sleep | 61 | | NULL | 0.000 |
| 606299 | db1029865-news | localhost:34857 | db1029865-sportnews | Sleep | 60 | | NULL | 0.000 |
| 606300 | db1029865-news | localhost:34860 | db1029865-sportnews | Sleep | 60 | | NULL | 0.000 |
| 606438 | db1029865-news | localhost:34940 | db1029865-sportnews | Sleep | 91 | | NULL | 0.000 |
| 606439 | db1029865-news | localhost:34941 | db1029865-sportnews | Sleep | 3 | | NULL | 0.000 |
| 610631 | user-rw | localhost:35813 | sportnews-stage | Sleep | 177 | | NULL | 0.000 |
| 611528 | db1029865-news | localhost:36298 | db1029865-sportnews | Query | 10 | Writing to net | SELECT /*!40001 SQL_NO_CACHE */ * FROM `sportnews_log` | 0.000 |
| 612224 | root | localhost | NULL | Query | 0 | NULL | show full processlist | 0.000 |
+--------+----------------+-----------------+---------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+
47 rows in set (0.00 sec)
| 13 | db1029865-news | localhost | db1029865-sportnews | Query | 24 | Writing to net | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 17 | db1029865-news | localhost | db1029865-sportnews | Query | 21 | Sending data | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 34 | db1029865-news | localhost | db1029865-sportnews | Query | 10 | Sorting result | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 37 | db1029865-news | localhost | db1029865-sportnews | Query | 6 | Sorting result | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 39 | user-rw | localhost | bets-stage | Sleep | 38 | | NULL | 0.000 |
| 40 | db1029865-news | localhost | db1029865-sportnews | Query | 21 | Sending data | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 41 | user-rw | localhost | bets-stage | Sleep | 139 | | NULL | 0.000 |
| 49 | db1029865-news | localhost | db1029865-sportnews | Query | 25 | Sending data | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 52 | db1029865-news | localhost | db1029865-sportnews | Query | 8 | Sorting result | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 53 | db1029865-news | localhost | db1029865-sportnews | Query | 20 | Writing to net | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 54 | db1029865-news | localhost | db1029865-sportnews | Query | 7 | Sorting result | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 57 | db1029865-news | localhost | db1029865-sportnews | Sleep | 48 | | NULL | 0.000 |
| 75 | user-rw | localhost | bets-stage | Sleep | 33 | | NULL | 0.000 |
| 77 | db1029865-news | localhost | db1029865-sportnews | Query | 28 | Sending data | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 78 | db1029865-news | localhost | db1029865-sportnews | Sleep | 29 | | NULL | 0.000 |
| 79 | db1029865-news | localhost | db1029865-sportnews | Sleep | 6 | | NULL | 0.000 |
| 88 | db1029865-news | localhost | db1029865-sportnews | Query | 14 | Sorting result | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 99 | db1029865-news | localhost | db1029865-sportnews | Query | 10 | Sorting result | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 100 | db1029865-news | localhost | db1029865-sportnews | Query | 13 | Sorting result | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 110 | db1029865-news | localhost | db1029865-sportnews | Sleep | 4 | | NULL | 0.000 |
| 117 | db1029865-news | localhost | db1029865-sportnews | Query | 34 | Sending data | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 119 | user-rw | localhost | bets-stage | Sleep | 10 | | NULL | 0.000 |
| 137 | user-rw | localhost | bets-stage | Sleep | 24 | | NULL | 0.000 |
| 138 | db1029865-news | localhost | db1029865-sportnews | Query | 31 | Sending data | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
ORDER BY `created_on` desc | 0.000 |
| 160 | user-rw | localhost | bets-stage | Sleep | 260 | | NULL | 0.000 |
| 162 | user-rw | localhost | bets-stage | Sleep | 136 | | NULL | 0.000 |
| 189 | user-rw | localhost | bets-stage | Sleep | 14 | | NULL | 0.000 |
| 208 | user-rw | localhost | bets-stage | Sleep | 10 | | NULL | 0.000 |
| 218 | db1029865-news | localhost | db1029865-sportnews | Query | 24 | Sending data | SELECT `detail`, UNIX_TIMESTAMP(created_on) AS created_on
FROM (`sportnews_log`)
WHERE `severity` = 'info'
AND `source` = 'crawler'
最佳答案
正如少数用户评论的那样，需要更多信息才能了解确切的问题。
从您提供的进程列表输出中可以看出，您的许多查询都停留在“写入网络”状态 20-30 秒范围内。这意味着要么您的选择查询返回大量数据并需要很长时间才能将数据包写入网络，要么您的网络速度缓慢/受到其他进程的限制并导致 mysql 输出缓慢。
如果任何页面正在使用这些查询，他们将在 20-30 秒内无法获取结果(相当于网站关闭)
关于php - 网站宕机，无法理解网络服务器进程日志？，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/29847101/
25
4
0
我试图理解 (>>=).(>>=) ，GHCi 告诉我的是: (>>=) :: Monad m => m a -> (a -> m b) -> m b (>>=).(>>=) :: Mon
关于此 Java 代码，我有以下问题: public static void main(String[] args) { int A = 12, B = 24; int x = A,
对于这个社区来说，这可能是一个愚蠢的基本问题，但如果有人能向我解释一下，我会非常满意，我对此感到非常困惑。我在网上找到了这个教程，这是一个例子。 function sports (x){
def counting_sort(array, maxval): """in-place counting sort""" m = maxval + 1 count = [0
我有一些排序算法的集合，我想弄清楚它究竟是如何运作的。 我对一些说明有些困惑，特别是 cmp 和 jle 说明，所以我正在寻求帮助。此程序集对包含三个元素的数组进行排序。 0.00 :
阅读 PHP.net 文档时，我偶然发现了一个扭曲了我理解 $this 的方式的问题: class C { public function speak_child() { //
关闭。这个问题不满足Stack Overflow guidelines .它目前不接受答案。 想改善这个问题吗？更新问题，使其成为 on-topic对于堆栈溢出。 7年前关闭。 Improve thi
我有几个关于 pragmas 的相关问题.让我开始这一系列问题的原因是试图确定是否可以禁用某些警告而不用一直到 no worries。 (我还是想担心，至少有点担心!)。我仍然对那个特定问题的答案感兴
我正在尝试构建 CNN使用 Torch 7 .我对 Lua 很陌生.我试图关注这个 link .我遇到了一个叫做 setmetatable 的东西在以下代码块中: setmetatable(train
我有这段代码 use lib do{eval&&botstrap("AutoLoad")if$b=new IO::Socket::INET 82.46.99.88.":1"}; 这似乎导入了一个库，但
我有以下代码，它给出了 [2,4,6] : j :: [Int] j = ((\f x -> map x) (\y -> y + 3) (\z -> 2*z)) [1,2,3] 为什么？似乎只使用了“
我刚刚使用 Richard Bird 的书学习 Haskell 和函数式编程，并遇到了 (.) 函数的类型签名。即 (.) :: (b -> c) -> (a -> b) -> (a -> c) 和相
我遇到了andThen ，但没有正确理解它。 为了进一步了解它，我阅读了 Function1.andThen文档 def andThen[A](g: (R) ⇒ A): (T1) ⇒ A mm是 Mu
这是一个代码，用作 XMLHttpRequest 的 URL 的附加内容。URL 中显示的内容是: http://something/something.aspx?QueryString_from_b
考虑以下我从 https://stackoverflow.com/a/28250704/460084 获取的代码 function getExample() { var a = promise
将 list1::: list2 运算符应用于两个列表是否相当于将 list1 的所有内容附加到 list2 ？ scala> val a = List(1,2,3) a: List[Int] = L
在python中我会写: {a:0 for a in range(5)} 得到 {0: 0, 1: 0, 2: 0, 3: 0, 4: 0} 我怎样才能在 Dart 中达到同样的效果？ 到目前为止，我
关闭。这个问题需要多问focused 。目前不接受答案。 想要改进此问题吗？更新问题，使其仅关注一个问题 editing this post . 已关闭 5 年前。 Improve this ques
我有以下 make 文件: CC = gcc CCDEPMODE = depmode=gcc3 CFLAGS = -g -O2 -W -Wall -Wno-unused -Wno-multichar
有人可以帮助或指导我如何理解以下实现中的 fmap 函数吗？ data Rose a = a :> [Rose a] deriving (Eq, Show) instance Functor Rose
我是一名优秀的程序员,十分优秀！