How to know the Average load per second when we insert data into MySQL table?

Question

How I 'll check how many rows inserted into every second on an average in a table of MySQL database?

Answer 1

You can monitor it in real time by simply doing something like this

Count the number of rows
Wait x seconds
Count the number of rows, find delta y between two counts
rate = y/x

If you don't want to do it in real time, you can could parse the MySQL binary log to see how many insert statements were executed and obtain their timestamps.
Or you could give each row a timestamp, and then find the average insertion rate for any arbitrary period by counting the rows inserted in that period. For example, to get a count of rows inserted in last hour

SELECT count(*) AS inserted FROM table 
WHERE unix_timestamp(created) 
BETWEEN unix_timestamp()-3600 AND unix_timestamp();

Finally, if you want some general graphing of insertions (and other operations) you could use something like munin (though by default this would be tracking all inserts, not just those in a particular table).