MySQL Forums
Forum List  »  Connector/ODBC

Re: Optimization of application to reduce db workload and improve performance
Posted by: Peter Brawley
Date: December 15, 2018 04:11PM

> 40 virtual boxes (VMs) in parallel

Does that occasion swapping? If so there's a major slowdown cause.

> Which indexes should it have?

Impossible to answer in general. Tt needs the indexes that best optimise queries that are running. To find that out you need to run Explain on the slow queries, and optimise them and their indexes based on those results.

> Sometimes I see, in PHPMyAdmin, that the table is locked.

Yikes, is the app using MyISAM!?

> Maybe it is mainly an ODBC problem.

No need to guess. Find out: stub out and log timings in the app, compare ODBC times with direct mysql client times.

ODBCis useful because it works with so many different frontends and backends. That flexibility costs performance. Why are you using it?

Edited 1 time(s). Last edit at 12/15/2018 04:14PM by Peter Brawley.

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.