在PhpMyAdmin中进行监视 [英] Monitoring in PhpMyAdmin

问题描述

我想我对此有些困惑. 在phpmyadmin的状态"->监视"部分中，当我的网站是 当时甚至没有做任何基于sql的操作，我遇到了6000个问题和200个连接.

I guess I'm a little confused what's going on here. In phpmyadmin in the Status->Monitor section, when my website is not even doing anything sql based at the time, I'm getting 6000 questions and 200 connections.

这似乎很不正常，任何人都可以给我一些有关这里实际发生情况的提示，这不正常，对吧?

This very much does not seem normal, can anyone give me some tips about what's really going on here, this can't be normal, right?

我试图每五秒钟连接到大约四个不同的表并从中获取信息，我相信这会导致服务器崩溃.这是不好的说法吗?

edit: Im trying to connect to about four different tables every five seconds and pull information from them, and I believe it's causing my server to crash. Is this a bad parctice?

我正在使用jquery和php.我认为，即使通过错误的编程，我也无法通过第二个phpmyadmin达到我所要求的400个查询.

I'm using jquery and php. I think even through bad programming I can't be hitting the 400 queries a second phpmyadmin is saying I'm hitting.

推荐答案

您也许能够在从移动图获取的特定时间范围内，从状态">监控器"中查看正在运行的查询.请参阅从6开始的 http://www.youtube.com/watch?v=7ZRZoCsrKis :00.

You might be able to see which queries are running from Status > Monitor, in a particular time range taken from the moving graph. See http://www.youtube.com/watch?v=7ZRZoCsrKis starting at 6:00.

这篇关于在PhpMyAdmin中进行监视的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！