…this great opportunity to connect with the MySQL community at the largest community gathering in the world. To …now, we are pleased to make a special, limited time offer. Register between Thursday March 22nd … copies of the new book High Performance MySQL, 3rd Edition Don’t miss this special offer – …
Post: BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo
March 22, 2012 By Leave a Comment
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… that it works with all MySQL storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in combination with… total data. then spread over six servers). Due to ICE limitations, the data was split before loading. The splitting/loading process…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…=/var/lib/mysql‘ ‘–infodir=/usr/share/info’ ‘–includedir=/usr/include’ ‘–mandir=/usr/share/man’ ‘–enable-thread-safe-client’ ‘–with-comment=MySQL Community Edition (GPL… both SET SESSION and SET GLOBAL. log_slow_rate_limit=# Rate limit statement writes to slow log to only those from every…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From this I get… the slow query log output. The stock MySQL server’s limitation of one-second granularity makes it hide … small adjustments to the direction we’re going, communicate to the client how much time we’re …
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… is big limitation from my point of view. As workaround I tried to create temporary table, but got another error: mysql> create… GROUP BY Origin ORDER BY c DESC LIMIT 10; 4.96 sec Query Q4: mysql> SELECT Carrier, count(*) FROM ontime WHERE DepDelay… Conclusions InfiniDB server version shows Server version: 5.1.39-community InfiniDB Community Edition 0.9.4.0-5-alpha (GPL), so I…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… the final result set. Intern-node communication One or more gearman queues … above. If you have any limitation in resources in a cluster (cpu, … SQL, but right now only MySQL storage nodes are supported. Amdahl’… TABLE IF EXISTS `aggregation_tmp#74082863` ; Edit *MIN/MAX are only distributable …
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
…Infobright a try. They have an open-source community edition, which is crippled but not enough to matter… An abstracted front-end is a great idea; MySQL abstracts the storage backend, but why not do …-purpose” database use — there are a number of limitations (concurrency, for one) and it looks like …
Post: XtraDB storage engine release 1.0.2-2 (New Year edition)
December 29, 2008 By 20 Comments
… innodb_extra_undoslots InnoDB has a concurrent transaction limit of 1024 because in the standard InnoDB the… to use as drop-in plugin for existing MySQL-5.1.30 installation XtraDB is compatible with…requests for new engine and ready to accept community patches. You can monitor Percona’s current tasks…
