…var/lib/mysql/mysql.sock’ port: 3306 Percona …mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql…MySQL will think that the connections are always coming from the load balancer. You can work this around using T-Proxy patches…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
…performance from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL Remote DBA services. With our MySQL Server …MySQL build which can include community patches from various sources as well as some internally developed features. For example, shared hosting…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…patches. Second is “-percona-highperf” release, which contains experimental patches that can improve performance significantly. On this stage “percona-highperf” contains patches…PATCHES command, which is based on Jeremy Cole’s patch mysql> show patches…
Post: Percona's patches spread to a wider audience
October 13, 2008 By 7 Comments
… builds with features (Percona patches, Google patches, etc) and storage engines (PBXT, Sphinx, etc) that aren’t in the main MySQL server. Arjen Lentz… useful. We’re still building our own builds and hosting the downloads from our own website; it’s important that…. The Percona patches and builds represent our best judgment about what’s the state of the art in the MySQL server for…
Post: Hidden columns of query_review_history table
August 28, 2012 By Leave a Comment
… pt-query-digest to process a MySQL slow query log and store historical values for… example, you may have a server with the Percona patches). With creative use of –filter, you can … – User who executed the query. * `host_max` varchar(64) DEFAULT NULL – Client host which executed the query. * `db…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… your site or hearing you say “we are a SaaS hosted application for data mining stock market transactions,” or whatever the… stock MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server that has the Percona patches for microsecond logging and additional information in the slow query log output. The stock MySQL server’s limitation…
Post: 5.0.75-build12 Percona binaries
January 23, 2009 By 18 Comments
… symptoms of problem with Insert buffer. http://www.percona.com/docs/wiki/patches:innodb_io_patches * innodb_flush_neighbor_pages (default 1) – When…, hosting provider for Ruby on Rails application. You can download binaries (RPMS x86_64) and sources with patches here http://www.percona.com/mysql…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…1 SELECT id FROM users WHERE name=’baouong’; # User@Host: root[root] @ localhost [] # Query_time: 0.001943 Lock_time…. Final Note: You do not have to have patched MySQL for these utilities to work. they are designed …. Update 2009-03-04: most of us at Percona now use mk-query-digest from Maatkit for …
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
… version of MySQL: community release, enterprise release, percona builds, ourdelta distributions. You do not need to patch MySQL to run backup. The patch for MySQL is… you can run it as innobackupex –stream=tar ./ | ssh user@host cat “>” backup.tar and get copy on remote box. Also…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
… technologies. So how do the hosting providers manage to host hundreds of users on single server with single MySQL server ? Well people just… typically focused on the load eliminating – using Google UserStats patches (included in Percona releases) or Log analyzes as well as PROCESSLIST monitoring…
