… your site or hearing you say “we are a SaaS hosted application for data mining stock market transactions,” or whatever the… has the Percona patches for microsecond logging and additional information in the slow query log output. The stock MySQL server’s limitation….) If it’s not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
…to support multiple rollback segments – and Yasufumi just made patch to enable it. I rerun benchmarks on different server…auto –mysql-host localhost –mysql-port 3306 –mysql-socket /data/vadim/benchwork/var/mysql_benchwork.sock –mysql-user user –mysql-password –mysql-db sbtest –mysql-table-…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… the database instance or, even more work, by applying the patch and rebuilding the entire database from sources. I know that… with MySQL through TCP sockets. When localhost (not to be confused with 127.0.0.1) is used as a MySQL host, this will not work since all traffic goes through a unix socket file. It’s most definitely not a MySQL…
Comment: 10+ Ways to Crash or Overload MySQL
November 14, 2007 By 20 Comments
… host mapping), nothing is ever counted. As you probably know, I’ve been trying to get MySQL to overhaul how it handles hosts for a long time now. My host cache patches are a good start to this: http://jcole.us/patches/mysql/5.0/host_cache…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…_time=0 This patch is adapted version of patch by Georg Richter which was made to run with recent MySQL version. Now why…_examined: 1 SELECT id FROM users WHERE name=’baouong’; # User@Host: root[root] @ localhost [] # Query_time: 0.001943 Lock_time: 0…/UPDATE ones. Final Note: You do not have to have patched MySQL for these utilities to work. they are designed to handle…
Comment: About This Blog
October 7, 2008 By 48 Comments
… Company that just released an extensive set of Open Source patches for MySQL to improve statistical gathering — SHOW STATUS on steroids! We… connecting host. We love it! We decided to better document our changes and developed an extensive set of patches for MySQL and recently released them as Open Source (we hope it will get picked up in the main MySQL distribution…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
… and filesystem layout. Recompile the same version of mysql, with this patch applied (we compile mysql from source ourselves anyway, so this is…): #!perl use Time::Local; use DBI(); # Setup who your DB host host, and a hash of copnnection passwords. # You need one password… %{$queries{$conn}}) { my $dt = $_; while((time() – $offset) connect(“DBI:mysql:database=$DBNAME;host=$DBHOST”, “$DBUSER”, “$DBPASS”) || die “Couldn’t create dbh”; } foreach…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
… (SELECT privileges required). This is important for hosting providers Here is example of new tables: mysql> select * from information_schema.user_statistics\G… it here is link to patch for 5.0.67. http://www.mysqlperformanceblog.com/mysql/experimental/userstatv2.patch. When we consider it stable…
Post: Limiting InnoDB Data Dictionary
February 11, 2009 By 13 Comments
… with say 100-1000 tables. But for hosting providers and for user oriented applications ( each … http://mysqlperformanceblog.com/files/patches/innodb_dict_size_limit_standalone.patch. Currently patch is on testing stage, … used or not on MySQL level. We made it by checking MySQL table_cache. If table …
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
… to run patched MySQL, because the build instruction mentions the patch for MySQL ? A: xtrabackup can be run with any 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…
