performance comparison after converting from myisam to innodb

In my application I have changed the database engine from myisam to innodb.
Now I want to check the difference in performance if any.
I can run my old application if needed.
pvinodpAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

flytox06Commented:
Hi,

technicaly to see a difference, there must be a before and an after. In your case, you didn't benchmark your application before, then I don't see how you could see a difference... :-/

pvinodpAuthor Commented:
OK.  I can invoke my application with myisam in another machine. So I will have 2 machines running the application each with different engine.
flytox06Commented:
idealy, with a php or a shell script I would suggest you to run a specific scenario based on realistic events on your web site, and fork it to replay almost live conditions.
Adding appropriate timestamps you could get an interesting vision of the performance evolution.

technicaly, this can be done just by your knowledge of the platform or by dumping with tcpdump the queries running live or by dumping processlist regularily. I suggest mk-query-digest to get a vision of statements spearding over a specific period.

Consider disks, memory pressure, cpu pressure and TPS to get a view of how the machine is dealing with the load on each engine.

this is always a tricky exercise to reproduce live pressure to evaluate performance evolutions.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pvinodpAuthor Commented:
performance was compared using both methods for a same operation.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.