Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-users digest..."
Today's Topics:
1. Re: Netdot 1.0.1-RC1 available for download (Daniel Griggs)
2. Re: Netdot 1.0.1-RC1 available for download (Phil Regnauld)
----------------------------------------------------------------------
Message: 1
Date: Mon, 25 Jun 2012 11:23:46 +1200
From: Daniel Griggs <[email protected]>
Subject: Re: [Netdot-users] Netdot 1.0.1-RC1 available for download
To: Carlos Vicente <[email protected]>
Cc: netdot-users <[email protected]>
Message-ID:
<CA+ycCUMH_ed3u7=ybiqonzfdtxjl+qesrzkagfg1__g+qf3...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Phil is just trying to troll you, pay no attention.
He just thinks that if something is popular it can't be good :P
Dumping the database, modifying the resulting output, truncating all the
tables and then reloading them from the modified sql dump sounds like a
long way round.
I did try the update but it aborted on a repeated index (bug logged), if
there are optimisations for altering and inserting into tables then reading
the docs for mysqldump and the output it produces might be good start.
On 23 June 2012 07:44, Carlos Vicente <[email protected]> wrote:
> On 6/22/12 3:31 PM, Phil Regnauld wrote:
> >
> >
> > On 22/06/2012, at 20.03, Carlos Vicente <[email protected]> wrote:
> >
> >> Actually, I did look into this before. The 'DISABLE KEYS' feature in
> >> mysql only works with MyISAM tables. Netdot uses InnoDB.
> >
> > Oh dear. And DROP INDEX ?
>
>
> 99 tables and 297 indexes... hmm.
>
>
> >>
> >> If anyone has suggestions on how to speed up ALTER TABLE, etc. commands
> >> in Mysql, please let me know.
> >
> > Dump, truncate, patch, load?
>
> truncate, patch ?
>
> Can you elaborate?
>
> --
> cv
>
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
--
Daniel Griggs
Network Operations
e: [email protected]
d: +64 4 4989567
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20120625/a2adeb5d/attachment-0001.html
------------------------------
Message: 2
Date: Mon, 25 Jun 2012 10:30:46 +0200
From: Phil Regnauld <[email protected]>
Subject: Re: [Netdot-users] Netdot 1.0.1-RC1 available for download
To: Daniel Griggs <[email protected]>
Cc: netdot-users <[email protected]>, Carlos Vicente
<[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=us-ascii
On 25/06/2012, at 01.23, Daniel Griggs <[email protected]> wrote:
> Dumping the database, modifying the resulting output, truncating all the
> tables and then reloading them from the modified sql dump sounds like a long
> way round
Years of experience with MySQL have taught me that sometimes the long way round
is the shortest one. :)
But it's most certainly an index or lack of tuning that hurts.
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 43, Issue 9
*******************************************
