mysql load testing tools

Question

I want to calculate the each row size of a table. are there any tools available for this. Also Does anyone aware of any load testing tools.

Thanks in advance.

Regards, Manasi

Answer 1

• Calculate average row size with:

  SHOW TABLE STATUS [FROM databasename] [LIKE 'pattern']

• Super Smack is a benchmarking, stress testing, and load generation tool for MySQL (and PostgreSQL).