MySQL存储数据怎么越来越慢

Question

建立了一个有35个数据项的表，每条数据是170字节，
存储超过200条之后速度就明显慢了下来，300条左右时几乎就不能再存了，
请问是需要设置什么吗 

Answer 1

怎么存储的  insert语句吗

Answer 2

WaitForSingleObject(hMutex,INFINITE);
recvfrom(sockSrv,recdata,1024,0,(SOCKADDR*)&addrClient,&len);
memcpy(&datahead,recdata,sizeof(datahead));
memcpy(&datainfo,recdata+sizeof(datahead),sizeof(datainfo));
if(datahead.flag==0x98ac&&datahead.length==170)
{
Sleep(1);
sprintf(sqlstr,"INSERT INTO exchangehouse(exchangehouse,\
InstrumentID,TradingDay,UpdateTime,PreSettlementPrice,\
PreClosePrice,PreOpenInterest,OpenPrice,HighestPrice,\
LowestPrice,ClosePrice,SettlementPrice,LastPrice,Volume,\
OpenInterest,BidPrice1,BidVolume1,AskPrice1,AskVolume1,\
        BidPrice2,BidVolume2,AskPrice2,AskVolume2,BidPrice3,BidVolume3,\
AskPrice3,AskVolume3,BidPrice4,BidVolume4,AskPrice4,AskVolume4,\
BidPrice5,BidVolume5,AskPrice5,AskVolume5)VALUES('%d','%s','%s','%s','%f','%f','%lf','%f','%f','%f','%f','%f','%f','%d','%lf','%f','%d','%f','%d','%f','%d','%f','%d','%f','%d','%f','%d','%f','%d','%f','%d','%f','%d','%f','%d')",
    num,datainfo.InstrumentID,datainfo.TradingDay,datainfo.UpdateTime
,datainfo.PreSettlementPrice,datainfo.PreClosePrice
,datainfo.PreOpenInterest,datainfo.OpenPrice,datainfo.HighestPrice,
datainfo.LowestPrice,datainfo.ClosePrice,datainfo.SettlementPrice,
datainfo.LastPrice,datainfo.Volume,datainfo.OpenInterest,datainfo.BidPrice1
,datainfo.BidVolume1,datainfo.AskPrice1,datainfo.AskVolume1,datainfo.BidPrice2
,datainfo.BidVolume2,datainfo.AskPrice2,datainfo.AskVolume2,datainfo.BidPrice3
    ,datainfo.BidVolume3,datainfo.AskPrice3,datainfo.AskVolume3,datainfo.BidPrice4
,datainfo.BidVolume4,datainfo.AskPrice4,datainfo.AskVolume4,datainfo.BidPrice5
,datainfo.BidVolume5,datainfo.AskPrice5,datainfo.AskVolume5);
            mysql_query(&mydata,sqlstr);
}
ReleaseMutex(hMutex);一共4个线程同时接收数据

Answer 3

在你足够权限情况下，可以参考下面这个SQL来查看
SELECT CONCAT(ROUND(SUM(data_length)/(1024*1024*1024), 2), ' GB') AS 'Total Data Size'
FROM information_schema.TABLES WHERE table_schema LIKE 'database';