Huge performance difference AIX/Linux
I have two instances of mysql, one on Linux (5.0.51) and one on AIX (5.0.45).
I see a HUGE difference in a query performed on the same database(schema and data). One particular fulltext search spends 98% of the time in Copying to tmp table on AIX while it is almost instantaneous on Linux.
On the AIX instance there is no my.cnf.
My questions: Which parameters influence Copying to tmp table
Subject
Views
Written By
Posted
Huge performance difference AIX/Linux
1969
August 24, 2010 02:38AM
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.