Members Members   Search Search   Help Help   Register Register   Login Login   Home Home


Home » Performance » MySQL » performance tests
performance tests [message #3290] Mon, 14 July 2008 09:12 Go to next message
afflictedd2 is currently offline afflictedd2
Messages: 4
Registered: July 2008
Location: Texas
Junior Member
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.
Report message to a moderator
Re: performance tests [message #3319 is a reply to message #3290 ] Fri, 18 July 2008 07:11 Go to previous message
debug is currently offline debug
Messages: 122
Registered: March 2008
Senior Member
Check information_schema database (if you are using MySQL 5.0)

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
Report message to a moderator
Previous Topic:MySQL 5.0 and Partitioning
Next Topic:Several MySQL performance questions
Goto Forum:
  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]


Current Time: Fri Dec 5 11:46:11 EST 2008

Total time taken to generate the page: 0.01404 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge