… fixed #1175447. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a bitmap… returned if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete…/O error if changed page tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…the intermediate server, thus resulting in less binary log data being sent down to the lower-level…simply attempt to connect and run a simple query, but it’s always possible to build … 2:22:41 [ERROR] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect …
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a bitmap… returned if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete… #1185040. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t running. Bug fixed #1185304. Fixed the…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… known as a “flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight examines different time… in the largest table. You can find the individual SSB query definitions in my previous blog post. Test environment These tests… innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
….3. My node is crashed and I have this error in my log : 07:53:55 UTC – mysqld got signal 11 ; This… was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try… pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 3…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…; Query OK, 0 rows affected (0.04 sec) mysql> show slave status\G Empty set (0.00 sec) mysql> start slave; ERROR 1200… Master_Port: 35301 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay…: mysql> stop slave; Query OK, 0 rows affected (0,01 sec) mysql> change master to master_host=”; ERROR 1210 (HY000): Incorrect arguments…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… it already tried pretty hard to keep working despite recoverable errors and such. Whereas pt-osc 2.1 only retries certain… of log now (slow, general, binary, and tcpdump), so you shouldn’t have a problem finding queries to run and compare. pt-query… its primary objective: analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was removed. We also removed…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… set long_query_time to 0 in order to log every query. (See part two for handling massive slow log volume.) The slow logs are… query traffic. This is an important step because update statements that match no rows or insert statements that have duplicate key errors may be faster than an actual database write. The slow logs were split into chunks, each containing roughly 1M queries. We…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… one database server to another. Currently it can read queries from MySQL query-log and MySQL tcpdump files and run them on other… shows error when it’s unable to connect to the MySQL database server. Bug fixed #1070824 (Vlad Lesin). Multi-line query parsing… for MySQL wouldn’t reconnect or log the error if the connection was broken during the query. Bug fixed #1080654 (Vlad Lesin). Release…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… working because of an error: Last_SQL_Error: Error ‘Duplicate entry ’4′ for key ‘PRIMARY” on query. Default database: ‘test’. Query: ‘insert into t VALUES… to find the failed transaction. You can examine the binary logs or you can also check Retrieved_Gtid_Set and Executed… checks that transaction 5 is already in its own binary log and that means that it has been executed. This is…
