Re: MySQL on T2000

2014-01-31 Thread Stewart Smith
Chris Lawrence  writes:
> I've done a good amount of fine tuning of the database, but I'm
> finding any query of complexity taking sometimes as much as 30x longer
> to execute than on same-era x86 hardware running Debian.

MySQL query execution is single threaded (one query in one thread).

The T2000 chips (and T1000 before it) have absolutely awful single
threaded performance - they're all about concurrency, not single thread
perf.

So these are really not the machines to run complex single queries
on. They're more suited to many small queries at once.

What doesn't help is that unaligned memory accesses abound in the MySQL
server (I once switched the GCC flags for generating code to handle
unaligned access... urgh)

30x sounds a little high... but I wouldn't be surprised if you had said
10 or 20x.

It'll also very much depend on MySQL version you're using. ASsuming
current debian, 5.5 should be the best possible...

-- 
Stewart Smith


pgphHyPEpbRS6.pgp
Description: PGP signature


Re: Bits from the Release Team (Jessie freeze info)

2013-10-23 Thread Stewart Smith
Geert Uytterhoeven  writes:
> On Wed, Oct 23, 2013 at 12:36 AM, Stewart Smith
>  wrote:
>> Jenkins can have slaves on remote hosts, via SSH. It runs a small java
>> app there, so as long as the arch has a JVM then you're pretty right.
>
> For whatever definition of small. I've seen it consuming 1 GiB of
> memory...

with 'm68k' in your email address your definition of small is likely
much different than my "many years in large scale databases" small :)

That being said... I haven't recently seen a slave jenkins java process
more than one or two hundred mb.

This is (of course) absolutely insane, as is the 4-6GB jenkins master
process. However, dollars per GB of memory is suitably low that it's not
worth me fixing it, instead it just sits there annoying me as it could
undoubtedly be better


-- 
Stewart Smith


pgpBBYdyNkP40.pgp
Description: PGP signature


Re: Bits from the Release Team (Jessie freeze info)

2013-10-22 Thread Stewart Smith
Steven Chamberlain  writes:
> On 21/10/13 16:42, Niels Thykier wrote:
>> I would love for us to have an automated system to give us a
>> "weather-report" on the toolchain for each architecture.  It would be
>> nice both for us to see how ports are doing and for porters to spot and
>> fix problems early.
>
> That sounds a lot like the purpose of Jenkins[0], but I'm not sure if
> it's exactly suitable.  It seems a little heavy, that someone could more
> easily be able to script some cron jobs for a task than learn how to
> use it.

It's actually a pretty low barrier to entry, if you know what commands
you need to run, it's pretty easy to get started with jenkins (create
job, have it execute shell commands, write shell in box, hit build).

I'd say that it's about 10 times more likely you'll get it right in
Jenkins before you get it right in cron.

> And Jenkins isn't available yet on all arches;  some ports may not have
> hardware powerful enough to run it.  Maybe that doesn't matter - a
> single Jenkins instance might be able to launch jobs via remote shells
> to other boxes, running the actual test suite there, or maybe just to
> fetch, analyse and report on the resulting log files.

Jenkins can have slaves on remote hosts, via SSH. It runs a small java
app there, so as long as the arch has a JVM then you're pretty right.

-- 
Stewart Smith


pgpIdHmMbdnaF.pgp
Description: PGP signature


Re: Sun T1000 noise level

2013-02-20 Thread Stewart Smith
Frans van Berckel  writes:
> On Wed, 2013-02-20 at 19:21 +1100, Stewart Smith wrote:
>> Dániel Kasza  writes:
>> > I'm thinking about buying a Sun T1000 just to have a sparc-based
>> > computer at home again. I know that these servers can be really noisy.
>> > I have a walk-in closet (air conditioned, of course), so I could lock
>> > the computer there, and the CPU would be idle most of the time.
>> > Do you think having a T1000 running in the next room would be
>> > noticeable?
>> 
>> I have a T1000. It's in the garage as it was too loud *anywhere* in the
>> house (only have a ground floor).
>> 
>> I tried keeping it in the laundry with the door closed, still too loud
>> From the rest of the house.
>> 
>> Even when it's in the garage, if it's on, I'll switch it off if I go
>> outside (the garage is not directly attached to the house).
>
> Are the T1000 fan sensors supported by the Linux kernel?

I'm pretty sure it doesn't have fan sensors, it was crazy loud running
Solaris too.

-- 
Stewart Smith


pgpf68z41zOYr.pgp
Description: PGP signature


Re: Sun T1000 noise level

2013-02-20 Thread Stewart Smith
Dániel Kasza  writes:
> I'm thinking about buying a Sun T1000 just to have a sparc-based
> computer at home again. I know that these servers can be really noisy.
> I have a walk-in closet (air conditioned, of course), so I could lock
> the computer there, and the CPU would be idle most of the time.
> Do you think having a T1000 running in the next room would be
> noticeable?

I have a T1000. It's in the garage as it was too loud *anywhere* in the
house (only have a ground floor).

I tried keeping it in the laundry with the door closed, still too loud
From the rest of the house.

Even when it's in the garage, if it's on, I'll switch it off if I go
outside (the garage is not directly attached to the house).

-- 
Stewart Smith


pgpuptVW2Y3qB.pgp
Description: PGP signature


NR_CPUS is only 32

2009-08-21 Thread Stewart Smith
The sparc64-SMP kernels seem to only support up to 32 CPU cores. It's
increasingly hard to get a SPARC box with less than this... should it be
raised? Maybe to 128 or 256? (128 is fairly easy to get too actually)
-- 
Stewart Smith


-- 
To UNSUBSCRIBE, email to debian-sparc-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org