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

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 do

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 panicke

Re: Re: Re: max connections

2001-03-03 Thread vinod panicker
el Conde" <[EMAIL PROTECTED]> 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+ connecti

Scaling mysql

2001-03-03 Thread vinod panicker
hey, i'm having a problem with scaling a mysql server. This is the situation... i have a database with 5 tables containing user data. Except one, all the other tables have only 2 fields. This data is queried often and needs to be accessed by multiple web servers. Each table would contai

Re: Re: max connections

2001-03-03 Thread vinod panicker
tance). 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 -060

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 of

Connection to server lost...

2001-02-24 Thread vinod panicker
hey... i'm getting a weird problem... i'm running a mysql 3.23 server on a dual-processor machine with 2 GB RAM. The number of tables are very few.. and so are the records. I've configured max_connectins as 2000 and i'm using PHP 4.0.4pl1 to access the database. I'm using persistent conn