… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… integers now. Bug fixed #714925. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding the… data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL clients to return bogus error…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still… temporary table to store an interim result set, and then use that to ultimately produce the result you want, that’s another technique… it pays to test all different solutions, and measure the resulting performance! Q: Bill, back to the query where you were…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad… available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it…_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn’t…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… it. One way is to set up replication filters on the slave, as described in the MySQL manual. You can configure the… binary log filters are executed on the intermediate server, thus resulting in less binary log data being sent down to the… the SQL nodes in a MySQL Cluster installation are going to be talking to the same set of data nodes on the…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… MySQL 5.6 is to use a caching layer to store expensive result sets or objects. Some typical use cases include: Complicated query result set (search results, recent users, recent posts, etc…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set… chunk 4’s workload warmed up with chunk 3. The result is similar for every single graph, each chunk warmed up…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… which set innodb_lock_wait_timeout because that now conflicts, or is at least confused with, lock_wait_timeout (introduced in MySQL 5.5) for metadata locks. Now –set-vars is used to set both of these (or any… exit. To do that, the tool magically set some options and clobbered others, resulting in no way to do repeated collections at…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… end up with non-deterministic ordering of transactions as a result. So this brings us back to Callaghan’s law for… SET last_joined=NOW(), last_user_id=100 WHERE id=1; COMMIT; How often might multiple users join the same group? Results…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding… tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc… would expect that a large receive queue might be the result of some brief performance issue on a given node, or…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… feature-set comparison between vCache and FlashCache and also to conduct some benchmarks for the use case where the MySQL working set is… post and the next, I’ll present some of those results. Disclosure: The research and testing for this post series was… be written to the backing store, whereas FlashCache has a setting called “fallow_delay”, defined in the documentation as the time…
