RE: lug-bg: Repairing of MySQL DB

[gashti_dolu@xxxxxxxxx (gggg ggg)]

e,eeeee !
da ti e jiv i zdrav mascon-a :-)
nali si na jasno kakvi shte sa promenite pri tova deto
me karash da go napravia ?
i to v baza s 40k zapisa ?

mersi za vnimanieto ,no kato gledam opisanieto na
mascon-a ne e po-dobar ot zeos componentite ,koito
polzvam.Pak i viarvam znaesh , 4e vsiaka komponenta si
ima sobstven podhod kam bazata i dosta ot neshtata
koito pravi ne gi vijdash .Interpretiraneto na krainia
rezultat moje da e podvejdashto.
Moita komponenta me nakara da napisha "ALTER TABLE
tblname ORDER BY tbl_id" i se kalne 4e tova mi triabwa
- da-ama ne.

georgi

--- yavor shahpasov <yavo@xxxxxxxxxxxxxxxxxx> wrote:
> probvai
> 
> alter table tablename
> , auto_increment=50
> 
> Tova mi go generira mascon kato smenih auto
> increment value in table
> properties, ako se interesuvash kakvo e mascon goto
> http://www.scibit.com/
> 
> yavor shahpasov
> 
> 
> 
> > -----Original Message-----
> > From: owner-lug-bg@xxxxxxxxxxxxxxxxxx
> > [mailto:owner-lug-bg@xxxxxxxxxxxxxxxxxx]On Behalf
> Of gggg ggg
> > Sent: Sunday, September 02, 2001 2:49 PM
> > To: lug-bg@xxxxxxxxxxxxxxxxxx
> > Subject: lug-bg: Repairing of MySQL DB
> >
> >
> > zdraveite,
> > iztrih 5-6 hiliadi zapisa ot MySQL bazata si.
> Opitah
> > vsi4ki vazmijni na4ini za repair ,kato REPAIR
> > TABLE,OPTIMIZE TABLE, ANALYZE TABLE i t.n. , no ne
> > mojah da nakaram MySQL-a da mi smeni indexite da
> > po4nat ot 1 , shtoto sega se seshtate , 4e ako sam
> > iztril 5000 zapisa , indexite po4vat ot 5001 -
> > neudobno e .
> >
> > niakakvi idei za optimizacia /repaire ?
> >
> > georgi
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email alerts & NEW webcam video instant
> messaging with Yahoo!
> > Messenger
> > http://im.yahoo.com
> >
>
==================================================================
> > =========
> > A mail-list of Linux Users Group - Bulgaria
> (bulgarian linuxers)
> > http://www.linux-bulgaria.org/ Hosted by Internet
> Group Ltd. -
> > Stara Zagora
> >
> 
>
===========================================================================
> A mail-list of Linux Users Group - Bulgaria
> (bulgarian linuxers)
> http://www.linux-bulgaria.org/ Hosted by Internet
> Group Ltd. - Stara Zagora

__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
===========================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers)
http://www.linux-bulgaria.org/ Hosted by Internet Group Ltd. - Stara Zagora