Primary Key Issue while importing BIN Logs

2001-09-22 Thread Michael McConnell
bin/mysql -f -u root --password=l4ka5Tdj databasename; done I can see there is a -r function in mysqlimport, but of course the BinLogs are in SQL format and this will not work Any help would be GREATLY appreciated p.s. suggesting that I use mysql's built in replication is not help.

Importing of MySQL BinLogs on Slave

2001-09-21 Thread Michael McConnell
bin/mysql -f -u root --password=l4ka5Tdj databasename; done I can see there is a -r function in mysqlimport, but of course the BinLogs are in SQL format and this will not work Any help would be GREATLY appreciated p.s. suggesting that I use mysql's built in replication is not help.

Re: MySQL is hogging my box

2001-09-18 Thread Michael McConnell
Run the RPM's Binaries provided by MySQL and all will work correctly. There is something MySQL is doing in the RPM's that there not telling us Source users. Michael McConnell - Original Message - From: "djinn" <[EMAIL PROTECTED]> To: "Rodney Broom&q

Re: MySQL Spawning Tons of Processes

2001-09-17 Thread Michael McConnell
It certainly does seem that 3.23.40+ take considerably more resources to do the exact same thing, than MySQL 3.22.xx Is this correct? > On Sun, Sep 16, 2001 at 10:21:05PM -0700, Michael McConnell wrote: > > > > So what your saying is MySQL is supposed to fork a new processe

Re: MySQL Spawning Tons of Processes

2001-09-16 Thread Michael McConnell
So what your saying is MySQL is supposed to fork a new processes for every connection? I don't think so... > > > > I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I > > > > connect 400 requests and and ask for something all at the same time, > > > > MySQL spawns many child proccess

Re: MySQL Spawning Tons of Processes

2001-09-16 Thread Michael McConnell
> On Sun, Sep 16, 2001 at 04:44:05PM -0700, Michael McConnell wrote: > > > > I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I > > connect 400 requests and and ask for something all at the same time, > > MySQL spawns many child proccess (hundreds a

MySQL Spawning Tons of Processes

2001-09-16 Thread Michael McConnell
I'm running MySQL 3.23.42 on a PIII 866 with 1 Gig of RAM. If I connect 400 requests and and ask for something all at the same time, MySQL spawns many child proccess (hundreds and hundreds). As a result of all these processes the system essentailly hangs (Loadavg of 588 525 310) Does anyone know