…, and isn’t flexible at all. The specific problem of logging failed connection attempts has been discussed on a previous post in…-sys-maint”,”host”:”localhost”,”cmd”:”Connect”,”query“:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”user”:”debian-sys…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… could cause a memory leak if query cache was used together with InnoDB. Bug…log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log… #1003776. Rebuilding Debian source package would fail because dpatch and automake were missing …
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… unsigned integers now. Bug fixed #714925. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed… file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug… #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t running. Bug fixed #1185304. Other bug…
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 slaves…PRM simply attempt to connect and run a simple query, but it’s always possible to build something …, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every …
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…is crashed and I have this error in my log : 07:53:55 UTC – mysqld got signal 11 ; …already crashed, something is definitely wrong and this may fail. Please help us make Percona Server better by …may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID):…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… mysqld running and replicating from the active master. In theory, failing over is the simple matter of moving the virtual IP… 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-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1\” > /var/log/playback.log 2…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… of the first available binary log, which is very likely to corrupt your data by reexecuting some queries. Here’s a trick… TO Much better! If we try to restart replication, it fails. However, I don’t like the error message, specifically the… ALL to remove all replication-related configuration: mysql> stop slave; Query OK, 0 rows affected (0,00 sec) mysql> reset slave…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… Percona XtraBackup enables backups without blocking user queries, making it ideal for companies with large…when rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows parallel processing …starts, and try to remove it or fail if it cannot be removed. Bug fixed #1175860…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… during installation. Bugs fixed #1031427 and #1051874 (Ignacio Nin). The log tracker thread was unaware of the situation when the oldest… a metadata lock instead of failing or returning immediately if there is a transaction that executed a query which opened that table… the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… during installation. Bugs fixed #1031427 and #1051874 (Ignacio Nin). The log tracker thread was unaware of the situation when the oldest… a metadata lock instead of failing or returning immediately if there is a transaction that executed a query which opened that table… the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey…
