Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

performance tests

afflictedd2afflictedd2 EntrantCurrent User Role Beginner
Hi everyone,

I need to try different types of engines for a MySQL database that will be created by a program in C++. The program has to create the database and populate it. I need to measure times and sizes for the database to find which gives the better overall performance. Right now, I am measuring time with a timer class for measuring time to populate the database. I want to know if someone knows if MySQL itself provides a way to determine the size of a database, and perhaps also ask on what things to consider for these performance tests.

Thanks in advance,

David.

Comments

  • debugdebug Contributor Current User Role Beginner
    Check information_schema database (if you are using MySQL 5.0)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.