Re: Most Performance, Opinions ?

2001-12-28 Thread Steve Rapaport
Hi. My question is similar to yours in some ways, perhaps we can help each other. You say We need no transactions, or any data integrity at all. We can afford to loose some data in trade for performance. (like a few hours or something, which seems like a lot even if the replication whould

Re: Most Performance, Opinions ?

2001-12-28 Thread Johan Wahlström
- Original Message - From: Johan Wahlström [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 29, 2001 2:39 AM Subject: Re: Most Performance, Opinions ? Hello! Can I actually turn off locks all the way, so that updates never locks a MyISAM table at all ? regarding

RE: Most Performance, Opinions ?

2001-12-28 Thread Chris Bolt
regarding mysql_pconnect() we haven't tried that, but the nature of the site suggests it would need like 500 apache deamons connected all the time. And that's a lot of sort buffers and stuff beeing allocated for each one of those ? Not if you disable keepalive requests, which I do on