ANN: MySQL Performance Monitoring

2014-05-21 Thread Mick Emmett
Greetings MySQL users -- If MySQL monitoring is something you are doing with one specific tool -- or not at all -- then you might find this blog post on MySQL Performance Monitoring in SPM worth a read: http://wp.me/pwdA7-Xo We frequently hear from organizations across industries who tackle perf

Re: Case sensitivity

2014-05-21 Thread Larry Martell
On Wed, May 21, 2014 at 4:50 AM, Hartmut Holzgraefe wrote: > On 05/21/2014 08:14 AM, Johan De Meersman wrote: > >>> ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE >>> latin1_general_ci; >> >> Purely from memory, doesn't that change the table but add the old setting to >> individual t

Re: Case sensitivity

2014-05-21 Thread Reindl Harald
Am 21.05.2014 10:50, schrieb Hartmut Holzgraefe: > On 05/21/2014 08:14 AM, Johan De Meersman wrote: > >>> ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE >>> latin1_general_ci; >> >> Purely from memory, doesn't that change the table but add the old setting to >> individual text colum

Re: Case sensitivity

2014-05-21 Thread Hartmut Holzgraefe
On 05/21/2014 08:14 AM, Johan De Meersman wrote: >> ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE >> latin1_general_ci; > > Purely from memory, doesn't that change the table but add the old setting to > individual text columns? right, the above will only change the default for new