…I started to chat with them about their MySQL backup product. One of the representatives told … time on production systems, measured in many minutes, or potentially even hours. And during this time, the server … READ LOCK command completes and sends its response to the client that issued it. Holding …
Post: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
…_LRU_invalidate_tablespace 168823 0.6009 mysql mysql completion_hash_update(hashtable*, char*, unsigned int…were problems of scanning large lists which were responsible for poor performance of SHOW STATUS…performance of dropping tables I measured on the test server was 10 times better with single …
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
… single row and so be responsible for one undo entry or…you’re running Percona Server the following can be helpful: mysql> select * from innodb_rseg; +———+———-+———-+———+————+———–+ …speaking about Long Transactions the time is a bad measure. Having transaction in …
