RE: Question!

2009-03-30 Thread Joshua Gordon
Read the online Manual. -Original Message- From: Jarikre Efemena [mailto:jefem...@yahoo.com] Sent: Monday, March 30, 2009 11:30 PM To: mysql@lists.mysql.com Subject: Question! Dear sir,   I am young web developer using PHP Script in designing interactive website. I desire to include Mys

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 machine

Re: IN vs. OR on performance

2009-03-30 Thread Baron Schwartz
On Sun, Mar 29, 2009 at 10:19 AM, Claudio Nanni 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 of OR's just evaluate

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 co

Re: ATTN: OWNER/MODERATOR

2009-03-30 Thread Daniel Brown
On Mon, Mar 30, 2009 at 19:45, Dian Crayne 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 about this, my

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: 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 com

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 > Subje

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: 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 part

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 must

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

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 ?