表上的 sql select 查询未完成

发布于 2024-11-01 21:50:25 字数 424 浏览 4 评论 0原文

我在从名为节点的表中读取数据时遇到了这个奇怪的问题。任何选择查询都需要永远执行。我什至不知道它最终是否会回来，但看起来并非如此。以前恢复得很快。据我所知，一切都没有改变。没有插入新记录，也没有删除任何记录。我尝试过的几个查询。

select count(1) from  nodes;

select node_id, type from nodes where node_id='abc';

如果有帮助的话，node_id 是节点表中的主键。前一天，所有选择查询都会立即返回，例如 0.01 毫秒等。

我的猜测是，不知何故在表上放置了一个锁，阻止我的查询继续进行。如果有人能让我知道或指导如何在 MYSQL 5.0.90-log FreeBSD 中查找特定表上的锁，我将不胜感激。

还有什么其他可能性？

非常感谢。

原文

I'm experiencing this weird problem reading data from a table called nodes. Any select query is taking forever to execute. I don't even know if its going to return eventually but it doesn't seem like that. It used to return quickly before. Nothing has changed as far as I know. No new records are inserted and none are deleted too. Couple of queries that I tried.

select count(1) from  nodes;

select node_id, type from nodes where node_id='abc';

node_id is a primary key in nodes table if that helps. The previous day all of select queries used to return in no time like in 0.01ms etc.

My guess is that somehow a lock is placed on the table preventing my queries from proceeding.
I appreciate if someone can let me know or give a pointer to how to find locks on a particular table in MYSQL 5.0.90-log FreeBSD.

What could be other possibilities?

Thanks a bunch.

分享到QQ

分享到微博