moin moin,
t1: t1id, varchar1, stuff
t2: t2id, timestamp, varchar1, varchar2, status
I need to match the most recently entered status from t2 with stuff from
t1 in MySQL.
t2 is grouped by varchar2.
t1 will have millions of rows. t2 has millions of rows and will grow at 4
or 5 times the rate
Without any other details it seems simple, just create indexes on any
join or where column, setup a slave box for data warehousing purposes,
run the simple SQL
On Mon, Jun 21, 2010 at 11:09 PM, der.hans pl...@lufthans.com wrote:
moin moin,
t1: t1id, varchar1, stuff
t2: t2id, timestamp,
how were they mirrored? firmware or software?
On Mon, Jun 21, 2010 at 7:26 PM, Lisa Kachold lisakach...@obnosis.com wrote:
Gee,
Anyone know an easy tool or procedure to make a standard Laptop C and D
drive no longer mirrored instead 2 usable drives?
I heard a rumor that you can boot into
On Tue, Jun 22, 2010 at 8:29 AM, Stephen cryptwo...@gmail.com wrote:
how were they mirrored? firmware or software?
On Mon, Jun 21, 2010 at 7:26 PM, Lisa Kachold lisakach...@obnosis.com
wrote:
Gee,
Anyone know an easy tool or procedure to make a standard Laptop C and D
drive no longer
Greetings All,
So my dad bought a Hitachi Travelstar 5K100 and apparently the drive is
password locked at a hardware level and requires some sort of voodoo to
report back anything other than vendor data. Anyway I guess there is a byte
code you send to the drive and then a password then you live
ntfs software mirror should pretty much be broken once you pull it out
of its host OS/environment. unless they did 2 partitions on one drive
and then mirrored them. but in any of those cases the data should be
100% accessible mirror or no.
On Tue, Jun 22, 2010 at 8:34 AM, Lisa Kachold
get the Hitachi drive diagnostics and see if you can write 0's to the
drive or contact Hitachi support or contact the seller of the drive
thats about all i can think of, because firmware level passwords are
pretty hard to circumvent.
On Tue, Jun 22, 2010 at 8:51 AM, James Finstrom
On Mon, 21 Jun 2010, der.hans wrote:
I need to match the most recently entered status from t2 with stuff from
t1 in MySQL.
t1.stuff, t2.status == $some_val where max(t2.timestamp) and t1.varchar1
== t2.varchar1 and t2.varchar2 == t2.varchar2
I can also add columns to either table.
The last time this happened to me I just sent the drive back to the
manufacturer under RMA and received a new drive in about a week.
On Tue, Jun 22, 2010 at 8:56 AM, Stephen cryptwo...@gmail.com wrote:
get the Hitachi drive diagnostics and see if you can write 0's to the
drive or contact
If your going to drop acid drop mysql and use Casandra. I hate
Casandra because it makes no attempt at being acid complaint but it is
the best of your high performance eventually/mostly consistent
databases. Mind you I think anyone who thinks not using an ACID
complaint database is a good idea
Lisa Kachold wrote:
Gee,
Anyone know an easy tool or procedure to make a standard Laptop C and D
drive no longer mirrored instead 2 usable drives?
I heard a rumor that you can boot into say Knoppix and use gpartd?
--
Office: (480)307-8707
ATT: (503)754-4452
That doesn't sound right. Are
I have built several including a few with 3 drives in raid 5. they do
exist, just not common unless you get into some of the more desktop
replacement systems. most mainstream Tier 1/2 vendors just use one to
save space/cost/complexity
On Tue, Jun 22, 2010 at 10:01 AM, Eric Shubert e...@shubes.net
A warning: in my experience and that of others of late, Hitachi drives
aren't that good. Worse than Samsung. Nowhere near as good as WD or
Seagate. I wouldn't trust a Hitachi for anything really important.
Jim
---
PLUG-discuss mailing list -
Ah remember we used to call them the death star drive - because they
would burn out hot and fast :)
On Tue, Jun 22, 2010 at 10:28 AM, Jim March 1.jim.ma...@gmail.com wrote:
A warning: in my experience and that of others of late, Hitachi drives
aren't that good. Worse than Samsung. Nowhere
On Tue, Jun 22, 2010 at 10:32 AM, Bryan O'Neal
bryan.on...@theonealandassociates.com wrote:
Ah remember we used to call them the death star drive - because they
would burn out hot and fast :)
We're at a point now where brand new WD drives of respectable but not
cutting-edge size are so damn
Ah remember we used to call them the death star drive - because they
would burn out hat and fast :)
On Tue, Jun 22, 2010 at 10:28 AM, Jim March 1.jim.ma...@gmail.com wrote:
A warning: in my experience and that of others of late, Hitachi drives
aren't that good. Worse than Samsung. Nowhere
I should think that'd put a real strain on the battery. Unless of course
they're SSDs. :)
Stephen wrote:
I have built several including a few with 3 drives in raid 5. they do
exist, just not common unless you get into some of the more desktop
replacement systems. most mainstream Tier 1/2
Desktop replacements aren't known for battery life.. unless you count
the shortest possible... SLI graphics raided HDD and sometimes Desktop
CPU's you get the idea.
On Tue, Jun 22, 2010 at 11:00 AM, Eric Shubert e...@shubes.net wrote:
I should think that'd put a real strain on the battery.
More like 'portable' than 'laptop' then, I suppose.
I refer to mine as a 'deskbook'. ;)
Stephen wrote:
Desktop replacements aren't known for battery life.. unless you count
the shortest possible... SLI graphics raided HDD and sometimes Desktop
CPU's you get the idea.
On Tue, Jun 22, 2010
just set up a new Linux server, just recently demoed my xenserver and
moved it into a new case... dropped the optical and in all tons
quieter
but my main purpose in this email is what sort of services do people
run at home and what do they do with them.
--
A mouse trap, placed on top of your
I have an old Dell that is over 5 years old. It was my wife's desktop until
about 3 years ago. I added some RAM and put Fedora on it and have been using
it on a daily basis as a LAMP dev server.
I have been thinking about a new box though, since it is over 5 years old and I
use it for my
I have an old Socket 775 Server board i might trade/sell PDSMA+ or PDSMI i
think. If your interested let me know.
but mine has been in service for about 4 years now. I added some drives and
changes its chassis to one that makes less noise but still the same guts
inside (also gave it a good
normally, its just file (smb) and printer sharing. Those tend to be the
biggies and a home user with more
than one machine in the house might employ. the more advanced geeks
among that group would
use something more esoteric (like opendirectory or some other single
sign on authentication and
Just go to windows control panel - administrative tools computer
management -disk management and disble the mirror and your second
drive will be clean for whatever you like to do---no data lost on the
primary drive
o whatever version of windows this machine have- your place to work
Stephen wrote:
just set up a new Linux server, just recently demoed my xenserver and
moved it into a new case... dropped the optical and in all tons
quieter
but my main purpose in this email is what sort of services do people
run at home and what do they do with them.
I expect to see more
I run a FreeBSD box for OpenVPN, file server, and SVN server. its an old
celeron with 512MB of ram.
Eric
On Tue, Jun 22, 2010 at 1:40 PM, keith smith klsmith2...@yahoo.com wrote:
I have an old Dell that is over 5 years old. It was my wife's desktop
until about 3 years ago. I added some RAM
downside to this one is the filtering Cox applies to email services.
On Tue, Jun 22, 2010 at 2:57 PM, Eric Shubert e...@shubes.net wrote:
Stephen wrote:
just set up a new Linux server, just recently demoed my xenserver and
moved it into a new case... dropped the optical and in all tons
http://www.google.com/googlevoice/about.html
Was talking to der.hans about this last week. He mentioned that it might
be a while before it was out of beta :). Well look at that its available
to everyone now.
I got a number that is 480 - XXX - JAVA.
Everything I've read says qmail is a heavy hitter.
Keith Smith
--- On Tue, 6/22/10, Eric Shubert e...@shubes.net wrote:
From: Eric Shubert e...@shubes.net
Subject: Re: New Linux server at home
To: plug-discuss@lists.plug.phoenix.az.us
Date: Tuesday, June 22, 2010,
HAHA cute.
On Tue, Jun 22, 2010 at 4:00 PM, Stephen P Rufle
stephen.p.ru...@cox.net wrote:
http://www.google.com/googlevoice/about.html
Was talking to der.hans about this last week. He mentioned that it might be
a while before it was out of beta :). Well look at that its available to
well the server is a x3210 2.13 quad core xeon with 4gb ram and 4x160 sata2
hdd in raid 10 and 2x400 gb sata2 RE in a mirror.
i think its got some spare resources.
On Tue, Jun 22, 2010 at 4:07 PM, keith smith klsmith2...@yahoo.com wrote:
Everything I've read says qmail is a heavy hitter.
How can you - you can configure your server to use cox for your outbound
messages
Do you connect to their SMTP server and look like a client?
Keith Smith
--- On Tue, 6/22/10, Eric Shubert e...@shubes.net wrote:
From: Eric Shubert e...@shubes.net
Subject: Re: New
On Tue, Jun 22, 2010 at 16:16, keith smith klsmith2...@yahoo.com wrote:
How can you - you can configure your server to use cox for your outbound
messages
Do you connect to their SMTP server and look like a client?
Keith Smith
The setup varies depending on which
Not a resource hog. I meant it can handle the load. As I recall, I read that
qmail is rather efficient.
Keith Smith
--- On Tue, 6/22/10, Stephen cryptwo...@gmail.com wrote:
From: Stephen cryptwo...@gmail.com
Subject: Re: New Linux server at home
To: Main PLUG
That would come in handy. I have a LAMP server on a private IP that I use for
software dev. I can test almost everything except the parts that send mail
out. When I get to that point I move the code to a test server.
I've tried to configure a mail server in the past and have found it
I got 916-XX-GAMES :)
On Tue, Jun 22, 2010 at 4:13 PM, Stephen cryptwo...@gmail.com wrote:
HAHA cute.
On Tue, Jun 22, 2010 at 4:00 PM, Stephen P Rufle
stephen.p.ru...@cox.net wrote:
http://www.google.com/googlevoice/about.html
Was talking to der.hans about this last week. He mentioned that
I have an old Dell Precision 380 used for
File Sever: SMB internal WebDAVS external
LAMP Server: HTTP internal HTTPS external - dotProject, etc.
XTupple Server: PostBooks for Accounting
SSH Server: Mostly for tunneling, but never really have need since my
files and applications are available via
If the hardware manufacturer implemented the ATA spec correctly, the
password cannot be bypassed by any normal means. That is, after all,
what the password is supposed to do.
With special knowledge of the specific hard drive model, not just the
manufacturer, the model and even the specific
As I understand your structure and requirements (it's a bit fuzzy, especially
the t2.varchar2 == t2.varchar2)
Create two *materialized* views and refresh both views (1 then 2) every
reporting period (daily?).
View1 : select status, varchar1, varchar2, max(timestamp) from t2 where
varchar1 !=
39 matches
Mail list logo