Re: delete��id��δ�1��ʼ ��

Article View: cn.bbs.comp.database

Article #1347

Back to cn.bbs.comp.database Previous Next

#1347

From: Galaxy��VOLUNTEERS
Date: Tue, 18 Dec 2007 14:49

14 lines
1740 bytes

����deleteһ����?delete��һ����ʾ����Ӳ�̲��㣬�˳���һ����־log�ļ�ռ��
138G�������ˡ���������ļ���ֻ��4G�ࡣ����delete����log����д�ܶණ����
��ɾ�����ٶȶ���Ҳ��ȷ��truncate��
�� �� QuadCore (�ĺ�) �Ĵ������ᵽ: ��
: truncate������Ҫ��delete��á���ô���id��1��ʼ�ؼ���ʲô��˼�أ�����1�Ժ�ļ�
: ¼����ɾ���������1, 2, 3...����������ּ�¼���ٴ�������ʱ���ǻ�Ҫ���ǵ�
: �Ѵ��ڵļ�¼��
: �� �� thatnight �Ĵ������ᵽ: ��
: : ���������� һ��ɾ��͸����㳲��ҵĴ��


--

[m[1;35m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.51.51][m

Technical Details

Message-ID: <4XWOT4$cGc@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!news.bbh.net.cn!bbsnews.sdu.edu.cn!SJTUBBS

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,88f53beadf90fa9c,start
X-Google-Attributes: gid101948,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!news.bbh.net.cn!bbsnews.sdu.edu.cn!SJTUBBS
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS)
Newsgroups: cn.bbs.comp.database
Subject: Re: delete��id��δ�1��ʼ ��
Date: 18 Dec 2007 14:49:50 GMT
Organization: ��ˮ˼Դ
Message-ID: <4XWOT4$cGc@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1197989236.A
Lines: 13
X-Original-Bytes: 1075