… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on…_dir variable didn’t have the path separator at the end. Bug fixed #1181887. A warning is now returned if a…_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… just a moderate load on the host system, DRBD can end up in a split-brain situation. Typically DRBD is run… queries in the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL… simple query, but it’s always possible to build something more involved if that’s what you need. Q: What MySQL HA…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX (col2); Query… # test.test # ######################################################################## # Key redundant ends with a prefix of …
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona…didn’t have the path separator at the end. Bug fixed #1181887. Changed page tracking used to…O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result …
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 3… mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I have three nodes…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –…query-log-stdin command-line option for accepting a never-ending stream of queries to playback. Read-only playback Using the –session-init-query…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-statement transactions (TPS… perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are, by definition… boxes. You can find setup/config details at the very end of this post. Hardware: HP ProLiant DL380 G6 (8cores/16…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… is a little known goodie from Percona Toolkit for MySQL called pt-query-digest. One customer was suffering from periods of high…-format profile, to get just the ranking of queries. To my luck, one query stood out right away, always appearing many times… during peaks. Rewriting that query (actually the customer removed it altogether, by merging it with another query that ended up having a much…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… entry ’4′ for key ‘PRIMARY” on query. Default database: ‘test’. Query: ‘insert into t VALUES(NULL,’salazar’)’ … account that by doing this you will end up with data inconsistencies between Master and … Percona Toolkit for MySQL. Last week I gave a talk at Percona MySQL University @Toronto about GTID…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… which transactions are seen in the view later. To this end, InnoDB scans trx_list (i.e. the list of currently…-only server nor rewriting application queries. Furthermore, it can be combined with the read-only optimization in MySQL 5.6 to achieve… PK lookup SELECT queries wrapped into regular (i.e. not marked as read-only) transactions. In this case MySQL 5.6 scalability…
