Re: Unnecessary charset conversion causes performance issue?
Posted by:
Joe Cai
Date: February 27, 2006 09:05PM
Sorry,it appears that my guess about the cause of this performance issue is simply wrong.
Innodb is slow when importing large sql files with multiple-row INSERT syntax. I re-dumped the data with "mysqldump --skip-opt" and the time spent on importing went back to normal.
It's weird that last time when I encountered this problem. I replaced all the charset configuration with default values ,and the speed became normal.So I made the assumption that it's the charset conversion problem.Well,it turns out I was wrong from the beginning.
Subject
Views
Written By
Posted
3683
February 27, 2006 09:24AM
Re: Unnecessary charset conversion causes performance issue?
1875
February 27, 2006 09:05PM
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.