EmergencyEMERGENCY? Get 24/7 Help Now!

CentOS 5.8 users: your UTF-8 data is in peril with Perl MySQL

 | February 22, 2013 |  Posted In: Insight for Developers, Percona Toolkit

CentOS 5.8 and earlier use Perl module DBD::mysql v3.0007 which has a bug that causes Perl not to flag UTF-8 data as being UTF-8.  Presuming that the MySQL table/column is using UTF-8, and the Perl MySQL connection is also using UTF-8, then a correct system returns: PV = 0x9573840 "\343\203\213 \303\250"\0 [UTF8 "\x{30cb} \x{e8}"] That’s a Devel::Peek inside a Perl scalar variable which […]

Read More

DBD::mysql 4.014 breaks pt-table-checksum 2.0

 | February 21, 2012 |  Posted In: Insight for DBAs, MySQL, Percona Software

DBD::mysql 4.014 breaks pt-table-checksum 2.0.  The cause is unknown, but the effect is a lot of errors like: DBD::mysql::st execute failed: called with 2 bind variables when 6 are needed [for Statement “…” with ParamValues: …] at ./pt-table-checksum line 7216. The fix is simple: upgrade (or even downgrade) DBD::mysql to any version except 4.014. To […]

Read More