… XtraDB Cluster has implemented ability to have a MySQL Utility user who has system access to …control to system variables. New table INNODB_UNDO_LOGS has been added to allow access to …has improved “clustercheck.sh“ script which makes a proxy (ie HAProxy) capable of monitoring Percona XtraDB …
Comment: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
… a log on-the fly, in any version from 4.1 to 6.0, using MySQL Proxy with an appropriate script. http://forge.mysql… the clients, you can use a IPTABLES command http://forge.mysql.com/snippets/view.php?id=82 Cheers Giuseppe
Comment: Logging MySQL queries from the client instead of the server
February 3, 2011 By 2 Comments
I suppose you could also use MySQL Proxy to do the logging. This is like how MySQL Enterprise does the query capturing for the Query Analyzer. The Query Analyzer also uses hooks in the JDBC connector for an interceptor plugin, so you could also write a plugin for Connector/J.
Comment: Percona Playback 0.3 development release
August 12, 2012 By 15 Comments
… an “Error query: …” error. In addition, it loaded the whole log file (sized 15GB) into memory, consuming totally about 18GB of…. There’s not much point in replaying only the slow logs, because they don’t normally represent a normal load pattern… server’s workload without utilizing some kind of proxy in front of the MySQL server. Also, is there a way to set…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…entry/server_defaults_changes_in_mysql , in documentation now at http://dev.mysql.com/doc/refman/5.6…high connection rates. max_connections was the best proxy we had for expected high connection rates when…write less information in the binary log when using row-based logging. Both of those are good …
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
… 226 | +—————————–+ 1 row in set (0.05 sec) mysql> EXPLAIN SELECT * FROM country WHERE population > 1000; # query 3 …either use a proxy that checks EXPLAIN information (like QUAN) or set your slow query log to zero …
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… one of our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master-Master replication… replication if tables on master and replica are different. binary log should be a good place to look for these. OK… must change application to use different IP for MySQL or ensure some load balancer/proxy does this, set read-only manually on…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… spoon feeding. You can place squid in front, use apache proxy module or even use lighttpd with FastCGI all can fix… connections were added to PHP during times of MySQL 3.22/3.23 when MySQL was simple enough so you could recycle… so if you track web requests in MySQL Logs by connection ID it would still work. MySQL has change_user() call which kind…
