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.

Options: ReplyQuote

Written By
Re: Unnecessary charset conversion causes performance issue?
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.