… large numbers and actively engaged. The exhibitors deserve a lot of credit for putting on a great show, with fun activities for everyone…. Sheeri Cabral also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
… other sessions. How to troubleshoot gap locks? Is possible to detect those gap locks using SHOW ENGINE INNODB STATUS: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL thread id…/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level so it…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… SESSION: —TRANSACTION 0 0, not started, process no 3396, OS thread id 1152440672 MySQL thread id 8080, query id 728900 localhost root show… shows activity on the row basics and some system information. It shows innodb thread queue status – how many threads are waiting and being active…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
…`), KEY `j` (`j`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 mysql> show table status like “sample” \G; *************************** 1. row *************************** Name:…SESSION: —TRANSACTION 0 42306989, ACTIVE 195 sec, process no 10099, OS thread id 1878960 6093 lock struct(s), heap size 503104 MySQL…
Post: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
… if you would like to use MySQL Slave as it can contain stale data… used in Master-Master replication in Active-Passive mode, just think about passive …ve added comment and it does not show up. If other visitors see a …the dedicated slave for the duration of session which is both good from performance …
Post: MySQL on OSCON
July 26, 2007 By 13 Comments
…show to much interest in the MySQL, and Databases for that reason. Our talk comparing performance of MySQL… lot of familiar faces. MySQL booth was not to active ether – in many …sessions etc. Or may be people think they know they need to know about MySQL already and nothing cool happened from MySQL…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… sql/sql_select.cc patching file sql/sql_show.cc patching file sql/structs.h Now it …the original code. In order to activate the patch you will need to restart MySQL. You can obviously choose …SESSION and SET GLOBAL. Downloads msl patch for MySQL 5.0.45 msl patch for MySQL 5.0.51a msl patch for MySQL…
Post: Worse than DDOS
August 18, 2008 By 5 Comments
…banned IPs of web services which were very actively used by the application which caused even worse…mysql – waiting on long query to come back) – this is our query if it is waiting on the session…for parallel session use so only the process which actually stalls waiting on external resource will show …
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
… In addition to building on MySQL 5.5, here are the…: #688866. (Yasufumi Kinoshita) Information from SHOW INNODB STATUS was made … innodb_flush_log_at_trx_commit_session was deleted. Bug fixed: #635399. (…Old variable innodb_ibuf_active_contract was renamed to innodb_ibuf_active_merge. Bug fixed: …
Post: How to track down the source of Aborted_connects
August 23, 2008 By 17 Comments
…does not indicate that an active connection is closed at all. Rather, it shows that a connection …resulting file. Inspecting the session with tcpdump -r showed that there was a complete TCP session; nothing bad …’ is not allowed to connect to this MySQL server I’ve anonymized the offending IP address….
