…being enabled) it will exit with an error. It will exit with a message “setup …number of tables, and you want to track changes on all of them. You … because the source table is `test`.`demo`. mysql> select * from flexviews.test_demo\G *************************** 1. row *************************** …
Post: How to track down the source of Aborted_connects
August 23, 2008 By 19 Comments
… page that explains them). The first was related to the errors the client was seeing: the server was closing inactive connections… it by increasing the wait_timeout configuration variable. The second error does not indicate that an active connection is closed at….XX.XX.XXX’ is not allowed to connect to this MySQL server I’ve anonymized the offending IP address. However, I…
Post: Announcing Percona Playback 0.5
November 26, 2012 By
…accurate –db-plugin=libmysqlclient –mysql-host=10.8.2.10 \ –mysql-username=root –mysql-password=passW0rd –mysql-schema=imdb This example … 21 were slower A total of 0 queries had errors. Expected 30298 rows, got 30298 (a difference of 0…encounter any bugs, please report them to our bug tracking …
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…SET @a13:=repeat(“a”,1000000); select sleep(1); … Causes MySQL to “leak” 1MB of memory per second with…the PROCESS LIST and you can’t really track how much memory was allocated for given session …handle_mm_fault+0x1f8/0xe23 [] do_page_fault+0x4cb/0×830 [] error_exit+0×0/0×84 Do I need any particular…
Post: MySQL Session variables and Hints
December 28, 2006 By 2 Comments
… ways to find tune execution of particular query. First is MySQL Hints, such as SQL_BIG_RESULT, STRAIGHT_JOIN, FORCE INDEX… created dynamically some complex way) – adding extra MySQL calls with possibly their own error control is more complicated. Many people even dislike… LIMIT 10 This would also make it much easier to track – settings would show up in the query log (ie slow…
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
January 30, 2013 By 8 Comments
… State Snapshot Transfer would fail due to mktemp error. Bug fixed #1080829 (Alex Yurchenko). XtraBackup donor would … and Percona-XtraDB-Cluster-client would conflict with mysql and mysql-server packages. Bug fixed #1087506 (Ignacio Nin). …you encounter them, please report them to our bug tracking …
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 16 Comments
…-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup SST methods, better error handling… expected. If you encounter them, please report to our bug tracking system. Links: We provide tar.gz and RPM binaries for…
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.2
February 13, 2013 By Leave a Comment
… the parent table, which would cause the foreign key constraint errors. Bug fixed #1117175 (Seppo Jaakola). Based on Percona Server 5…. If you encounter them, please report them to our bug tracking system.
Comment: Using Flexviews - part two, change data capture
August 13, 2012 By 26 Comments
…. are we tracking only insert/delete updates or are we tracking even UPDATE modifications? 2. I get the following error when trying to update my view: mysql -e “CALL flexviews.refresh(14, ‘COMPLETE’, NULL);” ERROR 1054 (42S22) at line 1: Unknown column ‘ERROR: ERROR…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… your number of connections is limited you start getting connection errors which are easy to handle, in case of large number… can lead to very hard to track bugs. What would be proper solution to this ? MySQL should support command which resets connection… connection ID so if you track web requests in MySQL Logs by connection ID it would still work. MySQL has change_user() call…
