June 19, 2013

Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL

… of Percona? as earlier it use to work fine on SQL. does it not support concurrent submission of a form (multiple…

Post: Percona XtraBackup 2.0.7 for MySQL available for download

… copying failure. Bug fixed #1170806. innobackupex would fail if the SQL_MODE was set to ANSI_QUOTES. Bug fixed #945161. Missing…

Comment: Be careful when joining on CONCAT

Hi there! Is there any ways to EXPLAIN the SQL which is imported from the SOURCE command! @@

Comment: CVE-2012-4414 strikes back in MySQL 5.5.29 (and what we're doing in Percona Server 5.5.29)

…, thank you for correcting me. I am able to cause sql injection due to truncation, I have opened a new bug…

Comment: CVE-2012-4414 strikes back in MySQL 5.5.29 (and what we're doing in Percona Server 5.5.29)

Incorrect truncation is certainly a vulnerability. Why would you say otherwise? For example, if a string litteral is truncated in the middle. Then a later string litteral will be parsed as SQL expression.

Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL

… replication inside PXC has an additional overhead, this means the SQL_THREAD will not be able to execute events as fast…

Comment: Is your MySQL buffer pool warm? Make it sweat!

… similar, and I have had a lot of success writing sql queries (taken through Proxy at this stage) to a fifo…

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

… was used with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly named foreign key…

Post: MySQL alternative Percona Server 5.1.68 -14.6 now available

… was used with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly named foreign key…

Comment: 10 years of MySQL User Conferences

@Henrik, This is all due to the stup1d SQL 1-based convention (e.g SUBSTRING(s,1))!