如题:我用的是mysql5.1
对一个数据量为3G,索引2G,执行一个alter table add 操作,mysql -hxx -uxx -Dxx -e“”
会出现
ERROR 1317 (70100) at line 2: Query execution was interrupted
对一个数据量为3G,索引2G,执行一个alter table add 操作,mysql -hxx -uxx -Dxx -e“”
会出现
ERROR 1317 (70100) at line 2: Query execution was interrupted
Linux db10-001 2.6.18-128.el5 #1 SMP Wed Dec 17 11:41:38 EST 2008 x86_64 x86_64 x86_64 GNU/Linux
total used free shared buffers cached
Mem: 32177 30325 1851 0 247 9537
-/+ buffers/cache: 20541 11635
Swap: 16002 0 16002
do
echo `free`
sleep 1
done两个窗口 一个窗口执行alter语句 一个窗口执行上面的循环
另外查看dmesg 看看是否有out of memory的报错