-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Alan Brown wrote:
| On Mon, 18 Aug 2008, Ryan Novosielski wrote:
|
|> Is there any way to tell if it's actually making any progress? I guess
|> probably not.
|
| Top, and "show all processes" inside a mysql client.

OK. I had been using "mysqladmin processlist" which ultimately churns
out the same information looks like. It appears as if the MySQL syntax
for the command (if we're talking about the same thing) is actually
"SHOW FULL PROCESSLIST."

|> | have you tweaked your my.cnf to ensure you're not using the default
mysql
|> | limits which are designed for a 64Mb multiuser machine?
|>
|> Ah! No, I have not -- this may in fact be my problem. I'll take a look
|> and see what ground can be gained in that area.
|
| "Quite a lot". I saw a speedup factor of over 500.

I was apparently using my-medium.cnf without having read exactly what
that was going to mean. This machine is primarily the database server
and certainly there are no quality of service issues with other
processes at the times this thing is really going to be churning. It is
also multi-CPU and my-medium.cnf doesn't do any thread concurrency.

| There are several example config files in the documentation, use myhuge if
| you have enough memory.

I apparently do not, but I did step up to my-large.cnf at least which
does seem to have some important differences. I'll see what happens.

Any comment on the indexes I pasted earlier? Maybe they're hard to read
and that's why I don't get any feedback on them? I'm reluctant to strip
anything out, not knowing 100% what they mean.

- --
~ ---- _  _ _  _ ___  _  _  _
~ |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer II
~ |$&| |__| |  | |__/ | \| _| |novosirj AT umdnj DOT edu - 973/972.0922 (2-0922)
~ \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIqZatmb+gadEcsb4RAumiAKDfXjsZ5AO+xbSJyLSdAg4vbEtw1wCbBqyo
2EmCGA4LZcexW9HcSM8IMC8=
=AAV0
-----END PGP SIGNATURE-----

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users