Are you running MySQL on Debian or Ubuntu with InnoDB? You might want to disable /etc/mysql/debian-start. When you run /etc… that one is the debian-sys-maint thread. You also see the other threads: —TRANSACTION 0 228527423, ACTIVE 0 sec, process no 30034, OS thread id 1159956816 starting index read, thread declared inside InnoDB 500 mysql tables…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
… useful information to understand the server activity and identify the source of the load…INNODB_INDEX_STATS.TABLE_NAME, INNODB_INDEX_STATS.INDEX_NAME from INNODB_INDEX_STATS WHERE CONCAT(INNODB_INDEX_STATS.index_name, INNODB… indexes. This is an example: root@debian:/var/log# pt-index-usage slow.log…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
…in development (nothing stops you from starting to actively break old code though). Indeed there are some… since MySQL 4.0. This even applies to Innodb tables which were already on par with general…for RHEL you can use CentOS, Fedora or Debian,Ubuntu. Most articles speaking about MySQL for Enterprises…
