On Wed, May 03, 2006 at 12:10:38PM +0100, Alan Brown wrote:
> On Wed, 3 May 2006, Christoph Haas wrote:
>
> >>That won't help, but proper indexing should speed things up.
> >
> >Au contraire. In this case the indexing is slowing down the import.
> >Importing the pure data is taking a few minutes o
On Wed, 3 May 2006, Christoph Haas wrote:
That won't help, but proper indexing should speed things up.
Au contraire. In this case the indexing is slowing down the import.
Importing the pure data is taking a few minutes only while creating the
indexes is taking a day.
Doh, of course...
Are y
On Wed, May 03, 2006 at 11:02:20AM +0100, Alan Brown wrote:
> On Tue, 2 May 2006, Christoph Haas wrote:
> >While I used settings from the "large" my.cnf example configuration file
> >and had a slight speedup it still took longer than a few hours so I
> >interrupted.
>
> What indexes do you have?
On Tue, 2 May 2006, Christoph Haas wrote:
By way of comparison my systems were thrashing badly even with 2Gb of ram
because mySQL wasn't using enough memory. Allowing it to grow to 1Gb ram
solved it almost entirely.
I just have 512 MB of RAM but you made me think about my server parameters.
On Mon, May 01, 2006 at 10:43:11PM +0100, Alan Brown wrote:
> On Mon, 1 May 2006, John Kodis wrote:
>
> >You have more CPU than I do, but only about half the memory. Since
> >you say that the disks are thrashing, I'd guess that the lack of
> >memory is more likely to be the culprit than the diffe
Hi
Christoph Haas schrieb:
What I wonder about:
- is a 2.4 dump file/database size common when backup up ~1 million files
that sum up to ~50 GB? (file and job retention are 1 month while I run
one full backup per week and an incremental daily)
My Dumpfile is about 2 GB (1,5 million files abo
On Mon, 1 May 2006, John Kodis wrote:
You have more CPU than I do, but only about half the memory. Since
you say that the disks are thrashing, I'd guess that the lack of
memory is more likely to be the culprit than the difference in
databases. There have, however, been some messages posted her
On Mon, May 01, 2006 at 12:04:10PM +0200, Christoph Haas wrote:
> Now it's 12 hours after I started to restore the 2.4 GB dump file
> and MySQL still seems to be doing the "/*!4 ALTER TABLE `File`
> ENABLE KEYS */" part of the dump. The disk is trashing like fury
> while the database is creati
On Mon, 1 May 2006 12:04:10 +0200
Christoph Haas <[EMAIL PROTECTED]> wrote:
> Evening,
>
> I'm using MySQL (4.1) as an index storage with the default MyISAM table
> format. Unfortunately the partition holding the MySQL databases ran full
> and the database became corrupt. So I wanted to restore t
Evening,
I'm using MySQL (4.1) as an index storage with the default MyISAM table
format. Unfortunately the partition holding the MySQL databases ran full
and the database became corrupt. So I wanted to restore the mysqldump of
the index from the day before.
Now it's 12 hours after I started to re
10 matches
Mail list logo
