… amazing MySQL manual, especially the option and …commanual Com_rollbackblogpercona.commanual Com_rollback_to_savepointblogpercona.commanual Com_…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL…closed, the ALTER proceeds through successfully: session1 > rollback; Query OK, 0 rows affected (0.00 sec)…closing tables | 0.000003 | | freeing items | 0.000007 | | logging slow query | 0.000002 | | cleaning up | 0.000002 | …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018…: 0 OTHER_COMMANDS: 0 COMMIT_TRANSACTIONS: 181243 ROLLBACK_TRANSACTIONS: 0 DENIED_CONNECTIONS: 0 LOST_CONNECTIONS:… Server, enabled full query logging and log_slow_verbosity=full you can also get great…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…Handler_read_rnd’, ’234159075′ ‘Handler_read_rnd_next’, ’2358572961′ ‘Handler_rollback‘, ’4947643′ ‘Handler_update’, ’12524′ ‘Handler_write’, ’292923929′ ‘Key_…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…and from the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug …from locking rows only to undo changes at rollback. Using this approach, support for Fake Changes have…error number correctly. #830199 (Oleg Tsarev). Variable log-slow-admin-statements was not listed with SHOW …
Post: MySQL: Followup on UNION for query optimization, Query profiling
August 14, 2006 By 14 Comments
… | 0 | | Handler_read_rnd_next | 0 | | Handler_rollback | 0 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 0 | | Handler_write | 14… range or as IN filesort appears and query becomes very slow: mysql> explain select * from people where age=18 order by last…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…bring the server down. You can have slow query log enabled and review it occasionally… Other_commands: 85 Commit_transactions: 0 Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; +——————————–+———–+————–+————————-+ | Table | …
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
…transactions which have some locks, like in this case: MySQL thread id 2059, query id 1014425 10.10….old transaction and so you can get system to slow down because of maintaining many old row versions. … If you can’t fix your connection pool to rollback transactions when they are recycled it might be …
Post: Rebuilding MySQL Binary
November 16, 2006 By 2 Comments
… RPM based or other packaged MySQL Binary you may have a problem if you would like …for Innodb scalability and Vadim’s patches to get proper slow query log). There are number of things as default …which I’m interested in. Quick to try, quick to rollback. You may run make install though if you need to…
Post: 5.0.77 / 5.0.82 -build16 Percona binaries
June 11, 2009 By 4 Comments
… patch adds information from SHOW PROFILE to query information in slow.log output. profiling_server. This variable ( ON / OFF ) enables profiling… information about all rollback segments innodb_thread_concurrency_timer_based.patch This patch provides the configuration variable backport from MySQL 5.4…
