… release, which will be based on MySQL 5.1.55. We merged a …_checkpoint_limit feature from the Facebook patches into Percona Server. Peter requested a …statistics for the ::records_in_range() handler function, instead of accessing the data. This could improve performance for complex queries. A user…
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
… host # tail /var/log/mysql/mysql-slow.log # Time: 090115 2:25:28 # User@Host: me[me] @ localhost …_disk: No Merge_passes: 0 # No InnoDB statistics available for this query SELECT whatstheweatherlike(5…patch – which is included in all Community tree based Percona MySQL builds since it is part of MySQL…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
…the same version of mysql, with this patch applied (we compile mysql from source ourselves…# my $DBHOST=”slush”; my %passwords = ( “user” => “pass”, “reporting” => “reporting”, “user-no-pw” => “”, “etc” => “etc” ); …+([0-9]+) ((Query)|(Quit)|(Connect)|(Statistics)|(Binlog Dump Log))//) { # If we enter…
Post: Percona RPMS for RedHat 5 / CentOS 5 x86_64
July 31, 2008 By 4 Comments
… statistics. You can read more here http://www.mysqlperformanceblog.com/2008/04/20/updated-msl-microslow-patch-installation-walk-through/ User / Table / Index statistics (Google’s patch). More here http://www.mysqlperformanceblog.com/2008/04/24/mysql-extensions-for…
Post: SystemTap - DTrace for Linux ?
September 14, 2009 By 17 Comments
… with SystemTap your kernel should be patches with uprobes patch, which fortunately is included in RedHat based…: stap -v lsprob.stp Pass 1: parsed user script and 52 library script(s) in … you can intersect internal MySQL function and script (measure time, count of call, statistics) what you what. …
Comment: Percona RPMS for RedHat 5 / CentOS 5 x86_64
July 31, 2008 By 4 Comments
… monitoring rather than SHOW {TABLE,USER,INDEX}_STATISTICS. That sounds great. We are still in a MySQL 4.0 mindset and don’t… trying to add SHOW CLIENT_STATISTICS that will aggregate resource consumption by client IP. That should be out in a patch soon.
Comment: Percona Server and XtraBackup weekly news, February 5th
February 6, 2011 By 2 Comments
… somewhat OT question: are there any statistics on whether (and which) Percona patches propagate back to MySQL, MariaDB, etc.? And vice-versa? Is… diverting fast? I suppose users have their favorite server packages which they would use whatever a certain patch‘s propagation status, nevertheless…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
… XtraDB has over the built-in InnoDB included in MySQL 5.0 and 5.1. Building this list… of the buffer pool (see docs), and InnoDB row statistics are inserted into the slow query log (see docs)…. XtraDB introduces a patch to be able to control this, which is useful in cases where users have a large …
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
…0 RC contains a couple of patches from the Facebook-MySQL tree – https://launchpad.net/mysqlatfacebook ….code compatibilities with MySQL 5.5. (Oleg Tsarev) query_cache_totally_disable – Allows the user to …_stats_table – If ON, the table’s statistics are stored statically in the internal table …
