Hi Wiley, I am still not sure if we are talking about 360k threats or clients, but I take your word from the first e-mail.
basically I think its possible to setup a big DB (as Google, Yahoo etc. have shown already). About the hardware may I recommend 64 bit Opteron systems and scsi drives (array). Performancewise you have many options to stretch MySQLs legs. - Merge table format (for non transactions) - Raid options included in MySQL - Replication - Cluster Filesystem from MySQL - A "REAL" Cluster One thing that surprise me is that you obviously dont use transactions. Note that your data may corrupt not repairable if you dont take any precautions. Anyway, may I suggest 2 books to get you started quickly. "MySQL Certification study guide" from Paul DuBois "High Performance MySQL" from Zawodny You will probably need more info or books later, but that should get you up to speed within a few weeks. I trust that you have 2-10 boxes near you to get started and see how well that system scales. About posting: Just make Sure you create a new Subject line when starting a new threat or topic. That should do the trick and nobody gets confused. I hope that you find this information useful. Best regards Nils Valentin Tokyo / Japan http://www.be-known-online.com > So is karma :) > > > >>From: sol beach <[EMAIL PROTECTED]> >>Reply-To: sol beach <[EMAIL PROTECTED]> >>To: B Wiley Snyder <[EMAIL PROTECTED]> >>Subject: Re: MySQL bottleneck >>Date: Sat, 16 Apr 2005 20:56:08 -0700 >> >>Incompetence is its own reward. >> >>Simply put, 360K is NOT a big number or DB given today's hardware. >> >>On 4/16/05, B Wiley Snyder <[EMAIL PROTECTED]> wrote: >> > Oh wait, I see what happend. I stepped on MY OWN thread. I hate when I >>do >> > that ! Sorry >> > >> > >From: [EMAIL PROTECTED] >> > >To: "B Wiley Snyder" <[EMAIL PROTECTED]> >> > >CC: mysql@lists.mysql.com >> > >Subject: Re: MySQL bottleneck >> > >Date: Sun, 17 Apr 2005 01:21:36 -0000 (UTC) >> > > >> > >Hello there, >> > > >> > >no offence but that questions is not answerable. I wouldnt expect >> many >> > >replies. Let me try to help you out by asking YOU a few questions >> which >> > >might point you into the correct direction: >> > > >> > >1) Is the data entered once and than mostly read access or is it >> > >frequently updated ? >> > > >> > >2) Do you need transaction support ? >> > > >> > >3) Do you need the data to be EASY transferable between different OS >> > >(MAC/WIN/Unix/Linux) ? >> > > >> > >BTW: You posted into another thread (which is not good). >> > >I suggest you think about the above questions and start a new topic >>again. >> > > >> > >Best regards >> > > >> > >Nils Valentin >> > >Tokyo / Japan >> > > >> > >http://www.be-known-online.com >> > > >> > > >> > > > Hello there, let's say I have 365,000 users I need to enter their >>data, >> > > > pull >> > > > from it and modify it regularly. Is MySql the way to go ? Or do I >>need >> > >to >> > > > buy an oracle or ms server ? >> > > > >> > > > thanks in advance for a clue >> > > > >> > > >>From: [EMAIL PROTECTED] >> > > >>To: "B Wiley Snyder" <[EMAIL PROTECTED]> >> > > >>CC: mysql@lists.mysql.com >> > > >>Subject: Re: How to retain "Key" order when Deleting a Row >> > > >>Date: Tue, 12 Apr 2005 14:48:54 -0400 >> > > >> >> > > >>"B Wiley Snyder" <[EMAIL PROTECTED]> wrote on 04/11/2005 >>10:38:12 >> > > >> PM: >> > > >> >> > > >> > Hello experts, >> > > >> > >> > > >> > I just need someone to please point me in the right direction >> on >> > > >>retaining >> > > >> > my "key" or id order in my table when I delete a row. So for >>example >> > >I >> > > >>have >> > > >> > 10 rows Id 1-10 that are created automatically when the record >> is >> > > >>inserted. >> > > >> > >> > > >> > So if I delete record with id 5 my id's are not >>1,2,3,4,6,7,8,9,10 >> > >but >> > > >> > 1,2,3,4,5,6,7,8,9 ??? >> > > >> > >> > > >> > >> > > >> > thanks >> > > >> > >> > > >> > _________________________________________________________________ >> > > >> > Express yourself instantly with MSN Messenger! Download today - >>it's >> > > >>FREE! >> > > >> > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ >> > > >> > >> > > >> >> > > >>It sounds like you are confusing a data storage requirement (a >>unique, >> > > >>non-repeating identifier for every row) with a presentation >>requirement >> > > >> (a >> > > >>neatly numbered list of records). If I need a nicely ordered list >> of >> > > >>numbers, I use my programming language to provide it. If I need to >> > > >>uniquely identify a record, I use the ID. >> > > >> >> > > >>When an ID has been issued, it generally stays "used" even if that >> > >record >> > > >>no longer exists. >> > > >> >> > > >> >> > > >>Shawn Green >> > > >>Database Administrator >> > > >>Unimin Corporation - Spruce Pine >> > > > >> > > > _________________________________________________________________ >> > > > Express yourself instantly with MSN Messenger! Download today - >> it's >> > >FREE! >> > > > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ >> > > > >> > > > >> > > > -- >> > > > MySQL General Mailing List >> > > > For list archives: http://lists.mysql.com/mysql >> > > > To unsubscribe: >> > > > http://lists.mysql.com/[EMAIL PROTECTED] >> > > > >> > > > >> > > >> > > >> > >-- >> > >MySQL General Mailing List >> > >For list archives: http://lists.mysql.com/mysql >> > >To unsubscribe: >> > >http://lists.mysql.com/[EMAIL PROTECTED] >> > > >> > >> > _________________________________________________________________ >> > Express yourself instantly with MSN Messenger! Download today - it's >>FREE! >> > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ >> > >> > -- >> > MySQL General Mailing List >> > For list archives: http://lists.mysql.com/mysql >> > To unsubscribe: >>http://lists.mysql.com/[EMAIL PROTECTED] >> > >> > > > _________________________________________________________________ > Don’t just search. Find. Check out the new MSN Search! > http://search.msn.click-url.com/go/onm00200636ave/direct/01/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
