… it. All of Percona’s software is open-source and free, all the details of the release can be found in… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL clients to return bogus…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…a copy on write filesystem, the snapshots are free, no performance penalty. You can easily run a… is surprisingly cheap. In fact the best tpcc results I got were when using compression. I still… on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona… of Percona’s software is open-source and free, all the details of the release can be… query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…*, unsigned long, char const*, unsigned long) | |–99.14%– buf_LRU_free_block(buf_page_t*, unsigned long) | | | |–100.00%– buf_LRU… result. In the best possible combination I got ~15k operations per second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL… in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and Percona Server shows much better results Configurations…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… notably slowdown MySQL-transaction creation and many threads will get stuck on glibc/kernel syscalls, which will in turn result in contention… structure, reuse that memory during the entire connection lifetime and free it at disconnect. If some transactions require a larger amount… recent release and such we have almost no difference in results between runs either with glibc or jemalloc
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…, it has a really helpful new feature: “reference results“, i.e. saved results from running queries on a server. Granted, this can… also more: it’s a free service from Percona that advises when certain programs (Percona Toolkit tools, MySQL, Perl, etc.) are either… that, the tool magically set some options and clobbered others, resulting in no way to do repeated collections at intervals. Now…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… time in buf_LRU_scan_and_free_block you are not going to have good performance results. Prior to 5.6 foreground threads were responsible for moving pages to the free list via buf_flush_free_margin… them. http://bugs.mysql.com/bug.php?id=68658 http://bugs.mysql.com/bug.php?id=68588 http://bugs.mysql.com/bug.php…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… time in buf_LRU_scan_and_free_block you are not going to have good performance results. Prior to 5.6 foreground threads were responsible for moving pages to the free list via buf_flush_free_margin… them. http://bugs.mysql.com/bug.php?id=68658 http://bugs.mysql.com/bug.php?id=68588 http://bugs.mysql.com/bug.php…
Post: Handling big result sets
June 26, 2006 By 13 Comments
… = ‘SELECT * FROM longf’; $result = mysql_query($query) or die(‘Query failed: ‘ . mysql_error()); // retrive result while ($line = mysql_fetch_array($result, MYSQL_NUM)) { } // Free resultset mysql_free_result($result); $time_end = microtime(true); $time = $time_end – $time_start; echo “execution time: “.$time.” s”; mysql…
Post: MySQL net_write_timeout vs wait_timeout and protocol notes
July 8, 2007 By 1 Comment
… partial query received. Result set however comes back in multiple pieces and if you’re using mysql_use_result you can do any… comes from simplicity of MySQL protocol which does not allow client to talk to the server until full result set is fetched. This is also the reason why you can’t stop fetching for ordinary statements and mysql_free_result will…
