Re: Master-master replication configuration...how?

2009-03-30 Thread blue . trapezius
Hi Craig and others, On Fri, Mar 27, 2009 at 4:16 PM, Craig Dunn li...@codenation.net wrote: blue.trapez...@gmail.com wrote: Hi I have 2 servers and I am trying to set up (for testing purposes) a master-master replication environment. I read the instructions in the manual for

RAID-10 perf numbers

2009-03-30 Thread dbrb2002-sql
Does anybody have any RAID-10 sysbench fileio numbers for random writes with any number of disks(4/6/8/12...) to compare with write cache(512,256,...) backed by BBU.. I really appreciate your nos.. or whats the decent requests/sec for pure rndwrs ?

MySQL University session on April 2: How to Create a Test Case

2009-03-30 Thread Stefan Hinz
How to Create a Test Case http://forge.mysql.com/wiki/How_to_Create_a_Test_Case This Thursday (April 2nd, 14:00 UTC), Patrick Crews will give a MySQL University session on How to Create a Test Case. This is an updated session of a talk we had in 2007, but this time it will be recorded (slides and

SSL Connections

2009-03-30 Thread Stefano Elmopi
Hi, I'm trying to make connections ssl. I followed the MySQL guide and I've configured the server then I created a normal user, without the REQUIRE SSL. On the same server can connect with the only option: mysql --ssl-ca=cacert.pem -u Pluto -p but if I try to connect from another host, I

Re: dynamically splitting a table through one full table scan

2009-03-30 Thread Jacek Becla
Hi Kabel Yes, I did, it won't do the job for us. I didn't explain the whole usecase: we are dealing with a 50-billion row table which we want to split into 1-million-row tables, and then dynamically break each of these into smaller pieces in order to speed up n^2 near-neighbor joins. If we

Re: SSL Connections

2009-03-30 Thread Andy Shellam
Hi Stefano, I'm guessing your remote (non-local) server is using a different user account than your local server. r...@localhost r...@% r...@somehost.com are all different users. If your remote host, or wildhost user account has the REQUIRE X509 flag (user must be certified) but your local

RE: Data structure for matching for company data

2009-03-30 Thread ChoiSaehoon
Thanks, PB. I found that I cannot use FK for Myisam tables. Then, this kind of data structuring is no use at all for Mysiam tables. Is this correct? Date: Fri, 27 Mar 2009 09:54:47 -0500 From: peter.braw...@earthlink.net To: saeho...@hotmail.com CC: mysql@lists.mysql.com Subject:

RE: Data structure for matching for company data

2009-03-30 Thread ChoiSaehoon
Thanks for the resource! Arthur. SIC seems to be great for most industries, but not for high-tech industries. (e.g. it doesn't have Internet or software etc) Still a great tip, though. Thanks again! :) Date: Fri, 27 Mar 2009 19:13:51 -0500 Subject: Re: Data structure for matching for

ATTN: OWNER/MODERATOR

2009-03-30 Thread Dian Crayne
Chuck Crayne (ccra...@crayne.org) has died. I am his widow. I cannot unsubscribe him from this list because I do not have his user name and password. Please remove him from your membership list. If you need to talk to me about this, my phone number is (707) 459-2623. Thank you very much!!

Re: ATTN: OWNER/MODERATOR

2009-03-30 Thread Daniel Brown
On Mon, Mar 30, 2009 at 19:45, Dian Crayne dcra...@crayne.org wrote: Chuck Crayne (ccra...@crayne.org) has died.  I am his widow. I cannot unsubscribe him from this list because I do not have his user name  and password.  Please remove him from your membership list.  If you need to talk to me

Re: Data structure for matching for company data

2009-03-30 Thread Peter Brawley
Choi, I found that I cannot use FK for Myisam tables. Then, this kind of data structuring is no use at all for Mysiam tables. Is this correct? You can use this structure with MyISAM tables. It will work fine except you won't have the advantage of database-level enforcement of foreign key

Re: IN vs. OR on performance

2009-03-30 Thread Baron Schwartz
On Sun, Mar 29, 2009 at 10:19 AM, Claudio Nanni claudio.na...@gmail.com wrote: An explain of the two statements yields the same plan, anybody knows if they are actually translated in the same plan? There is a difference. The IN list is sorted so lookups can be done as a binary search. A bunch

Question!

2009-03-30 Thread Jarikre Efemena
Dear sir,   I am young web developer using PHP Script in designing interactive website. I desire to include Mysql database on my websites.   Please, how do I import, upload/export Mysql database to a website server after creating a Mysql user account and a particular database on my local