?
Solved

How to benchmark mysql databse performance using Perl DBI?

Posted on 2004-09-29
1
Medium Priority
?
339 Views
Last Modified: 2012-05-05
Hello all,

I'm trying out different database designs and want to benchmark their performance in terms of speed.

The only operations that matter to me are Select and Count.

How can I run a few thousand Selects and then get the time taken using a Perl script and the DBI?

Thanks
0
Comment
Question by:xfvgdrthbdtyvhgscv
1 Comment
 
LVL 26

Accepted Solution

by:
Umesh earned 1000 total points
ID: 12181076
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question