Re: utf8, 4.1, and character length truncation in mysql system tables

2005-05-12 Thread Adam Fields
le. This was done through the stock mysql client, which defaults to latin1 even if you set the server character set to utf8 (which makes sense, as most terminals don't support utf8). Is there something else I should be doing to create new users post 4.1? Is this behavior something I should be wor

utf8, 4.1, and character length truncation in mysql system tables

2005-05-12 Thread Adam Fields
I changed the default character set on a 4.1 server to utf8. As expected, this caused the lengths of character fields to be shortened, requiring alter table to be run on them to extend the lengths. But I didn't expect that this would also shorten the mysql system tables (the "mysql" db), so that

Query execution times in general query log?

2003-02-26 Thread Adam Fields
options to get this info put in the log (in 3.23 or otherwise)? 3) Does anybody have a better way to get this info from a running instance (not necessarily in realtime)? -- - Adam - Adam Fields, Managing Partner, [EMAIL PROTECTED] Surgam, Inc. is a