开发者

what is "Waiting for table level lock"?

Why I have so many queries when I using 'show processlist '

what is "Waiting for table level lock"?

And my CPU is 600+% used

开发者_运维百科

what is "Waiting for table level lock"?

Is there anything i can do to improve mysql performance? Thanks


Yes, you can change your storage engine from MyISAM to InnoDB - MyISAM only knows table level locking (when it writes to a record, it blocks the whole table), while InnoDB knows row level locking (it locks just the row you are writing to)

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜