RE: Need Help Converting Character Sets

Thanks for that link! That's another subtle issue I had not noted. There are so many combinations, that it is hard to say "do this": * Incoming bytes are latin1 / utf8 / Microsquish control characters. * You do/don't have SET NAMES (or equivalent) * The database/table/column is declared latin1/ut

Re: checking progress of alter table on an InnoDB table (Was: Re: checking progress of alter table on a MyISAM table)

On Thu, Sep 27, 2012 at 3:02 PM, Akshay Suryavanshi wrote: > Hi, > > 22 indexes are simply too many, assuming they are not composite, which means > you already have a very large table. Secondly the most important bottleneck > is shown by the inserts/sec, only 405 inserts is very very slow. This co