… mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows affected (0.25 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> SHOW CREATE… ADD INDEX (col2); Query OK, 0 rows affected, 1 warning (0.56 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1…, it will throw an error and the second ALTER will fail, preventing the creation of the duplicate index. Does it mean…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory … that could cause a memory leak if query cache was used together with InnoDB. Bug fixed…Bug fixed #1172090. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…-running 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… volume mounted, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried, I…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…and then subsequent queries against the temp table fail. Q: Why doesn’t the query optimizer take…an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be…to the query where you were trying to determine the last episode of each TV show. …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… try: mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> reset slave; Query OK, 0 rows affected (0.03 sec) mysql> show slave… TO Much better! If we try to restart replication, it fails. However, I don’t like the error message, specifically the… differently: mysql> stop slave; Query OK, 0 rows affected (0,01 sec) mysql > reset slave; Query OK, 0 rows affected (0,11 sec) mysql> show slave…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…replicating from the active master. In theory, failing over is the simple matter of …percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-…(we did 39 measurements), the next graph shows chunk 4’s workload warmed up with…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
…’4′ for key ‘PRIMARY” on query. Default database: ‘test’. Query: ‘insert into t VALUES(NULL… different ways to find the failed transaction. You can examine the … Executed_Gtid_Set from the SHOW SLAVE OUTPUT as we can see…Toolkit for MySQL. Last week I gave a talk at Percona MySQL University @Toronto…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL…query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…XtraBackup enables backups without blocking user queries, making it ideal for companies…s DBD::MySQL package for server communication instead of spawning the MySQL command …. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog … try to remove it or fail if it cannot be removed. Bug …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL…query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…
