On Sun, Nov 22, 2009 at 11:26 AM, Aryeh Gregor Simetrical+wikilist@gmail.com wrote:
Last I checked, edit summaries were just passed to the database with no hard length check, so MySQL in non-strict mode with a binary schema (like Wikipedia) will just truncate them to fit. (In strict mode it will raise an error, and if we used utf8 rather than binary it would presumably truncate by characters.)
Hmm, okay. Should I be using character set and collation "binary"? The dumps build the table using character set utf8, and don't say anything about the collation. Is this specific to edit summaries, or does it apply to all the text fields?
I guess this is getting off topic, but I'm not quite sure what the topic of this thread is anyway.
On Sun, Nov 22, 2009 at 11:54 AM, Aryeh Gregor Simetrical+wikilist@gmail.com wrote:
On Sun, Nov 22, 2009 at 11:45 AM, Ryan Chan ryanchan404@gmail.com wrote:
May I ask why still using the 4.0 version? Seems 5.1 above did provide much performance enhancements?
I'm not the one to ask. My understanding is that it's mostly a question of how much administrative resources it would take to switch.
I don't know if it was supposed to be taken as sarcasm or not, but Tim Starling recently commented that "it seems that I'm the only staff member who knows MySQL." That was a joke, right?