VP> Can you supply us with an example? Some explain plans to corroborate your
VP> reported slowness.
Of course.
Here is the query.
It is big and ugly, I'm curently working on system optimization. But
why the same query is good at one machine and bad at another?
I've made some experiments and can
VP> Can you supply us with an example? Some explain plans to corroborate your
VP> reported slowness.
Of course.
Here is the query.
It is big and ugly, I'm curently working on system optimization. But
why the same query is good at one machine and bad at another?
SELECT ...
FROM positionReports p
Can you supply us with an example? Some explain plans to corroborate your
reported slowness.
-Original Message-
From: Andrey Chernyh
To: [EMAIL PROTECTED]
Sent: 3/9/04 3:35 AM
Subject: Performance problem with 4.0.18
Hello All!
After we converted our tables from MyISAM to InnoDB the
Hello All!
After we converted our tables from MyISAM to InnoDB the database
became very slow!
The same database on another machine on MySQL 3.23.58 works very good.
The machines are identical, my.cnf files are the same.
What can be the reason of such slow performance?
Thank you!
Best regards, An
