…a look at this bug report (not a bug). Looking at MySQL status Now we’re … | 38563413074 | 1708212 | | Bytes_sent | 216162991863 | 7796961 | | Com_admin_commands | 255868807 | 11893 | | Com_alter_db | 0 | 0 | …… queries, in total execution time. By the way, the slow query logs in the stock MySQL …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… data smaller) or can a bit slow it down. Plus there were bunch…’last’ serious bug in it was only recently found and fixed: http://bugs.mysql.com/bug.php?id…There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation…
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… more than a year ago. Great news are MySQL finally released new Community release – MySQL 5.0.33, which however as promised… (Links removed) We added one more RPM to stantard MySQL RPMs – MySQL-microslow-5.0.33-0.glibc23.x86_64.rpm This… microsecound in slow-log. More info about the patch http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/ http://bugs.mysql.com/bug.php?id…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
… reported bug http://bugs.mysql.com/bug.php?id=29847, with ETA MySQL-6.0 Preload table / index into buffer_pool. You can use custom queries by… probes during opening table, as it is slow operation. See also http://www.mysqlperformanceblog.com/2006/11/21/opening-tables-scalability/. Partially…
Comment: MySQL Query Cache WhiteSpace and comments
March 25, 2008 By 9 Comments
… mysql command line client now has an *option* to pass comments to the server, but it’s disabled by default: http://bugs.mysql.com/bug… the query recorded in the slow query log). However, when I ran this php script: I *did* see the comment in the slow log: # Time: 080325 9:31:43 # User@Host: dbadmin[dbadmin] @ localhost [] # Query_time: 2 Lock_time…
Comment: Learning about MySQL Table Fragmentation
May 11, 2008 By 19 Comments
… posted this to MySQL: http://bugs.mysql.com/bug.php?id=36588 Originally we had this discussion in our Forums: http://www.webyog.com/forums//index… is that also SHOW TABLE STATUS can be very slow. Same for queries to Information_Schema fetching the same information. But it…
Comment: Innodb row size limitation
April 9, 2011 By 11 Comments
… compressed. The relaxation of the check was done for http://bugs.mysql.com/bug.php?id=50495 . If you’re putting so much data… you probably don’t need all of it for every query and could probably improve performance by moving some of it… of general reporting. There’s no need to slow down the general queries by having the address information in the main record…
Comment: Innodb row size limitation
April 7, 2011 By 11 Comments
… compressed. The relaxation of the check was done for http://bugs.mysql.com/bug.php?id=50495 . If you’re putting so much data… you probably don’t need all of it for every query and could probably improve performance by moving some of it… of general reporting. There’s no need to slow down the general queries by having the address information in the main record…
Post: 5.0.77 / 5.0.82 -build16 Percona binaries
June 11, 2009 By 4 Comments
… Bug #381430: mysql-test profiling fails on 5.0.77 Bug #375494: log_slow_rate_limit logs all queries on a connection after a >1s query Bug #378761: compilation fails on 5.0.77 Bug #381900: mysql… sources with patches here http://www.percona.com/mysql/5.0.77-b16/ http://www.percona.com/mysql/5.0.82-b16/ The Percona…
Post: 5.0.86-build19 Percona binaries
October 12, 2009 By 10 Comments
… on MySQL-5.0.86 Fix from Neil Katin to userstatv2.patch fix InnoDB slowness with large queries Fixed bugs in the build: Bug #413858… http://www.percona.com/mysql/5.0.86-b19/ There is Debian packages repository available since Build 19. To install MySQL with Percona… mysql-server-5.0 The Percona patches live on Launchpad : https://launchpad.net/percona-patches and you can report bug to Launchpad bug…
