MySQL reporting question
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 of t1. t2.varchar1 will often be NULL. Non-NULL values will mostly match up with t1.varchar1. t1.varchar1 can not be NULL. varchar2 is a clustering of information about varchar1, but usually only one entry in the cluster will have a value for varchar1. t1.stuff, t2.status == $some_val where max(t2.timestamp) and t1.varchar1 == t2.varchar1 and t2.varchar2 == t2.varchar2 This is for reporting and will run on a slave. Any suggestions on how to efficiently build out the report? Unlike my last DB job, I can create indexes, views, etc. I can also add columns to either table. ciao, der.hans -- # http://www.LuftHans.com/Classeshttp://www.TwoGeekTechs.com/ # Director of Engineering, FonWallet Transaction Solutions, Inc. # If you're not learning, you're not living. - der.hans --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: MySQL reporting question
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, 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 of t1. t2.varchar1 will often be NULL. Non-NULL values will mostly match up with t1.varchar1. t1.varchar1 can not be NULL. varchar2 is a clustering of information about varchar1, but usually only one entry in the cluster will have a value for varchar1. t1.stuff, t2.status == $some_val where max(t2.timestamp) and t1.varchar1 == t2.varchar1 and t2.varchar2 == t2.varchar2 This is for reporting and will run on a slave. Any suggestions on how to efficiently build out the report? Unlike my last DB job, I can create indexes, views, etc. I can also add columns to either table. ciao, der.hans -- # http://www.LuftHans.com/Classes http://www.TwoGeekTechs.com/ # Director of Engineering, FonWallet Transaction Solutions, Inc. # If you're not learning, you're not living. - der.hans --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: OT: HowTo Gpartd Windows Mirrored Drives to Expand Usable Space?
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 say Knoppix and use gpartd? -- Office: (480)307-8707 ATT: (503)754-4452 --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: OT: HowTo Gpartd Windows Mirrored Drives to Expand Usable Space?
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 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 Standard DELL laptop configuration! I believe it's NTSF? -- Office: (480)307-8707 ATT: (503)754-4452 --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Breaking in to a Harddrive
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 happily ever after. Needless to say we don't have the password. I am sure there is data on the drive but none that we own so don't care if all data is lost. Looking for suggestions on breaking in or clearing the drive. Again total data loss is ok. Tried DD in case it was in the partition table and no dice.. -- James Finstrom --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: OT: HowTo Gpartd Windows Mirrored Drives to Expand Usable Space?
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 lisakach...@obnosis.com wrote: 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 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 Standard DELL laptop configuration! I believe it's NTSF? -- Office: (480)307-8707 ATT: (503)754-4452 --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: Breaking in to a Harddrive
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 jfinst...@rhinoequipment.com wrote: 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 happily ever after. Needless to say we don't have the password. I am sure there is data on the drive but none that we own so don't care if all data is lost. Looking for suggestions on breaking in or clearing the drive. Again total data loss is ok. Tried DD in case it was in the partition table and no dice.. -- James Finstrom --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
MySQL reporting question
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. ugghhh -- you mention MySQL in the subject line, but just because one has a hammer does not mean everything is a nail. The MySQL database server kernel engine can use a journal and serialization of transactions to attain ACID. This can slow things down a lot if used There is the 'new' interest in 'eventually consistent' databases. Can you use 'almost the latest' data? [some problem domains do not admit a use case permitting this, but some do: consider: DNS which might update detail all the way through only every couple of weeks in some cases] I would take a hint and amend my code to emit both the insert to t1 AND a destructive update write to 'last seen' location outside of the database. A strict SQL approach is gonna kill you on retrieval time and lock serialization This avoids that killing JOIN I would also generate a hash of t1.varchar1, t2.varchar1, t2.varchar2 and t2.varchar2 as each is written and as you are sorting (selecting, but ... ) on max(t2.timestamp) and generate a series of the first four directory permuted values, each in their own tree, and spread that across sufficient spindles that the write and read load performance can keep up As this point we need to look at the structure for the problem domain t1.stuff, t2.status == $some_val and we lack enough to design further the structures needed ... I had to automate precompution of 'cribs' of subsets of data and pre-populate a cache for a call center application I wote, to keep up with the database read load on one project. If I were doing it again, I would drill in even more 'out of database' cacheing Financial markets data is often like this -- one needs very fast access to arbitrary data, and usually just the latest trade or the lastest day's trade data; after that it is merely of less time critical access needs. We recently spent several months with the trading-shim working in this area -- Russ herrold 614 488 6954 --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: Breaking in to a Harddrive
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 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 jfinst...@rhinoequipment.com wrote: 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 happily ever after. Needless to say we don't have the password. I am sure there is data on the drive but none that we own so don't care if all data is lost. Looking for suggestions on breaking in or clearing the drive. Again total data loss is ok. Tried DD in case it was in the partition table and no dice.. -- James Finstrom --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: MySQL reporting question
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 did one to many hits of acid and is now locked in a permenait halucination / delision - OR - just does not give a $#*! about thier data. But your also talking to an accountant who would have a kaniption is his $1.5Millon books were off by a nickle and other may not care quite so much about their business. That being said with MySQL you can set up replication very easily and just run your reporting off of the replication box. Thus you can devoting all of your resources to a single query without worry. In addition if you are using an INnoDB engine vs a MyIsam engine your joins are far less expensive. In addition using inner joins vs subquerys is much faster. And if you have many tables you can increase performance by creating temp tables and views but again, you need to understand your dealing with cached data so design as appropriate. On Tue, Jun 22, 2010 at 9:05 AM, R P Herrold herr...@owlriver.com wrote: 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. ugghhh -- you mention MySQL in the subject line, but just because one has a hammer does not mean everything is a nail. The MySQL database server kernel engine can use a journal and serialization of transactions to attain ACID. This can slow things down a lot if used There is the 'new' interest in 'eventually consistent' databases. Can you use 'almost the latest' data? [some problem domains do not admit a use case permitting this, but some do: consider: DNS which might update detail all the way through only every couple of weeks in some cases] I would take a hint and amend my code to emit both the insert to t1 AND a destructive update write to 'last seen' location outside of the database. A strict SQL approach is gonna kill you on retrieval time and lock serialization This avoids that killing JOIN I would also generate a hash of t1.varchar1, t2.varchar1, t2.varchar2 and t2.varchar2 as each is written and as you are sorting (selecting, but ... ) on max(t2.timestamp) and generate a series of the first four directory permuted values, each in their own tree, and spread that across sufficient spindles that the write and read load performance can keep up As this point we need to look at the structure for the problem domain t1.stuff, t2.status == $some_val and we lack enough to design further the structures needed ... I had to automate precompution of 'cribs' of subsets of data and pre-populate a cache for a call center application I wote, to keep up with the database read load on one project. If I were doing it again, I would drill in even more 'out of database' cacheing Financial markets data is often like this -- one needs very fast access to arbitrary data, and usually just the latest trade or the lastest day's trade data; after that it is merely of less time critical access needs. We recently spent several months with the trading-shim working in this area -- Russ herrold 614 488 6954 --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: OT: HowTo Gpartd Windows Mirrored Drives to Expand Usable Space?
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 you sure that the drive D is a mirror, and not a recovery partition? Mirroring to a separate partition on the same drive would seem to me to be pointless, and I've never heard of a Laptop with 2 HDDs. -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: OT: HowTo Gpartd Windows Mirrored Drives to Expand Usable Space?
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 wrote: 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 you sure that the drive D is a mirror, and not a recovery partition? Mirroring to a separate partition on the same drive would seem to me to be pointless, and I've never heard of a Laptop with 2 HDDs. -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: Breaking in to a Harddrive
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 - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: Breaking in to a Harddrive
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 near as good as WD or Seagate. I wouldn't trust a Hitachi for anything really important. Jim --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: Breaking in to a Harddrive
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 cheap it's not funny. Honestly, if your time is halfway valuable and you have $80 or often even less (check NewEgg) it's worth using good stuff. Jim --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: Breaking in to a Harddrive
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 near as good as WD or Seagate. I wouldn't trust a Hitachi for anything really important. Jim --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: OT: HowTo Gpartd Windows Mirrored Drives to Expand Usable Space?
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 vendors just use one to save space/cost/complexity On Tue, Jun 22, 2010 at 10:01 AM, Eric Shubert e...@shubes.net wrote: 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 you sure that the drive D is a mirror, and not a recovery partition? Mirroring to a separate partition on the same drive would seem to me to be pointless, and I've never heard of a Laptop with 2 HDDs. -- -Eric 'shubes' --- -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: OT: HowTo Gpartd Windows Mirrored Drives to Expand Usable Space?
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. 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 vendors just use one to save space/cost/complexity On Tue, Jun 22, 2010 at 10:01 AM, Eric Shubert e...@shubes.net wrote: 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 you sure that the drive D is a mirror, and not a recovery partition? Mirroring to a separate partition on the same drive would seem to me to be pointless, and I've never heard of a Laptop with 2 HDDs. -- -Eric 'shubes' --- -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: OT: HowTo Gpartd Windows Mirrored Drives to Expand Usable Space?
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 at 11:00 AM, Eric Shubert e...@shubes.net wrote: 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 vendors just use one to save space/cost/complexity On Tue, Jun 22, 2010 at 10:01 AM, Eric Shubert e...@shubes.net wrote: 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 you sure that the drive D is a mirror, and not a recovery partition? Mirroring to a separate partition on the same drive would seem to me to be pointless, and I've never heard of a Laptop with 2 HDDs. -- -Eric 'shubes' --- -- -Eric 'shubes' --- -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
New Linux server at home
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 alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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 work. Keith Smith --- On Tue, 6/22/10, Stephen cryptwo...@gmail.com wrote: From: Stephen cryptwo...@gmail.com Subject: New Linux server at home To: Main PLUG discussion list plug-discuss@lists.plug.phoenix.az.us Date: Tuesday, June 22, 2010, 1:32 PM 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 alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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 dusting) 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 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 work. Keith Smith --- On *Tue, 6/22/10, Stephen cryptwo...@gmail.com* wrote: From: Stephen cryptwo...@gmail.com Subject: New Linux server at home To: Main PLUG discussion list plug-discuss@lists.plug.phoenix.az.us Date: Tuesday, June 22, 2010, 1:32 PM 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 alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.ushttp://mc/compose?to=plug-disc...@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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 syncing package). Us mac users (of which I am one) prefer afp over smb but both are usable. On 6/22/10 1:32 PM, 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. --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: OT: HowTo Gpartd Windows Mirrored Drives to Expand Usable Space?
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 is disk management command line tool id call Diskpart. now be sure that you have a mirror because when you do that it is only on drive C, or one drive with 2 partition , then will be C and D, and if you have that mirror with a second drive, then you have C and D I understand that you're aware of that, but again, are you sure that has two drives, with gparted, it have a live cd that is able to work with drive mirror and change that, but it is better to do it within windows app. unless that whatever that computer have it is not important, you can try it, but is faster and simpler from disk management, now i got a question which laptop brand provide the ability of use 2 drives, unless that you use docking stations I never see one, well good luck Walter Tocalini On Tue, Jun 22, 2010 at 11:05 AM, Stephen cryptwo...@gmail.com 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 at 11:00 AM, Eric Shubert e...@shubes.net wrote: 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 vendors just use one to save space/cost/complexity On Tue, Jun 22, 2010 at 10:01 AM, Eric Shubert e...@shubes.net wrote: 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 you sure that the drive D is a mirror, and not a recovery partition? Mirroring to a separate partition on the same drive would seem to me to be pointless, and I've never heard of a Laptop with 2 HDDs. -- -Eric 'shubes' --- -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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 personal mail servers in the future. http://qmailtoaster.com will get you up and running in no time. I know that qmail is frowned upon by some, but QMT 'just works'. I'm active in the QMT community, so I'm biased (but for good reasons). ;) -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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 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 work. Keith Smith --- On *Tue, 6/22/10, Stephen cryptwo...@gmail.com* wrote: From: Stephen cryptwo...@gmail.com Subject: New Linux server at home To: Main PLUG discussion list plug-discuss@lists.plug.phoenix.az.us Date: Tuesday, June 22, 2010, 1:32 PM 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 alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.ushttp://mc/compose?to=plug-disc...@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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 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 personal mail servers in the future. http://qmailtoaster.com will get you up and running in no time. I know that qmail is frowned upon by some, but QMT 'just works'. I'm active in the QMT community, so I'm biased (but for good reasons). ;) -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
OT: Google Voice available to everyone
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. --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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, 2:57 PM 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 personal mail servers in the future. http://qmailtoaster.com will get you up and running in no time. I know that qmail is frowned upon by some, but QMT 'just works'. I'm active in the QMT community, so I'm biased (but for good reasons). ;) -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: OT: Google Voice available to everyone
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 everyone now. I got a number that is 480 - XXX - JAVA. --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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. 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, 2:57 PM 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 personal mail servers in the future. http://qmailtoaster.com will get you up and running in no time. I know that qmail is frowned upon by some, but QMT 'just works'. I'm active in the QMT community, so I'm biased (but for good reasons). ;) -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.ushttp://mc/compose?to=plug-disc...@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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 Linux server at home To: plug-discuss@lists.plug.phoenix.az.us Date: Tuesday, June 22, 2010, 3:53 PM They simply block the std ports, and there are ways around that. You don't need to run a full-fledged domain right off the bat though. You might start with a private mail server that you can use IMAP with, so you can access your email from all of your devices (multiple computers, phone, etc), and the devices all see your email the same way (ie you file/delete something from one device, it's filed/deleted on all of them). You can run fetchmail on your private server to fetch email from your other accounts, and you can configure your server to use cox for your outbound messages. -- -Eric 'shubes' Stephen wrote: 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 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 personal mail servers in the future. http://qmailtoaster.com will get you up and running in no time. I know that qmail is frowned upon by some, but QMT 'just works'. I'm active in the QMT community, so I'm biased (but for good reasons). ;) -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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 mail server you're running. Google smarthost and the mail server you're using (such as exim, postfix,qmail or sendmail) --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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 discussion list plug-discuss@lists.plug.phoenix.az.us Date: Tuesday, June 22, 2010, 4:14 PM 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. 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, 2:57 PM 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 personal mail servers in the future. http://qmailtoaster.com will get you up and running in no time. I know that qmail is frowned upon by some, but QMT 'just works'. I'm active in the QMT community, so I'm biased (but for good reasons). ;) -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen -Inline Attachment Follows- --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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 difficult at best. I never seem to figure out where to start. 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 discussion list plug-discuss@lists.plug.phoenix.az.us Date: Tuesday, June 22, 2010, 4:18 PM The concept of it is called an SMTP smarthost, basically you point your SMTP server directly to theirs. On Tue, Jun 22, 2010 at 4:16 PM, 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 --- 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, 3:53 PM They simply block the std ports, and there are ways around that. You don't need to run a full-fledged domain right off the bat though. You might start with a private mail server that you can use IMAP with, so you can access your email from all of your devices (multiple computers, phone, etc), and the devices all see your email the same way (ie you file/delete something from one device, it's filed/deleted on all of them). You can run fetchmail on your private server to fetch email from your other accounts, and you can configure your server to use cox for your outbound messages. -- -Eric 'shubes' Stephen wrote: 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 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 personal mail servers in the future. http://qmailtoaster.com will get you up and running in no time. I know that qmail is frowned upon by some, but QMT 'just works'. I'm active in the QMT community, so I'm biased (but for good reasons). ;) -- -Eric 'shubes' --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen -Inline Attachment Follows- --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: OT: Google Voice available to everyone
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 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. --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: New Linux server at home
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 HTTPS but that is it. Fortunately cox does not block inbound HTTPS On Tue, Jun 22, 2010 at 1:32 PM, Stephen cryptwo...@gmail.com 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. -- A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. Stephen --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: Breaking in to a Harddrive
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 firmware, one can find where the password is stored and erase or nullify it. Oh, and you might need special equipment to get to that password on the platters. To put it another way, throw this hard drive away and go buy a new one. It'll be less costly of your time. Alan On Tue, Jun 22, 2010 at 8:51 AM, James Finstrom jfinst...@rhinoequipment.com wrote: 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 happily ever after. Needless to say we don't have the password. I am sure there is data on the drive but none that we own so don't care if all data is lost. Looking for suggestions on breaking in or clearing the drive. Again total data loss is ok. Tried DD in case it was in the partition table and no dice.. -- James Finstrom --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
Re: MySQL reporting question
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 != NULL AND max(timestamp) GROUP BY status, varchar1, varchar2; View2 : select stuff, status from t1 INNER JOIN View1 ON t1.varchar1 = t2.varchar1; Report is then: Select * from View2 where status = $some_val; der.hans wrote: 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 of t1. t2.varchar1 will often be NULL. Non-NULL values will mostly match up with t1.varchar1. t1.varchar1 can not be NULL. varchar2 is a clustering of information about varchar1, but usually only one entry in the cluster will have a value for varchar1. t1.stuff, t2.status == $some_val where max(t2.timestamp) and t1.varchar1 == t2.varchar1 and t2.varchar2 == t2.varchar2 This is for reporting and will run on a slave. Any suggestions on how to efficiently build out the report? Unlike my last DB job, I can create indexes, views, etc. I can also add columns to either table. ciao, der.hans signature.asc Description: OpenPGP digital signature --- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss