…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: 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 83 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…
Page: Percona Server and Percona XtraBackup
October 17, 2007 By 25 Comments
… enhanced version of MySQL for many years. We call it Percona Server with XtraDB, and some of the largest MySQL installations in the… tool. This page used to contain links to MySQL patches. Those patches are now available in Percona Server, and the code is hosted on Launchpad.
Post: Profiling MySQL stored routines
January 19, 2009 By 3 Comments
… in set (0.00 sec) host # tail /var/log/mysql/mysql-slow.log # Time: 090115 2:25:28 # User@Host: me[me] @ localhost [] # Thread…’s SHOW PROFILE patch – which is included in all Community tree based Percona MySQL builds since it is part of MySQL community version ever since 5.0.37 (note – not all Percona builds are…
Post: Percona BOFs at OSCON
July 18, 2009 By Leave a Comment
… sessions so we host/co-host number of BOFs at the comming OSCON conference. Future of MySQL Forks, Branches and Patches I guess is…
