mysql慢查询 [英] mysql slow query

问题描述

ALTER TABLE customers ADD split INT(1);

1000万记录...我执行了此命令1个小时，但仍在加载..是否有任何方法可以使它更快地完成?

10 mil. records... I performed this command for 1 hour and still loading ..is there any way to make it finish faster ?

推荐答案

可能不是通过代码实现的..
关闭所有其他应用程序，确保没有其他东西占用您的CPU使用率，没有恶意软件?拥有更快的计算机?
如果您可以告诉我们您正在使用的环境设置等，这将对您有所帮助.可能还涉及到您的网络，服务器等.

Probably not by code..
Close all other apps, make sure nothing else is taking up your cpu usage, no malware? get a faster computer?
It would help if you could tell us the environment setup you're working with and such. It could be a number of things involving your network, your server, etc, as well.

这篇关于mysql慢查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！