[ale] LAMP performance

[Mike Harrison]

On Mon, 13 Sep 2010, mike barnes wrote:

> I have been asked to come up with a solution for a 6 sigma application that
> can have up to 1 million transaction/hour.

Just updated some code with some stats generation, the code is PHP
and is using SimpleXML to parse the XML being fed in.

On my dev system. a  several year old Intel rack mount server
with "Intel(R) Xeon(TM) CPU 3.80GHz" with Ultra320 SCSI drives and 4gb of 
ram..

Running Ubuntu Lamp Server 10.04 (amd64)

Reading some 20-30mb XML fat ugly XML files
and inserting the data into MySQL.
The billings and quality tables are rather wide,
the interval data table is only 3 columns wide.
Note the speed difference: 2-3k SQl transactions
per second to 7-8k per second for the simpler
tables.

and the tables on this machine are huge.. have
hundreds of millions or records.

----------------------------------------------------

Total: 92 / 0.031371831893921   = 2932.5670337354 TPS
Reads: 75 Inserts: 17   Billings; 0  Quality Data: 17 Interval Data: 0

Total: 24713 / 11.176017999649   = 2211.2527020604 TPS
Reads: 12574 Inserts: 12139   Billings; 6056  Quality Data: 6083 Interval 
Data: 0

Total: 24648 / 11.676768064499   = 2110.8580613961 TPS
Reads: 12574 Inserts: 12074   Billings; 5991  Quality Data: 6083 Interval 
Data: 0

Total: 666211 / 86.727150917053   = 7681.6889861535 TPS
Reads: 4875 Inserts: 661336   Billings; 0 Quality Data: 18 Interval Data: 
661318

Total: 695205 / 92.852468967438   = 7487.1999391185 TPS
Reads: 4618 Inserts: 690587   Billings; 0 Quality Data: 15 Interval Data: 690572



System load, even when running lots of these in a row, is always < 0.8