…=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3306 –mysql-user=sbtest –mysql-password=sbpass –oltp-table… MySQL will think that the connections are always coming from the load balancer. You can work this around using T-Proxy patches…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… –datadir=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852… not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… “MySQL“: Port 3306 as connection in TCP/IP protocol is identified by pair of IP addresses and pair of ports (local port and remote port). Yes… 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…
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
… sidelines: it is NOT a man in the middle like mysql-proxy, so it has basically zero impact on the running server… about queries that mysql-proxy can, making this a viable way to monitor servers without the disadvantages of a proxy. In theory, we… you can see how it works. sudo tcpdump -i lo port 3306 -s 65535 -x -n -q -tttt > tcpdump.out I run…
