RE: Replication with HEAP tables slave insert error

2004-02-02 Thread Vinod Panicker
Hi Egor, Thanks for the reply. My responses below - Vinod Panicker [EMAIL PROTECTED] wrote: Hi, Had a query regarding replication with HEAP tables. It seems like I cannot use LOAD DATA FROM MASTER to update the stopped slave with data from the master since it apparently works only

Replication with HEAP tables slave insert error

2004-02-01 Thread Vinod Panicker
Hi, Had a query regarding replication with HEAP tables. It seems like I cannot use LOAD DATA FROM MASTER to update the stopped slave with data from the master since it apparently works only for MyISAM tables. Any other way of updating the slave with a snapshot of the data? Since a HEAP table

Re: Re: max connections

2001-03-03 Thread vinod panicker
). Tx. Vinod - Original Message -- "Jorge del Conde" [EMAIL PROTECTED] wrote: To:[EMAIL PROTECTED], "vinod panicker" [EMAIL PROTECTED] From:"Jorge del Conde" [EMAIL PROTECTED] Date:Sat, 3 Mar 2001 01:17:41 -0600 Subject: Re: max connec

Re: Re: Re: max connections

2001-03-03 Thread vinod panicker
TED] wrote: To:"vinod panicker" [EMAIL PROTECTED] From:"Jorge del Conde" [EMAIL PROTECTED] Date:Sat, 3 Mar 2001 03:51:30 -0600 CC:[EMAIL PROTECTED] Subject: Re: Re: max connections Hi, If you want to have 1000+ connections, you will need to modify and recompile LinuxThr

Re: Re: Scaling mysql

2001-03-03 Thread vinod panicker
hey, replication was ruled out coz the writes are very very frequent. and consistency of data is a very important issue. tx. vinod - Original Message -- "Jason Landry" [EMAIL PROTECTED] wrote: To:[EMAIL PROTECTED], "vinod panicker" [EMAIL PR

max connections

2001-03-02 Thread vinod panicker
hey, i'm developing a product that heavily utilizes mysql databases through PHP. The max number of connections that any server can handle is needed as i have to think of scaleability issues. The servers are pretty powerful - it maxes out at 4G's 2x850 P-III. I need max performance out