Re: MySQL on Cluster

2002-06-18 Thread Terrence Cox
Can you give some more information about this disc cluster? The term to me is vague. I am assuming that it's NOT a RAID array, but I'm also guessing that it's not a reference to a group of machines either. Can you explain some more? Later on, TRC - Original Message - From: "Frank" <[E

Re: Mysql..Python..

2002-06-12 Thread Terrence Cox
> > Python has the ability to produce ( with modules) graphics for my > database > interface, outside of the Browser enviorment. Seems, from what I have > read PHP > is restricted to the Browser, is this correct? > Just to answer the question about PHP being restricted to the browser, the answe

Re: mysql not supporting php.

2002-06-03 Thread Terrence Cox
It sounds as if you didn't compile in mysql support with you php executable. You can check this using the phpinfo() function. If you are using the cgi only, try something like... 'php -q -i | grep configure' This will show you all the configuration options you selected when compiling/installi

Re: count...I think

2002-05-30 Thread Terrence Cox
In short, it would be "LIMIT 20,0" If I'm not mistaken. However, the db isn't going to kick out the string "The query returned 0-20 of 132 records" for you. Are you trying to do database pagination? Mulitple rows spread across multiple page views? If that's the case, PHPBuilder has an article

Re: Eliminating downtime

2002-05-30 Thread Terrence Cox
How would you guarantee the success of the transaction? If it fails as a result of a hardware failure, then ultimately, the system as a whole has suffered a hardware failure. If it fails for any other reason, then it's an issue with software or bad data. Once those things are figured out, you p

Re: how to design mysql clusters with 30,000 clients?

2002-05-24 Thread Terrence Cox
> On Wednesday 22 May 2002 18:44, Dave Watkins wrote: > > At 16:02 22/05/2002 +0800, Patrick Hsieh wrote: > > >Hello list, > > > > > >I am expecting to have 30,000 http clients visting my website at the > > >same time. To meet the HA requirement, we use dual firewall, dual > > >Layer-4 switch and

Re: error while start mysql service

2002-05-14 Thread Terrence Cox
Have you considered using perror? Try perror 10 67. - Original Message - From: "Priyesh Panchmatia" <[EMAIL PROTECTED]> Date: Tue, 14 May 2002 20:20:45 +0800 To: <[EMAIL PROTECTED]> Subject: error while start mysql service > Hi, > > I get the follwoing error while starting myssql servi

re: replication

2002-05-10 Thread Terrence Cox
Let's see your my.cnf file. - Original Message - From: "Azhar Khan" <[EMAIL PROTECTED]> Date: Wed, 8 May 2002 17:49:55 -0400 To: <[EMAIL PROTECTED]> Subject: re: replication > During the replication process >http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_A

Re: Replication Problem

2002-05-10 Thread Terrence Cox
Hi Raymond, That's an interesting message you're getting. Obviously there is an issue with IP address not getting to mysqld. The only thing that can make any sense to me in this one is double check the name and location of the my.cnf file. See ya, Terrence - Original Message - From:

Re: Parsing SQL statements

2002-05-04 Thread Terrence Cox
other way ? > > > > >From: "Terrence Cox" <[EMAIL PROTECTED]> > >To: "mustafa karabulut" <[EMAIL PROTECTED]> > >CC: [EMAIL PROTECTED] > >Subject: Re: Parsing SQL statements > >Date: Sat, 04 May 2002 21:30:54 +0800 > > >

Re: Parsing SQL statements

2002-05-04 Thread Terrence Cox
Just to make sure I understand you, you need to check the sql statements themselves for errors. Is this correct? Or, do you instead need to check that a query ran with success? Late on, BDKR - Original Message - From: "mustafa karabulut" <[EMAIL PROTECTED]> Date: Sat, 04 May 2002 12:4