Re: why does throughput increase with number of connections even if it exceeds number of processors?

2011-09-05 Thread Andrew Moore
Hong, What you are seeing is probably your server's ability to keep up with your benchmark with some comfort. I assume your benchmark isn't completing in a couple of seconds but would presume that you are not IO bound and all changes are happening in memory. Its hard to give you 'the' answer as yo

Re: Seconds Behind the master 0 but in reality it's over 10 minutes or hours..

2011-09-05 Thread Rob Wultsch
> Hm. > > It seems we have sort of ethernet segment saturation problem. A possible bandaid/quick fix is turning on compression for mysql replication. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

why does throughput increase with number of connections even if it exceeds number of processors?

2011-09-05 Thread Chuntao HONG
Hi, I wrote a micro benchmark to test the performance of my MySQL server. In the benchmark, which is written in C#, I created several threads, each with a connection to the MySQL server, to insert rows into the same table. Totally 3200 rows are inserted into the table. When I try to vary the numb