开发者

View in Mysql crashes the DB

Our DB crashed (mysql 5.2) and the reason when i looked was

show create table <view_name>

This was not logged as a slow query, but was a pointer value in the crash debug. I really can't understand this, can a view in the DB crash the DB?

Although i can think of removing this view and test, it will be helpful if any of one faced this开发者_JS百科 kind of scenario, its better to know to the reason than hide the reason.


Are you sure you are using 5.2?

You may want to review this bug. Does the View reference any tables that no longer exist?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜